participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
406 rows where station_code = "ZA0006" 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 |
---|---|---|---|---|---|
5579443 | 5579443 | 20241121224343_UQJJn | ZA0006 | 2024-11-23T14:18:25.643Z | 2024-11-23T14:21:25.032Z |
5578233 | 5578233 | 20241121191422_dzNvV | ZA0006 | 2024-11-23T14:16:37.505Z | 2024-11-23T14:21:24.789Z |
5541226 | 5541226 | 20241113211156_kh3yJ | ZA0006 | 2024-11-15T14:06:59.980Z | 2024-11-22T14:24:17.251Z |
5541215 | 5541215 | 20241113200943_HeMNg | ZA0006 | 2024-11-15T14:06:57.606Z | 2024-11-22T14:24:17.063Z |
5541205 | 5541205 | 20241113194109_SQp5n | ZA0006 | 2024-11-15T14:06:56.334Z | 2024-11-22T14:24:16.773Z |
5541178 | 5541178 | 20241113185015_ZYIJX | ZA0006 | 2024-11-15T14:06:51.044Z | 2024-11-22T14:24:16.322Z |
5537416 | 5537416 | 20241112224621_83TfZ | ZA0006 | 2024-11-14T14:11:46.478Z | 2024-11-21T14:26:12.798Z |
5537214 | 5537214 | 20241112210359_QbAuP | ZA0006 | 2024-11-14T14:11:19.747Z | 2024-11-21T14:26:09.820Z |
5537204 | 5537204 | 20241112205956_NSWfn | ZA0006 | 2024-11-14T14:11:18.220Z | 2024-11-21T14:26:09.688Z |
5537190 | 5537190 | 20241112205400_uDt2D | ZA0006 | 2024-11-14T14:11:16.200Z | 2024-11-21T14:26:09.579Z |
5537161 | 5537161 | 20241112204034_PJtFE | ZA0006 | 2024-11-14T14:11:09.959Z | 2024-11-21T14:26:09.418Z |
5537088 | 5537088 | 20241112202434_24mWz | ZA0006 | 2024-11-14T14:11:00.681Z | 2024-11-21T14:26:08.730Z |
5537065 | 5537065 | 20241112202008_12zaq | ZA0006 | 2024-11-14T14:10:57.723Z | 2024-11-21T14:26:08.656Z |
5537034 | 5537034 | 20241112200927_b94VF | ZA0006 | 2024-11-14T14:10:53.091Z | 2024-11-21T14:26:08.424Z |
5536955 | 5536955 | 20241112194909_HmcBu | ZA0006 | 2024-11-14T14:10:46.453Z | 2024-11-21T14:26:07.343Z |
5536918 | 5536918 | 20241112194047_OXhk8 | ZA0006 | 2024-11-14T14:10:41.652Z | 2024-11-21T14:26:07.177Z |
5536842 | 5536842 | 20241112192441_U1Pqp | ZA0006 | 2024-11-14T14:10:36.750Z | 2024-11-21T14:26:06.289Z |
5536762 | 5536762 | 20241112190213_at8tT | ZA0006 | 2024-11-14T14:10:32.202Z | 2024-11-21T14:26:05.425Z |
5536751 | 5536751 | 20241112190203_221Qo | ZA0006 | 2024-11-14T14:10:31.859Z | 2024-11-21T14:26:05.366Z |
5536541 | 5536541 | 20241112182618_itFGp | ZA0006 | 2024-11-14T14:10:12.895Z | 2024-11-21T14:26:02.596Z |
5528542 | 5528542 | 20241111212954_Qf23G | ZA0006 | 2024-11-13T14:11:04.908Z | 2024-11-20T14:25:32.070Z |
5528522 | 5528522 | 20241111212137_sDh4a | ZA0006 | 2024-11-13T14:11:02.880Z | 2024-11-20T14:25:31.825Z |
5528363 | 5528363 | 20241111203059_B2owK | ZA0006 | 2024-11-13T14:10:30.503Z | 2024-11-20T14:25:28.954Z |
5528349 | 5528349 | 20241111202754_jcs6P | ZA0006 | 2024-11-13T14:10:29.552Z | 2024-11-20T14:25:28.879Z |
5528170 | 5528170 | 20241111194838_0rNeK | ZA0006 | 2024-11-13T14:10:12.108Z | 2024-11-20T14:25:26.290Z |
5527966 | 5527966 | 20241111190814_qBR8s | ZA0006 | 2024-11-13T14:09:38.594Z | 2024-11-20T14:25:23.644Z |
5515588 | 5515588 | 20241109220527_QsR8e | ZA0006 | 2024-11-11T14:11:15.602Z | 2024-11-18T14:26:26.911Z |
5515352 | 5515352 | 20241109204926_KoY7w | ZA0006 | 2024-11-11T14:10:49.576Z | 2024-11-18T14:26:25.670Z |
5515339 | 5515339 | 20241109203852_ZGPiU | ZA0006 | 2024-11-11T14:10:47.641Z | 2024-11-18T14:26:25.637Z |
5515329 | 5515329 | 20241109203635_bsgSP | ZA0006 | 2024-11-11T14:10:45.444Z | 2024-11-18T14:26:25.528Z |
5515273 | 5515273 | 20241109201054_fZux0 | ZA0006 | 2024-11-11T14:10:32.268Z | 2024-11-18T14:26:25.220Z |
5515155 | 5515155 | 20241109194138_BrVK3 | ZA0006 | 2024-11-11T14:10:12.316Z | 2024-11-18T14:26:24.569Z |
5515038 | 5515038 | 20241109190838_X7uuT | ZA0006 | 2024-11-11T14:09:56.560Z | 2024-11-18T14:26:24.006Z |
5514992 | 5514992 | 20241109185257_HffOl | ZA0006 | 2024-11-11T14:09:51.997Z | 2024-11-18T14:26:23.727Z |
5514923 | 5514923 | 20241109183155_IubmD | ZA0006 | 2024-11-11T14:09:44.204Z | 2024-11-18T14:26:23.330Z |
5508962 | 5508962 | 20241108210122_Ae7gX | ZA0006 | 2024-11-10T14:12:10.071Z | 2024-11-17T14:23:38.209Z |
5508825 | 5508825 | 20241108194305_tJVQG | ZA0006 | 2024-11-10T14:11:53.366Z | 2024-11-17T14:23:34.301Z |
5508783 | 5508783 | 20241108192117_OmyRW | ZA0006 | 2024-11-10T14:11:48.556Z | 2024-11-17T14:23:33.459Z |
5503515 | 5503515 | 20241107223902_QFITs | ZA0006 | 2024-11-09T14:13:14.636Z | 2024-11-16T14:28:08.406Z |
5503113 | 5503113 | 20241107204348_9OlxK | ZA0006 | 2024-11-09T14:12:25.898Z | 2024-11-16T14:28:03.234Z |
5502938 | 5502938 | 20241107201423_Zq1hQ | ZA0006 | 2024-11-09T14:12:13.579Z | 2024-11-16T14:28:00.796Z |
5502907 | 5502907 | 20241107201106_7L33G | ZA0006 | 2024-11-09T14:12:11.785Z | 2024-11-16T14:28:00.475Z |
5502902 | 5502902 | 20241107201009_DYCeo | ZA0006 | 2024-11-09T14:12:11.681Z | 2024-11-16T14:28:00.454Z |
5502615 | 5502615 | 20241107191817_3myGg | ZA0006 | 2024-11-09T14:11:51.550Z | 2024-11-16T14:27:58.030Z |
5502549 | 5502549 | 20241107190355_bM1hP | ZA0006 | 2024-11-09T14:11:43.642Z | 2024-11-16T14:27:57.434Z |
5502450 | 5502450 | 20241107183454_hr4HZ | ZA0006 | 2024-11-09T14:11:23.278Z | 2024-11-16T14:27:55.949Z |
5495646 | 5495646 | 20241106204943_yzAYP | ZA0006 | 2024-11-08T14:10:32.767Z | 2024-11-15T14:24:51.819Z |
5495603 | 5495603 | 20241106203035_1IJwx | ZA0006 | 2024-11-08T14:10:27.618Z | 2024-11-15T14:24:51.242Z |
5495594 | 5495594 | 20241106202853_q1y3i | ZA0006 | 2024-11-08T14:10:26.811Z | 2024-11-15T14:24:51.033Z |
5495315 | 5495315 | 20241106192157_HZk3l | ZA0006 | 2024-11-08T14:09:56.297Z | 2024-11-15T14:24:48.249Z |
5495265 | 5495265 | 20241106191057_2EsuS | ZA0006 | 2024-11-08T14:09:46.841Z | 2024-11-15T14:24:47.947Z |
5495260 | 5495260 | 20241106190730_mSbxJ | ZA0006 | 2024-11-08T14:09:45.423Z | 2024-11-15T14:24:47.885Z |
5495033 | 5495033 | 20241106182234_9NJVU | ZA0006 | 2024-11-08T14:09:05.122Z | 2024-11-15T14:24:45.739Z |
5495024 | 5495024 | 20241106182119_VXFYB | ZA0006 | 2024-11-08T14:09:03.763Z | 2024-11-15T14:24:45.641Z |
5494993 | 5494993 | 20241106180944_9Hkt7 | ZA0006 | 2024-11-08T14:08:56.736Z | 2024-11-15T14:24:45.257Z |
5490249 | 5490249 | 20241105214734_FTrSR | ZA0006 | 2024-11-07T14:13:43.430Z | 2024-11-14T14:23:18.392Z |
5490223 | 5490223 | 20241105214436_ru5Jw | ZA0006 | 2024-11-07T14:13:36.949Z | 2024-11-14T14:23:18.332Z |
5490091 | 5490091 | 20241105205606_l5vZt | ZA0006 | 2024-11-07T14:13:09.815Z | 2024-11-14T14:23:17.471Z |
5490048 | 5490048 | 20241105204758_xThyz | ZA0006 | 2024-11-07T14:13:06.260Z | 2024-11-14T14:23:17.238Z |
5489617 | 5489617 | 20241105192815_ctds0 | ZA0006 | 2024-11-07T14:12:19.558Z | 2024-11-14T14:23:14.248Z |
5489584 | 5489584 | 20241105192214_Plyav | ZA0006 | 2024-11-07T14:12:14.267Z | 2024-11-14T14:23:13.866Z |
5489574 | 5489574 | 20241105192028_MyyJU | ZA0006 | 2024-11-07T14:12:13.718Z | 2024-11-14T14:23:13.859Z |
5489462 | 5489462 | 20241105190108_gD28H | ZA0006 | 2024-11-07T14:12:04.150Z | 2024-11-14T14:23:13.410Z |
5489242 | 5489242 | 20241105181438_INHEE | ZA0006 | 2024-11-07T14:11:38.453Z | 2024-11-14T14:23:11.168Z |
5467571 | 5467571 | 20241102215439_w4atx | ZA0006 | 2024-11-04T14:12:04.853Z | 2024-11-11T14:22:47.602Z |
5466741 | 5466741 | 20241102184403_7EpRW | ZA0006 | 2024-11-04T14:09:40.889Z | 2024-11-11T14:22:42.974Z |
5461847 | 5461847 | 20241101214740_iAkcp | ZA0006 | 2024-11-03T14:16:26.861Z | 2024-11-10T14:26:30.604Z |
5450892 | 5450892 | 20241031213452_SxY1X | ZA0006 | 2024-11-02T12:16:12.513Z | 2024-11-09T14:24:19.639Z |
5450814 | 5450814 | 20241031211339_rIeei | ZA0006 | 2024-11-02T12:15:58.608Z | 2024-11-09T14:24:18.484Z |
5450681 | 5450681 | 20241031201812_n3KLQ | ZA0006 | 2024-11-02T12:15:44.259Z | 2024-11-09T14:24:17.490Z |
5450666 | 5450666 | 20241031201402_u6JL1 | ZA0006 | 2024-11-02T12:15:43.254Z | 2024-11-09T14:24:17.422Z |
5450415 | 5450415 | 20241031191323_d3ARN | ZA0006 | 2024-11-02T12:15:14.641Z | 2024-11-09T14:24:15.895Z |
5450322 | 5450322 | 20241031184254_tW0UA | ZA0006 | 2024-11-02T12:14:58.351Z | 2024-11-09T14:24:15.420Z |
5441352 | 5441352 | 20241029215006_A52Y2 | ZA0006 | 2024-11-01T12:18:28.703Z | 2024-11-07T14:26:41.851Z |
5441136 | 5441136 | 20241029205521_34EKs | ZA0006 | 2024-11-01T12:18:09.971Z | 2024-11-07T14:26:40.886Z |
5441110 | 5441110 | 20241029204825_u3DTu | ZA0006 | 2024-11-01T12:18:07.373Z | 2024-11-07T14:26:40.781Z |
5433428 | 5433428 | 20241029195608_G3tf3 | ZA0006 | 2024-10-31T12:22:14.858Z | 2024-11-07T14:26:39.482Z |
5433273 | 5433273 | 20241029184353_LWFQH | ZA0006 | 2024-10-31T12:22:03.300Z | 2024-11-07T14:26:37.436Z |
5429801 | 5429801 | 20241028200702_8di5S | ZA0006 | 2024-10-31T12:17:03.266Z | 2024-11-06T14:27:17.597Z |
5429706 | 5429706 | 20241028195227_MGgD2 | ZA0006 | 2024-10-31T12:16:56.052Z | 2024-11-06T14:27:17.420Z |
5403814 | 5403814 | 20241026223306_2zrGO | ZA0006 | 2024-10-29T12:10:15.550Z | 2024-11-04T14:28:49.785Z |
5403741 | 5403741 | 20241026222708_ZZjbm | ZA0006 | 2024-10-29T12:10:10.868Z | 2024-11-04T14:28:49.532Z |
5403722 | 5403722 | 20241026222515_iC7rO | ZA0006 | 2024-10-29T12:10:09.841Z | 2024-11-04T14:28:49.520Z |
5403703 | 5403703 | 20241026222408_glSJJ | ZA0006 | 2024-10-29T12:10:08.507Z | 2024-11-04T14:28:49.501Z |
5403589 | 5403589 | 20241026221427_4OxyI | ZA0006 | 2024-10-29T12:10:00.608Z | 2024-11-04T14:28:49.294Z |
5403181 | 5403181 | 20241026212640_2n4Bl | ZA0006 | 2024-10-29T12:09:10.978Z | 2024-11-04T14:28:47.927Z |
5395000 | 5395000 | 20241025215832_E55gh | ZA0006 | 2024-10-28T12:15:52.409Z | 2024-11-03T14:27:23.633Z |
5394877 | 5394877 | 20241025213844_3t6Xp | ZA0006 | 2024-10-28T12:15:36.653Z | 2024-11-03T14:27:23.256Z |
5394724 | 5394724 | 20241025211613_Tvbh9 | ZA0006 | 2024-10-28T12:15:18.164Z | 2024-11-03T14:27:22.411Z |
5394599 | 5394599 | 20241025205519_RMESS | ZA0006 | 2024-10-28T12:15:03.113Z | 2024-11-03T14:27:21.796Z |
5394532 | 5394532 | 20241025204616_ax4G3 | ZA0006 | 2024-10-28T12:14:51.581Z | 2024-11-03T14:27:21.467Z |
5394361 | 5394361 | 20241025202115_EEVmn | ZA0006 | 2024-10-28T12:14:29.426Z | 2024-11-03T14:27:21.016Z |
5394334 | 5394334 | 20241025201642_veGmb | ZA0006 | 2024-10-28T12:14:23.915Z | 2024-11-03T14:27:20.912Z |
5393897 | 5393897 | 20241025190622_4D0mz | ZA0006 | 2024-10-28T12:13:49.534Z | 2024-11-03T14:27:18.836Z |
5385042 | 5385042 | 20241024214032_IJ5nW | ZA0006 | 2024-10-27T12:18:16.991Z | 2024-11-02T12:28:28.982Z |
5385016 | 5385016 | 20241024213744_rwcAh | ZA0006 | 2024-10-27T12:18:13.719Z | 2024-11-02T12:28:28.932Z |
5385006 | 5385006 | 20241024213509_nNDZf | ZA0006 | 2024-10-27T12:18:11.794Z | 2024-11-02T12:28:28.914Z |
5384979 | 5384979 | 20241024213013_96eHx | ZA0006 | 2024-10-27T12:18:06.707Z | 2024-11-02T12:28:28.839Z |
5384945 | 5384945 | 20241024211937_2O8wb | ZA0006 | 2024-10-27T12:18:02.417Z | 2024-11-02T12:28:28.776Z |
5384854 | 5384854 | 20241024210419_6IENG | ZA0006 | 2024-10-27T12:17:50.765Z | 2024-11-02T12:28:28.514Z |
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);