participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,682 rows where station_code = "USL01B" 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 |
---|---|---|---|---|---|
5134817 | 5134817 | 20240916120930_3kIKj | USL01B | 2024-09-19T12:18:07.145Z | 2024-09-19T12:18:07.145Z |
5134783 | 5134783 | 20240916114748_m2rK8 | USL01B | 2024-09-19T12:18:06.493Z | 2024-09-19T12:18:06.493Z |
5134777 | 5134777 | 20240916114607_cs8I8 | USL01B | 2024-09-19T12:18:06.347Z | 2024-09-19T12:18:06.347Z |
5134761 | 5134761 | 20240916114307_Xjn2G | USL01B | 2024-09-19T12:18:05.961Z | 2024-09-19T12:18:05.961Z |
5134703 | 5134703 | 20240916112020_K3Exg | USL01B | 2024-09-19T12:18:04.214Z | 2024-09-19T12:18:04.214Z |
5134325 | 5134325 | 20240916081421_Fe1TV | USL01B | 2024-09-19T12:17:36.902Z | 2024-09-19T12:17:36.902Z |
5134181 | 5134181 | 20240916061746_a3kc2 | USL01B | 2024-09-19T12:17:28.063Z | 2024-09-19T12:17:28.063Z |
5126407 | 5126407 | 20240918113216_ondh3 | USL01B | 2024-09-19T12:05:54.696Z | 2024-09-19T12:06:42.195Z |
5126401 | 5126401 | 20240918112601_NxdKv | USL01B | 2024-09-19T12:05:53.942Z | 2024-09-19T12:06:42.194Z |
5126378 | 5126378 | 20240918111946_qjfy3 | USL01B | 2024-09-19T12:05:51.786Z | 2024-09-19T12:06:42.191Z |
5126357 | 5126357 | 20240918111041_NnmXB | USL01B | 2024-09-19T12:05:49.440Z | 2024-09-19T12:06:42.187Z |
5126329 | 5126329 | 20240918105717_ti32a | USL01B | 2024-09-19T12:05:45.629Z | 2024-09-19T12:06:42.182Z |
5126323 | 5126323 | 20240918105436_p7Tv7 | USL01B | 2024-09-19T12:05:44.676Z | 2024-09-19T12:06:42.181Z |
5126280 | 5126280 | 20240918102741_Xj2Am | USL01B | 2024-09-19T12:05:30.288Z | 2024-09-19T12:06:42.173Z |
5126259 | 5126259 | 20240918101915_eYj0S | USL01B | 2024-09-19T12:05:27.415Z | 2024-09-19T12:06:42.169Z |
5126208 | 5126208 | 20240918094324_arIUY | USL01B | 2024-09-19T12:05:21.411Z | 2024-09-19T12:06:42.161Z |
5126179 | 5126179 | 20240918091621_lAziM | USL01B | 2024-09-19T12:05:17.319Z | 2024-09-19T12:06:42.155Z |
5126109 | 5126109 | 20240918082415_NfgUX | USL01B | 2024-09-19T12:05:07.866Z | 2024-09-19T12:06:42.142Z |
5118956 | 5118956 | 20240915114859_yMEnr | USL01B | 2024-09-18T12:09:14.559Z | 2024-09-19T12:19:27.782Z |
5118926 | 5118926 | 20240915113928_1uiL2 | USL01B | 2024-09-18T12:09:13.037Z | 2024-09-19T12:19:27.609Z |
5118918 | 5118918 | 20240915113632_1lgdg | USL01B | 2024-09-18T12:09:12.736Z | 2024-09-19T12:19:27.589Z |
5118826 | 5118826 | 20240915111647_UItIA | USL01B | 2024-09-18T12:09:05.966Z | 2024-09-19T12:19:25.840Z |
5118788 | 5118788 | 20240915110839_EhVqU | USL01B | 2024-09-18T12:09:03.128Z | 2024-09-19T12:19:25.499Z |
5118764 | 5118764 | 20240915110304_orEGx | USL01B | 2024-09-18T12:09:01.784Z | 2024-09-19T12:19:25.341Z |
5118693 | 5118693 | 20240915104807_dtjue | USL01B | 2024-09-18T12:08:58.953Z | 2024-09-19T12:19:24.975Z |
5118674 | 5118674 | 20240915104232_iX1Dz | USL01B | 2024-09-18T12:08:57.636Z | 2024-09-19T12:19:24.870Z |
5118556 | 5118556 | 20240915101353_C7jsY | USL01B | 2024-09-18T12:08:50.864Z | 2024-09-19T12:19:23.808Z |
5118547 | 5118547 | 20240915101233_KKCdm | USL01B | 2024-09-18T12:08:50.654Z | 2024-09-19T12:19:23.784Z |
5118515 | 5118515 | 20240915100303_TMru2 | USL01B | 2024-09-18T12:08:49.292Z | 2024-09-19T12:19:23.515Z |
5118395 | 5118395 | 20240915093619_26hGq | USL01B | 2024-09-18T12:08:42.109Z | 2024-09-19T12:19:22.478Z |
5118202 | 5118202 | 20240915084958_YJz9K | USL01B | 2024-09-18T12:08:29.670Z | 2024-09-19T12:19:21.240Z |
5118115 | 5118115 | 20240915083535_K5rWS | USL01B | 2024-09-18T12:08:24.676Z | 2024-09-19T12:19:20.567Z |
5117961 | 5117961 | 20240915075944_5E2su | USL01B | 2024-09-18T12:08:11.992Z | 2024-09-19T12:19:19.352Z |
5117921 | 5117921 | 20240915074722_tmxPM | USL01B | 2024-09-18T12:08:07.216Z | 2024-09-19T12:19:18.958Z |
5117773 | 5117773 | 20240915065842_s9ZC8 | USL01B | 2024-09-18T12:07:58.201Z | 2024-09-19T12:19:17.721Z |
5117628 | 5117628 | 20240915055449_2O92a | USL01B | 2024-09-18T12:07:49.864Z | 2024-09-19T12:19:16.555Z |
5117573 | 5117573 | 20240915053302_XYiiw | USL01B | 2024-09-18T12:07:47.617Z | 2024-09-19T12:19:16.113Z |
5110121 | 5110121 | 20240913120708_LNhBk | USL01B | 2024-09-17T12:14:57.115Z | 2024-09-19T12:20:55.780Z |
5110061 | 5110061 | 20240913115738_6iVji | USL01B | 2024-09-17T12:14:56.057Z | 2024-09-19T12:20:55.697Z |
5109993 | 5109993 | 20240913114432_atp7e | USL01B | 2024-09-17T12:14:53.291Z | 2024-09-19T12:20:55.569Z |
5109987 | 5109987 | 20240913114345_XsPou | USL01B | 2024-09-17T12:14:53.098Z | 2024-09-19T12:20:55.556Z |
5109966 | 5109966 | 20240913114144_7kVix | USL01B | 2024-09-17T12:14:51.827Z | 2024-09-19T12:20:55.501Z |
5109940 | 5109940 | 20240913113940_FkRz8 | USL01B | 2024-09-17T12:14:50.682Z | 2024-09-19T12:20:55.449Z |
5109922 | 5109922 | 20240913113604_2dvR7 | USL01B | 2024-09-17T12:14:49.204Z | 2024-09-19T12:20:55.348Z |
5109914 | 5109914 | 20240913113542_QJF6g | USL01B | 2024-09-17T12:14:49.162Z | 2024-09-19T12:20:55.343Z |
5109858 | 5109858 | 20240913112353_yRT87 | USL01B | 2024-09-17T12:14:47.824Z | 2024-09-19T12:20:54.987Z |
5109848 | 5109848 | 20240913112240_TbiaM | USL01B | 2024-09-17T12:14:47.618Z | 2024-09-19T12:20:54.964Z |
5109845 | 5109845 | 20240913112144_Azb5K | USL01B | 2024-09-17T12:14:47.552Z | 2024-09-19T12:20:54.934Z |
5109841 | 5109841 | 20240913111912_GEgYX | USL01B | 2024-09-17T12:14:47.516Z | 2024-09-19T12:20:54.932Z |
5109830 | 5109830 | 20240913111446_uF2DK | USL01B | 2024-09-17T12:14:47.096Z | 2024-09-19T12:20:54.866Z |
5109826 | 5109826 | 20240913111427_M3bAl | USL01B | 2024-09-17T12:14:47.024Z | 2024-09-19T12:20:54.859Z |
5109774 | 5109774 | 20240913110428_A2x6u | USL01B | 2024-09-17T12:14:45.812Z | 2024-09-19T12:20:54.730Z |
5109746 | 5109746 | 20240913110245_22c6R | USL01B | 2024-09-17T12:14:45.268Z | 2024-09-19T12:20:54.674Z |
5109740 | 5109740 | 20240913110224_5J3sW | USL01B | 2024-09-17T12:14:45.227Z | 2024-09-19T12:20:54.663Z |
5109735 | 5109735 | 20240913110133_QXuB2 | USL01B | 2024-09-17T12:14:45.063Z | 2024-09-19T12:20:54.651Z |
5109720 | 5109720 | 20240913105338_IxTLj | USL01B | 2024-09-17T12:14:44.568Z | 2024-09-19T12:20:54.585Z |
5109669 | 5109669 | 20240913104359_kkCQu | USL01B | 2024-09-17T12:14:43.362Z | 2024-09-19T12:20:54.246Z |
5109654 | 5109654 | 20240913104219_ydC5t | USL01B | 2024-09-17T12:14:42.929Z | 2024-09-19T12:20:54.160Z |
5109623 | 5109623 | 20240913103641_z02e2 | USL01B | 2024-09-17T12:14:42.293Z | 2024-09-19T12:20:53.904Z |
5109615 | 5109615 | 20240913103618_FCtzB | USL01B | 2024-09-17T12:14:42.163Z | 2024-09-19T12:20:53.885Z |
5109577 | 5109577 | 20240913103016_vVHUu | USL01B | 2024-09-17T12:14:41.571Z | 2024-09-19T12:20:53.778Z |
5109532 | 5109532 | 20240913101818_2n9Wt | USL01B | 2024-09-17T12:14:40.464Z | 2024-09-19T12:20:53.657Z |
5109520 | 5109520 | 20240913101150_psblv | USL01B | 2024-09-17T12:14:40.069Z | 2024-09-19T12:20:53.619Z |
5109515 | 5109515 | 20240913101033_2Se8m | USL01B | 2024-09-17T12:14:39.940Z | 2024-09-19T12:20:53.604Z |
5109507 | 5109507 | 20240913100937_p49Sr | USL01B | 2024-09-17T12:14:39.793Z | 2024-09-19T12:20:53.592Z |
5109481 | 5109481 | 20240913100036_AgxdD | USL01B | 2024-09-17T12:14:39.173Z | 2024-09-19T12:20:53.469Z |
5109420 | 5109420 | 20240913095158_Ze5Jz | USL01B | 2024-09-17T12:14:37.811Z | 2024-09-19T12:20:53.267Z |
5109387 | 5109387 | 20240913094513_KK38K | USL01B | 2024-09-17T12:14:37.137Z | 2024-09-19T12:20:53.192Z |
5109384 | 5109384 | 20240913094500_aooHR | USL01B | 2024-09-17T12:14:36.984Z | 2024-09-19T12:20:53.179Z |
5109381 | 5109381 | 20240913094440_jly2w | USL01B | 2024-09-17T12:14:36.929Z | 2024-09-19T12:20:53.175Z |
5109379 | 5109379 | 20240913094420_cU7CS | USL01B | 2024-09-17T12:14:36.837Z | 2024-09-19T12:20:53.174Z |
5109323 | 5109323 | 20240913093232_P1uqC | USL01B | 2024-09-17T12:14:35.492Z | 2024-09-19T12:20:52.927Z |
5109312 | 5109312 | 20240913093108_8937b | USL01B | 2024-09-17T12:14:35.281Z | 2024-09-19T12:20:52.830Z |
5109211 | 5109211 | 20240913091316_wMXZe | USL01B | 2024-09-17T12:14:33.316Z | 2024-09-19T12:20:52.492Z |
5109174 | 5109174 | 20240913090334_FdVv4 | USL01B | 2024-09-17T12:14:32.359Z | 2024-09-19T12:20:52.371Z |
5109133 | 5109133 | 20240913085421_2WTSY | USL01B | 2024-09-17T12:14:31.115Z | 2024-09-19T12:20:51.793Z |
5109095 | 5109095 | 20240913084407_BWwFC | USL01B | 2024-09-17T12:14:29.915Z | 2024-09-19T12:20:51.691Z |
5109019 | 5109019 | 20240913082614_bSKfE | USL01B | 2024-09-17T12:14:25.827Z | 2024-09-19T12:20:51.480Z |
5108985 | 5108985 | 20240913081801_6fXBA | USL01B | 2024-09-17T12:14:23.772Z | 2024-09-19T12:20:51.351Z |
5108845 | 5108845 | 20240913074455_t3EnE | USL01B | 2024-09-17T12:14:09.446Z | 2024-09-19T12:20:50.919Z |
5108823 | 5108823 | 20240913074135_l7qWU | USL01B | 2024-09-17T12:14:08.927Z | 2024-09-19T12:20:50.866Z |
5108766 | 5108766 | 20240913072434_xs1Nn | USL01B | 2024-09-17T12:14:05.154Z | 2024-09-19T12:20:50.696Z |
5108760 | 5108760 | 20240913072434_49XlO | USL01B | 2024-09-17T12:14:04.790Z | 2024-09-19T12:20:50.691Z |
5108739 | 5108739 | 20240913071542_gWDZe | USL01B | 2024-09-17T12:14:02.850Z | 2024-09-19T12:20:50.552Z |
5108661 | 5108661 | 20240913065546_Fy2kX | USL01B | 2024-09-17T12:13:56.383Z | 2024-09-19T12:20:50.209Z |
5108650 | 5108650 | 20240913065354_wawd0 | USL01B | 2024-09-17T12:13:55.644Z | 2024-09-19T12:20:50.170Z |
5108505 | 5108505 | 20240913060427_NDs2d | USL01B | 2024-09-17T12:13:48.178Z | 2024-09-19T12:20:49.064Z |
5108364 | 5108364 | 20240913050207_3JXcf | USL01B | 2024-09-17T12:13:38.592Z | 2024-09-19T12:20:48.420Z |
5107177 | 5107177 | 20240913034554_fF3kn | USL01B | 2024-09-17T12:13:10.374Z | 2024-09-19T12:20:46.877Z |
5083084 | 5083084 | 20240911115545_xmqJy | USL01B | 2024-09-15T12:18:35.186Z | 2024-09-19T12:21:49.274Z |
5083018 | 5083018 | 20240911114643_9b0Jt | USL01B | 2024-09-15T12:18:33.383Z | 2024-09-19T12:21:49.126Z |
5082980 | 5082980 | 20240911114005_CyZgo | USL01B | 2024-09-15T12:18:32.339Z | 2024-09-19T12:21:49.012Z |
5082796 | 5082796 | 20240911110018_7X2pB | USL01B | 2024-09-15T12:18:25.683Z | 2024-09-19T12:21:48.680Z |
5082774 | 5082774 | 20240911105629_ceOOg | USL01B | 2024-09-15T12:18:25.212Z | 2024-09-19T12:21:48.653Z |
5082760 | 5082760 | 20240911105617_q72rt | USL01B | 2024-09-15T12:18:24.882Z | 2024-09-19T12:21:48.564Z |
5082715 | 5082715 | 20240911104841_D6EMZ | USL01B | 2024-09-15T12:18:23.358Z | 2024-09-19T12:21:48.436Z |
5082654 | 5082654 | 20240911103920_fcJ9w | USL01B | 2024-09-15T12:18:21.712Z | 2024-09-19T12:21:48.291Z |
5082626 | 5082626 | 20240911103624_sLnon | USL01B | 2024-09-15T12:18:21.469Z | 2024-09-19T12:21:48.205Z |
5082540 | 5082540 | 20240911102316_EgL2Y | USL01B | 2024-09-15T12:18:18.078Z | 2024-09-19T12:21:48.052Z |
5082537 | 5082537 | 20240911102226_M2Y29 | USL01B | 2024-09-15T12:18:17.820Z | 2024-09-19T12:21:48.052Z |
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);