participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
19,049 rows where station_code = "HR000D" 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 |
---|---|---|---|---|---|
5010191 | 5010191 | 20240904024206_Egg9k | HR000D | 2024-09-09T12:08:26.929Z | 2024-09-12T12:19:26.235Z |
5009873 | 5009873 | 20240904021102_RCPjB | HR000D | 2024-09-09T12:08:11.691Z | 2024-09-12T12:19:24.830Z |
5009774 | 5009774 | 20240904020116_iz7vT | HR000D | 2024-09-09T12:08:01.027Z | 2024-09-12T12:19:24.357Z |
5009515 | 5009515 | 20240904013104_hLhSB | HR000D | 2024-09-09T12:07:47.865Z | 2024-09-12T12:19:23.196Z |
5007236 | 5007236 | 20240903202958_p9Mtf | HR000D | 2024-09-09T12:05:37.839Z | 2024-09-12T12:19:12.206Z |
4991510 | 4991510 | 20240901024113_RoYSk | HR000D | 2024-09-07T12:12:06.948Z | 2024-09-09T12:27:10.448Z |
4991330 | 4991330 | 20240901022110_TNH80 | HR000D | 2024-09-07T12:11:56.604Z | 2024-09-09T12:27:05.436Z |
4991286 | 4991286 | 20240901021551_tRHaU | HR000D | 2024-09-07T12:11:49.934Z | 2024-09-09T12:27:04.305Z |
4990839 | 4990839 | 20240901011835_S4jIn | HR000D | 2024-09-07T12:11:12.446Z | 2024-09-09T12:26:48.188Z |
4990084 | 4990084 | 20240831232345_63Hn5 | HR000D | 2024-09-07T12:09:59.651Z | 2024-09-09T12:26:10.197Z |
4989882 | 4989882 | 20240831225301_eTNek | HR000D | 2024-09-07T12:09:45.456Z | 2024-09-09T12:26:04.805Z |
4989853 | 4989853 | 20240831224638_WBxkJ | HR000D | 2024-09-07T12:09:43.242Z | 2024-09-09T12:26:01.186Z |
4953263 | 4953263 | 20240811023506_flW9d | HR000D | 2024-09-03T12:17:29.281Z | 2024-09-06T12:28:22.060Z |
4952704 | 4952704 | 20240811022611_wK6oX | HR000D | 2024-09-03T12:17:04.513Z | 2024-09-06T12:28:07.297Z |
4952089 | 4952089 | 20240811021546_b598I | HR000D | 2024-09-03T12:16:46.388Z | 2024-09-06T12:27:52.597Z |
4950482 | 4950482 | 20240811020712_m1S55 | HR000D | 2024-09-02T12:16:29.220Z | 2024-09-06T12:27:44.886Z |
4950285 | 4950285 | 20240811020446_g2YeF | HR000D | 2024-09-02T12:16:20.722Z | 2024-09-06T12:27:42.973Z |
4949517 | 4949517 | 20240811015130_SPE3C | HR000D | 2024-09-02T12:15:48.210Z | 2024-09-06T12:27:34.362Z |
4949163 | 4949163 | 20240811014619_EUCho | HR000D | 2024-09-02T12:15:39.148Z | 2024-09-06T12:27:30.469Z |
4948664 | 4948664 | 20240811013752_nf0sW | HR000D | 2024-09-02T12:15:10.380Z | 2024-09-06T12:27:23.035Z |
4948569 | 4948569 | 20240811013614_NV5iZ | HR000D | 2024-09-02T12:15:06.795Z | 2024-09-06T12:27:20.627Z |
4948310 | 4948310 | 20240811013218_d1B1s | HR000D | 2024-09-02T12:14:59.709Z | 2024-09-06T12:27:14.752Z |
4948042 | 4948042 | 20240811012823_3jaLf | HR000D | 2024-09-02T12:14:53.581Z | 2024-09-06T12:27:07.339Z |
4947660 | 4947660 | 20240811012222_Hfl8i | HR000D | 2024-09-02T12:14:44.128Z | 2024-09-06T12:26:57.326Z |
4947578 | 4947578 | 20240811012111_xzlr8 | HR000D | 2024-09-02T12:14:38.782Z | 2024-09-06T12:26:55.305Z |
4947148 | 4947148 | 20240811011351_Va401 | HR000D | 2024-09-02T12:14:18.766Z | 2024-09-06T12:26:45.662Z |
4947018 | 4947018 | 20240811011150_VU4V8 | HR000D | 2024-09-02T12:14:14.286Z | 2024-09-06T12:26:42.470Z |
4946148 | 4946148 | 20240811005727_aV1C3 | HR000D | 2024-09-02T12:13:36.535Z | 2024-09-06T12:26:15.923Z |
4945929 | 4945929 | 20240811005344_MFR80 | HR000D | 2024-09-02T12:13:28.653Z | 2024-09-06T12:26:09.080Z |
4945372 | 4945372 | 20240811004505_HA1Fq | HR000D | 2024-09-02T12:13:16.100Z | 2024-09-06T12:25:54.186Z |
4944690 | 4944690 | 20240811003404_MquEm | HR000D | 2024-09-02T12:12:42.944Z | 2024-09-06T12:25:33.600Z |
4944179 | 4944179 | 20240811002455_R8qSP | HR000D | 2024-09-02T12:12:24.239Z | 2024-09-06T12:25:15.061Z |
4944171 | 4944171 | 20240811002455_gskHL | HR000D | 2024-09-02T12:12:24.095Z | 2024-09-06T12:25:15.023Z |
4943859 | 4943859 | 20240811001821_xAjY1 | HR000D | 2024-09-02T12:12:11.612Z | 2024-09-06T12:25:04.946Z |
4943675 | 4943675 | 20240811001525_Ee7Bn | HR000D | 2024-09-02T12:12:04.413Z | 2024-09-06T12:25:01.274Z |
4943286 | 4943286 | 20240811000915_isMTL | HR000D | 2024-09-02T12:11:46.413Z | 2024-09-06T12:24:42.805Z |
4943185 | 4943185 | 20240811000747_a8Noc | HR000D | 2024-09-02T12:11:44.009Z | 2024-09-06T12:24:40.214Z |
4942958 | 4942958 | 20240811000240_v3WgA | HR000D | 2024-09-02T12:11:39.041Z | 2024-09-06T12:24:35.187Z |
4942745 | 4942745 | 20240810235627_hMvDw | HR000D | 2024-09-02T12:11:32.435Z | 2024-09-06T12:24:29.114Z |
4942453 | 4942453 | 20240810235244_hhBIk | HR000D | 2024-09-02T12:11:15.056Z | 2024-09-06T12:24:17.742Z |
4941528 | 4941528 | 20240810233447_hQIQh | HR000D | 2024-09-02T12:10:33.567Z | 2024-09-06T12:23:49.754Z |
4941045 | 4941045 | 20240810232510_7uJQS | HR000D | 2024-09-02T12:10:08.955Z | 2024-09-06T12:23:42.304Z |
4940531 | 4940531 | 20240810231350_xvJOD | HR000D | 2024-09-01T12:10:30.568Z | 2024-09-06T12:23:36.129Z |
4940364 | 4940364 | 20240810231047_OTNWX | HR000D | 2024-09-01T12:10:26.272Z | 2024-09-06T12:23:34.319Z |
4939496 | 4939496 | 20240810224813_5Ezy1 | HR000D | 2024-09-01T12:09:49.687Z | 2024-09-06T12:23:23.374Z |
4938954 | 4938954 | 20240810223306_idifs | HR000D | 2024-09-01T12:09:32.473Z | 2024-09-06T12:23:08.743Z |
4938659 | 4938659 | 20240810222505_83Xip | HR000D | 2024-09-01T12:09:13.770Z | 2024-09-06T12:22:58.868Z |
4938639 | 4938639 | 20240810222444_4ZsWZ | HR000D | 2024-09-01T12:09:13.415Z | 2024-09-06T12:22:58.671Z |
4938357 | 4938357 | 20240810221746_NMrRE | HR000D | 2024-09-01T12:09:04.680Z | 2024-09-06T12:22:50.662Z |
4938133 | 4938133 | 20240810221108_yxjpn | HR000D | 2024-09-01T12:08:57.402Z | 2024-09-06T12:22:44.029Z |
4938106 | 4938106 | 20240810221055_ehyfL | HR000D | 2024-09-01T12:08:56.692Z | 2024-09-06T12:22:43.428Z |
4938066 | 4938066 | 20240810221010_5wUBt | HR000D | 2024-09-01T12:08:55.256Z | 2024-09-06T12:22:42.307Z |
4937709 | 4937709 | 20240810215809_J6eYR | HR000D | 2024-09-01T12:08:33.462Z | 2024-09-06T12:22:27.344Z |
4936920 | 4936920 | 20240810213544_lYgso | HR000D | 2024-09-01T12:07:55.996Z | 2024-09-06T12:21:52.626Z |
4936224 | 4936224 | 20240810210515_Ou5n3 | HR000D | 2024-09-01T12:07:15.260Z | 2024-09-06T12:21:21.677Z |
4936171 | 4936171 | 20240810210346_mKhtd | HR000D | 2024-09-01T12:07:12.211Z | 2024-09-06T12:21:18.399Z |
4928600 | 4928600 | 20240810024416_98fCl | HR000D | 2024-08-31T12:21:30.225Z | 2024-09-02T12:29:13.344Z |
4927955 | 4927955 | 20240810022647_NRcUn | HR000D | 2024-08-31T12:21:06.871Z | 2024-09-02T12:28:55.676Z |
4926828 | 4926828 | 20240810015812_BXRcV | HR000D | 2024-08-31T12:20:05.696Z | 2024-09-02T12:28:06.996Z |
4926435 | 4926435 | 20240810014959_58PBo | HR000D | 2024-08-31T12:19:39.833Z | 2024-09-02T12:27:51.158Z |
4926047 | 4926047 | 20240810013950_YXkvW | HR000D | 2024-08-31T12:19:27.219Z | 2024-09-02T12:27:40.851Z |
4926039 | 4926039 | 20240810013936_T9FL1 | HR000D | 2024-08-31T12:19:26.526Z | 2024-09-02T12:27:40.798Z |
4923254 | 4923254 | 20240810013708_uvx4W | HR000D | 2024-08-30T12:15:18.632Z | 2024-09-02T12:27:39.384Z |
4923098 | 4923098 | 20240810013158_lZGoc | HR000D | 2024-08-30T12:15:05.952Z | 2024-09-02T12:27:34.935Z |
4922694 | 4922694 | 20240810012214_NYTQg | HR000D | 2024-08-30T12:14:55.784Z | 2024-09-02T12:27:29.790Z |
4922280 | 4922280 | 20240810011404_f3I32 | HR000D | 2024-08-30T12:14:46.668Z | 2024-09-02T12:27:25.116Z |
4921416 | 4921416 | 20240810005452_HezYh | HR000D | 2024-08-30T12:14:09.423Z | 2024-09-02T12:27:00.173Z |
4920704 | 4920704 | 20240810003720_cMxJq | HR000D | 2024-08-30T12:13:37.294Z | 2024-09-02T12:26:35.750Z |
4920287 | 4920287 | 20240810003003_K8OEn | HR000D | 2024-08-30T12:13:15.497Z | 2024-09-02T12:26:20.314Z |
4920208 | 4920208 | 20240810002731_IEwxo | HR000D | 2024-08-30T12:13:12.964Z | 2024-09-02T12:26:16.634Z |
4920099 | 4920099 | 20240810002515_Z1j9b | HR000D | 2024-08-30T12:13:08.073Z | 2024-09-02T12:26:13.184Z |
4919834 | 4919834 | 20240810001941_XAnaS | HR000D | 2024-08-30T12:13:01.283Z | 2024-09-02T12:26:03.653Z |
4919702 | 4919702 | 20240810001744_W11q5 | HR000D | 2024-08-30T12:12:58.440Z | 2024-09-02T12:25:57.115Z |
4919115 | 4919115 | 20240810000422_vgz0j | HR000D | 2024-08-30T12:12:32.293Z | 2024-09-02T12:25:41.422Z |
4918488 | 4918488 | 20240809235246_1jzXK | HR000D | 2024-08-30T12:12:03.778Z | 2024-09-02T12:25:32.267Z |
4918483 | 4918483 | 20240809235243_tWVFJ | HR000D | 2024-08-30T12:12:03.578Z | 2024-09-02T12:25:32.125Z |
4918046 | 4918046 | 20240809234536_QHDoJ | HR000D | 2024-08-30T12:11:50.844Z | 2024-09-02T12:25:24.609Z |
4917947 | 4917947 | 20240809234350_07NXQ | HR000D | 2024-08-30T12:11:44.270Z | 2024-09-02T12:25:21.832Z |
4916333 | 4916333 | 20240809231054_Luc35 | HR000D | 2024-08-30T12:10:45.963Z | 2024-09-02T12:24:22.572Z |
4916148 | 4916148 | 20240809230742_FmS57 | HR000D | 2024-08-30T12:10:38.209Z | 2024-09-02T12:24:16.386Z |
4916104 | 4916104 | 20240809230640_4ENCN | HR000D | 2024-08-30T12:10:32.045Z | 2024-09-02T12:24:13.404Z |
4916058 | 4916058 | 20240809230417_McNuD | HR000D | 2024-08-30T12:10:29.921Z | 2024-09-02T12:24:10.923Z |
4915807 | 4915807 | 20240809225802_hL5rn | HR000D | 2024-08-30T12:10:15.672Z | 2024-09-02T12:24:04.085Z |
4915648 | 4915648 | 20240809225347_Pp9dq | HR000D | 2024-08-30T12:10:08.260Z | 2024-09-02T12:23:59.575Z |
4914547 | 4914547 | 20240809222303_sA0Kr | HR000D | 2024-08-30T12:09:16.035Z | 2024-09-02T12:23:36.203Z |
4914469 | 4914469 | 20240809222058_q5UsN | HR000D | 2024-08-30T12:09:12.778Z | 2024-09-02T12:23:31.718Z |
4914119 | 4914119 | 20240809220808_9UOgH | HR000D | 2024-08-30T12:08:56.403Z | 2024-09-02T12:23:17.360Z |
4913490 | 4913490 | 20240809215039_XgtuK | HR000D | 2024-08-29T12:09:15.662Z | 2024-09-02T12:22:58.063Z |
4899780 | 4899780 | 20240807232131_eakbi | HR000D | 2024-08-28T12:17:28.444Z | 2024-08-28T12:17:28.444Z |
4892374 | 4892374 | 20240809023902_aXDhJ | HR000D | 2024-08-28T12:10:10.401Z | 2024-08-30T12:22:03.007Z |
4892333 | 4892333 | 20240809023143_MyYV1 | HR000D | 2024-08-28T12:10:03.455Z | 2024-08-30T12:22:00.442Z |
4892330 | 4892330 | 20240809023141_GeTBX | HR000D | 2024-08-28T12:10:03.365Z | 2024-08-30T12:22:00.399Z |
4892214 | 4892214 | 20240809021715_WpUbk | HR000D | 2024-08-28T12:09:54.684Z | 2024-08-30T12:21:49.538Z |
4892081 | 4892081 | 20240809020404_C7n3d | HR000D | 2024-08-28T12:09:47.345Z | 2024-08-30T12:21:38.842Z |
4891904 | 4891904 | 20240809014714_OmNBS | HR000D | 2024-08-28T12:09:37.279Z | 2024-08-30T12:21:31.562Z |
4891855 | 4891855 | 20240809014305_ccj3L | HR000D | 2024-08-28T12:09:31.452Z | 2024-08-30T12:21:27.131Z |
4891747 | 4891747 | 20240809013405_4Z9uZ | HR000D | 2024-08-28T12:09:20.810Z | 2024-08-30T12:21:23.889Z |
4891673 | 4891673 | 20240809012622_c7oZy | HR000D | 2024-08-28T12:09:16.292Z | 2024-08-30T12:21:21.513Z |
4891626 | 4891626 | 20240809012126_Y3J3U | HR000D | 2024-08-28T12:09:13.861Z | 2024-08-30T12:21:20.210Z |
4891604 | 4891604 | 20240809011914_tM33A | HR000D | 2024-08-28T12:09:12.705Z | 2024-08-30T12:21:19.608Z |
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);