participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
12,112 rows where station_code = "USL01D" 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 |
---|---|---|---|---|---|
5135676 | 5135676 | 20240914104828_UGApK | USL01D | 2024-09-19T12:20:13.342Z | 2024-09-19T12:20:13.342Z |
5134815 | 5134815 | 20240916120256_pEpM3 | USL01D | 2024-09-19T12:18:07.097Z | 2024-09-19T12:18:07.097Z |
5134796 | 5134796 | 20240916115248_rFYSl | USL01D | 2024-09-19T12:18:06.657Z | 2024-09-19T12:18:06.657Z |
5134650 | 5134650 | 20240916110407_aXhLA | USL01D | 2024-09-19T12:18:00.829Z | 2024-09-19T12:18:00.829Z |
5134305 | 5134305 | 20240916075758_L8Y4X | USL01D | 2024-09-19T12:17:36.260Z | 2024-09-19T12:17:36.260Z |
5134120 | 5134120 | 20240916051420_P106Y | USL01D | 2024-09-19T12:17:22.705Z | 2024-09-19T12:17:22.705Z |
5132932 | 5132932 | 20240916023025_MhTXm | USL01D | 2024-09-19T12:16:37.813Z | 2024-09-19T12:16:37.813Z |
5130148 | 5130148 | 20240917093424_oChzf | USL01D | 2024-09-19T12:12:40.177Z | 2024-09-19T12:12:40.177Z |
5129974 | 5129974 | 20240917071048_dAl40 | USL01D | 2024-09-19T12:12:21.531Z | 2024-09-19T12:12:21.531Z |
5126368 | 5126368 | 20240918111408_xbeOo | USL01D | 2024-09-19T12:05:50.294Z | 2024-09-19T12:06:42.189Z |
5126081 | 5126081 | 20240918080136_u4Mjg | USL01D | 2024-09-19T12:04:58.037Z | 2024-09-19T12:06:42.137Z |
5126079 | 5126079 | 20240918075803_zw7Z3 | USL01D | 2024-09-19T12:04:57.489Z | 2024-09-19T12:06:42.136Z |
5126070 | 5126070 | 20240918074945_jIbzQ | USL01D | 2024-09-19T12:04:53.537Z | 2024-09-19T12:06:42.135Z |
5126064 | 5126064 | 20240918074628_G6w9V | USL01D | 2024-09-19T12:04:52.788Z | 2024-09-19T12:06:42.133Z |
5125938 | 5125938 | 20240918050216_2BILr | USL01D | 2024-09-19T12:04:36.018Z | 2024-09-19T12:06:42.112Z |
5125829 | 5125829 | 20240918040308_6Sd7e | USL01D | 2024-09-19T12:04:11.169Z | 2024-09-19T12:06:42.091Z |
5125570 | 5125570 | 20240918030201_Fg6tL | USL01D | 2024-09-19T12:03:32.909Z | 2024-09-19T12:06:42.052Z |
5123926 | 5123926 | 20240914120227_mIFxE | USL01D | 2024-09-18T12:12:00.080Z | 2024-09-19T12:20:16.624Z |
5123885 | 5123885 | 20240914115615_yj9ra | USL01D | 2024-09-18T12:11:59.329Z | 2024-09-19T12:20:16.114Z |
5123868 | 5123868 | 20240914115029_sJzmF | USL01D | 2024-09-18T12:11:58.995Z | 2024-09-19T12:20:15.911Z |
5123833 | 5123833 | 20240914114033_bduqh | USL01D | 2024-09-18T12:11:58.519Z | 2024-09-19T12:20:15.682Z |
5123792 | 5123792 | 20240914113141_I3d5V | USL01D | 2024-09-18T12:11:57.591Z | 2024-09-19T12:20:15.104Z |
5123785 | 5123785 | 20240914112942_nIIwO | USL01D | 2024-09-18T12:11:57.457Z | 2024-09-19T12:20:15.016Z |
5123681 | 5123681 | 20240914110335_gKIy1 | USL01D | 2024-09-18T12:11:53.923Z | 2024-09-19T12:20:13.754Z |
5123647 | 5123647 | 20240914105729_Pgxg9 | USL01D | 2024-09-18T12:11:53.002Z | 2024-09-19T12:20:13.445Z |
5123564 | 5123564 | 20240914103412_eBeM6 | USL01D | 2024-09-18T12:11:51.380Z | 2024-09-19T12:20:12.636Z |
5123553 | 5123553 | 20240914103040_TqWj9 | USL01D | 2024-09-18T12:11:51.314Z | 2024-09-19T12:20:12.562Z |
5123526 | 5123526 | 20240914102344_otQOs | USL01D | 2024-09-18T12:11:50.815Z | 2024-09-19T12:20:11.539Z |
5123523 | 5123523 | 20240914102344_E3vzZ | USL01D | 2024-09-18T12:11:50.749Z | 2024-09-19T12:20:11.531Z |
5123475 | 5123475 | 20240914101419_VUk3s | USL01D | 2024-09-18T12:11:49.857Z | 2024-09-19T12:20:11.178Z |
5123466 | 5123466 | 20240914101336_lcJaI | USL01D | 2024-09-18T12:11:49.754Z | 2024-09-19T12:20:11.156Z |
5123442 | 5123442 | 20240914100943_zX2jn | USL01D | 2024-09-18T12:11:48.906Z | 2024-09-19T12:20:11.056Z |
5123359 | 5123359 | 20240914095135_OGgYb | USL01D | 2024-09-18T12:11:46.525Z | 2024-09-19T12:20:10.530Z |
5123342 | 5123342 | 20240914094913_h4Uxi | USL01D | 2024-09-18T12:11:45.556Z | 2024-09-19T12:20:10.477Z |
5123331 | 5123331 | 20240914094641_boaeZ | USL01D | 2024-09-18T12:11:45.294Z | 2024-09-19T12:20:10.415Z |
5123325 | 5123325 | 20240914094617_x28bk | USL01D | 2024-09-18T12:11:45.289Z | 2024-09-19T12:20:10.376Z |
5123233 | 5123233 | 20240914092038_QnLbZ | USL01D | 2024-09-18T12:11:43.075Z | 2024-09-19T12:20:09.071Z |
5123177 | 5123177 | 20240914091252_4u30v | USL01D | 2024-09-18T12:11:41.660Z | 2024-09-19T12:20:08.591Z |
5123142 | 5123142 | 20240914090215_BGYsB | USL01D | 2024-09-18T12:11:40.872Z | 2024-09-19T12:20:08.416Z |
5123066 | 5123066 | 20240914084624_oaRdX | USL01D | 2024-09-18T12:11:39.434Z | 2024-09-19T12:20:07.529Z |
5123021 | 5123021 | 20240914084045_e6XCB | USL01D | 2024-09-18T12:11:38.212Z | 2024-09-19T12:20:07.328Z |
5122903 | 5122903 | 20240914081820_ZcoJ9 | USL01D | 2024-09-18T12:11:33.745Z | 2024-09-19T12:20:06.662Z |
5122843 | 5122843 | 20240914080717_Gddlv | USL01D | 2024-09-18T12:11:32.296Z | 2024-09-19T12:20:06.423Z |
5122808 | 5122808 | 20240914080212_ErnKI | USL01D | 2024-09-18T12:11:31.720Z | 2024-09-19T12:20:06.280Z |
5122718 | 5122718 | 20240914073634_38pOw | USL01D | 2024-09-18T12:11:29.175Z | 2024-09-19T12:20:05.846Z |
5122650 | 5122650 | 20240914072728_7ztSu | USL01D | 2024-09-18T12:11:27.004Z | 2024-09-19T12:20:05.516Z |
5122575 | 5122575 | 20240914071324_RfJd2 | USL01D | 2024-09-18T12:11:23.872Z | 2024-09-19T12:20:05.098Z |
5122525 | 5122525 | 20240914070123_U3j2C | USL01D | 2024-09-18T12:11:21.955Z | 2024-09-19T12:20:04.755Z |
5122503 | 5122503 | 20240914065321_2DYYg | USL01D | 2024-09-18T12:11:21.014Z | 2024-09-19T12:20:04.637Z |
5122420 | 5122420 | 20240914061511_axhsA | USL01D | 2024-09-18T12:11:17.794Z | 2024-09-19T12:20:04.251Z |
5122307 | 5122307 | 20240914053106_xc3dJ | USL01D | 2024-09-18T12:11:13.542Z | 2024-09-19T12:20:03.841Z |
5122293 | 5122293 | 20240914052452_V2EgS | USL01D | 2024-09-18T12:11:12.930Z | 2024-09-19T12:20:03.748Z |
5122268 | 5122268 | 20240914051646_93Ktw | USL01D | 2024-09-18T12:11:12.052Z | 2024-09-19T12:20:03.550Z |
5122197 | 5122197 | 20240914045104_zKwQG | USL01D | 2024-09-18T12:11:09.384Z | 2024-09-19T12:20:03.081Z |
5122005 | 5122005 | 20240914042551_35Qzf | USL01D | 2024-09-18T12:11:04.494Z | 2024-09-19T12:20:02.656Z |
5121229 | 5121229 | 20240914035608_82nzd | USL01D | 2024-09-18T12:10:52.578Z | 2024-09-19T12:20:01.516Z |
5120909 | 5120909 | 20240914034106_ZpFOG | USL01D | 2024-09-18T12:10:48.716Z | 2024-09-19T12:20:01.070Z |
5119422 | 5119422 | 20240914023146_NIECF | USL01D | 2024-09-18T12:10:20.966Z | 2024-09-19T12:19:58.128Z |
5118997 | 5118997 | 20240915120009_ZF1Yi | USL01D | 2024-09-18T12:09:17.409Z | 2024-09-19T12:19:28.081Z |
5118954 | 5118954 | 20240915114837_NrR4U | USL01D | 2024-09-18T12:09:14.391Z | 2024-09-19T12:19:27.745Z |
5118939 | 5118939 | 20240915114321_G84RU | USL01D | 2024-09-18T12:09:13.537Z | 2024-09-19T12:19:27.638Z |
5118930 | 5118930 | 20240915114047_cPt5K | USL01D | 2024-09-18T12:09:13.376Z | 2024-09-19T12:19:27.614Z |
5118889 | 5118889 | 20240915112738_ufMos | USL01D | 2024-09-18T12:09:11.541Z | 2024-09-19T12:19:27.027Z |
5118772 | 5118772 | 20240915110325_QzqjW | USL01D | 2024-09-18T12:09:02.306Z | 2024-09-19T12:19:25.385Z |
5118745 | 5118745 | 20240915105857_EK3dW | USL01D | 2024-09-18T12:09:01.036Z | 2024-09-19T12:19:25.234Z |
5118742 | 5118742 | 20240915105758_h3TuN | USL01D | 2024-09-18T12:09:00.866Z | 2024-09-19T12:19:25.229Z |
5118686 | 5118686 | 20240915104535_B3Zee | USL01D | 2024-09-18T12:08:58.263Z | 2024-09-19T12:19:24.919Z |
5118668 | 5118668 | 20240915104148_OTz2b | USL01D | 2024-09-18T12:08:57.510Z | 2024-09-19T12:19:24.830Z |
5118644 | 5118644 | 20240915103745_7UDA3 | USL01D | 2024-09-18T12:08:55.501Z | 2024-09-19T12:19:24.680Z |
5118622 | 5118622 | 20240915103140_vgKeX | USL01D | 2024-09-18T12:08:53.884Z | 2024-09-19T12:19:24.499Z |
5118585 | 5118585 | 20240915102157_TbxHZ | USL01D | 2024-09-18T12:08:51.898Z | 2024-09-19T12:19:24.066Z |
5118543 | 5118543 | 20240915101216_rb9mU | USL01D | 2024-09-18T12:08:50.543Z | 2024-09-19T12:19:23.773Z |
5118500 | 5118500 | 20240915100038_CCjb2 | USL01D | 2024-09-18T12:08:48.699Z | 2024-09-19T12:19:23.427Z |
5118473 | 5118473 | 20240915095408_G62tO | USL01D | 2024-09-18T12:08:46.539Z | 2024-09-19T12:19:23.191Z |
5118378 | 5118378 | 20240915093005_gSnfy | USL01D | 2024-09-18T12:08:41.241Z | 2024-09-19T12:19:22.402Z |
5118344 | 5118344 | 20240915092619_tN5rR | USL01D | 2024-09-18T12:08:38.297Z | 2024-09-19T12:19:22.181Z |
5118087 | 5118087 | 20240915082801_iaWNJ | USL01D | 2024-09-18T12:08:22.717Z | 2024-09-19T12:19:20.250Z |
5117806 | 5117806 | 20240915070701_2ki3n | USL01D | 2024-09-18T12:08:00.593Z | 2024-09-19T12:19:18.116Z |
5117726 | 5117726 | 20240915063715_0RER7 | USL01D | 2024-09-18T12:07:53.613Z | 2024-09-19T12:19:17.231Z |
5117385 | 5117385 | 20240915042225_TZfrr | USL01D | 2024-09-18T12:07:39.319Z | 2024-09-19T12:19:14.605Z |
5117187 | 5117187 | 20240915041041_b6iFW | USL01D | 2024-09-18T12:07:34.753Z | 2024-09-19T12:19:13.759Z |
5096870 | 5096870 | 20240912120041_hH6Y3 | USL01D | 2024-09-16T12:16:36.406Z | 2024-09-19T12:21:24.043Z |
5096839 | 5096839 | 20240912115520_Md4Vc | USL01D | 2024-09-16T12:16:35.546Z | 2024-09-19T12:21:24.006Z |
5096779 | 5096779 | 20240912114047_3owXx | USL01D | 2024-09-16T12:16:34.459Z | 2024-09-19T12:21:23.631Z |
5096673 | 5096673 | 20240912112809_TbXyZ | USL01D | 2024-09-16T12:16:31.190Z | 2024-09-19T12:21:23.394Z |
5096651 | 5096651 | 20240912112722_3U8Jc | USL01D | 2024-09-16T12:16:30.783Z | 2024-09-19T12:21:23.355Z |
5096482 | 5096482 | 20240912105629_U4vth | USL01D | 2024-09-16T12:16:24.391Z | 2024-09-19T12:21:22.378Z |
5096458 | 5096458 | 20240912105421_HmBXh | USL01D | 2024-09-16T12:16:23.966Z | 2024-09-19T12:21:22.351Z |
5096437 | 5096437 | 20240912104934_Djg3C | USL01D | 2024-09-16T12:16:23.369Z | 2024-09-19T12:21:22.304Z |
5096423 | 5096423 | 20240912104914_eKPMo | USL01D | 2024-09-16T12:16:23.218Z | 2024-09-19T12:21:22.289Z |
5096377 | 5096377 | 20240912103930_LJLSC | USL01D | 2024-09-16T12:16:21.859Z | 2024-09-19T12:21:22.212Z |
5096354 | 5096354 | 20240912103701_AsUHq | USL01D | 2024-09-16T12:16:21.190Z | 2024-09-19T12:21:22.169Z |
5096267 | 5096267 | 20240912102546_phlzu | USL01D | 2024-09-16T12:16:17.468Z | 2024-09-19T12:21:21.986Z |
5096242 | 5096242 | 20240912102326_aoF3v | USL01D | 2024-09-16T12:16:16.691Z | 2024-09-19T12:21:21.954Z |
5096233 | 5096233 | 20240912102123_vYw63 | USL01D | 2024-09-16T12:16:16.254Z | 2024-09-19T12:21:21.935Z |
5096152 | 5096152 | 20240912100819_1WO5I | USL01D | 2024-09-16T12:16:11.798Z | 2024-09-19T12:21:21.751Z |
5096132 | 5096132 | 20240912100532_fdOAL | USL01D | 2024-09-16T12:16:11.472Z | 2024-09-19T12:21:21.642Z |
5096118 | 5096118 | 20240912100432_Q2PEM | USL01D | 2024-09-16T12:16:10.975Z | 2024-09-19T12:21:21.577Z |
5096064 | 5096064 | 20240912095132_mRi62 | USL01D | 2024-09-16T12:16:08.254Z | 2024-09-19T12:21:21.222Z |
5096034 | 5096034 | 20240912094442_964i8 | USL01D | 2024-09-16T12:16:05.882Z | 2024-09-19T12:21:21.022Z |
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);