participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,275 rows where station_code = "BG000D" 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 |
---|---|---|---|---|---|
5119115 | 5119115 | 20240914021208_HzYMB | BG000D | 2024-09-18T12:10:16.285Z | 2024-09-19T12:19:57.181Z |
5103220 | 5103220 | 20240914020544_J7v5R | BG000D | 2024-09-17T12:07:59.661Z | 2024-09-19T12:19:56.954Z |
5102416 | 5102416 | 20240914012457_t2MJ5 | BG000D | 2024-09-17T12:07:08.057Z | 2024-09-19T12:19:54.088Z |
5101515 | 5101515 | 20240914003258_JyPpU | BG000D | 2024-09-17T12:05:58.796Z | 2024-09-19T12:19:50.845Z |
5101455 | 5101455 | 20240914002703_LDJEM | BG000D | 2024-09-17T12:05:51.489Z | 2024-09-19T12:19:50.591Z |
5101179 | 5101179 | 20240914000925_Jz3Z3 | BG000D | 2024-09-17T12:05:24.406Z | 2024-09-19T12:19:49.965Z |
5099138 | 5099138 | 20240913202923_IuqQK | BG000D | 2024-09-17T12:02:22.688Z | 2024-09-19T12:19:43.603Z |
5099097 | 5099097 | 20240913202304_xuQd8 | BG000D | 2024-09-17T12:02:20.274Z | 2024-09-19T12:19:43.398Z |
5098785 | 5098785 | 20240913192955_HiSI4 | BG000D | 2024-09-17T12:01:35.981Z | 2024-09-19T12:19:41.111Z |
5098670 | 5098670 | 20240913185353_elt6F | BG000D | 2024-09-17T12:01:16.586Z | 2024-09-19T12:19:39.975Z |
5098545 | 5098545 | 20240913180336_qY2He | BG000D | 2024-09-17T12:00:52.840Z | 2024-09-19T12:19:38.754Z |
5098525 | 5098525 | 20240913175429_kkfiL | BG000D | 2024-09-17T12:00:49.742Z | 2024-09-19T12:19:38.640Z |
5054458 | 5054458 | 20240908025358_qpbr7 | BG000D | 2024-09-13T12:16:42.517Z | 2024-09-16T12:21:15.644Z |
5054395 | 5054395 | 20240908024536_kzloG | BG000D | 2024-09-13T12:16:40.058Z | 2024-09-16T12:21:15.446Z |
5054278 | 5054278 | 20240908023541_SMGU1 | BG000D | 2024-09-13T12:16:36.003Z | 2024-09-16T12:21:14.722Z |
5054188 | 5054188 | 20240908022252_iDLFW | BG000D | 2024-09-13T12:16:32.692Z | 2024-09-16T12:21:14.226Z |
5054156 | 5054156 | 20240908021653_zmdDI | BG000D | 2024-09-13T12:16:31.512Z | 2024-09-16T12:21:14.154Z |
5054104 | 5054104 | 20240908021107_NKZ1o | BG000D | 2024-09-13T12:16:29.905Z | 2024-09-16T12:21:13.956Z |
5054052 | 5054052 | 20240908020416_g0Fy3 | BG000D | 2024-09-13T12:16:27.537Z | 2024-09-16T12:21:13.836Z |
5054041 | 5054041 | 20240908020319_Xq0fo | BG000D | 2024-09-13T12:16:27.201Z | 2024-09-16T12:21:13.810Z |
5054035 | 5054035 | 20240908020226_ARH3m | BG000D | 2024-09-13T12:16:27.038Z | 2024-09-16T12:21:13.798Z |
5054032 | 5054032 | 20240908020207_7ygAp | BG000D | 2024-09-13T12:16:26.975Z | 2024-09-16T12:21:13.788Z |
5053940 | 5053940 | 20240908015159_c23Cw | BG000D | 2024-09-13T12:16:23.320Z | 2024-09-16T12:21:13.348Z |
5053885 | 5053885 | 20240908014509_cMATO | BG000D | 2024-09-13T12:16:20.761Z | 2024-09-16T12:21:13.000Z |
5053861 | 5053861 | 20240908014132_d38xe | BG000D | 2024-09-13T12:16:20.094Z | 2024-09-16T12:21:12.940Z |
5053854 | 5053854 | 20240908014059_O5VBo | BG000D | 2024-09-13T12:16:19.848Z | 2024-09-16T12:21:12.934Z |
5053831 | 5053831 | 20240908013724_5ZpQO | BG000D | 2024-09-13T12:16:19.039Z | 2024-09-16T12:21:12.874Z |
5053823 | 5053823 | 20240908013646_mK1Gh | BG000D | 2024-09-13T12:16:18.438Z | 2024-09-16T12:21:12.821Z |
5053812 | 5053812 | 20240908013403_lgdlh | BG000D | 2024-09-13T12:16:17.983Z | 2024-09-16T12:21:12.798Z |
5053764 | 5053764 | 20240908012722_NlpII | BG000D | 2024-09-13T12:16:17.012Z | 2024-09-16T12:21:12.664Z |
5053602 | 5053602 | 20240908010436_x6qVz | BG000D | 2024-09-13T12:16:09.865Z | 2024-09-16T12:21:12.058Z |
5053591 | 5053591 | 20240908010221_fWSso | BG000D | 2024-09-13T12:16:09.481Z | 2024-09-16T12:21:12.018Z |
5053574 | 5053574 | 20240908005752_YGF9t | BG000D | 2024-09-13T12:16:08.833Z | 2024-09-16T12:21:11.942Z |
5053555 | 5053555 | 20240908005538_d79RZ | BG000D | 2024-09-13T12:16:08.468Z | 2024-09-16T12:21:11.898Z |
5053513 | 5053513 | 20240908005108_kuhR1 | BG000D | 2024-09-13T12:16:07.261Z | 2024-09-16T12:21:11.775Z |
5053498 | 5053498 | 20240908004556_YCYYJ | BG000D | 2024-09-13T12:16:06.622Z | 2024-09-16T12:21:11.678Z |
5053477 | 5053477 | 20240908004244_k7LIx | BG000D | 2024-09-13T12:16:05.620Z | 2024-09-16T12:21:11.516Z |
5053451 | 5053451 | 20240908003706_HvsD2 | BG000D | 2024-09-13T12:16:04.407Z | 2024-09-16T12:21:11.264Z |
5053378 | 5053378 | 20240908002204_vqAED | BG000D | 2024-09-13T12:16:02.147Z | 2024-09-16T12:21:10.458Z |
5053255 | 5053255 | 20240907235813_bVCXn | BG000D | 2024-09-13T12:15:55.331Z | 2024-09-16T12:21:10.163Z |
5053223 | 5053223 | 20240907235315_KYpPY | BG000D | 2024-09-13T12:15:54.112Z | 2024-09-16T12:21:10.020Z |
5053214 | 5053214 | 20240907235153_ilPFN | BG000D | 2024-09-13T12:15:53.698Z | 2024-09-16T12:21:10.014Z |
5053178 | 5053178 | 20240907234408_UDHed | BG000D | 2024-09-13T12:15:52.364Z | 2024-09-16T12:21:09.964Z |
5053101 | 5053101 | 20240907232641_ZY3lI | BG000D | 2024-09-13T12:15:46.366Z | 2024-09-16T12:21:09.475Z |
5052999 | 5052999 | 20240907225746_w3z53 | BG000D | 2024-09-13T12:15:41.328Z | 2024-09-16T12:21:08.905Z |
5052966 | 5052966 | 20240907224724_ciQNi | BG000D | 2024-09-13T12:15:38.916Z | 2024-09-16T12:21:08.769Z |
5052900 | 5052900 | 20240907223147_tZ0Bn | BG000D | 2024-09-13T12:15:35.064Z | 2024-09-16T12:21:08.536Z |
5052841 | 5052841 | 20240907221935_ON2zQ | BG000D | 2024-09-13T12:15:31.709Z | 2024-09-16T12:21:08.212Z |
5052744 | 5052744 | 20240907215042_l3fZT | BG000D | 2024-09-13T12:15:24.742Z | 2024-09-16T12:21:07.488Z |
5052512 | 5052512 | 20240907205737_xyrkR | BG000D | 2024-09-13T12:15:12.193Z | 2024-09-16T12:21:06.029Z |
5052403 | 5052403 | 20240907203340_SEffS | BG000D | 2024-09-13T12:15:07.786Z | 2024-09-16T12:21:05.412Z |
5052352 | 5052352 | 20240907202531_G5wd5 | BG000D | 2024-09-13T12:15:05.197Z | 2024-09-16T12:21:05.199Z |
5052249 | 5052249 | 20240907200345_yntXg | BG000D | 2024-09-13T12:15:01.534Z | 2024-09-16T12:21:04.767Z |
5052246 | 5052246 | 20240907200329_6sbJr | BG000D | 2024-09-13T12:15:01.416Z | 2024-09-16T12:21:04.765Z |
5052237 | 5052237 | 20240907200128_tRpdV | BG000D | 2024-09-13T12:15:01.206Z | 2024-09-16T12:21:04.739Z |
5052168 | 5052168 | 20240907195043_bOSM5 | BG000D | 2024-09-13T12:14:59.248Z | 2024-09-16T12:21:04.303Z |
5052066 | 5052066 | 20240907193835_WkC7W | BG000D | 2024-09-13T12:14:55.697Z | 2024-09-16T12:21:03.537Z |
5051846 | 5051846 | 20240907185132_oXX2f | BG000D | 2024-09-13T12:14:37.592Z | 2024-09-16T12:21:02.134Z |
5051651 | 5051651 | 20240907180831_di0Q3 | BG000D | 2024-09-13T12:14:27.339Z | 2024-09-16T12:21:01.484Z |
5047171 | 5047171 | 20240909025442_gFzqU | BG000D | 2024-09-13T12:08:34.273Z | 2024-09-17T12:19:01.362Z |
5047111 | 5047111 | 20240909023938_8ZbYJ | BG000D | 2024-09-13T12:08:17.978Z | 2024-09-17T12:19:01.148Z |
5047095 | 5047095 | 20240909023808_eS5J2 | BG000D | 2024-09-13T12:08:17.178Z | 2024-09-17T12:19:01.084Z |
5047074 | 5047074 | 20240909023427_2fcPD | BG000D | 2024-09-13T12:08:14.735Z | 2024-09-17T12:19:01.020Z |
5047070 | 5047070 | 20240909023156_CUq4a | BG000D | 2024-09-13T12:08:14.177Z | 2024-09-17T12:19:00.970Z |
5047046 | 5047046 | 20240909022415_eC23i | BG000D | 2024-09-13T12:08:11.527Z | 2024-09-17T12:19:00.893Z |
5047027 | 5047027 | 20240909021821_FnAoC | BG000D | 2024-09-13T12:08:09.390Z | 2024-09-17T12:19:00.870Z |
5047017 | 5047017 | 20240909021543_ib5Cf | BG000D | 2024-09-13T12:08:08.510Z | 2024-09-17T12:19:00.793Z |
5046961 | 5046961 | 20240909020014_6arIo | BG000D | 2024-09-13T12:08:01.188Z | 2024-09-17T12:19:00.653Z |
5046955 | 5046955 | 20240909015904_anXQn | BG000D | 2024-09-13T12:08:00.828Z | 2024-09-17T12:19:00.651Z |
5046909 | 5046909 | 20240909014747_ev3zh | BG000D | 2024-09-13T12:07:56.034Z | 2024-09-17T12:19:00.590Z |
5046897 | 5046897 | 20240909014639_Utkna | BG000D | 2024-09-13T12:07:55.246Z | 2024-09-17T12:19:00.576Z |
5046889 | 5046889 | 20240909014600_kZHef | BG000D | 2024-09-13T12:07:53.090Z | 2024-09-17T12:19:00.571Z |
5046858 | 5046858 | 20240909013941_A844U | BG000D | 2024-09-13T12:07:40.119Z | 2024-09-17T12:19:00.504Z |
5046846 | 5046846 | 20240909013633_OUstM | BG000D | 2024-09-13T12:07:38.601Z | 2024-09-17T12:19:00.483Z |
5046820 | 5046820 | 20240909013226_OYpAw | BG000D | 2024-09-13T12:07:36.576Z | 2024-09-17T12:19:00.448Z |
5046817 | 5046817 | 20240909013053_lvgli | BG000D | 2024-09-13T12:07:35.965Z | 2024-09-17T12:19:00.444Z |
5046783 | 5046783 | 20240909012106_0phzT | BG000D | 2024-09-13T12:07:30.927Z | 2024-09-17T12:19:00.318Z |
5046775 | 5046775 | 20240909011810_NybGh | BG000D | 2024-09-13T12:07:29.707Z | 2024-09-17T12:19:00.310Z |
5046758 | 5046758 | 20240909011319_CEzjW | BG000D | 2024-09-13T12:07:27.471Z | 2024-09-17T12:19:00.265Z |
5046744 | 5046744 | 20240909011043_26y3j | BG000D | 2024-09-13T12:07:25.864Z | 2024-09-17T12:19:00.222Z |
5046728 | 5046728 | 20240909010027_QHzTB | BG000D | 2024-09-13T12:07:23.911Z | 2024-09-17T12:19:00.198Z |
5046715 | 5046715 | 20240909005740_Cdg5n | BG000D | 2024-09-13T12:07:22.359Z | 2024-09-17T12:18:59.739Z |
5046712 | 5046712 | 20240909005210_71k32 | BG000D | 2024-09-13T12:07:21.722Z | 2024-09-17T12:18:59.735Z |
5046685 | 5046685 | 20240909004606_W56s9 | BG000D | 2024-09-13T12:07:17.806Z | 2024-09-17T12:18:59.697Z |
5046632 | 5046632 | 20240909003139_1D1d6 | BG000D | 2024-09-13T12:07:11.931Z | 2024-09-17T12:18:59.631Z |
5046603 | 5046603 | 20240909002123_qgb3h | BG000D | 2024-09-13T12:07:03.786Z | 2024-09-17T12:18:59.608Z |
5046534 | 5046534 | 20240909000624_EmM63 | BG000D | 2024-09-13T12:06:53.745Z | 2024-09-17T12:18:59.470Z |
5046518 | 5046518 | 20240908235907_4RaFQ | BG000D | 2024-09-13T12:06:51.142Z | 2024-09-17T12:18:59.457Z |
5046489 | 5046489 | 20240908235052_2R2A7 | BG000D | 2024-09-13T12:06:47.749Z | 2024-09-17T12:18:59.423Z |
5046480 | 5046480 | 20240908234835_mbgza | BG000D | 2024-09-13T12:06:46.952Z | 2024-09-17T12:18:59.417Z |
5046471 | 5046471 | 20240908234535_FXFW6 | BG000D | 2024-09-13T12:06:45.155Z | 2024-09-17T12:18:59.388Z |
5046407 | 5046407 | 20240908231859_1eZTh | BG000D | 2024-09-13T12:06:38.552Z | 2024-09-17T12:18:59.332Z |
5046392 | 5046392 | 20240908231618_3ABND | BG000D | 2024-09-13T12:06:37.073Z | 2024-09-17T12:18:59.322Z |
5046391 | 5046391 | 20240908231551_6yQ1G | BG000D | 2024-09-13T12:06:36.775Z | 2024-09-17T12:18:59.318Z |
5046367 | 5046367 | 20240908230727_bmpLl | BG000D | 2024-09-13T12:06:34.341Z | 2024-09-17T12:18:59.294Z |
5046338 | 5046338 | 20240908225012_vAV3A | BG000D | 2024-09-13T12:06:28.990Z | 2024-09-17T12:18:59.122Z |
5046324 | 5046324 | 20240908224810_Mv24f | BG000D | 2024-09-13T12:06:26.029Z | 2024-09-17T12:18:59.102Z |
5046299 | 5046299 | 20240908223505_kWHij | BG000D | 2024-09-13T12:06:20.225Z | 2024-09-17T12:18:59.011Z |
5046296 | 5046296 | 20240908223356_WsA6g | BG000D | 2024-09-13T12:06:19.627Z | 2024-09-17T12:18:59.008Z |
5046290 | 5046290 | 20240908223327_iLilb | BG000D | 2024-09-13T12:06:18.945Z | 2024-09-17T12:18:58.998Z |
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);