participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
198 rows where station_code = "ZA0007" 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 |
---|---|---|---|---|---|
5461906 | 5461906 | 20241101220729_3j2VY | ZA0007 | 2024-11-03T14:16:42.987Z | 2024-11-05T14:22:52.926Z |
5461894 | 5461894 | 20241101220327_t7q5a | ZA0007 | 2024-11-03T14:16:38.659Z | 2024-11-05T14:22:52.834Z |
5461872 | 5461872 | 20241101215519_7JrdL | ZA0007 | 2024-11-03T14:16:30.517Z | 2024-11-05T14:22:51.757Z |
5461740 | 5461740 | 20241101210417_2FYiq | ZA0007 | 2024-11-03T14:16:09.189Z | 2024-11-05T14:22:50.341Z |
5451062 | 5451062 | 20241031223004_xB3cI | ZA0007 | 2024-11-02T12:16:33.387Z | 2024-11-05T14:24:07.277Z |
5450976 | 5450976 | 20241031220703_A0Tt7 | ZA0007 | 2024-11-02T12:16:26.910Z | 2024-11-05T14:24:06.605Z |
5450942 | 5450942 | 20241031215904_Z6pkL | ZA0007 | 2024-11-02T12:16:20.181Z | 2024-11-05T14:24:06.443Z |
5450779 | 5450779 | 20241031205437_gwoZ6 | ZA0007 | 2024-11-02T12:15:52.238Z | 2024-11-05T14:24:04.556Z |
5450471 | 5450471 | 20241031192452_YTJfF | ZA0007 | 2024-11-02T12:15:27.086Z | 2024-11-05T14:24:01.829Z |
5450416 | 5450416 | 20241031191323_d3ARN | ZA0007 | 2024-11-02T12:15:14.641Z | 2024-11-05T14:24:01.162Z |
5371895 | 5371895 | 20241023220048_IXRRN | ZA0007 | 2024-10-26T12:17:53.737Z | 2024-11-01T12:26:54.242Z |
5364580 | 5364580 | 20241023223853_lq2m2 | ZA0007 | 2024-10-25T12:17:25.167Z | 2024-11-01T12:26:55.224Z |
5364391 | 5364391 | 20241023222610_53iys | ZA0007 | 2024-10-25T12:17:19.348Z | 2024-11-01T12:26:55.033Z |
5364279 | 5364279 | 20241023221843_T5WFO | ZA0007 | 2024-10-25T12:17:15.170Z | 2024-11-01T12:26:54.653Z |
5363496 | 5363496 | 20241023211350_lcRb5 | ZA0007 | 2024-10-25T12:16:16.353Z | 2024-11-01T12:26:53.325Z |
5350786 | 5350786 | 20241022222753_OGDL7 | ZA0007 | 2024-10-24T12:16:33.042Z | 2024-10-31T12:29:58.786Z |
5350718 | 5350718 | 20241022222134_aR0Ws | ZA0007 | 2024-10-24T12:16:20.921Z | 2024-10-31T12:29:58.703Z |
5350608 | 5350608 | 20241022220805_K2Pn7 | ZA0007 | 2024-10-24T12:16:04.300Z | 2024-10-31T12:29:58.550Z |
5350479 | 5350479 | 20241022215501_mUGW8 | ZA0007 | 2024-10-24T12:15:48.363Z | 2024-10-31T12:29:58.265Z |
5350225 | 5350225 | 20241022212429_neJqV | ZA0007 | 2024-10-24T12:15:29.670Z | 2024-10-31T12:29:57.577Z |
5350107 | 5350107 | 20241022211221_iMbEA | ZA0007 | 2024-10-24T12:15:22.799Z | 2024-10-31T12:29:57.316Z |
5350078 | 5350078 | 20241022210841_6DMeI | ZA0007 | 2024-10-24T12:15:17.292Z | 2024-10-31T12:29:57.273Z |
5349751 | 5349751 | 20241022203246_enhwv | ZA0007 | 2024-10-24T12:14:35.508Z | 2024-10-31T12:29:56.221Z |
5349272 | 5349272 | 20241022193840_BS2P2 | ZA0007 | 2024-10-24T12:13:23.289Z | 2024-10-31T12:29:54.956Z |
5348602 | 5348602 | 20241022183549_PRWMh | ZA0007 | 2024-10-24T12:11:47.982Z | 2024-10-31T12:29:53.134Z |
5348598 | 5348598 | 20241022183459_056n2 | ZA0007 | 2024-10-24T12:11:46.914Z | 2024-10-31T12:29:53.131Z |
5326205 | 5326205 | 20241020220856_BelTq | ZA0007 | 2024-10-21T12:07:48.690Z | 2024-10-29T12:26:33.781Z |
5326190 | 5326190 | 20241020204221_ivu99 | ZA0007 | 2024-10-21T12:07:46.840Z | 2024-10-29T12:26:33.504Z |
5318130 | 5318130 | 20241016214419_X5xvs | ZA0007 | 2024-10-18T12:02:57.919Z | 2024-10-25T12:24:33.420Z |
5317962 | 5317962 | 20241017181902_DkDS3 | ZA0007 | 2024-10-18T12:01:20.681Z | 2024-10-26T12:27:52.276Z |
5317958 | 5317958 | 20241017180733_TcxfG | ZA0007 | 2024-10-18T12:01:20.130Z | 2024-10-26T12:27:52.231Z |
5316465 | 5316465 | 20241015220934_WrITs | ZA0007 | 2024-10-17T12:06:42.226Z | 2024-10-24T12:27:56.573Z |
5316425 | 5316425 | 20241015213551_FftZ7 | ZA0007 | 2024-10-17T12:06:39.201Z | 2024-10-24T12:27:56.484Z |
5316410 | 5316410 | 20241015212212_0DPvT | ZA0007 | 2024-10-17T12:06:35.677Z | 2024-10-24T12:27:56.451Z |
5316387 | 5316387 | 20241015210054_q06Yc | ZA0007 | 2024-10-17T12:06:28.747Z | 2024-10-24T12:27:56.357Z |
5316288 | 5316288 | 20241015192506_aNe5X | ZA0007 | 2024-10-17T12:06:13.944Z | 2024-10-24T12:27:56.003Z |
5310882 | 5310882 | 20241014211616_vgmws | ZA0007 | 2024-10-16T12:07:57.172Z | 2024-10-23T12:24:39.474Z |
5310814 | 5310814 | 20241014203712_g2MvM | ZA0007 | 2024-10-16T12:07:50.439Z | 2024-10-23T12:24:38.888Z |
5310578 | 5310578 | 20241014190112_oaerZ | ZA0007 | 2024-10-16T12:07:16.562Z | 2024-10-23T12:24:35.713Z |
5300395 | 5300395 | 20241012203358_oz4xk | ZA0007 | 2024-10-14T12:13:57.691Z | 2024-10-21T12:23:48.892Z |
5300219 | 5300219 | 20241012201348_mr9cg | ZA0007 | 2024-10-14T12:13:38.620Z | 2024-10-21T12:23:47.380Z |
5299066 | 5299066 | 20241012180003_SZ2nt | ZA0007 | 2024-10-14T12:11:40.813Z | 2024-10-21T12:23:33.929Z |
5292093 | 5292093 | 20241011223846_T0leV | ZA0007 | 2024-10-13T12:15:42.612Z | 2024-10-20T12:24:40.085Z |
5292078 | 5292078 | 20241011223647_5w2Qs | ZA0007 | 2024-10-13T12:15:41.879Z | 2024-10-20T12:24:39.976Z |
5292072 | 5292072 | 20241011223515_1mQAL | ZA0007 | 2024-10-13T12:15:41.471Z | 2024-10-20T12:24:39.934Z |
5292042 | 5292042 | 20241011223135_cDumL | ZA0007 | 2024-10-13T12:15:40.039Z | 2024-10-20T12:24:39.751Z |
5292008 | 5292008 | 20241011222751_SwdHe | ZA0007 | 2024-10-13T12:15:38.057Z | 2024-10-20T12:24:39.190Z |
5291606 | 5291606 | 20241011212816_ra3LE | ZA0007 | 2024-10-13T12:14:51.366Z | 2024-10-20T12:24:33.899Z |
5291537 | 5291537 | 20241011211820_vHE0t | ZA0007 | 2024-10-13T12:14:45.464Z | 2024-10-20T12:24:32.832Z |
5291428 | 5291428 | 20241011205508_L7rrv | ZA0007 | 2024-10-13T12:14:31.832Z | 2024-10-20T12:24:30.670Z |
5291424 | 5291424 | 20241011205420_Gi0Je | ZA0007 | 2024-10-13T12:14:31.451Z | 2024-10-20T12:24:30.612Z |
5291337 | 5291337 | 20241011203722_KlOvD | ZA0007 | 2024-10-13T12:14:18.290Z | 2024-10-20T12:24:29.315Z |
5291140 | 5291140 | 20241011200605_gl7y0 | ZA0007 | 2024-10-13T12:14:00.068Z | 2024-10-20T12:24:26.780Z |
5290797 | 5290797 | 20241011185906_qrJ5h | ZA0007 | 2024-10-13T12:13:24.038Z | 2024-10-20T12:24:20.453Z |
5290624 | 5290624 | 20241011183255_2hKLo | ZA0007 | 2024-10-13T12:12:58.380Z | 2024-10-20T12:24:18.305Z |
5290467 | 5290467 | 20241011175707_3q2Pz | ZA0007 | 2024-10-13T12:12:31.919Z | 2024-10-20T12:24:16.440Z |
5282583 | 5282583 | 20241010222731_rUnFl | ZA0007 | 2024-10-12T12:15:45.465Z | 2024-10-19T12:27:44.846Z |
5282407 | 5282407 | 20241010213805_QwnOY | ZA0007 | 2024-10-12T12:15:31.450Z | 2024-10-19T12:27:43.712Z |
5282085 | 5282085 | 20241010201447_aYRKj | ZA0007 | 2024-10-12T12:15:11.128Z | 2024-10-19T12:27:40.614Z |
5281679 | 5281679 | 20241010191329_njr6Y | ZA0007 | 2024-10-12T12:14:30.710Z | 2024-10-19T12:27:35.840Z |
5281594 | 5281594 | 20241010190018_Ri2qH | ZA0007 | 2024-10-12T12:14:22.865Z | 2024-10-19T12:27:34.630Z |
5274641 | 5274641 | 20241009223144_8HWOg | ZA0007 | 2024-10-11T12:14:42.879Z | 2024-10-18T12:22:10.324Z |
5274565 | 5274565 | 20241009215655_mgbUr | ZA0007 | 2024-10-11T12:14:38.144Z | 2024-10-18T12:22:10.017Z |
5274554 | 5274554 | 20241009215001_aoRK3 | ZA0007 | 2024-10-11T12:14:37.691Z | 2024-10-18T12:22:09.969Z |
5274534 | 5274534 | 20241009214127_qkWa1 | ZA0007 | 2024-10-11T12:14:36.409Z | 2024-10-18T12:22:09.900Z |
5274262 | 5274262 | 20241009200450_a5icQ | ZA0007 | 2024-10-11T12:14:07.705Z | 2024-10-18T12:22:07.428Z |
5274141 | 5274141 | 20241009194224_CCHle | ZA0007 | 2024-10-11T12:13:55.296Z | 2024-10-18T12:22:06.667Z |
5267804 | 5267804 | 20241008222717_h8ggT | ZA0007 | 2024-10-10T12:14:36.455Z | 2024-10-17T12:20:11.948Z |
5267737 | 5267737 | 20241008221057_672Cd | ZA0007 | 2024-10-10T12:14:29.410Z | 2024-10-17T12:20:10.731Z |
5267676 | 5267676 | 20241008214350_05ez9 | ZA0007 | 2024-10-10T12:14:21.862Z | 2024-10-17T12:20:10.351Z |
5267656 | 5267656 | 20241008214032_5tNHk | ZA0007 | 2024-10-10T12:14:19.898Z | 2024-10-17T12:20:10.292Z |
5267540 | 5267540 | 20241008204152_IwetO | ZA0007 | 2024-10-10T12:14:05.505Z | 2024-10-17T12:20:09.622Z |
5267329 | 5267329 | 20241008194449_FfsFT | ZA0007 | 2024-10-10T12:13:50.735Z | 2024-10-17T12:20:08.963Z |
5261799 | 5261799 | 20241007221607_UdPR0 | ZA0007 | 2024-10-09T12:14:42.853Z | 2024-10-16T12:21:16.142Z |
5261795 | 5261795 | 20241007221410_FhZ89 | ZA0007 | 2024-10-09T12:14:42.611Z | 2024-10-16T12:21:16.128Z |
5261759 | 5261759 | 20241007215122_aY5oP | ZA0007 | 2024-10-09T12:14:37.879Z | 2024-10-16T12:21:15.831Z |
5261716 | 5261716 | 20241007213848_bpDBM | ZA0007 | 2024-10-09T12:14:33.733Z | 2024-10-16T12:21:15.482Z |
5261686 | 5261686 | 20241007212853_ukuXj | ZA0007 | 2024-10-09T12:14:32.142Z | 2024-10-16T12:21:15.300Z |
5261578 | 5261578 | 20241007204329_UIq5X | ZA0007 | 2024-10-09T12:14:25.780Z | 2024-10-16T12:21:14.740Z |
5245281 | 5245281 | 20241005223052_mBAqe | ZA0007 | 2024-10-07T12:15:35.507Z | 2024-10-14T12:24:34.909Z |
5245143 | 5245143 | 20241005220532_91FlN | ZA0007 | 2024-10-07T12:15:31.938Z | 2024-10-14T12:24:34.689Z |
5244834 | 5244834 | 20241005211207_yLd7N | ZA0007 | 2024-10-07T12:15:22.037Z | 2024-10-14T12:24:34.272Z |
5244757 | 5244757 | 20241005210255_TL8cb | ZA0007 | 2024-10-07T12:15:16.467Z | 2024-10-14T12:24:34.231Z |
5244727 | 5244727 | 20241005205506_eLt5P | ZA0007 | 2024-10-07T12:15:13.197Z | 2024-10-14T12:24:34.176Z |
5236781 | 5236781 | 20241003214647_KhPBB | ZA0007 | 2024-10-06T12:21:00.569Z | 2024-10-12T12:25:09.414Z |
5234226 | 5234226 | 20241004211224_wBZdZ | ZA0007 | 2024-10-06T12:14:43.879Z | 2024-10-13T12:26:22.346Z |
5233539 | 5233539 | 20241004195252_b7WMQ | ZA0007 | 2024-10-06T12:13:40.912Z | 2024-10-13T12:26:21.240Z |
5225473 | 5225473 | 20241003224245_MGrmY | ZA0007 | 2024-10-05T12:19:47.996Z | 2024-10-12T12:25:10.231Z |
5224956 | 5224956 | 20241003214642_yVoxp | ZA0007 | 2024-10-05T12:19:14.475Z | 2024-10-12T12:25:09.412Z |
5224655 | 5224655 | 20241003211000_PC2It | ZA0007 | 2024-10-05T12:18:56.815Z | 2024-10-12T12:25:08.808Z |
5224591 | 5224591 | 20241003205946_XtDMF | ZA0007 | 2024-10-05T12:18:46.851Z | 2024-10-12T12:25:08.736Z |
5224511 | 5224511 | 20241003205118_Mc9pA | ZA0007 | 2024-10-05T12:18:37.236Z | 2024-10-12T12:25:08.576Z |
5224072 | 5224072 | 20241003200210_VIOvG | ZA0007 | 2024-10-05T12:18:09.529Z | 2024-10-12T12:25:07.234Z |
5223423 | 5223423 | 20241003182856_9tvRY | ZA0007 | 2024-10-05T12:17:04.929Z | 2024-10-12T12:25:06.007Z |
5213581 | 5213581 | 20241002191010_0osrO | ZA0007 | 2024-10-04T12:08:29.468Z | 2024-10-11T12:23:31.279Z |
5210507 | 5210507 | 20241001220239_wfvHS | ZA0007 | 2024-10-03T12:15:14.533Z | 2024-10-10T12:24:47.193Z |
5210379 | 5210379 | 20241001205000_301Sd | ZA0007 | 2024-10-03T12:15:00.943Z | 2024-10-10T12:24:46.682Z |
5210335 | 5210335 | 20241001202537_9c3U2 | ZA0007 | 2024-10-03T12:14:57.933Z | 2024-10-10T12:24:46.502Z |
5210074 | 5210074 | 20241001184545_WaI37 | ZA0007 | 2024-10-03T12:14:28.956Z | 2024-10-10T12:24:45.438Z |
5205874 | 5205874 | 20240928223624_0aeTQ | ZA0007 | 2024-10-02T12:17:01.842Z | 2024-10-06T12:28:25.690Z |
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);