participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,369 rows where station_code = "BR0001" 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 |
---|---|---|---|---|---|
4992249 | 4992249 | 20240901064501_rsCCs | BR0001 | 2024-09-07T12:13:06.924Z | 2024-09-09T12:27:57.658Z |
4992167 | 4992167 | 20240901060651_1YaZg | BR0001 | 2024-09-07T12:12:59.172Z | 2024-09-09T12:27:52.655Z |
4992121 | 4992121 | 20240901055036_OxfLk | BR0001 | 2024-09-07T12:12:56.042Z | 2024-09-09T12:27:49.044Z |
4978133 | 4978133 | 20240811234814_E03E3 | BR0001 | 2024-09-06T12:12:29.895Z | 2024-09-06T12:12:29.895Z |
4956185 | 4956185 | 20240811065240_STwIu | BR0001 | 2024-09-03T12:20:01.791Z | 2024-09-06T12:30:19.959Z |
4956120 | 4956120 | 20240811064657_ovDPq | BR0001 | 2024-09-03T12:19:54.922Z | 2024-09-06T12:30:16.754Z |
4955562 | 4955562 | 20240811052853_BkD72 | BR0001 | 2024-09-03T12:19:18.686Z | 2024-09-06T12:29:47.580Z |
4955251 | 4955251 | 20240811041019_mufaY | BR0001 | 2024-09-03T12:19:00.977Z | 2024-09-06T12:29:28.320Z |
4953976 | 4953976 | 20240811024914_algXw | BR0001 | 2024-09-03T12:18:05.067Z | 2024-09-06T12:28:45.521Z |
4950252 | 4950252 | 20240811020409_rrdv0 | BR0001 | 2024-09-02T12:16:18.581Z | 2024-09-06T12:27:42.623Z |
4868697 | 4868697 | 20240806070134_kM6P2 | BR0001 | 2024-08-18T12:24:24.209Z | 2024-08-19T12:28:56.224Z |
4868644 | 4868644 | 20240806065535_d9n2j | BR0001 | 2024-08-18T12:24:20.776Z | 2024-08-19T12:28:52.267Z |
4868489 | 4868489 | 20240806064059_W22pM | BR0001 | 2024-08-18T12:24:11.372Z | 2024-08-19T12:28:46.659Z |
4868469 | 4868469 | 20240806063844_ZDGtE | BR0001 | 2024-08-18T12:24:11.031Z | 2024-08-19T12:28:46.430Z |
4868385 | 4868385 | 20240806063059_he5P1 | BR0001 | 2024-08-18T12:24:09.247Z | 2024-08-19T12:28:45.094Z |
4868217 | 4868217 | 20240806061007_D3jd1 | BR0001 | 2024-08-18T12:24:02.812Z | 2024-08-19T12:28:42.104Z |
4868168 | 4868168 | 20240806055433_kLPaV | BR0001 | 2024-08-18T12:24:01.167Z | 2024-08-19T12:28:37.980Z |
4867895 | 4867895 | 20240806043646_rXkJj | BR0001 | 2024-08-18T12:23:52.623Z | 2024-08-19T12:28:29.837Z |
4857785 | 4857785 | 20240806030725_6d2rk | BR0001 | 2024-08-17T12:23:03.359Z | 2024-08-19T12:28:23.061Z |
4857783 | 4857783 | 20240806030639_vyM7K | BR0001 | 2024-08-17T12:23:02.887Z | 2024-08-19T12:28:22.985Z |
4857339 | 4857339 | 20240806022023_UpVEs | BR0001 | 2024-08-17T12:22:23.479Z | 2024-08-19T12:28:06.818Z |
4836246 | 4836246 | 20240805021009_2ZYO2 | BR0001 | 2024-08-15T12:16:04.166Z | 2024-08-17T12:32:33.687Z |
4836094 | 4836094 | 20240805020336_w09CK | BR0001 | 2024-08-15T12:15:57.933Z | 2024-08-17T12:32:29.289Z |
4834965 | 4834965 | 20240805012223_VcKLB | BR0001 | 2024-08-15T12:15:10.963Z | 2024-08-17T12:32:02.866Z |
4806673 | 4806673 | 20240803024750_58eEZ | BR0001 | 2024-08-12T12:19:13.151Z | 2024-08-13T12:17:46.753Z |
4805238 | 4805238 | 20240802235138_wDRJl | BR0001 | 2024-08-12T12:17:34.520Z | 2024-08-13T12:17:10.592Z |
4804957 | 4804957 | 20240802232420_ZxGeW | BR0001 | 2024-08-12T12:17:13.981Z | 2024-08-13T12:17:05.246Z |
4804576 | 4804576 | 20240802225054_yfrhk | BR0001 | 2024-08-12T12:16:40.138Z | 2024-08-13T12:16:59.409Z |
4797200 | 4797200 | 20240802030513_Ea3MM | BR0001 | 2024-08-11T12:16:21.517Z | 2024-08-11T12:16:21.517Z |
4796011 | 4796011 | 20240802015209_sliYp | BR0001 | 2024-08-11T12:15:54.438Z | 2024-08-11T12:15:54.438Z |
4795462 | 4795462 | 20240802012830_vQOJR | BR0001 | 2024-08-11T12:15:32.289Z | 2024-08-11T12:15:32.289Z |
4787177 | 4787177 | 20240802051049_beYQM | BR0001 | 2024-08-11T12:01:11.057Z | 2024-08-13T12:15:20.968Z |
4787175 | 4787175 | 20240802051004_zU5Z7 | BR0001 | 2024-08-11T12:01:10.282Z | 2024-08-13T12:15:20.824Z |
4787142 | 4787142 | 20240802045420_OO6RR | BR0001 | 2024-08-11T12:01:00.372Z | 2024-08-13T12:15:19.271Z |
4787129 | 4787129 | 20240802045026_MrvwW | BR0001 | 2024-08-11T12:00:58.432Z | 2024-08-13T12:15:18.892Z |
4786929 | 4786929 | 20240802033355_tNw2J | BR0001 | 2024-08-11T12:00:23.395Z | 2024-08-13T12:15:11.750Z |
4780078 | 4780078 | 20240801014401_baVjC | BR0001 | 2024-08-07T12:14:48.305Z | 2024-08-10T12:21:45.917Z |
4779878 | 4779878 | 20240801012341_cmkv1 | BR0001 | 2024-08-07T12:14:44.086Z | 2024-08-10T12:21:41.320Z |
4779689 | 4779689 | 20240801010628_AP75U | BR0001 | 2024-08-07T12:14:36.551Z | 2024-08-10T12:21:36.428Z |
4779643 | 4779643 | 20240801005949_EGJxP | BR0001 | 2024-08-07T12:14:34.736Z | 2024-08-10T12:21:35.545Z |
4772209 | 4772209 | 20240801062137_mJFSy | BR0001 | 2024-08-07T12:02:50.416Z | 2024-08-11T12:11:19.054Z |
4737640 | 4737640 | 20240729071244_KSjj8 | BR0001 | 2024-08-03T12:06:25.483Z | 2024-08-06T12:15:03.813Z |
4737326 | 4737326 | 20240729053330_Sn5KD | BR0001 | 2024-08-03T12:05:25.702Z | 2024-08-06T12:15:00.465Z |
4737303 | 4737303 | 20240729052459_AjsAp | BR0001 | 2024-08-03T12:05:18.443Z | 2024-08-06T12:14:59.956Z |
4737218 | 4737218 | 20240729044504_9qict | BR0001 | 2024-08-03T12:04:56.190Z | 2024-08-06T12:14:58.357Z |
4737146 | 4737146 | 20240729030852_h2xGE | BR0001 | 2024-08-03T12:04:37.094Z | 2024-08-06T12:14:56.673Z |
4737120 | 4737120 | 20240729021715_o01TC | BR0001 | 2024-08-03T12:04:03.989Z | 2024-08-06T12:14:52.901Z |
4737116 | 4737116 | 20240729020410_7MqHp | BR0001 | 2024-08-03T12:03:47.516Z | 2024-08-06T12:14:51.467Z |
4737102 | 4737102 | 20240729011607_jWqv2 | BR0001 | 2024-08-03T12:02:45.403Z | 2024-08-06T12:14:45.804Z |
4737096 | 4737096 | 20240729004126_04Ojg | BR0001 | 2024-08-03T12:02:05.014Z | 2024-08-06T12:14:41.687Z |
4685302 | 4685302 | 20240725085306_28L29 | BR0001 | 2024-07-26T12:05:20.924Z | 2024-08-02T12:24:40.970Z |
4684911 | 4684911 | 20240725071622_T0Qet | BR0001 | 2024-07-26T12:04:40.441Z | 2024-08-02T12:24:33.894Z |
4684851 | 4684851 | 20240725065454_pO2UG | BR0001 | 2024-07-26T12:04:35.839Z | 2024-08-02T12:24:32.589Z |
4684742 | 4684742 | 20240725062313_HqWEJ | BR0001 | 2024-07-26T12:04:20.057Z | 2024-08-02T12:24:29.619Z |
4684731 | 4684731 | 20240725061753_GtEjR | BR0001 | 2024-07-26T12:04:16.790Z | 2024-08-02T12:24:29.185Z |
4684718 | 4684718 | 20240725060448_cHeRs | BR0001 | 2024-07-26T12:04:13.508Z | 2024-08-02T12:24:28.817Z |
4684699 | 4684699 | 20240725054025_bsrbu | BR0001 | 2024-07-26T12:04:07.328Z | 2024-08-02T12:24:28.537Z |
4684681 | 4684681 | 20240725050846_lXRNg | BR0001 | 2024-07-26T12:04:03.431Z | 2024-08-02T12:24:27.981Z |
4684679 | 4684679 | 20240725050700_Z8qR1 | BR0001 | 2024-07-26T12:04:03.107Z | 2024-08-02T12:24:27.877Z |
4684677 | 4684677 | 20240725050228_836kg | BR0001 | 2024-07-26T12:04:02.782Z | 2024-08-02T12:24:27.801Z |
4681551 | 4681551 | 20240724080043_hMvw0 | BR0001 | 2024-07-25T12:04:11.823Z | 2024-08-01T12:12:04.761Z |
4681253 | 4681253 | 20240724062053_tB3cM | BR0001 | 2024-07-25T12:03:48.670Z | 2024-08-01T12:12:04.056Z |
4681244 | 4681244 | 20240724061542_2beOl | BR0001 | 2024-07-25T12:03:47.861Z | 2024-08-01T12:12:04.040Z |
4681209 | 4681209 | 20240724053426_ISlG7 | BR0001 | 2024-07-25T12:03:44.453Z | 2024-08-01T12:12:03.877Z |
4678156 | 4678156 | 20240723063928_1ONN8 | BR0001 | 2024-07-24T12:03:16.366Z | 2024-07-31T12:17:58.433Z |
4678110 | 4678110 | 20240723054633_Qj9cb | BR0001 | 2024-07-24T12:03:09.332Z | 2024-07-31T12:17:58.138Z |
4676095 | 4676095 | 20240722055653_gmD00 | BR0001 | 2024-07-23T12:02:10.853Z | 2024-07-30T12:18:12.061Z |
4669203 | 4669203 | 20240719084906_KXNyD | BR0001 | 2024-07-20T12:05:41.926Z | 2024-07-27T12:17:23.905Z |
4669143 | 4669143 | 20240719080901_JyFgs | BR0001 | 2024-07-20T12:05:36.039Z | 2024-07-27T12:17:23.204Z |
4668918 | 4668918 | 20240719055627_w8qH2 | BR0001 | 2024-07-20T12:05:16.575Z | 2024-07-27T12:17:20.758Z |
4668909 | 4668909 | 20240719054832_F3oLc | BR0001 | 2024-07-20T12:05:15.155Z | 2024-07-27T12:17:20.691Z |
4667906 | 4667906 | 20240719011347_VW3UV | BR0001 | 2024-07-20T12:04:07.216Z | 2024-07-27T12:17:13.665Z |
4663025 | 4663025 | 20240718054759_FJiDi | BR0001 | 2024-07-19T12:05:37.717Z | 2024-07-26T12:17:48.627Z |
4663013 | 4663013 | 20240718053023_VYjtN | BR0001 | 2024-07-19T12:05:35.804Z | 2024-07-26T12:17:48.536Z |
4662814 | 4662814 | 20240718020042_YFW73 | BR0001 | 2024-07-19T12:05:11.515Z | 2024-07-26T12:17:45.512Z |
4662503 | 4662503 | 20240718011107_1rZ92 | BR0001 | 2024-07-19T12:04:38.285Z | 2024-07-26T12:17:43.246Z |
4662460 | 4662460 | 20240718010400_2D2Bh | BR0001 | 2024-07-19T12:04:33.969Z | 2024-07-26T12:17:42.778Z |
4659331 | 4659331 | 20240715002534_AfeN2 | BR0001 | 2024-07-18T12:12:43.285Z | 2024-07-23T12:08:44.721Z |
4651085 | 4651085 | 20240715040903_DzSrM | BR0001 | 2024-07-17T12:09:46.445Z | 2024-07-23T12:08:48.732Z |
4651081 | 4651081 | 20240715040556_wTAV2 | BR0001 | 2024-07-17T12:09:46.059Z | 2024-07-23T12:08:48.720Z |
4651065 | 4651065 | 20240715034539_UC0Yz | BR0001 | 2024-07-17T12:09:45.110Z | 2024-07-23T12:08:48.692Z |
4649121 | 4649121 | 20240715002904_Bya70 | BR0001 | 2024-07-17T12:08:30.370Z | 2024-07-23T12:08:44.864Z |
4643594 | 4643594 | 20240715083556_QPLA3 | BR0001 | 2024-07-17T12:00:13.423Z | 2024-07-24T12:16:28.594Z |
4598241 | 4598241 | 20240708080831_JzwXl | BR0001 | 2024-07-11T12:04:11.152Z | 2024-07-16T12:09:15.497Z |
4598197 | 4598197 | 20240708075912_B2ZE0 | BR0001 | 2024-07-11T12:04:07.759Z | 2024-07-16T12:09:15.329Z |
4597412 | 4597412 | 20240708045351_09LZ2 | BR0001 | 2024-07-11T12:02:32.077Z | 2024-07-16T12:09:11.693Z |
4597354 | 4597354 | 20240708042005_KdttR | BR0001 | 2024-07-11T12:02:19.390Z | 2024-07-16T12:09:11.484Z |
4597278 | 4597278 | 20240708032953_euQTw | BR0001 | 2024-07-11T12:02:07.765Z | 2024-07-16T12:09:10.895Z |
4597128 | 4597128 | 20240708022309_e9uXP | BR0001 | 2024-07-11T12:01:54.359Z | 2024-07-16T12:09:10.375Z |
4588554 | 4588554 | 20240707000459_0Ae3S | BR0001 | 2024-07-10T12:02:39.455Z | 2024-07-15T12:11:55.361Z |
4572116 | 4572116 | 20240706082949_vAhNv | BR0001 | 2024-07-08T12:05:03.183Z | 2024-07-14T12:14:00.521Z |
4571236 | 4571236 | 20240706060921_mB01F | BR0001 | 2024-07-08T12:03:47.868Z | 2024-07-14T12:13:56.752Z |
4571227 | 4571227 | 20240706060454_WMKq2 | BR0001 | 2024-07-08T12:03:47.130Z | 2024-07-14T12:13:56.740Z |
4571073 | 4571073 | 20240706045755_lAUDA | BR0001 | 2024-07-08T12:03:32.380Z | 2024-07-14T12:13:55.758Z |
4571049 | 4571049 | 20240706045029_zw4gS | BR0001 | 2024-07-08T12:03:29.112Z | 2024-07-14T12:13:55.401Z |
4570936 | 4570936 | 20240706035601_SNNAn | BR0001 | 2024-07-08T12:03:16.789Z | 2024-07-14T12:13:54.543Z |
4563600 | 4563600 | 20240705073416_guxf0 | BR0001 | 2024-07-07T12:05:38.979Z | 2024-07-13T12:12:53.298Z |
4563452 | 4563452 | 20240705070726_ExbLC | BR0001 | 2024-07-07T12:05:18.939Z | 2024-07-13T12:12:52.771Z |
4563358 | 4563358 | 20240705065244_y98hn | BR0001 | 2024-07-07T12:05:11.673Z | 2024-07-13T12:12:52.228Z |
4522605 | 4522605 | 20240629082437_P5svE | BR0001 | 2024-06-30T12:05:43.811Z | 2024-07-07T12:13:51.680Z |
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);