participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
851 rows where station_code = "US004N" 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 |
---|---|---|---|---|---|
5573077 | 5573077 | 20241121034903_8JLk3 | US004N | 2024-11-22T14:19:08.652Z | 2024-11-23T14:23:51.451Z |
5572929 | 5572929 | 20241121032528_SzRlR | US004N | 2024-11-22T14:18:59.264Z | 2024-11-23T14:23:49.517Z |
5569702 | 5569702 | 20241120094946_lG8yf | US004N | 2024-11-22T14:12:49.805Z | 2024-11-23T14:22:11.527Z |
5569699 | 5569699 | 20241120091454_21Jbw | US004N | 2024-11-22T14:12:44.629Z | 2024-11-23T14:22:07.213Z |
5567574 | 5567574 | 20241121103725_2yxVr | US004N | 2024-11-22T14:06:32.764Z | 2024-11-23T14:21:24.046Z |
5566815 | 5566815 | 20241121080053_g75d3 | US004N | 2024-11-22T14:04:10.199Z | 2024-11-23T14:21:23.815Z |
5566763 | 5566763 | 20241121074245_D3g7D | US004N | 2024-11-22T14:03:53.111Z | 2024-11-23T14:21:23.798Z |
5566448 | 5566448 | 20241121061301_5WB4Z | US004N | 2024-11-22T14:02:55.133Z | 2024-11-23T14:21:23.706Z |
5566408 | 5566408 | 20241121061022_wgu1R | US004N | 2024-11-22T14:02:50.450Z | 2024-11-23T14:21:23.698Z |
5565998 | 5565998 | 20241121051616_GOFub | US004N | 2024-11-22T14:01:32.934Z | 2024-11-23T14:21:23.590Z |
5565705 | 5565705 | 20241121043711_GERIc | US004N | 2024-11-22T14:00:44.561Z | 2024-11-23T14:21:23.510Z |
5560301 | 5560301 | 20241120123237_GalAj | US004N | 2024-11-21T14:08:33.426Z | 2024-11-23T14:22:33.421Z |
5560171 | 5560171 | 20241120121301_UEmz7 | US004N | 2024-11-21T14:08:11.347Z | 2024-11-23T14:22:31.089Z |
5559724 | 5559724 | 20241120110756_6kYkt | US004N | 2024-11-21T14:07:03.563Z | 2024-11-23T14:22:22.789Z |
5559633 | 5559633 | 20241120105203_PZJZw | US004N | 2024-11-21T14:06:48.787Z | 2024-11-23T14:22:20.585Z |
5559576 | 5559576 | 20241120104435_GbS3l | US004N | 2024-11-21T14:06:38.563Z | 2024-11-23T14:22:19.553Z |
5559540 | 5559540 | 20241120103921_ShKxG | US004N | 2024-11-21T14:06:33.336Z | 2024-11-23T14:22:18.773Z |
5559383 | 5559383 | 20241120101334_TKreO | US004N | 2024-11-21T14:06:12.458Z | 2024-11-23T14:22:15.062Z |
5559262 | 5559262 | 20241120095022_2Amru | US004N | 2024-11-21T14:05:45.539Z | 2024-11-23T14:22:11.576Z |
5559021 | 5559021 | 20241120090532_UeljT | US004N | 2024-11-21T14:05:04.078Z | 2024-11-23T14:22:05.725Z |
5558790 | 5558790 | 20241120080210_9KFJH | US004N | 2024-11-21T14:04:22.811Z | 2024-11-23T14:22:01.438Z |
5557205 | 5557205 | 20241119043158_PBTSm | US004N | 2024-11-20T14:12:27.528Z | 2024-11-23T14:25:10.711Z |
5556765 | 5556765 | 20241119014549_QEDh2 | US004N | 2024-11-20T14:11:26.367Z | 2024-11-23T14:25:08.468Z |
5555194 | 5555194 | 20241119120854_x2EeM | US004N | 2024-11-20T14:04:42.287Z | 2024-11-23T14:24:12.120Z |
5555189 | 5555189 | 20241119120744_zBTx7 | US004N | 2024-11-20T14:04:41.455Z | 2024-11-23T14:24:12.116Z |
5550977 | 5550977 | 20241118120534_q8cIF | US004N | 2024-11-19T14:03:43.319Z | 2024-11-23T14:24:58.756Z |
5550843 | 5550843 | 20241118113508_SlPS8 | US004N | 2024-11-19T14:03:12.095Z | 2024-11-23T14:24:56.911Z |
5550554 | 5550554 | 20241118104542_kgwMu | US004N | 2024-11-19T14:02:34.909Z | 2024-11-23T14:24:54.976Z |
5546702 | 5546702 | 20241117122245_bswFK | US004N | 2024-11-18T14:03:53.148Z | 2024-11-23T14:25:18.835Z |
5546660 | 5546660 | 20241117120714_ECcU1 | US004N | 2024-11-18T14:03:45.298Z | 2024-11-23T14:25:18.604Z |
5546578 | 5546578 | 20241117114608_KB9F4 | US004N | 2024-11-18T14:03:33.178Z | 2024-11-23T14:25:18.193Z |
5546196 | 5546196 | 20241117094050_MdwfL | US004N | 2024-11-18T14:02:25.723Z | 2024-11-23T14:25:16.248Z |
5545967 | 5545967 | 20241117082507_e39FX | US004N | 2024-11-18T14:01:35.585Z | 2024-11-23T14:25:15.170Z |
5544510 | 5544510 | 20241116120317_rOIWI | US004N | 2024-11-17T14:01:21.314Z | 2024-11-23T14:25:35.310Z |
5544410 | 5544410 | 20241116105328_fdrNw | US004N | 2024-11-17T14:01:02.844Z | 2024-11-23T14:25:34.965Z |
5544396 | 5544396 | 20241116104810_oDl0c | US004N | 2024-11-17T14:01:00.920Z | 2024-11-23T14:25:34.920Z |
5544373 | 5544373 | 20241116102928_bWE6l | US004N | 2024-11-17T14:00:57.993Z | 2024-11-23T14:25:34.761Z |
5544193 | 5544193 | 20241116075350_4C3vj | US004N | 2024-11-17T14:00:25.867Z | 2024-11-23T14:25:33.393Z |
5542526 | 5542526 | 20241115104117_2E7yD | US004N | 2024-11-16T14:01:36.101Z | 2024-11-23T14:25:48.916Z |
5542374 | 5542374 | 20241115090014_TBfhJ | US004N | 2024-11-16T14:01:05.585Z | 2024-11-23T14:25:47.670Z |
5541868 | 5541868 | 20241114050011_UG9bJ | US004N | 2024-11-15T14:08:35.877Z | 2024-11-22T14:24:20.737Z |
5541677 | 5541677 | 20241114035132_mb9wN | US004N | 2024-11-15T14:08:09.172Z | 2024-11-22T14:24:19.916Z |
5540807 | 5540807 | 20241114120837_BzKZ3 | US004N | 2024-11-15T14:04:30.553Z | 2024-11-23T14:26:13.382Z |
5540720 | 5540720 | 20241114115503_RFM2l | US004N | 2024-11-15T14:04:20.537Z | 2024-11-23T14:26:13.052Z |
5540597 | 5540597 | 20241114113714_Jm3wc | US004N | 2024-11-15T14:04:07.611Z | 2024-11-23T14:26:12.468Z |
5540569 | 5540569 | 20241114113316_LCVSv | US004N | 2024-11-15T14:04:04.310Z | 2024-11-23T14:26:12.313Z |
5540556 | 5540556 | 20241114113102_bTJbN | US004N | 2024-11-15T14:04:02.552Z | 2024-11-23T14:26:12.223Z |
5540541 | 5540541 | 20241114112530_bMAEC | US004N | 2024-11-15T14:04:00.722Z | 2024-11-23T14:26:11.985Z |
5540516 | 5540516 | 20241114112002_tI01O | US004N | 2024-11-15T14:03:57.903Z | 2024-11-23T14:26:11.868Z |
5540495 | 5540495 | 20241114111401_P7REq | US004N | 2024-11-15T14:03:55.211Z | 2024-11-23T14:26:11.769Z |
5540492 | 5540492 | 20241114111308_yu5Bc | US004N | 2024-11-15T14:03:55.082Z | 2024-11-23T14:26:11.767Z |
5540286 | 5540286 | 20241114103413_br06f | US004N | 2024-11-15T14:03:15.009Z | 2024-11-23T14:26:10.623Z |
5540174 | 5540174 | 20241114101659_2oag3 | US004N | 2024-11-15T14:03:03.981Z | 2024-11-23T14:26:09.635Z |
5540123 | 5540123 | 20241114101150_MqSqa | US004N | 2024-11-15T14:02:59.242Z | 2024-11-23T14:26:09.499Z |
5539993 | 5539993 | 20241114094623_f2Ard | US004N | 2024-11-15T14:02:29.722Z | 2024-11-23T14:26:08.334Z |
5539954 | 5539954 | 20241114093700_JTeHd | US004N | 2024-11-15T14:02:24.099Z | 2024-11-23T14:26:07.977Z |
5539869 | 5539869 | 20241114092005_YYiKR | US004N | 2024-11-15T14:02:14.857Z | 2024-11-23T14:26:07.361Z |
5539867 | 5539867 | 20241114091920_locaP | US004N | 2024-11-15T14:02:14.495Z | 2024-11-23T14:26:07.345Z |
5539841 | 5539841 | 20241114091015_rEBoK | US004N | 2024-11-15T14:02:10.286Z | 2024-11-23T14:26:07.165Z |
5539808 | 5539808 | 20241114090417_lV89P | US004N | 2024-11-15T14:02:02.800Z | 2024-11-23T14:26:06.925Z |
5539630 | 5539630 | 20241114081801_X3Ib0 | US004N | 2024-11-15T14:01:34.355Z | 2024-11-23T14:26:05.173Z |
5539563 | 5539563 | 20241114075457_2gVN2 | US004N | 2024-11-15T14:01:24.948Z | 2024-11-23T14:26:04.559Z |
5539431 | 5539431 | 20241114070539_NZr3B | US004N | 2024-11-15T14:00:59.487Z | 2024-11-23T14:26:03.304Z |
5539338 | 5539338 | 20241114062029_n32yy | US004N | 2024-11-15T14:00:45.327Z | 2024-11-23T14:26:02.349Z |
5535280 | 5535280 | 20241112120353_0tMyj | US004N | 2024-11-14T14:07:45.303Z | 2024-11-21T14:25:45.477Z |
5534896 | 5534896 | 20241112110519_IMWCE | US004N | 2024-11-14T14:06:57.671Z | 2024-11-21T14:25:41.477Z |
5534526 | 5534526 | 20241113123051_F5sTz | US004N | 2024-11-14T14:04:31.466Z | 2024-11-22T14:24:14.399Z |
5534493 | 5534493 | 20241113122258_BqZe1 | US004N | 2024-11-14T14:04:28.858Z | 2024-11-22T14:24:14.159Z |
5534455 | 5534455 | 20241113121218_hnII8 | US004N | 2024-11-14T14:04:26.032Z | 2024-11-22T14:24:13.966Z |
5534385 | 5534385 | 20241113115710_V5ktP | US004N | 2024-11-14T14:04:20.607Z | 2024-11-22T14:24:13.695Z |
5534298 | 5534298 | 20241113113804_MMzkM | US004N | 2024-11-14T14:04:06.621Z | 2024-11-22T14:24:13.319Z |
5534280 | 5534280 | 20241113113256_XdcTr | US004N | 2024-11-14T14:04:02.968Z | 2024-11-22T14:24:13.264Z |
5534257 | 5534257 | 20241113112736_1Du76 | US004N | 2024-11-14T14:03:57.727Z | 2024-11-22T14:24:13.135Z |
5533997 | 5533997 | 20241113103622_60gZy | US004N | 2024-11-14T14:03:24.406Z | 2024-11-22T14:24:11.957Z |
5533909 | 5533909 | 20241113102500_ix7aN | US004N | 2024-11-14T14:03:16.224Z | 2024-11-22T14:24:11.700Z |
5533834 | 5533834 | 20241113101649_1KAuj | US004N | 2024-11-14T14:02:58.646Z | 2024-11-22T14:24:11.448Z |
5532634 | 5532634 | 20241112054711_1n23x | US004N | 2024-11-13T14:17:04.789Z | 2024-11-20T14:26:25.321Z |
5532606 | 5532606 | 20241112054324_ID9n0 | US004N | 2024-11-13T14:17:02.809Z | 2024-11-20T14:26:25.068Z |
5532554 | 5532554 | 20241112053637_7WPpV | US004N | 2024-11-13T14:16:59.335Z | 2024-11-20T14:26:24.550Z |
5527042 | 5527042 | 20241112105126_NRR3n | US004N | 2024-11-13T14:04:54.838Z | 2024-11-21T14:25:40.777Z |
5526915 | 5526915 | 20241112102854_PlHDZ | US004N | 2024-11-13T14:04:32.228Z | 2024-11-21T14:25:39.638Z |
5526812 | 5526812 | 20241112101844_do2uI | US004N | 2024-11-13T14:04:13.081Z | 2024-11-21T14:25:38.760Z |
5526589 | 5526589 | 20241112095207_3XEdT | US004N | 2024-11-13T14:03:34.230Z | 2024-11-21T14:25:36.672Z |
5526413 | 5526413 | 20241112091444_tjBmN | US004N | 2024-11-13T14:02:56.719Z | 2024-11-21T14:25:34.741Z |
5526354 | 5526354 | 20241112090508_UxtWE | US004N | 2024-11-13T14:02:46.450Z | 2024-11-21T14:25:34.442Z |
5526245 | 5526245 | 20241112084410_gPWjo | US004N | 2024-11-13T14:02:24.154Z | 2024-11-21T14:25:33.115Z |
5526052 | 5526052 | 20241112075549_A6nuK | US004N | 2024-11-13T14:01:43.162Z | 2024-11-21T14:25:30.267Z |
5525835 | 5525835 | 20241112070023_CoqFE | US004N | 2024-11-13T14:00:53.624Z | 2024-11-21T14:25:28.052Z |
5525773 | 5525773 | 20241112063513_OybC6 | US004N | 2024-11-13T14:00:42.354Z | 2024-11-21T14:25:26.458Z |
5524736 | 5524736 | 20241111052449_kjVip | US004N | 2024-11-12T14:17:58.560Z | 2024-11-19T14:22:23.632Z |
5524549 | 5524549 | 20241111043121_axkqE | US004N | 2024-11-12T14:17:39.586Z | 2024-11-19T14:22:22.132Z |
5524540 | 5524540 | 20241111042914_ld40p | US004N | 2024-11-12T14:17:37.298Z | 2024-11-19T14:22:22.073Z |
5524398 | 5524398 | 20241111040751_wrZ3l | US004N | 2024-11-12T14:17:15.261Z | 2024-11-19T14:22:20.977Z |
5524101 | 5524101 | 20241111031409_MpfwY | US004N | 2024-11-12T14:16:32.502Z | 2024-11-19T14:22:17.207Z |
5519619 | 5519619 | 20241111121531_06y9w | US004N | 2024-11-12T14:04:36.900Z | 2024-11-20T14:24:53.863Z |
5519552 | 5519552 | 20241111115853_zmbGN | US004N | 2024-11-12T14:04:29.823Z | 2024-11-20T14:24:52.411Z |
5519488 | 5519488 | 20241111113621_2UbvT | US004N | 2024-11-12T14:04:12.866Z | 2024-11-20T14:24:51.071Z |
5519427 | 5519427 | 20241111112110_r0ra9 | US004N | 2024-11-12T14:03:59.068Z | 2024-11-20T14:24:50.102Z |
5519389 | 5519389 | 20241111111457_Wjv84 | US004N | 2024-11-12T14:03:54.640Z | 2024-11-20T14:24:48.761Z |
5519350 | 5519350 | 20241111110434_gnYX1 | US004N | 2024-11-12T14:03:49.080Z | 2024-11-20T14:24:47.892Z |
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);