participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
15,415 rows where station_code = "USL014" 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 |
---|---|---|---|---|---|
5134145 | 5134145 | 20240916053124_eMWhR | USL014 | 2024-09-19T12:17:25.024Z | 2024-09-19T12:17:25.024Z |
5133959 | 5133959 | 20240916042012_HpmgL | USL014 | 2024-09-19T12:17:14.134Z | 2024-09-19T12:17:14.134Z |
5126144 | 5126144 | 20240918084515_iP4jt | USL014 | 2024-09-19T12:05:12.318Z | 2024-09-19T12:06:42.148Z |
5126126 | 5126126 | 20240918083154_u32ft | USL014 | 2024-09-19T12:05:10.216Z | 2024-09-19T12:06:42.145Z |
5126069 | 5126069 | 20240918074945_jIbzQ | USL014 | 2024-09-19T12:04:53.537Z | 2024-09-19T12:06:42.135Z |
5126062 | 5126062 | 20240918074628_G6w9V | USL014 | 2024-09-19T12:04:52.788Z | 2024-09-19T12:06:42.133Z |
5126060 | 5126060 | 20240918074349_FzRyZ | USL014 | 2024-09-19T12:04:52.289Z | 2024-09-19T12:06:42.133Z |
5126056 | 5126056 | 20240918074104_d08Gu | USL014 | 2024-09-19T12:04:51.886Z | 2024-09-19T12:06:42.132Z |
5125961 | 5125961 | 20240918052152_o2RZX | USL014 | 2024-09-19T12:04:38.634Z | 2024-09-19T12:06:42.116Z |
5125895 | 5125895 | 20240918042802_dNqD9 | USL014 | 2024-09-19T12:04:30.315Z | 2024-09-19T12:06:42.103Z |
5125698 | 5125698 | 20240918032215_kczz7 | USL014 | 2024-09-19T12:03:54.518Z | 2024-09-19T12:06:42.071Z |
5125568 | 5125568 | 20240918030201_Fg6tL | USL014 | 2024-09-19T12:03:32.901Z | 2024-09-19T12:06:42.052Z |
5125503 | 5125503 | 20240918024940_dF6SH | USL014 | 2024-09-19T12:03:23.784Z | 2024-09-19T12:06:42.043Z |
5123876 | 5123876 | 20240914115458_QS6r6 | USL014 | 2024-09-18T12:11:59.191Z | 2024-09-19T12:20:15.946Z |
5123848 | 5123848 | 20240914114435_2G8gs | USL014 | 2024-09-18T12:11:58.624Z | 2024-09-19T12:20:15.765Z |
5123794 | 5123794 | 20240914113146_yudXc | USL014 | 2024-09-18T12:11:57.710Z | 2024-09-19T12:20:15.109Z |
5123733 | 5123733 | 20240914111558_DhRH2 | USL014 | 2024-09-18T12:11:55.329Z | 2024-09-19T12:20:14.329Z |
5123726 | 5123726 | 20240914111419_zWyhp | USL014 | 2024-09-18T12:11:55.206Z | 2024-09-19T12:20:14.281Z |
5123671 | 5123671 | 20240914110237_TcynA | USL014 | 2024-09-18T12:11:53.788Z | 2024-09-19T12:20:13.719Z |
5123638 | 5123638 | 20240914105308_FkB3c | USL014 | 2024-09-18T12:11:52.867Z | 2024-09-19T12:20:13.405Z |
5123556 | 5123556 | 20240914103258_pOIWF | USL014 | 2024-09-18T12:11:51.328Z | 2024-09-19T12:20:12.600Z |
5123519 | 5123519 | 20240914102331_7537c | USL014 | 2024-09-18T12:11:50.589Z | 2024-09-19T12:20:11.528Z |
5123478 | 5123478 | 20240914101456_Yw5dB | USL014 | 2024-09-18T12:11:49.911Z | 2024-09-19T12:20:11.190Z |
5123435 | 5123435 | 20240914100522_0Xe5U | USL014 | 2024-09-18T12:11:48.663Z | 2024-09-19T12:20:11.015Z |
5123375 | 5123375 | 20240914095316_22tNM | USL014 | 2024-09-18T12:11:47.258Z | 2024-09-19T12:20:10.623Z |
5123366 | 5123366 | 20240914095230_j3hoY | USL014 | 2024-09-18T12:11:46.889Z | 2024-09-19T12:20:10.575Z |
5123316 | 5123316 | 20240914094344_FaWhm | USL014 | 2024-09-18T12:11:45.214Z | 2024-09-19T12:20:10.351Z |
5123304 | 5123304 | 20240914093712_6HV5P | USL014 | 2024-09-18T12:11:45.056Z | 2024-09-19T12:20:10.149Z |
5123119 | 5123119 | 20240914085620_qtfFH | USL014 | 2024-09-18T12:11:40.258Z | 2024-09-19T12:20:07.999Z |
5123082 | 5123082 | 20240914084858_nsRVb | USL014 | 2024-09-18T12:11:39.571Z | 2024-09-19T12:20:07.582Z |
5123073 | 5123073 | 20240914084739_roOcv | USL014 | 2024-09-18T12:11:39.513Z | 2024-09-19T12:20:07.567Z |
5123017 | 5123017 | 20240914084036_Uoy0E | USL014 | 2024-09-18T12:11:38.146Z | 2024-09-19T12:20:07.323Z |
5123014 | 5123014 | 20240914083931_Lwwc0 | USL014 | 2024-09-18T12:11:37.984Z | 2024-09-19T12:20:07.322Z |
5123002 | 5123002 | 20240914083721_N2MWr | USL014 | 2024-09-18T12:11:37.548Z | 2024-09-19T12:20:07.205Z |
5122902 | 5122902 | 20240914081820_ZcoJ9 | USL014 | 2024-09-18T12:11:33.745Z | 2024-09-19T12:20:06.662Z |
5122891 | 5122891 | 20240914081636_wkLpF | USL014 | 2024-09-18T12:11:33.532Z | 2024-09-19T12:20:06.644Z |
5122834 | 5122834 | 20240914080526_t3LFm | USL014 | 2024-09-18T12:11:32.209Z | 2024-09-19T12:20:06.387Z |
5122791 | 5122791 | 20240914075801_V0o7g | USL014 | 2024-09-18T12:11:31.257Z | 2024-09-19T12:20:06.188Z |
5122777 | 5122777 | 20240914075631_w1AW2 | USL014 | 2024-09-18T12:11:30.825Z | 2024-09-19T12:20:06.106Z |
5122623 | 5122623 | 20240914072426_yNyoL | USL014 | 2024-09-18T12:11:25.499Z | 2024-09-19T12:20:05.427Z |
5122465 | 5122465 | 20240914062842_ObT7d | USL014 | 2024-09-18T12:11:19.624Z | 2024-09-19T12:20:04.425Z |
5122418 | 5122418 | 20240914061511_axhsA | USL014 | 2024-09-18T12:11:17.794Z | 2024-09-19T12:20:04.251Z |
5122219 | 5122219 | 20240914050112_m2Sgp | USL014 | 2024-09-18T12:11:10.752Z | 2024-09-19T12:20:03.264Z |
5121228 | 5121228 | 20240914035608_82nzd | USL014 | 2024-09-18T12:10:52.578Z | 2024-09-19T12:20:01.516Z |
5120908 | 5120908 | 20240914034106_ZpFOG | USL014 | 2024-09-18T12:10:48.716Z | 2024-09-19T12:20:01.070Z |
5120334 | 5120334 | 20240914031554_CpwnA | USL014 | 2024-09-18T12:10:37.558Z | 2024-09-19T12:19:59.942Z |
5119033 | 5119033 | 20240915121702_XX6ZZ | USL014 | 2024-09-18T12:09:19.771Z | 2024-09-19T12:19:28.468Z |
5118938 | 5118938 | 20240915114321_G84RU | USL014 | 2024-09-18T12:09:13.537Z | 2024-09-19T12:19:27.638Z |
5118874 | 5118874 | 20240915112405_2OQ81 | USL014 | 2024-09-18T12:09:10.676Z | 2024-09-19T12:19:26.840Z |
5118870 | 5118870 | 20240915112200_J2xnY | USL014 | 2024-09-18T12:09:10.428Z | 2024-09-19T12:19:26.722Z |
5118797 | 5118797 | 20240915110906_3hxq9 | USL014 | 2024-09-18T12:09:03.526Z | 2024-09-19T12:19:25.525Z |
5118771 | 5118771 | 20240915110325_QzqjW | USL014 | 2024-09-18T12:09:02.306Z | 2024-09-19T12:19:25.385Z |
5118702 | 5118702 | 20240915104913_65L7Z | USL014 | 2024-09-18T12:08:59.362Z | 2024-09-19T12:19:24.999Z |
5118680 | 5118680 | 20240915104413_z9wmI | USL014 | 2024-09-18T12:08:57.971Z | 2024-09-19T12:19:24.886Z |
5118655 | 5118655 | 20240915103901_Jb9Ge | USL014 | 2024-09-18T12:08:56.431Z | 2024-09-19T12:19:24.756Z |
5118525 | 5118525 | 20240915101012_5l2NQ | USL014 | 2024-09-18T12:08:49.785Z | 2024-09-19T12:19:23.632Z |
5118470 | 5118470 | 20240915095408_G62tO | USL014 | 2024-09-18T12:08:46.539Z | 2024-09-19T12:19:23.191Z |
5118459 | 5118459 | 20240915095051_GdXxF | USL014 | 2024-09-18T12:08:45.509Z | 2024-09-19T12:19:23.067Z |
5118444 | 5118444 | 20240915094740_3l1eI | USL014 | 2024-09-18T12:08:44.381Z | 2024-09-19T12:19:22.953Z |
5118435 | 5118435 | 20240915094646_fYAbN | USL014 | 2024-09-18T12:08:43.849Z | 2024-09-19T12:19:22.856Z |
5118385 | 5118385 | 20240915093148_q3Ebk | USL014 | 2024-09-18T12:08:41.458Z | 2024-09-19T12:19:22.426Z |
5118335 | 5118335 | 20240915092207_BvQog | USL014 | 2024-09-18T12:08:38.019Z | 2024-09-19T12:19:22.151Z |
5118071 | 5118071 | 20240915082339_23cx7 | USL014 | 2024-09-18T12:08:21.914Z | 2024-09-19T12:19:20.101Z |
5118033 | 5118033 | 20240915081127_dDvUf | USL014 | 2024-09-18T12:08:19.437Z | 2024-09-19T12:19:19.867Z |
5117753 | 5117753 | 20240915064648_3syzl | USL014 | 2024-09-18T12:07:55.556Z | 2024-09-19T12:19:17.567Z |
5117709 | 5117709 | 20240915063101_A42xB | USL014 | 2024-09-18T12:07:53.025Z | 2024-09-19T12:19:17.109Z |
5117638 | 5117638 | 20240915055634_UgAMU | USL014 | 2024-09-18T12:07:50.375Z | 2024-09-19T12:19:16.654Z |
5117600 | 5117600 | 20240915054144_YPEQ9 | USL014 | 2024-09-18T12:07:48.566Z | 2024-09-19T12:19:16.279Z |
5117580 | 5117580 | 20240915053633_QWOeY | USL014 | 2024-09-18T12:07:47.805Z | 2024-09-19T12:19:16.131Z |
5117019 | 5117019 | 20240915035634_MlZqZ | USL014 | 2024-09-18T12:07:29.473Z | 2024-09-19T12:19:13.062Z |
5116908 | 5116908 | 20240915034814_alspD | USL014 | 2024-09-18T12:07:25.295Z | 2024-09-19T12:19:12.648Z |
5110140 | 5110140 | 20240913121100_uL6lb | USL014 | 2024-09-17T12:14:57.299Z | 2024-09-19T12:20:55.821Z |
5110116 | 5110116 | 20240913120604_W7eW8 | USL014 | 2024-09-17T12:14:57.079Z | 2024-09-19T12:20:55.770Z |
5110102 | 5110102 | 20240913120331_scBw0 | USL014 | 2024-09-17T12:14:56.916Z | 2024-09-19T12:20:55.758Z |
5110090 | 5110090 | 20240913120306_JLZg3 | USL014 | 2024-09-17T12:14:56.793Z | 2024-09-19T12:20:55.750Z |
5110034 | 5110034 | 20240913115127_nftXz | USL014 | 2024-09-17T12:14:55.262Z | 2024-09-19T12:20:55.648Z |
5110019 | 5110019 | 20240913114917_Qd63n | USL014 | 2024-09-17T12:14:54.727Z | 2024-09-19T12:20:55.639Z |
5110012 | 5110012 | 20240913114817_Epf7s | USL014 | 2024-09-17T12:14:54.428Z | 2024-09-19T12:20:55.630Z |
5109976 | 5109976 | 20240913114227_3mAuP | USL014 | 2024-09-17T12:14:52.387Z | 2024-09-19T12:20:55.523Z |
5109970 | 5109970 | 20240913114214_JzPHs | USL014 | 2024-09-17T12:14:52.327Z | 2024-09-19T12:20:55.517Z |
5109931 | 5109931 | 20240913113850_Atnjv | USL014 | 2024-09-17T12:14:49.496Z | 2024-09-19T12:20:55.367Z |
5109904 | 5109904 | 20240913113509_hofyW | USL014 | 2024-09-17T12:14:48.886Z | 2024-09-19T12:20:55.341Z |
5109898 | 5109898 | 20240913113344_6oBfq | USL014 | 2024-09-17T12:14:48.822Z | 2024-09-19T12:20:55.324Z |
5109887 | 5109887 | 20240913113253_lO6N9 | USL014 | 2024-09-17T12:14:48.485Z | 2024-09-19T12:20:55.242Z |
5109788 | 5109788 | 20240913110525_fBvQ3 | USL014 | 2024-09-17T12:14:46.080Z | 2024-09-19T12:20:54.748Z |
5109783 | 5109783 | 20240913110502_aqdzM | USL014 | 2024-09-17T12:14:46.035Z | 2024-09-19T12:20:54.742Z |
5109707 | 5109707 | 20240913105033_ozsqA | USL014 | 2024-09-17T12:14:44.337Z | 2024-09-19T12:20:54.544Z |
5109685 | 5109685 | 20240913104727_Pa17N | USL014 | 2024-09-17T12:14:43.765Z | 2024-09-19T12:20:54.471Z |
5109595 | 5109595 | 20240913103140_zo9RM | USL014 | 2024-09-17T12:14:41.841Z | 2024-09-19T12:20:53.802Z |
5109572 | 5109572 | 20240913102954_qOeyT | USL014 | 2024-09-17T12:14:41.528Z | 2024-09-19T12:20:53.765Z |
5109550 | 5109550 | 20240913102440_dSLcG | USL014 | 2024-09-17T12:14:41.044Z | 2024-09-19T12:20:53.722Z |
5109534 | 5109534 | 20240913101819_Qacsg | USL014 | 2024-09-17T12:14:40.560Z | 2024-09-19T12:20:53.662Z |
5109485 | 5109485 | 20240913100404_fxPml | USL014 | 2024-09-17T12:14:39.239Z | 2024-09-19T12:20:53.495Z |
5109400 | 5109400 | 20240913094856_2pVPJ | USL014 | 2024-09-17T12:14:37.374Z | 2024-09-19T12:20:53.222Z |
5109373 | 5109373 | 20240913094337_8N66V | USL014 | 2024-09-17T12:14:36.803Z | 2024-09-19T12:20:53.162Z |
5109352 | 5109352 | 20240913093637_jIkQs | USL014 | 2024-09-17T12:14:36.195Z | 2024-09-19T12:20:53.052Z |
5109328 | 5109328 | 20240913093323_2oBae | USL014 | 2024-09-17T12:14:35.744Z | 2024-09-19T12:20:52.941Z |
5109315 | 5109315 | 20240913093122_lYA8f | USL014 | 2024-09-17T12:14:35.345Z | 2024-09-19T12:20:52.831Z |
5109240 | 5109240 | 20240913091818_TOlMs | USL014 | 2024-09-17T12:14:33.801Z | 2024-09-19T12:20:52.637Z |
5109202 | 5109202 | 20240913091140_TnCEC | USL014 | 2024-09-17T12:14:33.203Z | 2024-09-19T12:20:52.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);