participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,343 rows where station_code = "US001E" 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 |
---|---|---|---|---|---|
5130482 | 5130482 | 20240917122053_7PgVy | US001E | 2024-09-19T12:13:22.860Z | 2024-09-19T12:13:22.860Z |
5130457 | 5130457 | 20240917120848_RPVgJ | US001E | 2024-09-19T12:13:19.175Z | 2024-09-19T12:13:19.175Z |
5130444 | 5130444 | 20240917120358_623yq | US001E | 2024-09-19T12:13:16.919Z | 2024-09-19T12:13:16.919Z |
5130422 | 5130422 | 20240917115538_sCIBt | US001E | 2024-09-19T12:13:14.530Z | 2024-09-19T12:13:14.530Z |
5130420 | 5130420 | 20240917115406_mSen4 | US001E | 2024-09-19T12:13:13.967Z | 2024-09-19T12:13:13.967Z |
5095205 | 5095205 | 20240912063619_cpOLm | US001E | 2024-09-16T12:15:22.168Z | 2024-09-19T12:21:17.501Z |
5067958 | 5067958 | 20240910103604_KaVpZ | US001E | 2024-09-14T12:19:05.815Z | 2024-09-18T12:15:25.282Z |
5049126 | 5049126 | 20240909101137_DwN5E | US001E | 2024-09-13T12:11:37.115Z | 2024-09-17T12:19:09.235Z |
5048782 | 5048782 | 20240909090653_erBHj | US001E | 2024-09-13T12:11:15.241Z | 2024-09-17T12:19:08.276Z |
5047807 | 5047807 | 20240909060258_ScxrF | US001E | 2024-09-13T12:09:43.897Z | 2024-09-17T12:19:04.403Z |
5047801 | 5047801 | 20240909060024_Yb2pH | US001E | 2024-09-13T12:09:43.182Z | 2024-09-17T12:19:04.338Z |
5047361 | 5047361 | 20240909033916_gIDZF | US001E | 2024-09-13T12:08:51.943Z | 2024-09-17T12:19:02.179Z |
5040455 | 5040455 | 20240906041725_HCAD9 | US001E | 2024-09-12T12:16:11.991Z | 2024-09-14T12:23:09.275Z |
5035942 | 5035942 | 20240905121424_PyvgN | US001E | 2024-09-12T12:13:12.777Z | 2024-09-14T12:22:51.667Z |
5035938 | 5035938 | 20240905121343_GmqMo | US001E | 2024-09-12T12:13:12.439Z | 2024-09-14T12:22:51.639Z |
5029577 | 5029577 | 20240905100055_adX2Q | US001E | 2024-09-11T12:16:46.531Z | 2024-09-13T12:20:06.548Z |
5029543 | 5029543 | 20240905095415_OmN9C | US001E | 2024-09-11T12:16:44.799Z | 2024-09-13T12:20:06.480Z |
5029160 | 5029160 | 20240905113854_TjL1U | US001E | 2024-09-11T12:16:15.649Z | 2024-09-14T12:22:51.144Z |
5029107 | 5029107 | 20240905113115_475kq | US001E | 2024-09-11T12:16:10.253Z | 2024-09-14T12:22:50.743Z |
5028672 | 5028672 | 20240905103637_6W9e3 | US001E | 2024-09-11T12:15:41.457Z | 2024-09-14T12:22:48.762Z |
5028627 | 5028627 | 20240905103038_zR02R | US001E | 2024-09-11T12:15:38.524Z | 2024-09-14T12:22:48.667Z |
5028621 | 5028621 | 20240905102912_BZ3fs | US001E | 2024-09-11T12:15:38.077Z | 2024-09-14T12:22:48.537Z |
5028613 | 5028613 | 20240905102808_PdA9T | US001E | 2024-09-11T12:15:37.166Z | 2024-09-14T12:22:48.435Z |
5028073 | 5028073 | 20240905085930_KP85i | US001E | 2024-09-11T12:14:49.389Z | 2024-09-13T12:20:05.233Z |
5027961 | 5027961 | 20240905084348_oMDr5 | US001E | 2024-09-11T12:14:40.066Z | 2024-09-13T12:20:05.073Z |
5027833 | 5027833 | 20240905082747_2Or2I | US001E | 2024-09-11T12:14:33.695Z | 2024-09-13T12:20:04.765Z |
5027801 | 5027801 | 20240905082426_GFr2M | US001E | 2024-09-11T12:14:31.241Z | 2024-09-13T12:20:04.735Z |
5027758 | 5027758 | 20240905081817_xJij2 | US001E | 2024-09-11T12:14:27.988Z | 2024-09-13T12:20:04.553Z |
5027591 | 5027591 | 20240905075817_h18fj | US001E | 2024-09-11T12:14:18.998Z | 2024-09-13T12:20:03.949Z |
5027052 | 5027052 | 20240905062644_TwLjE | US001E | 2024-09-11T12:13:35.108Z | 2024-09-13T12:20:01.120Z |
5027042 | 5027042 | 20240905062311_055Q3 | US001E | 2024-09-11T12:13:33.753Z | 2024-09-13T12:20:01.079Z |
5026887 | 5026887 | 20240905055536_RT7C3 | US001E | 2024-09-11T12:13:19.568Z | 2024-09-13T12:20:00.317Z |
5026516 | 5026516 | 20240905035014_wIn8n | US001E | 2024-09-11T12:12:39.459Z | 2024-09-13T12:19:58.560Z |
5026433 | 5026433 | 20240905032848_ZGYTB | US001E | 2024-09-11T12:12:29.308Z | 2024-09-13T12:19:58.235Z |
5023008 | 5023008 | 20240905100055_aS8DC | US001E | 2024-09-10T12:16:34.722Z | 2024-09-11T12:15:21.656Z |
5022974 | 5022974 | 20240905095415_bZisE | US001E | 2024-09-10T12:16:33.699Z | 2024-09-11T12:15:20.322Z |
5022513 | 5022513 | 20240905085930_in5br | US001E | 2024-09-10T12:16:22.138Z | 2024-09-10T12:16:55.565Z |
5022400 | 5022400 | 20240905084348_9r7IJ | US001E | 2024-09-10T12:16:16.991Z | 2024-09-10T12:16:55.546Z |
5022279 | 5022279 | 20240905082747_ytNZH | US001E | 2024-09-10T12:16:13.185Z | 2024-09-10T12:16:55.526Z |
5022247 | 5022247 | 20240905082426_rfPJb | US001E | 2024-09-10T12:16:12.665Z | 2024-09-10T12:16:55.522Z |
5022196 | 5022196 | 20240905081817_lkA6D | US001E | 2024-09-10T12:16:10.094Z | 2024-09-10T12:16:55.513Z |
5022032 | 5022032 | 20240905075817_lQFgI | US001E | 2024-09-10T12:16:02.354Z | 2024-09-10T12:16:55.482Z |
5021638 | 5021638 | 20240905070116_sIf5k | US001E | 2024-09-10T12:15:44.808Z | 2024-09-10T12:16:55.413Z |
5021508 | 5021508 | 20240905062644_cZcVl | US001E | 2024-09-10T12:15:37.023Z | 2024-09-10T12:16:55.386Z |
5021498 | 5021498 | 20240905062311_hdYgH | US001E | 2024-09-10T12:15:36.528Z | 2024-09-13T12:20:01.088Z |
5021349 | 5021349 | 20240905055536_kkj8P | US001E | 2024-09-10T12:15:27.729Z | 2024-09-10T12:16:55.358Z |
5020976 | 5020976 | 20240905035014_xemJ9 | US001E | 2024-09-10T12:15:09.699Z | 2024-09-10T12:16:55.284Z |
5020887 | 5020887 | 20240905032848_220yA | US001E | 2024-09-10T12:15:06.281Z | 2024-09-10T12:16:55.265Z |
5015659 | 5015659 | 20240904120620_eZxS6 | US001E | 2024-09-10T12:06:35.777Z | 2024-09-13T12:19:44.562Z |
5015598 | 5015598 | 20240904115807_uVHdU | US001E | 2024-09-10T12:06:30.211Z | 2024-09-13T12:19:44.363Z |
5014273 | 5014273 | 20240905121424_AYMuA | US001E | 2024-09-10T12:02:41.933Z | 2024-09-11T12:16:31.104Z |
5014269 | 5014269 | 20240905121343_s4nAt | US001E | 2024-09-10T12:02:41.135Z | 2024-09-11T12:16:31.102Z |
5013973 | 5013973 | 20240905113854_Hv76x | US001E | 2024-09-10T12:01:59.237Z | 2024-09-11T12:00:44.368Z |
5013913 | 5013913 | 20240905113115_NF5Yl | US001E | 2024-09-10T12:01:48.769Z | 2024-09-11T12:00:41.002Z |
5013484 | 5013484 | 20240905103637_3iasu | US001E | 2024-09-10T12:00:49.016Z | 2024-09-14T12:22:48.769Z |
5013437 | 5013437 | 20240905103038_k2LE0 | US001E | 2024-09-10T12:00:38.983Z | 2024-09-11T12:00:20.479Z |
5013431 | 5013431 | 20240905102912_mF0We | US001E | 2024-09-10T12:00:38.038Z | 2024-09-11T12:00:20.219Z |
5013423 | 5013423 | 20240905102808_yQSaJ | US001E | 2024-09-10T12:00:35.897Z | 2024-09-11T12:00:19.607Z |
5012183 | 5012183 | 20240904085311_BvXVy | US001E | 2024-09-09T12:10:25.389Z | 2024-09-12T12:19:35.310Z |
5012145 | 5012145 | 20240904084506_BVV23 | US001E | 2024-09-09T12:10:23.375Z | 2024-09-12T12:19:34.903Z |
5011944 | 5011944 | 20240904081804_1yVPD | US001E | 2024-09-09T12:10:10.269Z | 2024-09-12T12:19:34.340Z |
5011843 | 5011843 | 20240904080601_eNypl | US001E | 2024-09-09T12:10:04.637Z | 2024-09-12T12:19:33.803Z |
5011222 | 5011222 | 20240904054055_cy2YL | US001E | 2024-09-09T12:09:30.523Z | 2024-09-12T12:19:30.894Z |
5010982 | 5010982 | 20240904041208_4bzss | US001E | 2024-09-09T12:09:17.415Z | 2024-09-12T12:19:30.058Z |
5004746 | 5004746 | 20240903122310_Vx53n | US001E | 2024-09-09T12:02:58.041Z | 2024-09-12T12:19:03.715Z |
5004726 | 5004726 | 20240903121608_u28HB | US001E | 2024-09-09T12:02:56.618Z | 2024-09-12T12:19:03.664Z |
5004482 | 5004482 | 20240903113619_h3tKB | US001E | 2024-09-09T12:02:45.023Z | 2024-09-12T12:19:02.351Z |
5004371 | 5004371 | 20240903112057_0cw3B | US001E | 2024-09-09T12:02:39.160Z | 2024-09-12T12:19:01.824Z |
5004231 | 5004231 | 20240903110124_BQcFd | US001E | 2024-09-09T12:02:29.077Z | 2024-09-12T12:19:01.294Z |
5003836 | 5003836 | 20240903100148_hbI9Z | US001E | 2024-09-09T12:02:07.538Z | 2024-09-12T12:18:59.475Z |
5003804 | 5003804 | 20240903095644_uSDN3 | US001E | 2024-09-09T12:02:05.488Z | 2024-09-12T12:18:59.187Z |
5003598 | 5003598 | 20240903092158_qY2yk | US001E | 2024-09-09T12:01:53.771Z | 2024-09-12T12:18:58.033Z |
5003375 | 5003375 | 20240903084217_3nesP | US001E | 2024-09-09T12:01:39.959Z | 2024-09-12T12:18:56.216Z |
5003353 | 5003353 | 20240903084048_CdMdb | US001E | 2024-09-09T12:01:38.429Z | 2024-09-12T12:18:56.079Z |
5003310 | 5003310 | 20240904113632_cCSrs | US001E | 2024-09-09T12:01:33.221Z | 2024-09-13T12:19:44.001Z |
5003098 | 5003098 | 20240904111143_A070h | US001E | 2024-09-09T12:01:20.278Z | 2024-09-13T12:19:43.348Z |
5002352 | 5002352 | 20240904093810_1GU93 | US001E | 2024-09-09T12:00:29.779Z | 2024-09-13T12:19:40.568Z |
5002348 | 5002348 | 20240904093555_zvTc2 | US001E | 2024-09-09T12:00:29.222Z | 2024-09-13T12:19:40.566Z |
5002266 | 5002266 | 20240904092856_lhUZv | US001E | 2024-09-09T12:00:20.389Z | 2024-09-13T12:19:40.192Z |
5002263 | 5002263 | 20240904092855_wB2OW | US001E | 2024-09-09T12:00:20.126Z | 2024-09-13T12:19:40.188Z |
5002037 | 5002037 | 20240902073125_724nJ | US001E | 2024-09-08T12:17:07.961Z | 2024-09-10T12:19:35.960Z |
5001666 | 5001666 | 20240902060754_zhfl2 | US001E | 2024-09-08T12:16:51.843Z | 2024-09-10T12:19:33.952Z |
5001313 | 5001313 | 20240902042836_rie5J | US001E | 2024-09-08T12:16:19.154Z | 2024-09-10T12:19:32.816Z |
5001150 | 5001150 | 20240902033923_FTcAp | US001E | 2024-09-08T12:16:12.124Z | 2024-09-10T12:19:32.128Z |
4999359 | 4999359 | 20240903062212_0m6D0 | US001E | 2024-09-08T12:08:41.890Z | 2024-09-11T12:21:17.370Z |
4999204 | 4999204 | 20240903055017_4tjrc | US001E | 2024-09-08T12:08:34.491Z | 2024-09-11T12:21:16.831Z |
4999181 | 4999181 | 20240903054503_XpLfl | US001E | 2024-09-08T12:08:32.917Z | 2024-09-11T12:21:16.728Z |
4999064 | 4999064 | 20240903051613_w6M5g | US001E | 2024-09-08T12:08:27.891Z | 2024-09-11T12:21:16.254Z |
4998918 | 4998918 | 20240903042932_BWHoW | US001E | 2024-09-08T12:08:11.631Z | 2024-09-11T12:21:15.492Z |
4998799 | 4998799 | 20240903040039_qBGmJ | US001E | 2024-09-08T12:08:05.646Z | 2024-09-11T12:21:14.943Z |
4994143 | 4994143 | 20240902122811_RfxOC | US001E | 2024-09-08T12:02:14.637Z | 2024-09-11T12:20:30.641Z |
4994066 | 4994066 | 20240902115956_Qh9q3 | US001E | 2024-09-08T12:02:10.083Z | 2024-09-11T12:20:29.758Z |
4994029 | 4994029 | 20240902115123_IbraH | US001E | 2024-09-08T12:02:08.416Z | 2024-09-11T12:20:29.403Z |
4993456 | 4993456 | 20240902103959_lFZWF | US001E | 2024-09-08T12:01:35.764Z | 2024-09-11T12:20:23.115Z |
4993396 | 4993396 | 20240902102923_rGUiD | US001E | 2024-09-08T12:01:30.981Z | 2024-09-11T12:20:22.436Z |
4993297 | 4993297 | 20240902101337_DCdVx | US001E | 2024-09-08T12:01:23.548Z | 2024-09-11T12:20:21.740Z |
4993290 | 4993290 | 20240902101233_cOD6F | US001E | 2024-09-08T12:01:23.129Z | 2024-09-11T12:20:21.696Z |
4992680 | 4992680 | 20240902083932_rJjBN | US001E | 2024-09-08T12:00:42.863Z | 2024-09-11T12:20:16.305Z |
4992171 | 4992171 | 20240901060737_vUvyl | US001E | 2024-09-07T12:12:59.492Z | 2024-09-09T12:27:52.926Z |
4992017 | 4992017 | 20240901045853_zoIOb | US001E | 2024-09-07T12:12:49.805Z | 2024-09-09T12:27:40.687Z |
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);