id, time, nodeaddr, appeui, gwaddr, modulation, datarate, snr, rssi, freq, fcount, lat, lon, alt, accuracy, hdop, sats, provider, name, user_agent 49840129, 2021-03-27 18:43:40, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, -12.00, -112.00, 867.300, 33, 53.085226, 8.932517, 40.2, 10.72, 0.0, 0, gps, bici121, null 49839968, 2021-03-27 18:42:18, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, -8.80, -112.00, 867.100, 32, 53.087045, 8.930907, 44.9, 10.72, 0.0, 0, gps, bici121, null 49839815, 2021-03-27 18:40:56, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, -12.20, -113.00, 867.700, 31, 53.087685, 8.929747, 47.8, 10.72, 0.0, 0, gps, bici121, null 49839684, 2021-03-27 18:39:34, lopy47242, 7242, 3133303759003D00, LORA, SF12BW125, -8.75, -114.00, 867.300, 30, 53.086849, 8.926578, 53.5, 10.72, 0.0, 0, gps, bici121, null 49839683, 2021-03-27 18:39:34, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, -5.20, -111.00, 867.300, 30, 53.086849, 8.926578, 53.5, 10.72, 0.0, 0, gps, bici121, null 49839566, 2021-03-27 18:38:12, lopy47242, 7242, 3133303759003D00, LORA, SF12BW125, -7.00, -117.00, 868.100, 29, 53.085966, 8.923067, 60.0, 10.72, 0.0, 0, gps, bici121, null 49839565, 2021-03-27 18:38:12, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, -5.50, -109.00, 868.100, 29, 53.085966, 8.923067, 60.0, 10.72, 0.0, 0, gps, bici121, null 49839418, 2021-03-27 18:36:50, lopy47242, 7242, 3133303759003D00, LORA, SF12BW125, -10.75, -116.00, 867.700, 28, 53.084957, 8.919183, 56.6, 10.72, 0.0, 0, gps, bici121, null 49839417, 2021-03-27 18:36:50, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, -4.00, -111.00, 867.700, 28, 53.084957, 8.919183, 56.6, 10.72, 0.0, 0, gps, bici121, null 49839254, 2021-03-27 18:35:28, lopy47242, 7242, 3133303759003D00, LORA, SF12BW125, -14.00, -116.00, 868.100, 27, 53.084065, 8.915572, 53.1, 10.72, 0.0, 0, gps, bici121, null 49839253, 2021-03-27 18:35:28, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, -7.20, -112.00, 868.100, 27, 53.084065, 8.915572, 53.1, 10.72, 0.0, 0, gps, bici121, null 49839135, 2021-03-27 18:34:06, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, -10.00, -115.00, 868.100, 26, 53.083035, 8.911940, 54.9, 10.72, 0.0, 0, gps, bici121, null 49839004, 2021-03-27 18:32:44, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, -9.20, -113.00, 867.100, 25, 53.082107, 8.911038, 55.1, 11.79, 0.0, 0, gps, bici121, null 49838862, 2021-03-27 18:31:22, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, -14.50, -113.00, 868.100, 24, 53.082039, 8.907258, 49.1, 13.94, 0.0, 0, gps, bici121, null 49838706, 2021-03-27 18:30:00, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, -10.50, -112.00, 867.500, 23, 53.082085, 8.904592, 63.5, 10.72, 0.0, 0, gps, bici121, null 49838573, 2021-03-27 18:28:38, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, -12.20, -108.00, 867.500, 22, 53.082216, 8.900260, 58.7, 12.86, 0.0, 0, gps, bici121, null 49838431, 2021-03-27 18:27:16, lopy47242, 7242, 3133303759003D00, LORA, SF12BW125, -14.00, -116.00, 868.100, 21, 53.082316, 8.896309, 62.1, 12.86, 0.0, 0, gps, bici121, null 49838430, 2021-03-27 18:27:16, lopy47242, 7242, FCC23DFFFE0A9698, LORA, SF12BW125, -15.50, -117.00, 868.100, 21, 53.082316, 8.896309, 62.1, 12.86, 0.0, 0, gps, bici121, null 49838429, 2021-03-27 18:27:16, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, -3.00, -111.00, 868.100, 21, 53.082316, 8.896309, 62.1, 12.86, 0.0, 0, gps, bici121, null 49838287, 2021-03-27 18:25:54, lopy47242, 7242, 3133303759003D00, LORA, SF12BW125, -3.50, -116.00, 867.900, 20, 53.082539, 8.892698, 76.2, 10.72, 0.0, 0, gps, bici121, null 49838286, 2021-03-27 18:25:54, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, 0.80, -100.00, 867.900, 20, 53.082539, 8.892698, 76.2, 10.72, 0.0, 0, gps, bici121, null 49838285, 2021-03-27 18:25:54, lopy47242, 7242, FCC23DFFFE0A9698, LORA, SF12BW125, -8.20, -115.00, 867.900, 20, 53.082539, 8.892698, 76.2, 10.72, 0.0, 0, gps, bici121, null 49838148, 2021-03-27 18:24:32, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, -1.80, -110.00, 868.100, 19, 53.082672, 8.887305, 28.2, 10.72, 0.0, 0, gps, bici121, null 49838023, 2021-03-27 18:23:10, lopy47242, 7242, 3133303759003D00, LORA, SF12BW125, -10.50, -119.00, 868.100, 18, 53.082682, 8.884981, 60.7, 11.79, 0.0, 0, gps, bici121, null 49838022, 2021-03-27 18:23:10, lopy47242, 7242, FCC23DFFFE0A9698, LORA, SF12BW125, -12.80, -115.00, 868.100, 18, 53.082682, 8.884981, 60.7, 11.79, 0.0, 0, gps, bici121, null 49838021, 2021-03-27 18:23:10, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, 1.00, -105.00, 868.100, 18, 53.082682, 8.884981, 60.7, 11.79, 0.0, 0, gps, bici121, null 49837885, 2021-03-27 18:21:48, lopy47242, 7242, 58A0CBFFFE80287C, LORA, SF12BW125, -9.25, -115.00, 867.300, 17, 53.082580, 8.881595, 61.0, 10.72, 0.0, 0, gps, bici121, null 49837884, 2021-03-27 18:21:48, lopy47242, 7242, 3133303759003D00, LORA, SF12BW125, -14.50, -115.00, 867.300, 17, 53.082580, 8.881595, 61.0, 10.72, 0.0, 0, gps, bici121, null 49837883, 2021-03-27 18:21:48, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, 0.50, -108.00, 867.300, 17, 53.082580, 8.881595, 61.0, 10.72, 0.0, 0, gps, bici121, null 49837882, 2021-03-27 18:21:48, lopy47242, 7242, FCC23DFFFE0A9698, LORA, SF12BW125, -12.00, -115.00, 867.300, 17, 53.082580, 8.881595, 61.0, 10.72, 0.0, 0, gps, bici121, null 49837706, 2021-03-27 18:20:26, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, -4.80, -113.00, 867.100, 16, 53.082275, 8.878067, 54.1, 10.72, 0.0, 0, gps, bici121, null 49837545, 2021-03-27 18:19:04, lopy47242, 7242, 58A0CBFFFE80287C, LORA, SF12BW125, 15.25, -117.00, 867.700, 15, 53.082091, 8.874524, 56.5, 10.72, 0.0, 0, gps, bici121, null 49837544, 2021-03-27 18:19:04, lopy47242, 7242, 3133303759003D00, LORA, SF12BW125, -6.75, -115.00, 867.700, 15, 53.082091, 8.874524, 56.5, 10.72, 0.0, 0, gps, bici121, null 49837543, 2021-03-27 18:19:04, lopy47242, 7242, FCC23DFFFE0A9698, LORA, SF12BW125, -11.00, -115.00, 867.700, 15, 53.082091, 8.874524, 56.5, 10.72, 0.0, 0, gps, bici121, null 49837542, 2021-03-27 18:19:04, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, 4.50, -104.00, 867.700, 15, 53.082091, 8.874524, 56.5, 10.72, 0.0, 0, gps, bici121, null 49837401, 2021-03-27 18:17:42, lopy47242, 7242, 3133303759003D00, LORA, SF12BW125, -8.75, -113.00, 867.300, 14, 53.081962, 8.870267, 60.4, 10.72, 0.0, 0, gps, bici121, null 49837400, 2021-03-27 18:17:42, lopy47242, 7242, FCC23DFFFE0A9698, LORA, SF12BW125, -8.50, -113.00, 867.300, 14, 53.081962, 8.870267, 60.4, 10.72, 0.0, 0, gps, bici121, null 49837399, 2021-03-27 18:17:42, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, 2.50, -107.00, 867.300, 14, 53.081962, 8.870267, 60.4, 10.72, 0.0, 0, gps, bici121, null 49837238, 2021-03-27 18:16:20, lopy47242, 7242, 3133303759003D00, LORA, SF12BW125, -12.50, -117.00, 867.900, 13, 53.082156, 8.865815, 45.5, 10.72, 0.0, 0, gps, bici121, null 49837237, 2021-03-27 18:16:20, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, 2.00, -109.00, 867.900, 13, 53.082156, 8.865815, 45.5, 10.72, 0.0, 0, gps, bici121, null 49837236, 2021-03-27 18:16:20, lopy47242, 7242, FCC23DFFFE0A9698, LORA, SF12BW125, -12.00, -117.00, 867.900, 13, 53.082156, 8.865815, 45.5, 10.72, 0.0, 0, gps, bici121, null 49837081, 2021-03-27 18:14:58, lopy47242, 7242, 3133303759003D00, LORA, SF12BW125, -12.00, -116.00, 867.900, 12, 53.082433, 8.861180, 55.0, 10.72, 0.0, 0, gps, bici121, null 49837080, 2021-03-27 18:14:58, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, 4.50, -107.00, 867.900, 12, 53.082433, 8.861180, 55.0, 10.72, 0.0, 0, gps, bici121, null 49837079, 2021-03-27 18:14:58, lopy47242, 7242, FCC23DFFFE0A9698, LORA, SF12BW125, -8.00, -115.00, 867.900, 12, 53.082433, 8.861180, 55.0, 10.72, 0.0, 0, gps, bici121, null 49836936, 2021-03-27 18:13:36, lopy47242, 7242, 3133303759003D00, LORA, SF12BW125, -15.25, -119.00, 868.100, 11, 53.082530, 8.856700, 50.4, 9.65, 0.0, 0, gps, bici121, null 49836935, 2021-03-27 18:13:36, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, 4.20, -109.00, 868.100, 11, 53.082530, 8.856700, 50.4, 9.65, 0.0, 0, gps, bici121, null 49836934, 2021-03-27 18:13:36, lopy47242, 7242, FCC23DFFFE0A9698, LORA, SF12BW125, -13.80, -115.00, 868.100, 11, 53.082530, 8.856700, 50.4, 9.65, 0.0, 0, gps, bici121, null 49836808, 2021-03-27 18:12:14, lopy47242, 7242, FCC23DFFFE0A9698, LORA, SF12BW125, -13.20, -112.00, 868.100, 10, 53.082260, 8.853970, 55.5, 10.72, 0.0, 0, gps, bici121, null 49836807, 2021-03-27 18:12:14, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, 6.20, -97.00, 868.100, 10, 53.082260, 8.853970, 55.5, 10.72, 0.0, 0, gps, bici121, null 49836649, 2021-03-27 18:10:52, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, 6.50, -92.00, 867.300, 9, 53.082545, 8.853452, 57.1, 10.72, 0.0, 0, gps, bici121, null 49836648, 2021-03-27 18:10:52, lopy47242, 7242, FCC23DFFFE0A9698, LORA, SF12BW125, -15.00, -112.00, 867.300, 9, 53.082545, 8.853452, 57.1, 10.72, 0.0, 0, gps, bici121, null 49836508, 2021-03-27 18:09:30, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, 5.00, -91.00, 867.100, 8, 53.083603, 8.851895, 48.8, 9.65, 0.0, 0, gps, bici121, null 49836507, 2021-03-27 18:09:30, lopy47242, 7242, FCC23DFFFE0A9698, LORA, SF12BW125, -10.80, -115.00, 867.100, 8, 53.083603, 8.851895, 48.8, 9.65, 0.0, 0, gps, bici121, null 49836380, 2021-03-27 18:08:08, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, 5.00, -95.00, 867.500, 7, 53.085130, 8.848585, 45.7, 9.65, 0.0, 0, gps, bici121, null 49836379, 2021-03-27 18:08:08, lopy47242, 7242, FCC23DFFFE0A9698, LORA, SF12BW125, -10.00, -111.00, 867.500, 7, 53.085130, 8.848585, 45.7, 9.65, 0.0, 0, gps, bici121, null 49836244, 2021-03-27 18:06:46, lopy47242, 7242, 3133303759003D00, LORA, SF12BW125, -10.75, -115.00, 867.300, 6, 53.083912, 8.844449, 44.6, 9.65, 0.0, 0, gps, bici121, null 49836243, 2021-03-27 18:06:46, lopy47242, 7242, FCC23DFFFE0A9698, LORA, SF12BW125, -12.00, -113.00, 867.300, 6, 53.083912, 8.844449, 44.6, 9.65, 0.0, 0, gps, bici121, null 49836242, 2021-03-27 18:06:46, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, 6.80, -89.00, 867.300, 6, 53.083912, 8.844449, 44.6, 9.65, 0.0, 0, gps, bici121, null 49836077, 2021-03-27 18:05:24, lopy47242, 7242, 3133303759003D00, LORA, SF12BW125, -6.75, -117.00, 868.100, 5, 53.083268, 8.842273, 49.3, 10.72, 0.0, 0, gps, bici121, null 49836076, 2021-03-27 18:05:24, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, 9.80, -74.00, 868.100, 5, 53.083268, 8.842273, 49.3, 10.72, 0.0, 0, gps, bici121, null 49836075, 2021-03-27 18:05:24, lopy47242, 7242, FCC23DFFFE0A9698, LORA, SF12BW125, -10.00, -115.00, 868.100, 5, 53.083268, 8.842273, 49.3, 10.72, 0.0, 0, gps, bici121, null 49835933, 2021-03-27 18:04:02, lopy47242, 7242, 3133303759003D00, LORA, SF12BW125, -5.00, -115.00, 867.900, 4, 53.083063, 8.841476, 44.3, 10.72, 0.0, 0, gps, bici121, null 49835932, 2021-03-27 18:04:02, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, 8.20, -77.00, 867.900, 4, 53.083063, 8.841476, 44.3, 10.72, 0.0, 0, gps, bici121, null 49835931, 2021-03-27 18:04:02, lopy47242, 7242, FCC23DFFFE0A9698, LORA, SF12BW125, -8.50, -113.00, 867.900, 4, 53.083063, 8.841476, 44.3, 10.72, 0.0, 0, gps, bici121, null 49835784, 2021-03-27 18:02:40, lopy47242, 7242, 3133303759003D00, LORA, SF12BW125, -8.75, -116.00, 868.100, 3, 53.082679, 8.838712, 42.5, 9.65, 0.0, 0, gps, bici121, null 49835783, 2021-03-27 18:02:40, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, 8.80, -79.00, 868.100, 3, 53.082679, 8.838712, 42.5, 9.65, 0.0, 0, gps, bici121, null 49835782, 2021-03-27 18:02:40, lopy47242, 7242, FCC23DFFFE0A9698, LORA, SF12BW125, -4.00, -115.00, 868.100, 3, 53.082679, 8.838712, 42.5, 9.65, 0.0, 0, gps, bici121, null 49835640, 2021-03-27 18:01:18, lopy47242, 7242, FCC23DFFFE0A9698, LORA, SF12BW125, -5.80, -104.00, 868.100, 2, 53.082383, 8.836970, 54.1, 9.65, 0.0, 0, gps, bici121, null 49835639, 2021-03-27 18:01:18, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, 9.80, -85.00, 868.100, 2, 53.082383, 8.836970, 54.1, 9.65, 0.0, 0, gps, bici121, null 49835484, 2021-03-27 17:59:56, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, 8.50, -80.00, 867.300, 1, 53.082587, 8.836785, 64.4, 10.72, 0.0, 0, gps, bici121, null 49835483, 2021-03-27 17:59:56, lopy47242, 7242, FCC23DFFFE0A9698, LORA, SF12BW125, 3.80, -105.00, 867.300, 1, 53.082587, 8.836785, 64.4, 10.72, 0.0, 0, gps, bici121, null 49835355, 2021-03-27 17:58:34, lopy47242, 7242, 3133303759003D00, LORA, SF12BW125, -9.50, -116.00, 867.100, 0, 53.082596, 8.836779, 64.8, 9.65, 0.0, 0, gps, bici121, null 49835354, 2021-03-27 17:58:34, lopy47242, 7242, FCC23DFFFE0B696A, LORA, SF12BW125, 7.50, -87.00, 867.100, 0, 53.082596, 8.836779, 64.8, 9.65, 0.0, 0, gps, bici121, null 49835353, 2021-03-27 17:58:34, lopy47242, 7242, FCC23DFFFE0A9698, LORA, SF12BW125, 1.50, -110.00, 867.100, 0, 53.082596, 8.836779, 64.8, 9.65, 0.0, 0, gps, bici121, null Number of rows dumped: 74