participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
588 rows where station_code = "US003Q" 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 |
---|---|---|---|---|---|
5498984 | 5498984 | 20241108103916_s5Ycd | US003Q | 2024-11-09T14:02:55.373Z | 2024-11-09T14:02:55.373Z |
5491856 | 5491856 | 20241106053453_JX293 | US003Q | 2024-11-07T14:17:11.834Z | 2024-11-09T14:20:15.422Z |
5479440 | 5479440 | 20241105092721_qTcww | US003Q | 2024-11-06T14:02:16.406Z | 2024-11-09T14:19:06.122Z |
5478705 | 5478705 | 20241104051253_bdL6i | US003Q | 2024-11-05T14:18:43.156Z | 2024-11-09T14:22:30.834Z |
5478085 | 5478085 | 20241104031846_LTCfs | US003Q | 2024-11-05T14:17:53.548Z | 2024-11-09T14:22:25.068Z |
5477924 | 5477924 | 20241104025338_5TQlW | US003Q | 2024-11-05T14:17:36.797Z | 2024-11-09T14:22:22.908Z |
5470899 | 5470899 | 20241104100113_Bj35I | US003Q | 2024-11-05T14:02:13.973Z | 2024-11-09T14:20:25.894Z |
5470606 | 5470606 | 20241104085734_A1Baa | US003Q | 2024-11-05T14:01:13.198Z | 2024-11-09T14:20:21.770Z |
5470560 | 5470560 | 20241104084828_Ed0zk | US003Q | 2024-11-05T14:01:05.557Z | 2024-11-09T14:20:21.350Z |
5470536 | 5470536 | 20241104083914_l992U | US003Q | 2024-11-05T14:01:01.853Z | 2024-11-09T14:20:21.267Z |
5470411 | 5470411 | 20241104075911_3XwW7 | US003Q | 2024-11-05T14:00:33.477Z | 2024-11-09T14:20:19.373Z |
5470350 | 5470350 | 20241104073052_WE4N2 | US003Q | 2024-11-05T14:00:20.722Z | 2024-11-09T14:20:18.685Z |
5470303 | 5470303 | 20241104064619_HoAqK | US003Q | 2024-11-05T14:00:10.518Z | 2024-11-09T14:20:18.004Z |
5470097 | 5470097 | 20241103052839_gHUO1 | US003Q | 2024-11-04T14:17:47.648Z | 2024-11-09T14:23:05.405Z |
5469438 | 5469438 | 20241103032714_9Kfaw | US003Q | 2024-11-04T14:16:27.932Z | 2024-11-09T14:23:02.589Z |
5464767 | 5464767 | 20241103090740_g5zHj | US003Q | 2024-11-04T14:01:36.864Z | 2024-11-09T14:21:28.687Z |
5464611 | 5464611 | 20241103083202_m4mN3 | US003Q | 2024-11-04T14:01:06.809Z | 2024-11-09T14:21:27.027Z |
5464490 | 5464490 | 20241103074326_q9SN2 | US003Q | 2024-11-04T14:00:40.366Z | 2024-11-09T14:21:25.948Z |
5464442 | 5464442 | 20241103072358_zgZPh | US003Q | 2024-11-04T14:00:29.351Z | 2024-11-09T14:21:25.495Z |
5463653 | 5463653 | 20241102042829_u1Vzk | US003Q | 2024-11-03T14:19:06.870Z | 2024-11-09T14:23:42.996Z |
5463415 | 5463415 | 20241102033524_lrsxe | US003Q | 2024-11-03T14:18:44.272Z | 2024-11-09T14:23:40.713Z |
5462390 | 5462390 | 20241102000907_SvE2m | US003Q | 2024-11-03T14:17:21.822Z | 2024-11-09T14:23:34.146Z |
5456259 | 5456259 | 20241102104916_B8cCm | US003Q | 2024-11-03T14:03:55.718Z | 2024-11-09T14:22:42.619Z |
5455832 | 5455832 | 20241102092633_aikTP | US003Q | 2024-11-03T14:02:26.530Z | 2024-11-09T14:22:39.952Z |
5454991 | 5454991 | 20241031060110_bO1KA | US003Q | 2024-11-02T12:23:28.905Z | 2024-11-08T14:23:26.599Z |
5454425 | 5454425 | 20241031041957_10b7d | US003Q | 2024-11-02T12:23:06.020Z | 2024-11-08T14:23:22.932Z |
5444853 | 5444853 | 20241028032557_hNilT | US003Q | 2024-11-01T12:24:07.118Z | 2024-11-05T14:27:16.125Z |
5444812 | 5444812 | 20241028002952_BYp6U | US003Q | 2024-11-01T12:23:59.897Z | 2024-11-05T14:27:13.587Z |
5444764 | 5444764 | 20241029052620_mcEGW | US003Q | 2024-11-01T12:23:08.668Z | 2024-11-06T14:27:29.392Z |
5444751 | 5444751 | 20241029051249_t3y46 | US003Q | 2024-11-01T12:23:08.096Z | 2024-11-06T14:27:29.244Z |
5444747 | 5444747 | 20241029050453_0BxtF | US003Q | 2024-11-01T12:23:07.708Z | 2024-11-06T14:27:29.073Z |
5444705 | 5444705 | 20241029024744_wjU32 | US003Q | 2024-11-01T12:22:56.629Z | 2024-11-06T14:27:26.052Z |
5444639 | 5444639 | 20241028094917_8rJ2s | US003Q | 2024-11-01T12:21:45.077Z | 2024-11-06T14:27:05.471Z |
5444563 | 5444563 | 20241028075613_5l336 | US003Q | 2024-11-01T12:21:35.564Z | 2024-11-06T14:27:03.422Z |
5441010 | 5441010 | 20241029082605_IGQHN | US003Q | 2024-11-01T12:16:19.365Z | 2024-11-07T14:26:24.422Z |
5434185 | 5434185 | 20241030083401_WBJXS | US003Q | 2024-11-01T12:01:28.585Z | 2024-11-08T14:22:45.504Z |
5433886 | 5433886 | 20241030073259_Cr9s6 | US003Q | 2024-11-01T12:00:26.868Z | 2024-11-08T14:22:43.630Z |
5412557 | 5412557 | 20241025052244_KJ12i | US003Q | 2024-10-29T12:23:34.205Z | 2024-11-02T12:28:34.418Z |
5412535 | 5412535 | 20241025044010_DRf9N | US003Q | 2024-10-29T12:23:33.004Z | 2024-11-02T12:28:34.039Z |
5412477 | 5412477 | 20241025005355_aWO6T | US003Q | 2024-10-29T12:23:20.735Z | 2024-11-02T12:28:31.297Z |
5412456 | 5412456 | 20241026050000_VP9JM | US003Q | 2024-10-29T12:22:09.460Z | 2024-11-03T14:27:40.424Z |
5412338 | 5412338 | 20241025075859_sBo36 | US003Q | 2024-10-29T12:19:59.045Z | 2024-11-03T14:27:06.265Z |
5412323 | 5412323 | 20241025073529_3Zfz4 | US003Q | 2024-10-29T12:19:54.229Z | 2024-11-03T14:27:05.480Z |
5401645 | 5401645 | 20241026083138_Q2fT8 | US003Q | 2024-10-29T12:02:41.504Z | 2024-11-04T14:28:25.906Z |
5400893 | 5400893 | 20241023061527_r22cl | US003Q | 2024-10-28T12:25:33.774Z | 2024-10-31T12:30:12.325Z |
5400875 | 5400875 | 20241023053232_7aKIB | US003Q | 2024-10-28T12:25:33.014Z | 2024-10-31T12:30:11.364Z |
5400851 | 5400851 | 20241023044237_DXBbB | US003Q | 2024-10-28T12:25:31.075Z | 2024-10-31T12:30:09.289Z |
5400827 | 5400827 | 20241023040109_vMk3Y | US003Q | 2024-10-28T12:25:29.703Z | 2024-10-31T12:30:08.502Z |
5400776 | 5400776 | 20241023011935_IGzHB | US003Q | 2024-10-28T12:25:21.869Z | 2024-10-31T12:30:04.128Z |
5400710 | 5400710 | 20241022085020_kWpLZ | US003Q | 2024-10-28T12:24:43.692Z | 2024-10-31T12:29:42.233Z |
5400705 | 5400705 | 20241022084228_C3G7a | US003Q | 2024-10-28T12:24:42.619Z | 2024-10-31T12:29:41.756Z |
5400573 | 5400573 | 20241023095117_8O7cu | US003Q | 2024-10-28T12:23:32.643Z | 2024-11-01T12:26:40.771Z |
5400562 | 5400562 | 20241023093659_EnOcZ | US003Q | 2024-10-28T12:23:31.471Z | 2024-11-01T12:26:40.471Z |
5400552 | 5400552 | 20241023092651_ZDSQf | US003Q | 2024-10-28T12:23:30.657Z | 2024-11-01T12:26:40.054Z |
5400517 | 5400517 | 20241023074231_5esHo | US003Q | 2024-10-28T12:23:24.017Z | 2024-11-01T12:26:36.739Z |
5400427 | 5400427 | 20241024093541_Y372P | US003Q | 2024-10-28T12:20:58.941Z | 2024-11-02T12:28:15.652Z |
5264380 | 5264380 | 20241009083609_E95MT | US003Q | 2024-10-10T12:03:58.100Z | 2024-10-18T12:21:43.583Z |
5263940 | 5263940 | 20241009064802_GTlhd | US003Q | 2024-10-10T12:02:36.269Z | 2024-10-18T12:21:39.595Z |
5263932 | 5263932 | 20241009064503_qctGI | US003Q | 2024-10-10T12:02:33.893Z | 2024-10-18T12:21:39.551Z |
5263602 | 5263602 | 20241009050711_l25EN | US003Q | 2024-10-10T12:01:32.674Z | 2024-10-18T12:21:36.056Z |
5263257 | 5263257 | 20241009035228_2jlRY | US003Q | 2024-10-10T12:00:21.794Z | 2024-10-18T12:21:31.555Z |
5263107 | 5263107 | 20241008030839_Pk3X7 | US003Q | 2024-10-09T12:16:38.854Z | 2024-10-16T12:21:21.596Z |
5257370 | 5257370 | 20241008094832_rh01g | US003Q | 2024-10-09T12:04:59.457Z | 2024-10-17T12:20:00.028Z |
5257088 | 5257088 | 20241008085927_reefR | US003Q | 2024-10-09T12:04:22.536Z | 2024-10-17T12:19:58.440Z |
5256682 | 5256682 | 20241008074241_jDq97 | US003Q | 2024-10-09T12:03:30.128Z | 2024-10-17T12:19:57.237Z |
5256410 | 5256410 | 20241008065400_am1ka | US003Q | 2024-10-09T12:02:57.275Z | 2024-10-17T12:19:56.310Z |
5256370 | 5256370 | 20241008064717_Iqats | US003Q | 2024-10-09T12:02:50.030Z | 2024-10-17T12:19:56.238Z |
5256203 | 5256203 | 20241008062323_yJ2SX | US003Q | 2024-10-09T12:02:34.249Z | 2024-10-17T12:19:55.735Z |
5255872 | 5255872 | 20241008053308_qpQcO | US003Q | 2024-10-09T12:01:56.312Z | 2024-10-17T12:19:54.360Z |
5253743 | 5253743 | 20241007003741_XuUCy | US003Q | 2024-10-08T12:13:36.298Z | 2024-10-15T12:29:10.663Z |
5249722 | 5249722 | 20241007100039_FCBOH | US003Q | 2024-10-08T12:05:40.021Z | 2024-10-16T12:21:05.159Z |
5246338 | 5246338 | 20241006013322_aXpAJ | US003Q | 2024-10-07T12:16:23.576Z | 2024-10-14T12:24:37.805Z |
5240381 | 5240381 | 20241005065042_zC25n | US003Q | 2024-10-07T12:08:13.478Z | 2024-10-14T12:24:22.780Z |
5238023 | 5238023 | 20241006071900_OIetr | US003Q | 2024-10-07T12:03:18.238Z | 2024-10-15T12:28:46.664Z |
5237949 | 5237949 | 20241006070331_2s7ro | US003Q | 2024-10-07T12:03:08.100Z | 2024-10-15T12:28:46.187Z |
5237943 | 5237943 | 20241006070222_bxR3N | US003Q | 2024-10-07T12:03:07.368Z | 2024-10-15T12:28:46.173Z |
5236972 | 5236972 | 20241006024153_NyAG8 | US003Q | 2024-10-07T12:00:15.208Z | 2024-10-15T12:28:37.418Z |
5143615 | 5143615 | 20240921071307_swokd | US003Q | 2024-09-22T12:05:15.719Z | 2024-09-29T12:22:08.651Z |
5143468 | 5143468 | 20240921052520_MnrUS | US003Q | 2024-09-22T12:04:46.792Z | 2024-09-29T12:22:07.478Z |
5143426 | 5143426 | 20240921045938_8oZUv | US003Q | 2024-09-22T12:04:41.740Z | 2024-09-29T12:22:07.285Z |
5143350 | 5143350 | 20240921041838_vZ3Vg | US003Q | 2024-09-22T12:04:33.091Z | 2024-09-29T12:22:06.806Z |
5123289 | 5123289 | 20240914093506_kXWjZ | US003Q | 2024-09-18T12:11:44.066Z | 2024-09-22T12:18:07.215Z |
5123206 | 5123206 | 20240914091659_QhDJY | US003Q | 2024-09-18T12:11:42.366Z | 2024-09-22T12:18:06.995Z |
5123085 | 5123085 | 20240914084953_zPdSs | US003Q | 2024-09-18T12:11:39.601Z | 2024-09-22T12:18:06.646Z |
5108857 | 5108857 | 20240913074752_k4124 | US003Q | 2024-09-17T12:14:10.763Z | 2024-09-21T12:16:43.189Z |
5095087 | 5095087 | 20240912054533_RCfyk | US003Q | 2024-09-16T12:15:13.365Z | 2024-09-20T12:21:57.344Z |
5080911 | 5080911 | 20240911052239_S5cDh | US003Q | 2024-09-15T12:17:17.039Z | 2024-09-19T12:21:44.038Z |
5067249 | 5067249 | 20240910091212_KxwMv | US003Q | 2024-09-14T12:18:37.273Z | 2024-09-18T12:15:23.677Z |
5067138 | 5067138 | 20240910085900_2drlE | US003Q | 2024-09-14T12:18:33.521Z | 2024-09-18T12:15:23.461Z |
5067031 | 5067031 | 20240910084832_uFwF5 | US003Q | 2024-09-14T12:18:27.456Z | 2024-09-18T12:15:23.221Z |
5066821 | 5066821 | 20240910082111_7ohb2 | US003Q | 2024-09-14T12:18:15.166Z | 2024-09-18T12:15:22.814Z |
5066599 | 5066599 | 20240910075328_8Djhn | US003Q | 2024-09-14T12:18:04.170Z | 2024-09-18T12:15:22.275Z |
5066214 | 5066214 | 20240910065331_edcEg | US003Q | 2024-09-14T12:17:45.348Z | 2024-09-18T12:15:21.388Z |
5065781 | 5065781 | 20240910053239_2zsS3 | US003Q | 2024-09-14T12:17:23.542Z | 2024-09-18T12:15:20.394Z |
5065753 | 5065753 | 20240910052657_Avc0I | US003Q | 2024-09-14T12:17:22.595Z | 2024-09-18T12:15:20.310Z |
5055967 | 5055967 | 20240908092735_mNsFB | US003Q | 2024-09-13T12:17:26.111Z | 2024-09-16T12:21:22.847Z |
5055824 | 5055824 | 20240908090746_s3ufj | US003Q | 2024-09-13T12:17:23.611Z | 2024-09-16T12:21:22.146Z |
5055538 | 5055538 | 20240908082124_KBYHv | US003Q | 2024-09-13T12:17:16.659Z | 2024-09-16T12:21:20.272Z |
5055063 | 5055063 | 20240908062618_JxORt | US003Q | 2024-09-13T12:17:04.737Z | 2024-09-16T12:21:17.836Z |
5055051 | 5055051 | 20240908062339_1WmQg | US003Q | 2024-09-13T12:17:04.448Z | 2024-09-16T12:21:17.794Z |
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);