participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
459 rows where station_code = "ZA0008" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
5579445 | 5579445 | 20241121224343_UQJJn | ZA0008 | 2024-11-23T14:18:25.643Z | 2024-11-23T14:21:25.032Z |
5579317 | 5579317 | 20241121222527_nayj2 | ZA0008 | 2024-11-23T14:18:10.628Z | 2024-11-23T14:21:25.007Z |
5579266 | 5579266 | 20241121221613_UU3qZ | ZA0008 | 2024-11-23T14:18:06.142Z | 2024-11-23T14:21:24.997Z |
5579251 | 5579251 | 20241121221408_Ks4JS | ZA0008 | 2024-11-23T14:18:05.075Z | 2024-11-23T14:21:24.994Z |
5579231 | 5579231 | 20241121220514_cbvnm | ZA0008 | 2024-11-23T14:18:01.384Z | 2024-11-23T14:21:24.989Z |
5579157 | 5579157 | 20241121215422_FHRkr | ZA0008 | 2024-11-23T14:17:56.216Z | 2024-11-23T14:21:24.975Z |
5579110 | 5579110 | 20241121214715_ZuW75 | ZA0008 | 2024-11-23T14:17:50.593Z | 2024-11-23T14:21:24.967Z |
5579108 | 5579108 | 20241121214704_vbmxa | ZA0008 | 2024-11-23T14:17:50.420Z | 2024-11-23T14:21:24.966Z |
5578804 | 5578804 | 20241121210316_vDwdn | ZA0008 | 2024-11-23T14:17:34.403Z | 2024-11-23T14:21:24.915Z |
5578770 | 5578770 | 20241121205815_LMbV0 | ZA0008 | 2024-11-23T14:17:32.673Z | 2024-11-23T14:21:24.907Z |
5578234 | 5578234 | 20241121191422_dzNvV | ZA0008 | 2024-11-23T14:16:37.521Z | 2024-11-23T14:21:24.789Z |
5578166 | 5578166 | 20241121190254_59dgZ | ZA0008 | 2024-11-23T14:16:32.634Z | 2024-11-23T14:21:24.773Z |
5577964 | 5577964 | 20241121182356_oQwqm | ZA0008 | 2024-11-23T14:16:19.735Z | 2024-11-23T14:21:24.729Z |
5541237 | 5541237 | 20241113214427_rVp83 | ZA0008 | 2024-11-15T14:07:05.332Z | 2024-11-22T14:24:17.351Z |
5541227 | 5541227 | 20241113211156_kh3yJ | ZA0008 | 2024-11-15T14:06:59.980Z | 2024-11-22T14:24:17.251Z |
5541206 | 5541206 | 20241113194109_SQp5n | ZA0008 | 2024-11-15T14:06:56.334Z | 2024-11-22T14:24:16.773Z |
5541179 | 5541179 | 20241113185015_ZYIJX | ZA0008 | 2024-11-15T14:06:51.057Z | 2024-11-22T14:24:16.322Z |
5537392 | 5537392 | 20241112223608_MEzt3 | ZA0008 | 2024-11-14T14:11:43.856Z | 2024-11-21T14:26:12.548Z |
5537215 | 5537215 | 20241112210359_QbAuP | ZA0008 | 2024-11-14T14:11:19.747Z | 2024-11-21T14:26:09.820Z |
5537205 | 5537205 | 20241112205956_NSWfn | ZA0008 | 2024-11-14T14:11:18.220Z | 2024-11-21T14:26:09.688Z |
5537072 | 5537072 | 20241112202057_swiEE | ZA0008 | 2024-11-14T14:10:58.814Z | 2024-11-21T14:26:08.665Z |
5537066 | 5537066 | 20241112202008_12zaq | ZA0008 | 2024-11-14T14:10:57.723Z | 2024-11-21T14:26:08.656Z |
5537035 | 5537035 | 20241112200927_b94VF | ZA0008 | 2024-11-14T14:10:53.091Z | 2024-11-21T14:26:08.424Z |
5536956 | 5536956 | 20241112194909_HmcBu | ZA0008 | 2024-11-14T14:10:46.453Z | 2024-11-21T14:26:07.343Z |
5536919 | 5536919 | 20241112194047_OXhk8 | ZA0008 | 2024-11-14T14:10:41.653Z | 2024-11-21T14:26:07.177Z |
5536843 | 5536843 | 20241112192441_U1Pqp | ZA0008 | 2024-11-14T14:10:36.750Z | 2024-11-21T14:26:06.289Z |
5536763 | 5536763 | 20241112190213_at8tT | ZA0008 | 2024-11-14T14:10:32.202Z | 2024-11-21T14:26:05.425Z |
5536752 | 5536752 | 20241112190203_221Qo | ZA0008 | 2024-11-14T14:10:31.859Z | 2024-11-21T14:26:05.366Z |
5536542 | 5536542 | 20241112182618_itFGp | ZA0008 | 2024-11-14T14:10:12.955Z | 2024-11-21T14:26:02.596Z |
5528683 | 5528683 | 20241111221451_1XMG3 | ZA0008 | 2024-11-13T14:11:16.224Z | 2024-11-20T14:25:33.583Z |
5528488 | 5528488 | 20241111211034_lYtfx | ZA0008 | 2024-11-13T14:10:52.881Z | 2024-11-20T14:25:31.177Z |
5528364 | 5528364 | 20241111203059_B2owK | ZA0008 | 2024-11-13T14:10:30.503Z | 2024-11-20T14:25:28.954Z |
5528351 | 5528351 | 20241111202754_jcs6P | ZA0008 | 2024-11-13T14:10:29.552Z | 2024-11-20T14:25:28.879Z |
5528186 | 5528186 | 20241111195039_ACfvA | ZA0008 | 2024-11-13T14:10:13.582Z | 2024-11-20T14:25:26.392Z |
5528171 | 5528171 | 20241111194838_0rNeK | ZA0008 | 2024-11-13T14:10:12.108Z | 2024-11-20T14:25:26.290Z |
5527967 | 5527967 | 20241111190814_qBR8s | ZA0008 | 2024-11-13T14:09:38.594Z | 2024-11-20T14:25:23.644Z |
5527776 | 5527776 | 20241111183303_h0siB | ZA0008 | 2024-11-13T14:09:06.267Z | 2024-11-20T14:25:20.045Z |
5515441 | 5515441 | 20241109212526_LiqsQ | ZA0008 | 2024-11-11T14:11:04.860Z | 2024-11-18T14:26:26.051Z |
5515397 | 5515397 | 20241109210653_2lMzW | ZA0008 | 2024-11-11T14:10:55.411Z | 2024-11-18T14:26:25.822Z |
5515395 | 5515395 | 20241109210639_qciQY | ZA0008 | 2024-11-11T14:10:54.909Z | 2024-11-18T14:26:25.821Z |
5515374 | 5515374 | 20241109210135_DzXyh | ZA0008 | 2024-11-11T14:10:51.854Z | 2024-11-18T14:26:25.742Z |
5515353 | 5515353 | 20241109204926_KoY7w | ZA0008 | 2024-11-11T14:10:49.576Z | 2024-11-18T14:26:25.670Z |
5515323 | 5515323 | 20241109203337_LCdu3 | ZA0008 | 2024-11-11T14:10:43.396Z | 2024-11-18T14:26:25.482Z |
5515274 | 5515274 | 20241109201054_fZux0 | ZA0008 | 2024-11-11T14:10:32.268Z | 2024-11-18T14:26:25.220Z |
5515252 | 5515252 | 20241109200431_tPAPh | ZA0008 | 2024-11-11T14:10:27.700Z | 2024-11-18T14:26:25.119Z |
5515039 | 5515039 | 20241109190838_X7uuT | ZA0008 | 2024-11-11T14:09:56.560Z | 2024-11-18T14:26:24.006Z |
5514924 | 5514924 | 20241109183155_IubmD | ZA0008 | 2024-11-11T14:09:44.223Z | 2024-11-18T14:26:23.330Z |
5509262 | 5509262 | 20241108223812_NUD81 | ZA0008 | 2024-11-10T14:13:04.283Z | 2024-11-17T14:23:42.116Z |
5509103 | 5509103 | 20241108215144_VOUCe | ZA0008 | 2024-11-10T14:12:33.510Z | 2024-11-17T14:23:40.312Z |
5508920 | 5508920 | 20241108204741_2bG8S | ZA0008 | 2024-11-10T14:12:03.874Z | 2024-11-17T14:23:36.995Z |
5508857 | 5508857 | 20241108200338_Cg5Rq | ZA0008 | 2024-11-10T14:11:57.081Z | 2024-11-17T14:23:34.711Z |
5508826 | 5508826 | 20241108194305_tJVQG | ZA0008 | 2024-11-10T14:11:53.366Z | 2024-11-17T14:23:34.301Z |
5508806 | 5508806 | 20241108193548_RPbE7 | ZA0008 | 2024-11-10T14:11:50.437Z | 2024-11-17T14:23:34.096Z |
5508784 | 5508784 | 20241108192117_OmyRW | ZA0008 | 2024-11-10T14:11:48.573Z | 2024-11-17T14:23:33.459Z |
5503594 | 5503594 | 20241107225932_SO73g | ZA0008 | 2024-11-09T14:13:23.046Z | 2024-11-16T14:28:09.543Z |
5503429 | 5503429 | 20241107221817_jXiD7 | ZA0008 | 2024-11-09T14:13:02.920Z | 2024-11-16T14:28:07.142Z |
5503139 | 5503139 | 20241107204629_2MRKk | ZA0008 | 2024-11-09T14:12:27.103Z | 2024-11-16T14:28:03.559Z |
5503114 | 5503114 | 20241107204348_9OlxK | ZA0008 | 2024-11-09T14:12:25.898Z | 2024-11-16T14:28:03.235Z |
5502939 | 5502939 | 20241107201423_Zq1hQ | ZA0008 | 2024-11-09T14:12:13.579Z | 2024-11-16T14:28:00.796Z |
5502906 | 5502906 | 20241107201016_hGuzj | ZA0008 | 2024-11-09T14:12:11.695Z | 2024-11-16T14:28:00.469Z |
5502904 | 5502904 | 20241107201009_DYCeo | ZA0008 | 2024-11-09T14:12:11.681Z | 2024-11-16T14:28:00.454Z |
5502889 | 5502889 | 20241107200635_k9WTa | ZA0008 | 2024-11-09T14:12:10.563Z | 2024-11-16T14:28:00.233Z |
5502854 | 5502854 | 20241107195719_3z1bX | ZA0008 | 2024-11-09T14:12:07.987Z | 2024-11-16T14:27:59.853Z |
5502698 | 5502698 | 20241107193239_2frjd | ZA0008 | 2024-11-09T14:11:58.710Z | 2024-11-16T14:27:58.771Z |
5502616 | 5502616 | 20241107191817_3myGg | ZA0008 | 2024-11-09T14:11:51.550Z | 2024-11-16T14:27:58.030Z |
5502599 | 5502599 | 20241107191443_WrdnC | ZA0008 | 2024-11-09T14:11:48.115Z | 2024-11-16T14:27:57.854Z |
5502550 | 5502550 | 20241107190355_bM1hP | ZA0008 | 2024-11-09T14:11:43.642Z | 2024-11-16T14:27:57.434Z |
5502483 | 5502483 | 20241107184502_Ujs5E | ZA0008 | 2024-11-09T14:11:28.577Z | 2024-11-16T14:27:56.210Z |
5502449 | 5502449 | 20241107183446_O13Le | ZA0008 | 2024-11-09T14:11:23.073Z | 2024-11-16T14:27:55.747Z |
5496128 | 5496128 | 20241106230259_DQ4jP | ZA0008 | 2024-11-08T14:11:36.630Z | 2024-11-15T14:24:55.476Z |
5495910 | 5495910 | 20241106220308_701A4 | ZA0008 | 2024-11-08T14:11:05.905Z | 2024-11-15T14:24:53.851Z |
5495905 | 5495905 | 20241106220114_X0aWi | ZA0008 | 2024-11-08T14:11:05.767Z | 2024-11-15T14:24:53.848Z |
5495894 | 5495894 | 20241106215855_KLETu | ZA0008 | 2024-11-08T14:11:04.502Z | 2024-11-15T14:24:53.828Z |
5495870 | 5495870 | 20241106215339_ZpYrX | ZA0008 | 2024-11-08T14:11:03.011Z | 2024-11-15T14:24:53.677Z |
5495836 | 5495836 | 20241106214324_H5wWG | ZA0008 | 2024-11-08T14:10:57.823Z | 2024-11-15T14:24:53.494Z |
5495789 | 5495789 | 20241106213453_SKwBH | ZA0008 | 2024-11-08T14:10:52.482Z | 2024-11-15T14:24:53.266Z |
5495740 | 5495740 | 20241106211857_7FvDM | ZA0008 | 2024-11-08T14:10:44.294Z | 2024-11-15T14:24:52.800Z |
5495697 | 5495697 | 20241106210512_J2XmM | ZA0008 | 2024-11-08T14:10:38.643Z | 2024-11-15T14:24:52.408Z |
5495690 | 5495690 | 20241106210412_ZbO22 | ZA0008 | 2024-11-08T14:10:37.860Z | 2024-11-15T14:24:52.341Z |
5495647 | 5495647 | 20241106204943_yzAYP | ZA0008 | 2024-11-08T14:10:32.767Z | 2024-11-15T14:24:51.819Z |
5495626 | 5495626 | 20241106204300_SLCYE | ZA0008 | 2024-11-08T14:10:30.574Z | 2024-11-15T14:24:51.721Z |
5495618 | 5495618 | 20241106203926_B3DGW | ZA0008 | 2024-11-08T14:10:29.285Z | 2024-11-15T14:24:51.627Z |
5495407 | 5495407 | 20241106194215_mqxBK | ZA0008 | 2024-11-08T14:10:11.581Z | 2024-11-15T14:24:48.711Z |
5495386 | 5495386 | 20241106194046_yqfJT | ZA0008 | 2024-11-08T14:10:10.536Z | 2024-11-15T14:24:48.676Z |
5495316 | 5495316 | 20241106192157_HZk3l | ZA0008 | 2024-11-08T14:09:56.297Z | 2024-11-15T14:24:48.249Z |
5495266 | 5495266 | 20241106191057_2EsuS | ZA0008 | 2024-11-08T14:09:46.841Z | 2024-11-15T14:24:47.947Z |
5495261 | 5495261 | 20241106190730_mSbxJ | ZA0008 | 2024-11-08T14:09:45.423Z | 2024-11-15T14:24:47.885Z |
5495091 | 5495091 | 20241106183642_hu5Ru | ZA0008 | 2024-11-08T14:09:16.855Z | 2024-11-15T14:24:46.599Z |
5495025 | 5495025 | 20241106182119_VXFYB | ZA0008 | 2024-11-08T14:09:03.763Z | 2024-11-15T14:24:45.641Z |
5494995 | 5494995 | 20241106180944_9Hkt7 | ZA0008 | 2024-11-08T14:08:56.778Z | 2024-11-15T14:24:45.257Z |
5490360 | 5490360 | 20241105222211_v8wCB | ZA0008 | 2024-11-07T14:13:55.495Z | 2024-11-14T14:23:19.132Z |
5490250 | 5490250 | 20241105214734_FTrSR | ZA0008 | 2024-11-07T14:13:43.430Z | 2024-11-14T14:23:18.392Z |
5490049 | 5490049 | 20241105204758_xThyz | ZA0008 | 2024-11-07T14:13:06.260Z | 2024-11-14T14:23:17.238Z |
5489656 | 5489656 | 20241105193640_shZml | ZA0008 | 2024-11-07T14:12:29.773Z | 2024-11-14T14:23:14.904Z |
5489585 | 5489585 | 20241105192214_Plyav | ZA0008 | 2024-11-07T14:12:14.267Z | 2024-11-14T14:23:13.866Z |
5489575 | 5489575 | 20241105192028_MyyJU | ZA0008 | 2024-11-07T14:12:13.718Z | 2024-11-14T14:23:13.859Z |
5489243 | 5489243 | 20241105181438_INHEE | ZA0008 | 2024-11-07T14:11:38.459Z | 2024-11-14T14:23:11.168Z |
5467572 | 5467572 | 20241102215439_w4atx | ZA0008 | 2024-11-04T14:12:04.853Z | 2024-11-11T14:22:47.602Z |
5466742 | 5466742 | 20241102184403_7EpRW | ZA0008 | 2024-11-04T14:09:40.901Z | 2024-11-11T14:22:42.974Z |
5461907 | 5461907 | 20241101220729_3j2VY | ZA0008 | 2024-11-03T14:16:42.987Z | 2024-11-10T14:26:30.777Z |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE participating_station ( meteor_unique_trajectory_identifier text NOT NULL, station_code text NOT NULL, created_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), updated_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier), FOREIGN KEY (station_code) REFERENCES station (code), UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE ); CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier); CREATE INDEX participating_station_created_at_index ON participating_station (created_at); CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);