participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
23,438 rows where station_code = "USL009" 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 |
---|---|---|---|---|---|
5134816 | 5134816 | 20240916120930_3kIKj | USL009 | 2024-09-19T12:18:07.145Z | 2024-09-19T12:18:07.145Z |
5134813 | 5134813 | 20240916120256_pEpM3 | USL009 | 2024-09-19T12:18:07.097Z | 2024-09-19T12:18:07.097Z |
5134801 | 5134801 | 20240916115526_cpUQd | USL009 | 2024-09-19T12:18:06.768Z | 2024-09-19T12:18:06.768Z |
5134782 | 5134782 | 20240916114748_m2rK8 | USL009 | 2024-09-19T12:18:06.492Z | 2024-09-19T12:18:06.492Z |
5134760 | 5134760 | 20240916114307_Xjn2G | USL009 | 2024-09-19T12:18:05.961Z | 2024-09-19T12:18:05.961Z |
5134719 | 5134719 | 20240916112627_QRY22 | USL009 | 2024-09-19T12:18:04.650Z | 2024-09-19T12:18:04.650Z |
5134699 | 5134699 | 20240916112020_K3Exg | USL009 | 2024-09-19T12:18:04.214Z | 2024-09-19T12:18:04.214Z |
5134668 | 5134668 | 20240916111108_T2Lk3 | USL009 | 2024-09-19T12:18:03.110Z | 2024-09-19T12:18:03.110Z |
5134590 | 5134590 | 20240916104156_hWKiR | USL009 | 2024-09-19T12:17:53.238Z | 2024-09-19T12:17:53.238Z |
5134520 | 5134520 | 20240916100438_DLD9S | USL009 | 2024-09-19T12:17:48.172Z | 2024-09-19T12:17:48.172Z |
5134496 | 5134496 | 20240916095135_gPJFy | USL009 | 2024-09-19T12:17:47.017Z | 2024-09-19T12:17:47.017Z |
5134440 | 5134440 | 20240916091834_HsAa7 | USL009 | 2024-09-19T12:17:44.113Z | 2024-09-19T12:17:44.113Z |
5134428 | 5134428 | 20240916090505_lzMpc | USL009 | 2024-09-19T12:17:43.497Z | 2024-09-19T12:17:43.497Z |
5134303 | 5134303 | 20240916075758_L8Y4X | USL009 | 2024-09-19T12:17:36.260Z | 2024-09-19T12:17:36.260Z |
5134248 | 5134248 | 20240916072549_u4f3a | USL009 | 2024-09-19T12:17:33.191Z | 2024-09-19T12:17:33.191Z |
5134242 | 5134242 | 20240916072151_XsOFb | USL009 | 2024-09-19T12:17:32.897Z | 2024-09-19T12:17:32.897Z |
5134220 | 5134220 | 20240916065736_6RWG2 | USL009 | 2024-09-19T12:17:31.992Z | 2024-09-19T12:17:31.992Z |
5134176 | 5134176 | 20240916061345_Zuryk | USL009 | 2024-09-19T12:17:27.480Z | 2024-09-19T12:17:27.480Z |
5134169 | 5134169 | 20240916055941_FE6Qy | USL009 | 2024-09-19T12:17:26.746Z | 2024-09-19T12:17:26.746Z |
5134035 | 5134035 | 20240916043422_xNc3y | USL009 | 2024-09-19T12:17:16.785Z | 2024-09-19T12:17:16.785Z |
5130412 | 5130412 | 20240917115210_tOtlO | USL009 | 2024-09-19T12:13:11.904Z | 2024-09-19T12:13:11.904Z |
5130358 | 5130358 | 20240917113703_hcMHM | USL009 | 2024-09-19T12:13:05.707Z | 2024-09-19T12:13:05.707Z |
5130206 | 5130206 | 20240917101939_07rht | USL009 | 2024-09-19T12:12:46.317Z | 2024-09-19T12:12:46.317Z |
5130164 | 5130164 | 20240917095246_iLU8R | USL009 | 2024-09-19T12:12:42.151Z | 2024-09-19T12:12:42.151Z |
5130122 | 5130122 | 20240917091648_oc6tx | USL009 | 2024-09-19T12:12:37.034Z | 2024-09-19T12:12:37.034Z |
5130081 | 5130081 | 20240917084811_xs5RF | USL009 | 2024-09-19T12:12:32.771Z | 2024-09-19T12:12:32.771Z |
5130047 | 5130047 | 20240917082911_JQV2F | USL009 | 2024-09-19T12:12:29.429Z | 2024-09-19T12:12:29.429Z |
5130010 | 5130010 | 20240917075021_fuyX8 | USL009 | 2024-09-19T12:12:25.431Z | 2024-09-19T12:12:25.431Z |
5129997 | 5129997 | 20240917073951_MoiQX | USL009 | 2024-09-19T12:12:24.459Z | 2024-09-19T12:12:24.459Z |
5129939 | 5129939 | 20240917063955_hC6ub | USL009 | 2024-09-19T12:12:18.246Z | 2024-09-19T12:12:18.246Z |
5129928 | 5129928 | 20240917062555_7wMPZ | USL009 | 2024-09-19T12:12:17.712Z | 2024-09-19T12:12:17.712Z |
5129636 | 5129636 | 20240917041548_Ws3ae | USL009 | 2024-09-19T12:11:56.461Z | 2024-09-19T12:11:56.461Z |
5126389 | 5126389 | 20240918112123_vcivU | USL009 | 2024-09-19T12:05:52.855Z | 2024-09-19T12:06:42.193Z |
5126359 | 5126359 | 20240918111255_HogMK | USL009 | 2024-09-19T12:05:49.751Z | 2024-09-19T12:06:42.188Z |
5126301 | 5126301 | 20240918103600_RL252 | USL009 | 2024-09-19T12:05:33.875Z | 2024-09-19T12:06:42.177Z |
5126255 | 5126255 | 20240918101915_eYj0S | USL009 | 2024-09-19T12:05:27.415Z | 2024-09-19T12:06:42.169Z |
5126180 | 5126180 | 20240918091827_M2EAV | USL009 | 2024-09-19T12:05:17.889Z | 2024-09-19T12:06:42.156Z |
5126151 | 5126151 | 20240918084954_RyB23 | USL009 | 2024-09-19T12:05:13.249Z | 2024-09-19T12:06:42.150Z |
5126142 | 5126142 | 20240918084515_iP4jt | USL009 | 2024-09-19T12:05:12.318Z | 2024-09-19T12:06:42.148Z |
5125686 | 5125686 | 20240918032109_6jeFP | USL009 | 2024-09-19T12:03:53.146Z | 2024-09-19T12:06:42.069Z |
5125565 | 5125565 | 20240918030201_Fg6tL | USL009 | 2024-09-19T12:03:32.864Z | 2024-09-19T12:06:42.052Z |
5123895 | 5123895 | 20240914115846_vHQOC | USL009 | 2024-09-18T12:11:59.565Z | 2024-09-19T12:20:16.157Z |
5123835 | 5123835 | 20240914114218_2f3hz | USL009 | 2024-09-18T12:11:58.531Z | 2024-09-19T12:20:15.725Z |
5123797 | 5123797 | 20240914113248_9qm52 | USL009 | 2024-09-18T12:11:57.882Z | 2024-09-19T12:20:15.339Z |
5123788 | 5123788 | 20240914112951_d8kEP | USL009 | 2024-09-18T12:11:57.570Z | 2024-09-19T12:20:15.069Z |
5123735 | 5123735 | 20240914111733_w3K3L | USL009 | 2024-09-18T12:11:55.387Z | 2024-09-19T12:20:14.341Z |
5123679 | 5123679 | 20240914110335_gKIy1 | USL009 | 2024-09-18T12:11:53.923Z | 2024-09-19T12:20:13.754Z |
5123645 | 5123645 | 20240914105729_Pgxg9 | USL009 | 2024-09-18T12:11:53.002Z | 2024-09-19T12:20:13.445Z |
5123635 | 5123635 | 20240914105308_FkB3c | USL009 | 2024-09-18T12:11:52.867Z | 2024-09-19T12:20:13.405Z |
5123622 | 5123622 | 20240914104820_4KGy2 | USL009 | 2024-09-18T12:11:52.593Z | 2024-09-19T12:20:13.324Z |
5123616 | 5123616 | 20240914104653_Ho4vp | USL009 | 2024-09-18T12:11:52.290Z | 2024-09-19T12:20:13.288Z |
5123525 | 5123525 | 20240914102344_otQOs | USL009 | 2024-09-18T12:11:50.815Z | 2024-09-19T12:20:11.539Z |
5123497 | 5123497 | 20240914102011_Rb22K | USL009 | 2024-09-18T12:11:50.378Z | 2024-09-19T12:20:11.344Z |
5123430 | 5123430 | 20240914100522_0Xe5U | USL009 | 2024-09-18T12:11:48.663Z | 2024-09-19T12:20:11.015Z |
5123406 | 5123406 | 20240914095924_Mu12k | USL009 | 2024-09-18T12:11:47.964Z | 2024-09-19T12:20:10.758Z |
5123387 | 5123387 | 20240914095615_cKjD8 | USL009 | 2024-09-18T12:11:47.562Z | 2024-09-19T12:20:10.696Z |
5123357 | 5123357 | 20240914095135_OGgYb | USL009 | 2024-09-18T12:11:46.525Z | 2024-09-19T12:20:10.530Z |
5123327 | 5123327 | 20240914094641_boaeZ | USL009 | 2024-09-18T12:11:45.294Z | 2024-09-19T12:20:10.415Z |
5123313 | 5123313 | 20240914094344_FaWhm | USL009 | 2024-09-18T12:11:45.214Z | 2024-09-19T12:20:10.351Z |
5123301 | 5123301 | 20240914093712_6HV5P | USL009 | 2024-09-18T12:11:45.056Z | 2024-09-19T12:20:10.149Z |
5123284 | 5123284 | 20240914093500_k2wcZ | USL009 | 2024-09-18T12:11:44.035Z | 2024-09-19T12:20:09.331Z |
5123244 | 5123244 | 20240914092423_XZLou | USL009 | 2024-09-18T12:11:43.340Z | 2024-09-19T12:20:09.130Z |
5123198 | 5123198 | 20240914091637_C3hPq | USL009 | 2024-09-18T12:11:42.276Z | 2024-09-19T12:20:08.919Z |
5123185 | 5123185 | 20240914091343_hDgLa | USL009 | 2024-09-18T12:11:42.067Z | 2024-09-19T12:20:08.876Z |
5123178 | 5123178 | 20240914091309_8oLMb | USL009 | 2024-09-18T12:11:41.756Z | 2024-09-19T12:20:08.605Z |
5123137 | 5123137 | 20240914090021_iYd8u | USL009 | 2024-09-18T12:11:40.688Z | 2024-09-19T12:20:08.401Z |
5122997 | 5122997 | 20240914083721_N2MWr | USL009 | 2024-09-18T12:11:37.548Z | 2024-09-19T12:20:07.205Z |
5122986 | 5122986 | 20240914083444_O8WTw | USL009 | 2024-09-18T12:11:36.999Z | 2024-09-19T12:20:07.105Z |
5122884 | 5122884 | 20240914081544_LmJ39 | USL009 | 2024-09-18T12:11:33.387Z | 2024-09-19T12:20:06.634Z |
5122832 | 5122832 | 20240914080526_t3LFm | USL009 | 2024-09-18T12:11:32.209Z | 2024-09-19T12:20:06.387Z |
5122805 | 5122805 | 20240914080212_ErnKI | USL009 | 2024-09-18T12:11:31.720Z | 2024-09-19T12:20:06.280Z |
5122789 | 5122789 | 20240914075801_V0o7g | USL009 | 2024-09-18T12:11:31.257Z | 2024-09-19T12:20:06.188Z |
5122752 | 5122752 | 20240914075155_XyYfp | USL009 | 2024-09-18T12:11:30.293Z | 2024-09-19T12:20:06.001Z |
5122715 | 5122715 | 20240914073634_38pOw | USL009 | 2024-09-18T12:11:29.175Z | 2024-09-19T12:20:05.845Z |
5122596 | 5122596 | 20240914071623_dZFLI | USL009 | 2024-09-18T12:11:24.490Z | 2024-09-19T12:20:05.361Z |
5122576 | 5122576 | 20240914071328_jUlGo | USL009 | 2024-09-18T12:11:24.053Z | 2024-09-19T12:20:05.134Z |
5122574 | 5122574 | 20240914071324_RfJd2 | USL009 | 2024-09-18T12:11:23.871Z | 2024-09-19T12:20:05.098Z |
5122524 | 5122524 | 20240914070123_U3j2C | USL009 | 2024-09-18T12:11:21.955Z | 2024-09-19T12:20:04.755Z |
5122440 | 5122440 | 20240914062351_3chsI | USL009 | 2024-09-18T12:11:18.837Z | 2024-09-19T12:20:04.384Z |
5122413 | 5122413 | 20240914061511_axhsA | USL009 | 2024-09-18T12:11:17.794Z | 2024-09-19T12:20:04.251Z |
5122304 | 5122304 | 20240914053106_xc3dJ | USL009 | 2024-09-18T12:11:13.542Z | 2024-09-19T12:20:03.841Z |
5122266 | 5122266 | 20240914051646_93Ktw | USL009 | 2024-09-18T12:11:12.052Z | 2024-09-19T12:20:03.550Z |
5122213 | 5122213 | 20240914045751_tFjqs | USL009 | 2024-09-18T12:11:10.370Z | 2024-09-19T12:20:03.214Z |
5122196 | 5122196 | 20240914045104_zKwQG | USL009 | 2024-09-18T12:11:09.384Z | 2024-09-19T12:20:03.081Z |
5120333 | 5120333 | 20240914031554_CpwnA | USL009 | 2024-09-18T12:10:37.558Z | 2024-09-19T12:19:59.942Z |
5119032 | 5119032 | 20240915121702_XX6ZZ | USL009 | 2024-09-18T12:09:19.771Z | 2024-09-19T12:19:28.468Z |
5118961 | 5118961 | 20240915115042_PX528 | USL009 | 2024-09-18T12:09:15.606Z | 2024-09-19T12:19:27.858Z |
5118824 | 5118824 | 20240915111647_UItIA | USL009 | 2024-09-18T12:09:05.966Z | 2024-09-19T12:19:25.839Z |
5118761 | 5118761 | 20240915110304_orEGx | USL009 | 2024-09-18T12:09:01.784Z | 2024-09-19T12:19:25.341Z |
5118737 | 5118737 | 20240915105758_h3TuN | USL009 | 2024-09-18T12:09:00.866Z | 2024-09-19T12:19:25.229Z |
5118722 | 5118722 | 20240915105458_kySUS | USL009 | 2024-09-18T12:09:00.188Z | 2024-09-19T12:19:25.152Z |
5118706 | 5118706 | 20240915105014_GRMTI | USL009 | 2024-09-18T12:08:59.536Z | 2024-09-19T12:19:25.010Z |
5118697 | 5118697 | 20240915104913_65L7Z | USL009 | 2024-09-18T12:08:59.362Z | 2024-09-19T12:19:24.999Z |
5118664 | 5118664 | 20240915104148_OTz2b | USL009 | 2024-09-18T12:08:57.510Z | 2024-09-19T12:19:24.830Z |
5118575 | 5118575 | 20240915102130_EZD0v | USL009 | 2024-09-18T12:08:51.723Z | 2024-09-19T12:19:24.008Z |
5118566 | 5118566 | 20240915102007_GvRFF | USL009 | 2024-09-18T12:08:51.343Z | 2024-09-19T12:19:23.920Z |
5118554 | 5118554 | 20240915101353_C7jsY | USL009 | 2024-09-18T12:08:50.864Z | 2024-09-19T12:19:23.808Z |
5118532 | 5118532 | 20240915101114_7Qeh1 | USL009 | 2024-09-18T12:08:50.203Z | 2024-09-19T12:19:23.734Z |
5118511 | 5118511 | 20240915100303_TMru2 | USL009 | 2024-09-18T12:08:49.291Z | 2024-09-19T12:19:23.515Z |
5118262 | 5118262 | 20240915090302_yIog5 | USL009 | 2024-09-18T12:08:34.361Z | 2024-09-19T12:19:21.667Z |
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);