participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
253 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 |
---|---|---|---|---|---|
5579444 | 5579444 | 20241121224343_UQJJn | ZA0007 | 2024-11-23T14:18:25.643Z | 2024-11-23T14:21:25.032Z |
5579316 | 5579316 | 20241121222527_nayj2 | ZA0007 | 2024-11-23T14:18:10.628Z | 2024-11-23T14:21:25.007Z |
5579265 | 5579265 | 20241121221613_UU3qZ | ZA0007 | 2024-11-23T14:18:06.142Z | 2024-11-23T14:21:24.997Z |
5579250 | 5579250 | 20241121221408_Ks4JS | ZA0007 | 2024-11-23T14:18:05.075Z | 2024-11-23T14:21:24.994Z |
5579230 | 5579230 | 20241121220514_cbvnm | ZA0007 | 2024-11-23T14:18:01.384Z | 2024-11-23T14:21:24.989Z |
5579156 | 5579156 | 20241121215422_FHRkr | ZA0007 | 2024-11-23T14:17:56.216Z | 2024-11-23T14:21:24.975Z |
5579109 | 5579109 | 20241121214715_ZuW75 | ZA0007 | 2024-11-23T14:17:50.593Z | 2024-11-23T14:21:24.967Z |
5579107 | 5579107 | 20241121214704_vbmxa | ZA0007 | 2024-11-23T14:17:50.420Z | 2024-11-23T14:21:24.966Z |
5578165 | 5578165 | 20241121190254_59dgZ | ZA0007 | 2024-11-23T14:16:32.634Z | 2024-11-23T14:21:24.773Z |
5577963 | 5577963 | 20241121182356_oQwqm | ZA0007 | 2024-11-23T14:16:19.720Z | 2024-11-23T14:21:24.729Z |
5541236 | 5541236 | 20241113214427_rVp83 | ZA0007 | 2024-11-15T14:07:05.332Z | 2024-11-22T14:24:17.351Z |
5537391 | 5537391 | 20241112223608_MEzt3 | ZA0007 | 2024-11-14T14:11:43.856Z | 2024-11-21T14:26:12.548Z |
5537071 | 5537071 | 20241112202057_swiEE | ZA0007 | 2024-11-14T14:10:58.814Z | 2024-11-21T14:26:08.665Z |
5528682 | 5528682 | 20241111221451_1XMG3 | ZA0007 | 2024-11-13T14:11:16.224Z | 2024-11-20T14:25:33.583Z |
5528487 | 5528487 | 20241111211034_lYtfx | ZA0007 | 2024-11-13T14:10:52.881Z | 2024-11-20T14:25:31.177Z |
5528350 | 5528350 | 20241111202754_jcs6P | ZA0007 | 2024-11-13T14:10:29.552Z | 2024-11-20T14:25:28.879Z |
5527775 | 5527775 | 20241111183303_h0siB | ZA0007 | 2024-11-13T14:09:06.267Z | 2024-11-20T14:25:20.045Z |
5515440 | 5515440 | 20241109212526_LiqsQ | ZA0007 | 2024-11-11T14:11:04.860Z | 2024-11-18T14:26:26.051Z |
5515396 | 5515396 | 20241109210653_2lMzW | ZA0007 | 2024-11-11T14:10:55.411Z | 2024-11-18T14:26:25.822Z |
5515394 | 5515394 | 20241109210639_qciQY | ZA0007 | 2024-11-11T14:10:54.909Z | 2024-11-18T14:26:25.821Z |
5515373 | 5515373 | 20241109210135_DzXyh | ZA0007 | 2024-11-11T14:10:51.854Z | 2024-11-18T14:26:25.742Z |
5515322 | 5515322 | 20241109203337_LCdu3 | ZA0007 | 2024-11-11T14:10:43.396Z | 2024-11-18T14:26:25.482Z |
5515251 | 5515251 | 20241109200431_tPAPh | ZA0007 | 2024-11-11T14:10:27.700Z | 2024-11-18T14:26:25.119Z |
5509261 | 5509261 | 20241108223812_NUD81 | ZA0007 | 2024-11-10T14:13:04.283Z | 2024-11-17T14:23:42.116Z |
5509102 | 5509102 | 20241108215144_VOUCe | ZA0007 | 2024-11-10T14:12:33.510Z | 2024-11-17T14:23:40.312Z |
5508919 | 5508919 | 20241108204741_2bG8S | ZA0007 | 2024-11-10T14:12:03.874Z | 2024-11-17T14:23:36.995Z |
5508856 | 5508856 | 20241108200338_Cg5Rq | ZA0007 | 2024-11-10T14:11:57.081Z | 2024-11-17T14:23:34.711Z |
5508805 | 5508805 | 20241108193548_RPbE7 | ZA0007 | 2024-11-10T14:11:50.437Z | 2024-11-17T14:23:34.096Z |
5503428 | 5503428 | 20241107221817_jXiD7 | ZA0007 | 2024-11-09T14:13:02.920Z | 2024-11-16T14:28:07.142Z |
5503138 | 5503138 | 20241107204629_2MRKk | ZA0007 | 2024-11-09T14:12:27.103Z | 2024-11-16T14:28:03.559Z |
5502905 | 5502905 | 20241107201016_hGuzj | ZA0007 | 2024-11-09T14:12:11.695Z | 2024-11-16T14:28:00.469Z |
5502903 | 5502903 | 20241107201009_DYCeo | ZA0007 | 2024-11-09T14:12:11.681Z | 2024-11-16T14:28:00.454Z |
5502888 | 5502888 | 20241107200635_k9WTa | ZA0007 | 2024-11-09T14:12:10.563Z | 2024-11-16T14:28:00.233Z |
5502853 | 5502853 | 20241107195719_3z1bX | ZA0007 | 2024-11-09T14:12:07.987Z | 2024-11-16T14:27:59.853Z |
5502697 | 5502697 | 20241107193239_2frjd | ZA0007 | 2024-11-09T14:11:58.710Z | 2024-11-16T14:27:58.771Z |
5502598 | 5502598 | 20241107191443_WrdnC | ZA0007 | 2024-11-09T14:11:48.115Z | 2024-11-16T14:27:57.854Z |
5502482 | 5502482 | 20241107184502_Ujs5E | ZA0007 | 2024-11-09T14:11:28.577Z | 2024-11-16T14:27:56.210Z |
5502448 | 5502448 | 20241107183446_O13Le | ZA0007 | 2024-11-09T14:11:23.056Z | 2024-11-16T14:27:55.747Z |
5495909 | 5495909 | 20241106220308_701A4 | ZA0007 | 2024-11-08T14:11:05.905Z | 2024-11-15T14:24:53.851Z |
5495904 | 5495904 | 20241106220114_X0aWi | ZA0007 | 2024-11-08T14:11:05.767Z | 2024-11-15T14:24:53.848Z |
5495893 | 5495893 | 20241106215855_KLETu | ZA0007 | 2024-11-08T14:11:04.502Z | 2024-11-15T14:24:53.828Z |
5495869 | 5495869 | 20241106215339_ZpYrX | ZA0007 | 2024-11-08T14:11:03.011Z | 2024-11-15T14:24:53.677Z |
5495835 | 5495835 | 20241106214324_H5wWG | ZA0007 | 2024-11-08T14:10:57.823Z | 2024-11-15T14:24:53.494Z |
5495788 | 5495788 | 20241106213453_SKwBH | ZA0007 | 2024-11-08T14:10:52.482Z | 2024-11-15T14:24:53.266Z |
5495739 | 5495739 | 20241106211857_7FvDM | ZA0007 | 2024-11-08T14:10:44.294Z | 2024-11-15T14:24:52.800Z |
5495696 | 5495696 | 20241106210512_J2XmM | ZA0007 | 2024-11-08T14:10:38.643Z | 2024-11-15T14:24:52.408Z |
5495689 | 5495689 | 20241106210412_ZbO22 | ZA0007 | 2024-11-08T14:10:37.860Z | 2024-11-15T14:24:52.341Z |
5495625 | 5495625 | 20241106204300_SLCYE | ZA0007 | 2024-11-08T14:10:30.574Z | 2024-11-15T14:24:51.721Z |
5495617 | 5495617 | 20241106203926_B3DGW | ZA0007 | 2024-11-08T14:10:29.285Z | 2024-11-15T14:24:51.627Z |
5495406 | 5495406 | 20241106194215_mqxBK | ZA0007 | 2024-11-08T14:10:11.581Z | 2024-11-15T14:24:48.711Z |
5495385 | 5495385 | 20241106194046_yqfJT | ZA0007 | 2024-11-08T14:10:10.536Z | 2024-11-15T14:24:48.676Z |
5495090 | 5495090 | 20241106183642_hu5Ru | ZA0007 | 2024-11-08T14:09:16.854Z | 2024-11-15T14:24:46.599Z |
5494994 | 5494994 | 20241106180944_9Hkt7 | ZA0007 | 2024-11-08T14:08:56.778Z | 2024-11-15T14:24:45.257Z |
5490359 | 5490359 | 20241105222211_v8wCB | ZA0007 | 2024-11-07T14:13:55.495Z | 2024-11-14T14:23:19.132Z |
5489655 | 5489655 | 20241105193640_shZml | ZA0007 | 2024-11-07T14:12:29.773Z | 2024-11-14T14:23:14.904Z |
5461906 | 5461906 | 20241101220729_3j2VY | ZA0007 | 2024-11-03T14:16:42.987Z | 2024-11-10T14:26:30.777Z |
5461894 | 5461894 | 20241101220327_t7q5a | ZA0007 | 2024-11-03T14:16:38.659Z | 2024-11-10T14:26:30.749Z |
5461872 | 5461872 | 20241101215519_7JrdL | ZA0007 | 2024-11-03T14:16:30.517Z | 2024-11-10T14:26:30.698Z |
5461740 | 5461740 | 20241101210417_2FYiq | ZA0007 | 2024-11-03T14:16:09.189Z | 2024-11-10T14:26:30.101Z |
5451062 | 5451062 | 20241031223004_xB3cI | ZA0007 | 2024-11-02T12:16:33.387Z | 2024-11-09T14:24:21.278Z |
5450976 | 5450976 | 20241031220703_A0Tt7 | ZA0007 | 2024-11-02T12:16:26.910Z | 2024-11-09T14:24:20.386Z |
5450942 | 5450942 | 20241031215904_Z6pkL | ZA0007 | 2024-11-02T12:16:20.181Z | 2024-11-09T14:24:20.253Z |
5450779 | 5450779 | 20241031205437_gwoZ6 | ZA0007 | 2024-11-02T12:15:52.238Z | 2024-11-09T14:24:17.950Z |
5450471 | 5450471 | 20241031192452_YTJfF | ZA0007 | 2024-11-02T12:15:27.086Z | 2024-11-09T14:24:16.075Z |
5450416 | 5450416 | 20241031191323_d3ARN | ZA0007 | 2024-11-02T12:15:14.641Z | 2024-11-09T14:24:15.895Z |
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 |
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);