participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,345 rows where station_code = "USL017" 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 |
---|---|---|---|---|---|
5134324 | 5134324 | 20240916081421_Fe1TV | USL017 | 2024-09-19T12:17:36.902Z | 2024-09-19T12:17:36.902Z |
5133494 | 5133494 | 20240916033314_5o7dv | USL017 | 2024-09-19T12:16:59.764Z | 2024-09-19T12:16:59.764Z |
5129875 | 5129875 | 20240917050234_QQ8UU | USL017 | 2024-09-19T12:12:12.249Z | 2024-09-19T12:12:12.249Z |
5128788 | 5128788 | 20240917023742_cX6Qo | USL017 | 2024-09-19T12:11:01.767Z | 2024-09-19T12:11:01.767Z |
5126377 | 5126377 | 20240918111946_qjfy3 | USL017 | 2024-09-19T12:05:51.786Z | 2024-09-19T12:06:42.191Z |
5126356 | 5126356 | 20240918111041_NnmXB | USL017 | 2024-09-19T12:05:49.440Z | 2024-09-19T12:06:42.187Z |
5126327 | 5126327 | 20240918105717_ti32a | USL017 | 2024-09-19T12:05:45.629Z | 2024-09-19T12:06:42.182Z |
5126321 | 5126321 | 20240918105436_p7Tv7 | USL017 | 2024-09-19T12:05:44.676Z | 2024-09-19T12:06:42.181Z |
5126302 | 5126302 | 20240918103600_RL252 | USL017 | 2024-09-19T12:05:33.875Z | 2024-09-19T12:06:42.177Z |
5126257 | 5126257 | 20240918101915_eYj0S | USL017 | 2024-09-19T12:05:27.415Z | 2024-09-19T12:06:42.169Z |
5126207 | 5126207 | 20240918094324_arIUY | USL017 | 2024-09-19T12:05:21.411Z | 2024-09-19T12:06:42.161Z |
5126141 | 5126141 | 20240918084204_pCafc | USL017 | 2024-09-19T12:05:11.925Z | 2024-09-19T12:06:42.148Z |
5126108 | 5126108 | 20240918082415_NfgUX | USL017 | 2024-09-19T12:05:07.848Z | 2024-09-19T12:06:42.142Z |
5123903 | 5123903 | 20240914115930_Jdu5z | USL017 | 2024-09-18T12:11:59.750Z | 2024-09-19T12:20:16.186Z |
5123863 | 5123863 | 20240914114847_4mHE1 | USL017 | 2024-09-18T12:11:58.939Z | 2024-09-19T12:20:15.838Z |
5123839 | 5123839 | 20240914114218_2f3hz | USL017 | 2024-09-18T12:11:58.531Z | 2024-09-19T12:20:15.725Z |
5123826 | 5123826 | 20240914114028_oAhav | USL017 | 2024-09-18T12:11:58.422Z | 2024-09-19T12:20:15.618Z |
5123800 | 5123800 | 20240914113248_9qm52 | USL017 | 2024-09-18T12:11:57.883Z | 2024-09-19T12:20:15.339Z |
5123770 | 5123770 | 20240914112704_ggkri | USL017 | 2024-09-18T12:11:56.930Z | 2024-09-19T12:20:14.770Z |
5123759 | 5123759 | 20240914112353_dd23y | USL017 | 2024-09-18T12:11:55.796Z | 2024-09-19T12:20:14.674Z |
5123737 | 5123737 | 20240914111733_w3K3L | USL017 | 2024-09-18T12:11:55.387Z | 2024-09-19T12:20:14.341Z |
5123730 | 5123730 | 20240914111443_fSfML | USL017 | 2024-09-18T12:11:55.256Z | 2024-09-19T12:20:14.310Z |
5123617 | 5123617 | 20240914104653_Ho4vp | USL017 | 2024-09-18T12:11:52.290Z | 2024-09-19T12:20:13.288Z |
5123468 | 5123468 | 20240914101415_sFF8j | USL017 | 2024-09-18T12:11:49.818Z | 2024-09-19T12:20:11.168Z |
5123407 | 5123407 | 20240914095924_Mu12k | USL017 | 2024-09-18T12:11:47.964Z | 2024-09-19T12:20:10.758Z |
5123388 | 5123388 | 20240914095615_cKjD8 | USL017 | 2024-09-18T12:11:47.562Z | 2024-09-19T12:20:10.696Z |
5123377 | 5123377 | 20240914095524_0D3Z2 | USL017 | 2024-09-18T12:11:47.305Z | 2024-09-19T12:20:10.659Z |
5123345 | 5123345 | 20240914095005_31KsQ | USL017 | 2024-09-18T12:11:45.596Z | 2024-09-19T12:20:10.509Z |
5123245 | 5123245 | 20240914092423_XZLou | USL017 | 2024-09-18T12:11:43.340Z | 2024-09-19T12:20:09.130Z |
5123218 | 5123218 | 20240914091845_VdRq7 | USL017 | 2024-09-18T12:11:42.623Z | 2024-09-19T12:20:09.023Z |
5123199 | 5123199 | 20240914091637_C3hPq | USL017 | 2024-09-18T12:11:42.276Z | 2024-09-19T12:20:08.919Z |
5123186 | 5123186 | 20240914091343_hDgLa | USL017 | 2024-09-18T12:11:42.067Z | 2024-09-19T12:20:08.876Z |
5123183 | 5123183 | 20240914091337_PM6k1 | USL017 | 2024-09-18T12:11:41.981Z | 2024-09-19T12:20:08.875Z |
5122987 | 5122987 | 20240914083444_O8WTw | USL017 | 2024-09-18T12:11:36.999Z | 2024-09-19T12:20:07.105Z |
5122885 | 5122885 | 20240914081544_LmJ39 | USL017 | 2024-09-18T12:11:33.387Z | 2024-09-19T12:20:06.634Z |
5122819 | 5122819 | 20240914080436_VkKLB | USL017 | 2024-09-18T12:11:31.805Z | 2024-09-19T12:20:06.360Z |
5122762 | 5122762 | 20240914075426_ocgkT | USL017 | 2024-09-18T12:11:30.644Z | 2024-09-19T12:20:06.040Z |
5122760 | 5122760 | 20240914075402_krl45 | USL017 | 2024-09-18T12:11:30.579Z | 2024-09-19T12:20:06.030Z |
5122753 | 5122753 | 20240914075155_XyYfp | USL017 | 2024-09-18T12:11:30.293Z | 2024-09-19T12:20:06.001Z |
5122667 | 5122667 | 20240914072937_zeIkj | USL017 | 2024-09-18T12:11:27.626Z | 2024-09-19T12:20:05.588Z |
5122597 | 5122597 | 20240914071623_dZFLI | USL017 | 2024-09-18T12:11:24.490Z | 2024-09-19T12:20:05.361Z |
5122441 | 5122441 | 20240914062351_3chsI | USL017 | 2024-09-18T12:11:18.837Z | 2024-09-19T12:20:04.384Z |
5118692 | 5118692 | 20240915104807_dtjue | USL017 | 2024-09-18T12:08:58.953Z | 2024-09-19T12:19:24.975Z |
5118672 | 5118672 | 20240915104232_iX1Dz | USL017 | 2024-09-18T12:08:57.635Z | 2024-09-19T12:19:24.870Z |
5118648 | 5118648 | 20240915103809_W3Jnj | USL017 | 2024-09-18T12:08:55.860Z | 2024-09-19T12:19:24.735Z |
5118602 | 5118602 | 20240915102512_TcHi2 | USL017 | 2024-09-18T12:08:52.693Z | 2024-09-19T12:19:24.224Z |
5118567 | 5118567 | 20240915102007_GvRFF | USL017 | 2024-09-18T12:08:51.343Z | 2024-09-19T12:19:23.920Z |
5118546 | 5118546 | 20240915101233_KKCdm | USL017 | 2024-09-18T12:08:50.653Z | 2024-09-19T12:19:23.784Z |
5118533 | 5118533 | 20240915101114_7Qeh1 | USL017 | 2024-09-18T12:08:50.203Z | 2024-09-19T12:19:23.734Z |
5118393 | 5118393 | 20240915093619_26hGq | USL017 | 2024-09-18T12:08:42.109Z | 2024-09-19T12:19:22.478Z |
5118358 | 5118358 | 20240915092915_SbRD5 | USL017 | 2024-09-18T12:08:39.632Z | 2024-09-19T12:19:22.304Z |
5118201 | 5118201 | 20240915084958_YJz9K | USL017 | 2024-09-18T12:08:29.670Z | 2024-09-19T12:19:21.240Z |
5118113 | 5118113 | 20240915083535_K5rWS | USL017 | 2024-09-18T12:08:24.676Z | 2024-09-19T12:19:20.567Z |
5118011 | 5118011 | 20240915080750_2X4Hm | USL017 | 2024-09-18T12:08:17.112Z | 2024-09-19T12:19:19.725Z |
5117960 | 5117960 | 20240915075944_5E2su | USL017 | 2024-09-18T12:08:11.992Z | 2024-09-19T12:19:19.352Z |
5117920 | 5117920 | 20240915074722_tmxPM | USL017 | 2024-09-18T12:08:07.216Z | 2024-09-19T12:19:18.958Z |
5117892 | 5117892 | 20240915073837_pw9FO | USL017 | 2024-09-18T12:08:05.091Z | 2024-09-19T12:19:18.759Z |
5117772 | 5117772 | 20240915065842_s9ZC8 | USL017 | 2024-09-18T12:07:58.201Z | 2024-09-19T12:19:17.721Z |
5117749 | 5117749 | 20240915064337_QKZG4 | USL017 | 2024-09-18T12:07:55.099Z | 2024-09-19T12:19:17.545Z |
5117683 | 5117683 | 20240915062035_mFxpG | USL017 | 2024-09-18T12:07:51.975Z | 2024-09-19T12:19:16.918Z |
5117632 | 5117632 | 20240915055601_gzcXa | USL017 | 2024-09-18T12:07:50.166Z | 2024-09-19T12:19:16.613Z |
5117627 | 5117627 | 20240915055449_2O92a | USL017 | 2024-09-18T12:07:49.864Z | 2024-09-19T12:19:16.555Z |
5117608 | 5117608 | 20240915054709_80kVq | USL017 | 2024-09-18T12:07:48.865Z | 2024-09-19T12:19:16.343Z |
5117572 | 5117572 | 20240915053302_XYiiw | USL017 | 2024-09-18T12:07:47.617Z | 2024-09-19T12:19:16.113Z |
5117403 | 5117403 | 20240915042854_f6wv1 | USL017 | 2024-09-18T12:07:40.398Z | 2024-09-19T12:19:14.876Z |
5117311 | 5117311 | 20240915041722_7jUpl | USL017 | 2024-09-18T12:07:37.678Z | 2024-09-19T12:19:14.255Z |
5110119 | 5110119 | 20240913120708_LNhBk | USL017 | 2024-09-17T12:14:57.115Z | 2024-09-19T12:20:55.780Z |
5109992 | 5109992 | 20240913114432_atp7e | USL017 | 2024-09-17T12:14:53.291Z | 2024-09-19T12:20:55.569Z |
5109939 | 5109939 | 20240913113940_FkRz8 | USL017 | 2024-09-17T12:14:50.682Z | 2024-09-19T12:20:55.449Z |
5109921 | 5109921 | 20240913113604_2dvR7 | USL017 | 2024-09-17T12:14:49.204Z | 2024-09-19T12:20:55.348Z |
5109912 | 5109912 | 20240913113542_QJF6g | USL017 | 2024-09-17T12:14:49.161Z | 2024-09-19T12:20:55.343Z |
5109857 | 5109857 | 20240913112353_yRT87 | USL017 | 2024-09-17T12:14:47.824Z | 2024-09-19T12:20:54.987Z |
5109847 | 5109847 | 20240913112240_TbiaM | USL017 | 2024-09-17T12:14:47.618Z | 2024-09-19T12:20:54.964Z |
5109839 | 5109839 | 20240913111912_GEgYX | USL017 | 2024-09-17T12:14:47.516Z | 2024-09-19T12:20:54.932Z |
5109829 | 5109829 | 20240913111446_uF2DK | USL017 | 2024-09-17T12:14:47.096Z | 2024-09-19T12:20:54.866Z |
5109825 | 5109825 | 20240913111427_M3bAl | USL017 | 2024-09-17T12:14:47.024Z | 2024-09-19T12:20:54.859Z |
5109772 | 5109772 | 20240913110428_A2x6u | USL017 | 2024-09-17T12:14:45.812Z | 2024-09-19T12:20:54.730Z |
5109739 | 5109739 | 20240913110224_5J3sW | USL017 | 2024-09-17T12:14:45.227Z | 2024-09-19T12:20:54.663Z |
5109718 | 5109718 | 20240913105338_IxTLj | USL017 | 2024-09-17T12:14:44.568Z | 2024-09-19T12:20:54.585Z |
5109668 | 5109668 | 20240913104359_kkCQu | USL017 | 2024-09-17T12:14:43.362Z | 2024-09-19T12:20:54.246Z |
5109622 | 5109622 | 20240913103641_z02e2 | USL017 | 2024-09-17T12:14:42.293Z | 2024-09-19T12:20:53.904Z |
5109614 | 5109614 | 20240913103618_FCtzB | USL017 | 2024-09-17T12:14:42.163Z | 2024-09-19T12:20:53.885Z |
5109506 | 5109506 | 20240913100937_p49Sr | USL017 | 2024-09-17T12:14:39.793Z | 2024-09-19T12:20:53.592Z |
5109479 | 5109479 | 20240913100036_AgxdD | USL017 | 2024-09-17T12:14:39.173Z | 2024-09-19T12:20:53.469Z |
5109464 | 5109464 | 20240913095850_28iSJ | USL017 | 2024-09-17T12:14:38.716Z | 2024-09-19T12:20:53.401Z |
5109419 | 5109419 | 20240913095158_Ze5Jz | USL017 | 2024-09-17T12:14:37.811Z | 2024-09-19T12:20:53.267Z |
5109386 | 5109386 | 20240913094513_KK38K | USL017 | 2024-09-17T12:14:37.137Z | 2024-09-19T12:20:53.192Z |
5109383 | 5109383 | 20240913094500_aooHR | USL017 | 2024-09-17T12:14:36.984Z | 2024-09-19T12:20:53.179Z |
5109380 | 5109380 | 20240913094440_jly2w | USL017 | 2024-09-17T12:14:36.929Z | 2024-09-19T12:20:53.175Z |
5109378 | 5109378 | 20240913094420_cU7CS | USL017 | 2024-09-17T12:14:36.837Z | 2024-09-19T12:20:53.174Z |
5109322 | 5109322 | 20240913093232_P1uqC | USL017 | 2024-09-17T12:14:35.492Z | 2024-09-19T12:20:52.927Z |
5109311 | 5109311 | 20240913093108_8937b | USL017 | 2024-09-17T12:14:35.281Z | 2024-09-19T12:20:52.830Z |
5109210 | 5109210 | 20240913091316_wMXZe | USL017 | 2024-09-17T12:14:33.316Z | 2024-09-19T12:20:52.492Z |
5109153 | 5109153 | 20240913085911_FBt7j | USL017 | 2024-09-17T12:14:31.816Z | 2024-09-19T12:20:52.305Z |
5109142 | 5109142 | 20240913085501_l4PnF | USL017 | 2024-09-17T12:14:31.367Z | 2024-09-19T12:20:51.828Z |
5109132 | 5109132 | 20240913085421_2WTSY | USL017 | 2024-09-17T12:14:31.115Z | 2024-09-19T12:20:51.793Z |
5109094 | 5109094 | 20240913084407_BWwFC | USL017 | 2024-09-17T12:14:29.915Z | 2024-09-19T12:20:51.691Z |
5108843 | 5108843 | 20240913074455_t3EnE | USL017 | 2024-09-17T12:14:09.445Z | 2024-09-19T12:20:50.919Z |
5108764 | 5108764 | 20240913072434_xs1Nn | USL017 | 2024-09-17T12:14:05.154Z | 2024-09-19T12:20:50.696Z |
5108758 | 5108758 | 20240913072434_49XlO | USL017 | 2024-09-17T12:14:04.790Z | 2024-09-19T12:20:50.691Z |
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);