participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
609 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 |
---|---|---|---|---|---|
5632458 | 5632458 | 20241129095801_QltLy | US003Q | 2024-11-30T14:11:05.612Z | 2024-11-30T14:11:05.612Z |
5632421 | 5632421 | 20241129095359_2AIQg | US003Q | 2024-11-30T14:11:03.376Z | 2024-11-30T14:11:03.376Z |
5620738 | 5620738 | 20241127005551_LXxGb | US003Q | 2024-11-28T14:16:42.183Z | 2024-11-30T14:25:18.369Z |
5602168 | 5602168 | 20241125110602_t2BF3 | US003Q | 2024-11-26T14:07:46.742Z | 2024-11-30T14:25:45.306Z |
5602122 | 5602122 | 20241125110155_Hfq6r | US003Q | 2024-11-26T14:07:41.164Z | 2024-11-30T14:25:45.186Z |
5601419 | 5601419 | 20241125084744_652Vp | US003Q | 2024-11-26T14:05:34.377Z | 2024-11-30T14:25:39.290Z |
5575952 | 5575952 | 20241122105042_SXxdi | US003Q | 2024-11-23T14:08:07.864Z | 2024-11-30T14:28:12.171Z |
5575493 | 5575493 | 20241122093302_C2KpR | US003Q | 2024-11-23T14:06:40.558Z | 2024-11-30T14:28:09.493Z |
5574270 | 5574270 | 20241122053047_yfIIS | US003Q | 2024-11-23T14:02:57.022Z | 2024-11-30T14:28:05.107Z |
5566738 | 5566738 | 20241121073531_NJviR | US003Q | 2024-11-22T14:03:49.700Z | 2024-11-30T14:28:42.707Z |
5549745 | 5549745 | 20241118061417_9YRWZ | US003Q | 2024-11-19T14:00:42.428Z | 2024-11-27T14:25:21.886Z |
5538137 | 5538137 | 20241113021930_D3Ey5 | US003Q | 2024-11-14T14:12:54.324Z | 2024-11-21T14:26:21.008Z |
5533853 | 5533853 | 20241113101855_fNhsB | US003Q | 2024-11-14T14:03:03.671Z | 2024-11-22T14:24:11.535Z |
5532888 | 5532888 | 20241113061132_Edy4f | US003Q | 2024-11-14T14:00:27.858Z | 2024-11-22T14:24:05.930Z |
5529037 | 5529037 | 20241111232147_O2DLk | US003Q | 2024-11-13T14:11:59.846Z | 2024-11-20T14:25:39.102Z |
5510822 | 5510822 | 20241109034107_Jio7h | US003Q | 2024-11-10T14:15:44.964Z | 2024-11-17T14:24:01.639Z |
5507128 | 5507128 | 20241109103421_N0Lo3 | US003Q | 2024-11-10T14:04:19.815Z | 2024-11-18T14:26:07.138Z |
5506391 | 5506391 | 20241109083326_ldGnj | US003Q | 2024-11-10T14:02:01.689Z | 2024-11-18T14:25:59.029Z |
5506033 | 5506033 | 20241109072746_J0pV2 | US003Q | 2024-11-10T14:01:05.012Z | 2024-11-18T14:25:55.790Z |
5505901 | 5505901 | 20241109070016_TPEEc | US003Q | 2024-11-10T14:00:41.991Z | 2024-11-18T14:25:54.543Z |
5505894 | 5505894 | 20241109065914_BIx3O | US003Q | 2024-11-10T14:00:41.133Z | 2024-11-18T14:25:54.383Z |
5498984 | 5498984 | 20241108103916_s5Ycd | US003Q | 2024-11-09T14:02:55.373Z | 2024-11-17T14:23:03.311Z |
5491856 | 5491856 | 20241106053453_JX293 | US003Q | 2024-11-07T14:17:11.834Z | 2024-11-14T14:23:26.991Z |
5479440 | 5479440 | 20241105092721_qTcww | US003Q | 2024-11-06T14:02:16.406Z | 2024-11-14T14:22:58.894Z |
5478705 | 5478705 | 20241104051253_bdL6i | US003Q | 2024-11-05T14:18:43.156Z | 2024-11-12T14:28:16.590Z |
5478085 | 5478085 | 20241104031846_LTCfs | US003Q | 2024-11-05T14:17:53.548Z | 2024-11-12T14:28:14.167Z |
5477924 | 5477924 | 20241104025338_5TQlW | US003Q | 2024-11-05T14:17:36.797Z | 2024-11-12T14:28:13.299Z |
5470899 | 5470899 | 20241104100113_Bj35I | US003Q | 2024-11-05T14:02:13.973Z | 2024-11-13T14:27:23.126Z |
5470606 | 5470606 | 20241104085734_A1Baa | US003Q | 2024-11-05T14:01:13.198Z | 2024-11-13T14:27:22.455Z |
5470560 | 5470560 | 20241104084828_Ed0zk | US003Q | 2024-11-05T14:01:05.557Z | 2024-11-13T14:27:22.351Z |
5470536 | 5470536 | 20241104083914_l992U | US003Q | 2024-11-05T14:01:01.853Z | 2024-11-13T14:27:22.326Z |
5470411 | 5470411 | 20241104075911_3XwW7 | US003Q | 2024-11-05T14:00:33.477Z | 2024-11-13T14:27:21.957Z |
5470350 | 5470350 | 20241104073052_WE4N2 | US003Q | 2024-11-05T14:00:20.722Z | 2024-11-13T14:27:21.804Z |
5470303 | 5470303 | 20241104064619_HoAqK | US003Q | 2024-11-05T14:00:10.518Z | 2024-11-13T14:27:21.636Z |
5470097 | 5470097 | 20241103052839_gHUO1 | US003Q | 2024-11-04T14:17:47.648Z | 2024-11-11T14:23:04.287Z |
5469438 | 5469438 | 20241103032714_9Kfaw | US003Q | 2024-11-04T14:16:27.932Z | 2024-11-11T14:23:00.284Z |
5464767 | 5464767 | 20241103090740_g5zHj | US003Q | 2024-11-04T14:01:36.864Z | 2024-11-12T14:27:43.186Z |
5464611 | 5464611 | 20241103083202_m4mN3 | US003Q | 2024-11-04T14:01:06.809Z | 2024-11-12T14:27:42.668Z |
5464490 | 5464490 | 20241103074326_q9SN2 | US003Q | 2024-11-04T14:00:40.366Z | 2024-11-12T14:27:41.987Z |
5464442 | 5464442 | 20241103072358_zgZPh | US003Q | 2024-11-04T14:00:29.351Z | 2024-11-12T14:27:41.678Z |
5463653 | 5463653 | 20241102042829_u1Vzk | US003Q | 2024-11-03T14:19:06.870Z | 2024-11-10T14:26:35.793Z |
5463415 | 5463415 | 20241102033524_lrsxe | US003Q | 2024-11-03T14:18:44.272Z | 2024-11-10T14:26:35.145Z |
5462390 | 5462390 | 20241102000907_SvE2m | US003Q | 2024-11-03T14:17:21.822Z | 2024-11-10T14:26:32.427Z |
5456259 | 5456259 | 20241102104916_B8cCm | US003Q | 2024-11-03T14:03:55.718Z | 2024-11-11T14:22:27.404Z |
5455832 | 5455832 | 20241102092633_aikTP | US003Q | 2024-11-03T14:02:26.530Z | 2024-11-11T14:22:24.424Z |
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 |
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);