participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,743 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 |
---|---|---|---|---|---|
5505590 | 5505590 | 20241108061857_JboFM | US002D | 2024-11-09T14:16:24.555Z | 2024-11-09T14:16:28.822Z |
5505509 | 5505509 | 20241108054922_vl7p3 | US002D | 2024-11-09T14:16:21.306Z | 2024-11-09T14:16:28.803Z |
5505486 | 5505486 | 20241108053925_Vhwyr | US002D | 2024-11-09T14:16:20.427Z | 2024-11-09T14:16:28.797Z |
5505335 | 5505335 | 20241108044036_FIuS3 | US002D | 2024-11-09T14:16:10.742Z | 2024-11-09T14:16:28.758Z |
5505216 | 5505216 | 20241108040912_3UeZH | US002D | 2024-11-09T14:15:56.400Z | 2024-11-09T14:16:28.727Z |
5505040 | 5505040 | 20241108034441_zmXbu | US002D | 2024-11-09T14:15:37.842Z | 2024-11-09T14:16:28.686Z |
5504916 | 5504916 | 20241108031840_5rJ1O | US002D | 2024-11-09T14:15:23.524Z | 2024-11-09T14:16:28.657Z |
5504779 | 5504779 | 20241108025603_rIoUX | US002D | 2024-11-09T14:15:10.946Z | 2024-11-09T14:16:28.623Z |
5504147 | 5504147 | 20241108010432_ldV2n | US002D | 2024-11-09T14:14:08.209Z | 2024-11-09T14:16:28.460Z |
5498972 | 5498972 | 20241108103714_zIL32 | US002D | 2024-11-09T14:02:53.709Z | 2024-11-09T14:02:53.709Z |
5498966 | 5498966 | 20241108103547_9u7V1 | US002D | 2024-11-09T14:02:52.625Z | 2024-11-09T14:02:52.625Z |
5498639 | 5498639 | 20241108092904_hYm8h | US002D | 2024-11-09T14:02:04.325Z | 2024-11-09T14:02:04.325Z |
5498545 | 5498545 | 20241108090049_wbFmy | US002D | 2024-11-09T14:01:44.782Z | 2024-11-09T14:01:44.782Z |
5498358 | 5498358 | 20241108081543_Dq2AV | US002D | 2024-11-09T14:01:13.846Z | 2024-11-09T14:01:13.846Z |
5498035 | 5498035 | 20241108063118_3n3pF | US002D | 2024-11-09T14:00:15.720Z | 2024-11-09T14:00:15.720Z |
5491803 | 5491803 | 20241106051305_4ly0m | US002D | 2024-11-07T14:17:01.188Z | 2024-11-09T14:20:14.776Z |
5491484 | 5491484 | 20241106032435_NYD3x | US002D | 2024-11-07T14:16:13.751Z | 2024-11-09T14:20:09.487Z |
5491433 | 5491433 | 20241106031639_LPEqU | US002D | 2024-11-07T14:16:07.440Z | 2024-11-09T14:20:07.653Z |
5490914 | 5490914 | 20241106011401_ByG0S | US002D | 2024-11-07T14:15:05.043Z | 2024-11-09T14:20:01.530Z |
5490869 | 5490869 | 20241106010053_za0J2 | US002D | 2024-11-07T14:15:01.387Z | 2024-11-09T14:20:00.709Z |
5490851 | 5490851 | 20241106005330_mNSQW | US002D | 2024-11-07T14:14:59.834Z | 2024-11-09T14:20:00.377Z |
5490792 | 5490792 | 20241106004118_4EHvq | US002D | 2024-11-07T14:14:56.338Z | 2024-11-09T14:19:59.652Z |
5490721 | 5490721 | 20241106002148_2Udtx | US002D | 2024-11-07T14:14:40.839Z | 2024-11-09T14:19:58.874Z |
5490635 | 5490635 | 20241105235031_vC3CR | US002D | 2024-11-07T14:14:21.059Z | 2024-11-09T14:19:57.505Z |
5486204 | 5486204 | 20241106100311_DP2Hh | US002D | 2024-11-07T14:02:13.295Z | 2024-11-09T14:16:39.718Z |
5486169 | 5486169 | 20241106095721_Ht6fz | US002D | 2024-11-07T14:02:07.751Z | 2024-11-09T14:16:39.039Z |
5486117 | 5486117 | 20241106094356_eiAMd | US002D | 2024-11-07T14:01:55.314Z | 2024-11-09T14:16:38.224Z |
5485912 | 5485912 | 20241106083332_8mrXW | US002D | 2024-11-07T14:01:07.715Z | 2024-11-09T14:16:34.447Z |
5485866 | 5485866 | 20241106080705_BcoaU | US002D | 2024-11-07T14:00:53.792Z | 2024-11-09T14:16:33.745Z |
5485823 | 5485823 | 20241106074257_dRUvx | US002D | 2024-11-07T14:00:44.371Z | 2024-11-09T14:16:32.979Z |
5479574 | 5479574 | 20241105100016_IJjZn | US002D | 2024-11-06T14:02:48.298Z | 2024-11-09T14:19:09.368Z |
5479564 | 5479564 | 20241105095811_xMNu0 | US002D | 2024-11-06T14:02:46.784Z | 2024-11-09T14:19:09.248Z |
5479444 | 5479444 | 20241105092935_MrXWi | US002D | 2024-11-06T14:02:17.518Z | 2024-11-09T14:19:06.274Z |
5478873 | 5478873 | 20241105064409_d2kMs | US002D | 2024-11-06T14:00:11.417Z | 2024-11-09T14:18:56.152Z |
5478713 | 5478713 | 20241104051721_58Udt | US002D | 2024-11-05T14:18:43.884Z | 2024-11-09T14:22:30.863Z |
5478628 | 5478628 | 20241104044540_Lf4xB | US002D | 2024-11-05T14:18:35.340Z | 2024-11-09T14:22:30.290Z |
5478264 | 5478264 | 20241104034406_GXNSQ | US002D | 2024-11-05T14:18:07.464Z | 2024-11-09T14:22:26.344Z |
5478259 | 5478259 | 20241104034254_t9x3l | US002D | 2024-11-05T14:18:07.121Z | 2024-11-09T14:22:26.341Z |
5478143 | 5478143 | 20241104032721_WgBSz | US002D | 2024-11-05T14:17:58.740Z | 2024-11-09T14:22:25.438Z |
5477070 | 5477070 | 20241104005759_5aO86 | US002D | 2024-11-05T14:16:20.400Z | 2024-11-09T14:22:14.140Z |
5470963 | 5470963 | 20241104101522_3Aqp2 | US002D | 2024-11-05T14:02:23.436Z | 2024-11-09T14:20:26.792Z |
5470916 | 5470916 | 20241104100311_34PlD | US002D | 2024-11-05T14:02:17.136Z | 2024-11-09T14:20:26.301Z |
5470217 | 5470217 | 20241103064011_QFg0h | US002D | 2024-11-04T14:17:54.479Z | 2024-11-09T14:23:05.948Z |
5470157 | 5470157 | 20241103061327_n5QgN | US002D | 2024-11-04T14:17:51.996Z | 2024-11-09T14:23:05.728Z |
5470155 | 5470155 | 20241103061159_kaKkv | US002D | 2024-11-04T14:17:51.960Z | 2024-11-09T14:23:05.723Z |
5470086 | 5470086 | 20241103052618_kDz9O | US002D | 2024-11-04T14:17:46.871Z | 2024-11-09T14:23:05.347Z |
5470058 | 5470058 | 20241103051759_Q0bB3 | US002D | 2024-11-04T14:17:41.222Z | 2024-11-09T14:23:04.939Z |
5470022 | 5470022 | 20241103051029_1ZnlB | US002D | 2024-11-04T14:17:35.931Z | 2024-11-09T14:23:04.787Z |
5469767 | 5469767 | 20241103041729_Yc08r | US002D | 2024-11-04T14:17:02.001Z | 2024-11-09T14:23:03.753Z |
5469545 | 5469545 | 20241103034251_2n2Fj | US002D | 2024-11-04T14:16:35.260Z | 2024-11-09T14:23:02.973Z |
5469483 | 5469483 | 20241103033448_7VZqA | US002D | 2024-11-04T14:16:31.212Z | 2024-11-09T14:23:02.756Z |
5469267 | 5469267 | 20241103030032_4y7mj | US002D | 2024-11-04T14:16:08.532Z | 2024-11-09T14:23:01.817Z |
5469114 | 5469114 | 20241103023810_Bs9aV | US002D | 2024-11-04T14:15:38.233Z | 2024-11-09T14:23:00.977Z |
5464830 | 5464830 | 20241103092745_TlSV3 | US002D | 2024-11-04T14:01:47.574Z | 2024-11-09T14:21:29.165Z |
5464748 | 5464748 | 20241103090636_2ZD8W | US002D | 2024-11-04T14:01:34.274Z | 2024-11-09T14:21:28.587Z |
5464733 | 5464733 | 20241103090410_wpdZM | US002D | 2024-11-04T14:01:31.092Z | 2024-11-09T14:21:28.368Z |
5464652 | 5464652 | 20241103084334_6n0HH | US002D | 2024-11-04T14:01:13.778Z | 2024-11-09T14:21:27.429Z |
5464578 | 5464578 | 20241103082315_s3nK3 | US002D | 2024-11-04T14:01:00.270Z | 2024-11-09T14:21:26.717Z |
5464524 | 5464524 | 20241103080322_hOy62 | US002D | 2024-11-04T14:00:51.107Z | 2024-11-09T14:21:26.378Z |
5464484 | 5464484 | 20241103073951_etXQ9 | US002D | 2024-11-04T14:00:39.279Z | 2024-11-09T14:21:25.924Z |
5464420 | 5464420 | 20241103071410_66rS5 | US002D | 2024-11-04T14:00:25.513Z | 2024-11-09T14:21:25.360Z |
5462887 | 5462887 | 20241102015136_7j2AG | US002D | 2024-11-03T14:18:08.949Z | 2024-11-09T14:23:36.701Z |
5462728 | 5462728 | 20241102011914_vjIDk | US002D | 2024-11-03T14:17:59.990Z | 2024-11-09T14:23:35.998Z |
5462633 | 5462633 | 20241102005841_PedkN | US002D | 2024-11-03T14:17:49.530Z | 2024-11-09T14:23:34.880Z |
5462355 | 5462355 | 20241101235643_dz3uJ | US002D | 2024-11-03T14:17:18.693Z | 2024-11-09T14:23:33.969Z |
5456148 | 5456148 | 20241102102933_geNX0 | US002D | 2024-11-03T14:03:32.580Z | 2024-11-09T14:22:42.123Z |
5454961 | 5454961 | 20241031055416_oXVpq | US002D | 2024-11-02T12:23:27.612Z | 2024-11-08T14:23:26.494Z |
5454919 | 5454919 | 20241031054628_83Rm2 | US002D | 2024-11-02T12:23:26.781Z | 2024-11-08T14:23:26.264Z |
5454403 | 5454403 | 20241031041649_lbGSI | US002D | 2024-11-02T12:23:05.703Z | 2024-11-08T14:23:22.862Z |
5452878 | 5452878 | 20241101051352_DNuSF | US002D | 2024-11-02T12:19:31.393Z | 2024-11-09T14:24:35.401Z |
5452757 | 5452757 | 20241101042328_L7bnX | US002D | 2024-11-02T12:19:20.501Z | 2024-11-09T14:24:33.553Z |
5446720 | 5446720 | 20241031102647_Rtr02 | US002D | 2024-11-02T12:06:07.197Z | 2024-11-09T14:23:56.096Z |
5446484 | 5446484 | 20241031100337_u28HG | US002D | 2024-11-02T12:05:26.188Z | 2024-11-09T14:23:54.900Z |
5443482 | 5443482 | 20241030063655_gxg6g | US002D | 2024-11-01T12:20:31.872Z | 2024-11-07T14:26:51.791Z |
5443474 | 5443474 | 20241030063448_nTNQi | US002D | 2024-11-01T12:20:31.429Z | 2024-11-07T14:26:51.771Z |
5443283 | 5443283 | 20241030043136_OsYvw | US002D | 2024-11-01T12:20:26.529Z | 2024-11-07T14:26:50.627Z |
5443068 | 5443068 | 20241030032728_HJQjL | US002D | 2024-11-01T12:20:17.029Z | 2024-11-07T14:26:49.378Z |
5443050 | 5443050 | 20241030032621_s0CsX | US002D | 2024-11-01T12:20:16.636Z | 2024-11-07T14:26:49.301Z |
5434301 | 5434301 | 20241030085743_wexIy | US002D | 2024-11-01T12:01:55.761Z | 2024-11-08T14:22:45.939Z |
5434110 | 5434110 | 20241030082121_ZY70W | US002D | 2024-11-01T12:01:16.616Z | 2024-11-08T14:22:44.761Z |
5434012 | 5434012 | 20241030080337_kTdE5 | US002D | 2024-11-01T12:00:49.394Z | 2024-11-08T14:22:44.491Z |
5433111 | 5433111 | 20241029064601_SCA1w | US002D | 2024-10-31T12:21:46.575Z | 2024-11-06T14:27:30.072Z |
5433061 | 5433061 | 20241029060724_R7tnt | US002D | 2024-10-31T12:21:44.493Z | 2024-11-06T14:27:29.787Z |
5433050 | 5433050 | 20241029060128_Fxi83 | US002D | 2024-10-31T12:21:44.253Z | 2024-11-06T14:27:29.767Z |
5432839 | 5432839 | 20241029045355_q92u9 | US002D | 2024-10-31T12:21:36.451Z | 2024-11-06T14:27:28.906Z |
5432580 | 5432580 | 20241029035459_QdNBA | US002D | 2024-10-31T12:21:27.532Z | 2024-11-06T14:27:27.969Z |
5432220 | 5432220 | 20241029025603_JAURA | US002D | 2024-10-31T12:21:13.615Z | 2024-11-06T14:27:26.263Z |
5423363 | 5423363 | 20241029095723_ocz3e | US002D | 2024-10-31T12:01:16.564Z | 2024-11-07T14:26:25.456Z |
5423354 | 5423354 | 20241029095012_7mPGm | US002D | 2024-10-31T12:01:12.587Z | 2024-11-07T14:26:25.364Z |
5423300 | 5423300 | 20241029092512_PZFFf | US002D | 2024-10-31T12:00:55.741Z | 2024-11-07T14:26:24.957Z |
5423295 | 5423295 | 20241029092339_RFTqf | US002D | 2024-10-31T12:00:54.758Z | 2024-11-07T14:26:24.946Z |
5423271 | 5423271 | 20241029090025_JhxGm | US002D | 2024-10-31T12:00:50.436Z | 2024-11-07T14:26:24.806Z |
5423246 | 5423246 | 20241029085121_82UHC | US002D | 2024-10-31T12:00:46.302Z | 2024-11-07T14:26:24.658Z |
5423217 | 5423217 | 20241029083501_Q3hGc | US002D | 2024-10-31T12:00:40.257Z | 2024-11-07T14:26:24.486Z |
5423209 | 5423209 | 20241029083010_8ULYD | US002D | 2024-10-31T12:00:38.838Z | 2024-11-07T14:26:24.465Z |
5423199 | 5423199 | 20241029080817_uOMDp | US002D | 2024-10-31T12:00:34.821Z | 2024-11-07T14:26:24.396Z |
5423149 | 5423149 | 20241029073414_hhbAI | US002D | 2024-10-31T12:00:23.393Z | 2024-11-07T14:26:24.124Z |
5421445 | 5421445 | 20241028063952_qz9vg | US002D | 2024-10-30T12:19:56.598Z | 2024-11-05T14:27:18.713Z |
5421368 | 5421368 | 20241028060834_59N28 | US002D | 2024-10-30T12:19:52.821Z | 2024-11-05T14:27:18.384Z |
5421337 | 5421337 | 20241028055252_W28IE | US002D | 2024-10-30T12:19:51.755Z | 2024-11-05T14:27:18.211Z |
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);