participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,785 rows where station_code = "US002D" 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 |
---|---|---|---|---|---|
5556878 | 5556878 | 20241119022839_UJg5w | US002D | 2024-11-20T14:11:36.561Z | 2024-11-24T14:25:04.814Z |
5556813 | 5556813 | 20241119020154_3uSGW | US002D | 2024-11-20T14:11:30.724Z | 2024-11-24T14:25:04.030Z |
5548519 | 5548519 | 20241117000706_x8O5O | US002D | 2024-11-18T14:09:23.716Z | 2024-11-24T14:25:32.040Z |
5546215 | 5546215 | 20241117095104_3EqAp | US002D | 2024-11-18T14:02:28.859Z | 2024-11-24T14:25:11.478Z |
5545908 | 5545908 | 20241117074743_P22u6 | US002D | 2024-11-18T14:01:24.435Z | 2024-11-24T14:25:09.824Z |
5545854 | 5545854 | 20241117072709_Vf2T2 | US002D | 2024-11-18T14:01:12.647Z | 2024-11-24T14:25:09.269Z |
5545833 | 5545833 | 20241117072006_Ym2Lx | US002D | 2024-11-18T14:01:07.720Z | 2024-11-24T14:25:09.152Z |
5545792 | 5545792 | 20241117070042_g68ln | US002D | 2024-11-18T14:00:58.504Z | 2024-11-24T14:25:08.830Z |
5545648 | 5545648 | 20241117055916_29wvi | US002D | 2024-11-18T14:00:32.661Z | 2024-11-24T14:25:08.427Z |
5541396 | 5541396 | 20241114012423_5bJZE | US002D | 2024-11-15T14:07:33.894Z | 2024-11-22T14:24:18.488Z |
5538980 | 5538980 | 20241113052736_ly0zi | US002D | 2024-11-14T14:14:06.716Z | 2024-11-21T14:26:30.564Z |
5538968 | 5538968 | 20241113052607_nV3mg | US002D | 2024-11-14T14:14:05.881Z | 2024-11-21T14:26:30.494Z |
5538655 | 5538655 | 20241113043207_1PtUi | US002D | 2024-11-14T14:13:47.393Z | 2024-11-21T14:26:28.406Z |
5538528 | 5538528 | 20241113040405_pHodN | US002D | 2024-11-14T14:13:35.820Z | 2024-11-21T14:26:27.019Z |
5538187 | 5538187 | 20241113023308_RLHtZ | US002D | 2024-11-14T14:13:01.673Z | 2024-11-21T14:26:21.607Z |
5533917 | 5533917 | 20241113102706_PWwLK | US002D | 2024-11-14T14:03:16.661Z | 2024-11-22T14:24:11.732Z |
5533181 | 5533181 | 20241113074214_4NT5d | US002D | 2024-11-14T14:01:20.303Z | 2024-11-22T14:24:07.529Z |
5533125 | 5533125 | 20241113072559_SaRgK | US002D | 2024-11-14T14:01:11.582Z | 2024-11-22T14:24:07.178Z |
5533086 | 5533086 | 20241113070736_fmYt2 | US002D | 2024-11-14T14:01:05.901Z | 2024-11-22T14:24:07.012Z |
5532980 | 5532980 | 20241113063522_Wszs2 | US002D | 2024-11-14T14:00:42.694Z | 2024-11-22T14:24:06.450Z |
5532898 | 5532898 | 20241113061337_9QwKK | US002D | 2024-11-14T14:00:29.795Z | 2024-11-22T14:24:06.003Z |
5526927 | 5526927 | 20241112103315_wCzDN | US002D | 2024-11-13T14:04:36.100Z | 2024-11-21T14:25:39.792Z |
5526202 | 5526202 | 20241112083214_vx4qY | US002D | 2024-11-13T14:02:10.521Z | 2024-11-21T14:25:31.790Z |
5517614 | 5517614 | 20241110041206_SL3b2 | US002D | 2024-11-11T14:14:40.299Z | 2024-11-18T14:26:37.402Z |
5516536 | 5516536 | 20241110011516_1aP8Z | US002D | 2024-11-11T14:13:07.001Z | 2024-11-18T14:26:31.730Z |
5511351 | 5511351 | 20241109055402_S43HW | US002D | 2024-11-10T14:16:42.063Z | 2024-11-17T14:24:08.143Z |
5511298 | 5511298 | 20241109053438_C9lwO | US002D | 2024-11-10T14:16:38.641Z | 2024-11-17T14:24:07.764Z |
5510405 | 5510405 | 20241109023637_Kd3Y3 | US002D | 2024-11-10T14:15:10.016Z | 2024-11-17T14:23:57.096Z |
5509978 | 5509978 | 20241109012030_qQ9gQ | US002D | 2024-11-10T14:14:21.752Z | 2024-11-17T14:23:51.501Z |
5509971 | 5509971 | 20241109011837_VMbo8 | US002D | 2024-11-10T14:14:20.406Z | 2024-11-17T14:23:51.423Z |
5509947 | 5509947 | 20241109011427_WeVvh | US002D | 2024-11-10T14:14:18.716Z | 2024-11-17T14:23:51.336Z |
5509912 | 5509912 | 20241109010827_ALTdG | US002D | 2024-11-10T14:14:14.391Z | 2024-11-17T14:23:50.743Z |
5507032 | 5507032 | 20241109101749_3p7mj | US002D | 2024-11-10T14:04:06.025Z | 2024-11-18T14:26:06.052Z |
5506998 | 5506998 | 20241109101216_Fbc9N | US002D | 2024-11-10T14:04:01.828Z | 2024-11-18T14:26:05.594Z |
5506538 | 5506538 | 20241109085521_dpN8U | US002D | 2024-11-10T14:02:30.936Z | 2024-11-18T14:26:00.469Z |
5506462 | 5506462 | 20241109084306_QEeSi | US002D | 2024-11-10T14:02:20.420Z | 2024-11-18T14:25:59.553Z |
5506156 | 5506156 | 20241109074638_9iEa3 | US002D | 2024-11-10T14:01:21.592Z | 2024-11-18T14:25:56.999Z |
5506001 | 5506001 | 20241109071902_Q4k7y | US002D | 2024-11-10T14:01:01.116Z | 2024-11-18T14:25:55.515Z |
5505930 | 5505930 | 20241109070702_pE8dJ | US002D | 2024-11-10T14:00:49.344Z | 2024-11-18T14:25:54.808Z |
5505863 | 5505863 | 20241109065409_Jic8W | US002D | 2024-11-10T14:00:37.018Z | 2024-11-18T14:25:53.412Z |
5505709 | 5505709 | 20241109062323_5KRfC | US002D | 2024-11-10T14:00:13.102Z | 2024-11-18T14:25:51.576Z |
5505689 | 5505689 | 20241109061810_aiMV5 | US002D | 2024-11-10T14:00:09.033Z | 2024-11-18T14:25:51.205Z |
5505590 | 5505590 | 20241108061857_JboFM | US002D | 2024-11-09T14:16:24.555Z | 2024-11-16T14:28:33.928Z |
5505509 | 5505509 | 20241108054922_vl7p3 | US002D | 2024-11-09T14:16:21.306Z | 2024-11-16T14:28:33.026Z |
5505486 | 5505486 | 20241108053925_Vhwyr | US002D | 2024-11-09T14:16:20.427Z | 2024-11-16T14:28:32.905Z |
5505335 | 5505335 | 20241108044036_FIuS3 | US002D | 2024-11-09T14:16:10.742Z | 2024-11-16T14:28:30.174Z |
5505216 | 5505216 | 20241108040912_3UeZH | US002D | 2024-11-09T14:15:56.400Z | 2024-11-16T14:28:28.549Z |
5505040 | 5505040 | 20241108034441_zmXbu | US002D | 2024-11-09T14:15:37.842Z | 2024-11-16T14:28:25.833Z |
5504916 | 5504916 | 20241108031840_5rJ1O | US002D | 2024-11-09T14:15:23.524Z | 2024-11-16T14:28:24.886Z |
5504779 | 5504779 | 20241108025603_rIoUX | US002D | 2024-11-09T14:15:10.946Z | 2024-11-16T14:28:23.467Z |
5504147 | 5504147 | 20241108010432_ldV2n | US002D | 2024-11-09T14:14:08.209Z | 2024-11-16T14:28:16.654Z |
5498972 | 5498972 | 20241108103714_zIL32 | US002D | 2024-11-09T14:02:53.709Z | 2024-11-17T14:23:02.897Z |
5498966 | 5498966 | 20241108103547_9u7V1 | US002D | 2024-11-09T14:02:52.625Z | 2024-11-17T14:23:02.645Z |
5498639 | 5498639 | 20241108092904_hYm8h | US002D | 2024-11-09T14:02:04.325Z | 2024-11-17T14:22:58.590Z |
5498545 | 5498545 | 20241108090049_wbFmy | US002D | 2024-11-09T14:01:44.782Z | 2024-11-17T14:22:57.537Z |
5498358 | 5498358 | 20241108081543_Dq2AV | US002D | 2024-11-09T14:01:13.846Z | 2024-11-17T14:22:53.381Z |
5498035 | 5498035 | 20241108063118_3n3pF | US002D | 2024-11-09T14:00:15.720Z | 2024-11-17T14:22:49.531Z |
5491803 | 5491803 | 20241106051305_4ly0m | US002D | 2024-11-07T14:17:01.188Z | 2024-11-14T14:23:26.810Z |
5491484 | 5491484 | 20241106032435_NYD3x | US002D | 2024-11-07T14:16:13.751Z | 2024-11-14T14:23:25.851Z |
5491433 | 5491433 | 20241106031639_LPEqU | US002D | 2024-11-07T14:16:07.440Z | 2024-11-14T14:23:25.691Z |
5490914 | 5490914 | 20241106011401_ByG0S | US002D | 2024-11-07T14:15:05.043Z | 2024-11-14T14:23:22.867Z |
5490869 | 5490869 | 20241106010053_za0J2 | US002D | 2024-11-07T14:15:01.387Z | 2024-11-14T14:23:22.670Z |
5490851 | 5490851 | 20241106005330_mNSQW | US002D | 2024-11-07T14:14:59.834Z | 2024-11-14T14:23:22.627Z |
5490792 | 5490792 | 20241106004118_4EHvq | US002D | 2024-11-07T14:14:56.338Z | 2024-11-14T14:23:21.835Z |
5490721 | 5490721 | 20241106002148_2Udtx | US002D | 2024-11-07T14:14:40.839Z | 2024-11-14T14:23:21.461Z |
5490635 | 5490635 | 20241105235031_vC3CR | US002D | 2024-11-07T14:14:21.059Z | 2024-11-14T14:23:21.070Z |
5486204 | 5486204 | 20241106100311_DP2Hh | US002D | 2024-11-07T14:02:13.295Z | 2024-11-15T14:24:27.461Z |
5486169 | 5486169 | 20241106095721_Ht6fz | US002D | 2024-11-07T14:02:07.751Z | 2024-11-15T14:24:27.019Z |
5486117 | 5486117 | 20241106094356_eiAMd | US002D | 2024-11-07T14:01:55.314Z | 2024-11-15T14:24:26.431Z |
5485912 | 5485912 | 20241106083332_8mrXW | US002D | 2024-11-07T14:01:07.715Z | 2024-11-15T14:24:24.214Z |
5485866 | 5485866 | 20241106080705_BcoaU | US002D | 2024-11-07T14:00:53.792Z | 2024-11-15T14:24:23.844Z |
5485823 | 5485823 | 20241106074257_dRUvx | US002D | 2024-11-07T14:00:44.371Z | 2024-11-15T14:24:23.636Z |
5479574 | 5479574 | 20241105100016_IJjZn | US002D | 2024-11-06T14:02:48.298Z | 2024-11-14T14:22:59.384Z |
5479564 | 5479564 | 20241105095811_xMNu0 | US002D | 2024-11-06T14:02:46.784Z | 2024-11-14T14:22:59.363Z |
5479444 | 5479444 | 20241105092935_MrXWi | US002D | 2024-11-06T14:02:17.518Z | 2024-11-14T14:22:58.926Z |
5478873 | 5478873 | 20241105064409_d2kMs | US002D | 2024-11-06T14:00:11.417Z | 2024-11-14T14:22:56.052Z |
5478713 | 5478713 | 20241104051721_58Udt | US002D | 2024-11-05T14:18:43.884Z | 2024-11-12T14:28:16.746Z |
5478628 | 5478628 | 20241104044540_Lf4xB | US002D | 2024-11-05T14:18:35.340Z | 2024-11-12T14:28:16.411Z |
5478264 | 5478264 | 20241104034406_GXNSQ | US002D | 2024-11-05T14:18:07.464Z | 2024-11-12T14:28:14.748Z |
5478259 | 5478259 | 20241104034254_t9x3l | US002D | 2024-11-05T14:18:07.121Z | 2024-11-12T14:28:14.728Z |
5478143 | 5478143 | 20241104032721_WgBSz | US002D | 2024-11-05T14:17:58.740Z | 2024-11-12T14:28:14.431Z |
5477070 | 5477070 | 20241104005759_5aO86 | US002D | 2024-11-05T14:16:20.400Z | 2024-11-12T14:28:08.500Z |
5470963 | 5470963 | 20241104101522_3Aqp2 | US002D | 2024-11-05T14:02:23.436Z | 2024-11-13T14:27:23.295Z |
5470916 | 5470916 | 20241104100311_34PlD | US002D | 2024-11-05T14:02:17.136Z | 2024-11-13T14:27:23.156Z |
5470217 | 5470217 | 20241103064011_QFg0h | US002D | 2024-11-04T14:17:54.479Z | 2024-11-11T14:23:04.901Z |
5470157 | 5470157 | 20241103061327_n5QgN | US002D | 2024-11-04T14:17:51.996Z | 2024-11-11T14:23:04.698Z |
5470155 | 5470155 | 20241103061159_kaKkv | US002D | 2024-11-04T14:17:51.960Z | 2024-11-11T14:23:04.692Z |
5470086 | 5470086 | 20241103052618_kDz9O | US002D | 2024-11-04T14:17:46.871Z | 2024-11-11T14:23:04.245Z |
5470058 | 5470058 | 20241103051759_Q0bB3 | US002D | 2024-11-04T14:17:41.222Z | 2024-11-11T14:23:03.838Z |
5470022 | 5470022 | 20241103051029_1ZnlB | US002D | 2024-11-04T14:17:35.931Z | 2024-11-11T14:23:03.651Z |
5469767 | 5469767 | 20241103041729_Yc08r | US002D | 2024-11-04T14:17:02.001Z | 2024-11-11T14:23:02.197Z |
5469545 | 5469545 | 20241103034251_2n2Fj | US002D | 2024-11-04T14:16:35.260Z | 2024-11-11T14:23:01.037Z |
5469483 | 5469483 | 20241103033448_7VZqA | US002D | 2024-11-04T14:16:31.212Z | 2024-11-11T14:23:00.675Z |
5469267 | 5469267 | 20241103030032_4y7mj | US002D | 2024-11-04T14:16:08.532Z | 2024-11-11T14:22:59.402Z |
5469114 | 5469114 | 20241103023810_Bs9aV | US002D | 2024-11-04T14:15:38.233Z | 2024-11-11T14:22:58.463Z |
5464830 | 5464830 | 20241103092745_TlSV3 | US002D | 2024-11-04T14:01:47.574Z | 2024-11-12T14:27:43.290Z |
5464748 | 5464748 | 20241103090636_2ZD8W | US002D | 2024-11-04T14:01:34.274Z | 2024-11-12T14:27:43.166Z |
5464733 | 5464733 | 20241103090410_wpdZM | US002D | 2024-11-04T14:01:31.092Z | 2024-11-12T14:27:43.115Z |
5464652 | 5464652 | 20241103084334_6n0HH | US002D | 2024-11-04T14:01:13.778Z | 2024-11-12T14:27:42.761Z |
5464578 | 5464578 | 20241103082315_s3nK3 | US002D | 2024-11-04T14:01:00.270Z | 2024-11-12T14:27:42.568Z |
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);