id, time, nodeaddr, appeui, gwaddr, modulation, datarate, snr, rssi, freq, fcount, lat, lon, alt, accuracy, hdop, sats, provider, name, user_agent 5879184, 2019-05-23 15:43:42, bigclown_lora_tester, bigclown_test, 58A0CBFFFE8002FE, LORA, SF8BW125, 11.25, -65.00, 868.100, null, 49.256580, 17.699840, 237.0, null, null, 7, sats, bigclown_lora_tester, null 5879130, 2019-05-23 15:36:13, bigclown_lora_tester, bigclown_test, 58A0CBFFFE8002FE, LORA, SF12BW125, 10.25, -58.00, 867.100, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5878986, 2019-05-23 15:13:30, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF8BW125, 8.00, -49.00, 867.500, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5878985, 2019-05-23 15:13:26, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF12BW125, 10.00, -49.00, 868.100, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5865581, 2019-05-22 13:32:27, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF8BW125, 10.75, -53.00, 867.900, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5865345, 2019-05-22 13:19:49, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF12BW125, 10.00, -51.00, 868.100, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5865306, 2019-05-22 13:17:41, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF7BW125, 10.25, -49.00, 867.700, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5865305, 2019-05-22 13:17:33, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF8BW125, 11.75, -49.00, 868.100, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5865218, 2019-05-22 13:06:40, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF8BW125, 11.75, -48.00, 867.700, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5865211, 2019-05-22 13:04:47, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF8BW125, 10.25, -46.00, 868.300, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5865210, 2019-05-22 13:04:40, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF12BW125, 11.50, -48.00, 868.100, null, 0.000000, 0.000000, 0.0, null, null, 0, sats, bigclown_lora_tester, null 5865006, 2019-05-22 12:17:34, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF7BW125, 8.25, -52.00, 867.700, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5865003, 2019-05-22 12:17:25, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF7BW125, 9.00, -51.00, 867.300, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5864970, 2019-05-22 12:11:18, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF7BW125, 9.25, -53.00, 867.900, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5864969, 2019-05-22 12:11:15, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF7BW125, 8.50, -53.00, 867.700, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5864967, 2019-05-22 12:11:10, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF7BW125, 9.25, -55.00, 868.300, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5864912, 2019-05-22 11:55:39, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF7BW125, 9.75, -51.00, 868.300, null, 0.000000, 0.000000, 0.0, null, null, 0, sats, bigclown_lora_tester, null 5864766, 2019-05-22 11:08:49, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF7BW125, 9.00, -49.00, 867.100, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5857774, 2019-05-21 14:53:31, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF7BW125, 10.00, -49.00, 867.100, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5857650, 2019-05-21 14:43:52, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF7BW125, 9.75, -51.00, 867.700, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5857649, 2019-05-21 14:43:48, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF7BW125, 9.50, -53.00, 867.300, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5857073, 2019-05-21 13:47:57, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF7BW125, 9.00, -58.00, 867.300, null, 842.150450, 842.150450, 1285.0, null, null, 5, sats, bigclown_lora_tester, null 5857072, 2019-05-21 13:47:46, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF7BW125, 9.25, -67.00, 867.900, null, 673.720360, 673.720360, 1028.0, null, null, 4, sats, bigclown_lora_tester, null 5857071, 2019-05-21 13:47:37, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF7BW125, 9.75, -60.00, 867.700, null, 336.860180, 336.860180, 514.0, null, null, 2, sats, bigclown_lora_tester, null 5857068, 2019-05-21 13:47:02, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF7BW125, 7.75, -46.00, 868.300, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5856785, 2019-05-21 13:16:36, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF7BW125, 7.50, -48.00, 868.500, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5856775, 2019-05-21 13:15:13, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF8BW125, 11.00, -48.00, 867.700, null, 0.000000, 0.000000, 0.0, null, null, 0, sats, bigclown_lora_tester, null 5856772, 2019-05-21 13:14:52, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF8BW125, 10.75, -45.00, 867.300, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5856770, 2019-05-21 13:14:46, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF8BW125, 10.50, -46.00, 868.100, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5856769, 2019-05-21 13:14:38, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF8BW125, 11.50, -47.00, 867.700, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5856742, 2019-05-21 13:09:16, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF8BW125, 8.50, -47.00, 868.500, null, 49.256670, 17.699760, 250.0, null, null, 10, sats, bigclown_lora_tester, null 5856674, 2019-05-21 12:56:22, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF8BW125, 11.25, -48.00, 868.300, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5856673, 2019-05-21 12:56:12, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF8BW125, 11.00, -49.00, 867.100, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5856671, 2019-05-21 12:56:01, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF8BW125, 10.50, -49.00, 867.100, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5856669, 2019-05-21 12:55:50, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF8BW125, 10.75, -47.00, 867.700, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5856667, 2019-05-21 12:55:45, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF8BW125, 12.00, -48.00, 867.300, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5856666, 2019-05-21 12:55:40, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF8BW125, 11.75, -49.00, 867.900, null, 0.000000, 0.000000, 0.0, null, null, null, payload_fields, bigclown_lora_tester, null 5856531, 2019-05-21 12:29:18, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF8BW125, 12.75, -48.00, 867.900, null, 49.256660, 17.699780, 256.0, null, null, 12, sats, bigclown_lora_tester, null 5856508, 2019-05-21 12:22:40, lora_11, bigclown_test, 58A0CBFFFE8002FE, LORA, SF8BW125, 11.50, -47.00, 868.300, null, 49.256690, 17.699720, 247.0, null, null, 9, sats, bigclown_lora_tester, null Number of rows dumped: 39