participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,121 rows where station_code = "BG0009" 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 |
---|---|---|---|---|---|
5505053 | 5505053 | 20241108034622_ULOxf | BG0009 | 2024-11-09T14:15:39.996Z | 2024-11-09T14:16:28.690Z |
5505044 | 5505044 | 20241108034446_yvE7m | BG0009 | 2024-11-09T14:15:38.708Z | 2024-11-09T14:16:28.687Z |
5505026 | 5505026 | 20241108033629_3tyDQ | BG0009 | 2024-11-09T14:15:36.961Z | 2024-11-09T14:16:28.683Z |
5504885 | 5504885 | 20241108031215_uH9by | BG0009 | 2024-11-09T14:15:19.733Z | 2024-11-09T14:16:28.648Z |
5504883 | 5504883 | 20241108031215_BwNr8 | BG0009 | 2024-11-09T14:15:19.632Z | 2024-11-09T14:16:28.648Z |
5504803 | 5504803 | 20241108030007_DNfNA | BG0009 | 2024-11-09T14:15:12.385Z | 2024-11-09T14:16:28.630Z |
5504756 | 5504756 | 20241108025300_ewLMc | BG0009 | 2024-11-09T14:15:09.258Z | 2024-11-09T14:16:28.617Z |
5504646 | 5504646 | 20241108023245_jWR6e | BG0009 | 2024-11-09T14:15:00.545Z | 2024-11-09T14:16:28.591Z |
5504418 | 5504418 | 20241108015622_NZgQG | BG0009 | 2024-11-09T14:14:36.443Z | 2024-11-09T14:16:28.532Z |
5504175 | 5504175 | 20241108010932_wKfAH | BG0009 | 2024-11-09T14:14:11.613Z | 2024-11-09T14:16:28.468Z |
5504107 | 5504107 | 20241108005544_Ivn5o | BG0009 | 2024-11-09T14:14:05.048Z | 2024-11-09T14:16:28.451Z |
5504024 | 5504024 | 20241108004137_cfXKh | BG0009 | 2024-11-09T14:13:59.091Z | 2024-11-09T14:16:28.429Z |
5503897 | 5503897 | 20241108000634_w2ep1 | BG0009 | 2024-11-09T14:13:50.278Z | 2024-11-09T14:16:28.385Z |
5503873 | 5503873 | 20241108000420_WHuIU | BG0009 | 2024-11-09T14:13:49.058Z | 2024-11-09T14:16:28.376Z |
5503657 | 5503657 | 20241107231843_n9swq | BG0009 | 2024-11-09T14:13:29.793Z | 2024-11-09T14:16:28.314Z |
5503653 | 5503653 | 20241107231709_GB2LM | BG0009 | 2024-11-09T14:13:29.595Z | 2024-11-09T14:16:28.313Z |
5503555 | 5503555 | 20241107224935_U8zCb | BG0009 | 2024-11-09T14:13:17.771Z | 2024-11-09T14:16:28.289Z |
5503486 | 5503486 | 20241107223100_DOx3X | BG0009 | 2024-11-09T14:13:10.226Z | 2024-11-09T14:16:28.274Z |
5503277 | 5503277 | 20241107212019_8yA39 | BG0009 | 2024-11-09T14:12:43.111Z | 2024-11-09T14:16:28.207Z |
5503252 | 5503252 | 20241107211053_LpY22 | BG0009 | 2024-11-09T14:12:39.268Z | 2024-11-09T14:16:28.201Z |
5503106 | 5503106 | 20241107204215_Wxj0X | BG0009 | 2024-11-09T14:12:25.274Z | 2024-11-09T14:16:28.168Z |
5502895 | 5502895 | 20241107200853_LHlR0 | BG0009 | 2024-11-09T14:12:11.140Z | 2024-11-09T14:16:28.122Z |
5502564 | 5502564 | 20241107190806_GcA81 | BG0009 | 2024-11-09T14:11:44.935Z | 2024-11-09T14:16:28.056Z |
5502462 | 5502462 | 20241107183919_gIX9Y | BG0009 | 2024-11-09T14:11:25.019Z | 2024-11-09T14:16:28.033Z |
5502431 | 5502431 | 20241107183256_yWcR5 | BG0009 | 2024-11-09T14:11:21.523Z | 2024-11-09T14:16:28.027Z |
5502186 | 5502186 | 20241107173717_k8BG8 | BG0009 | 2024-11-09T14:11:03.065Z | 2024-11-09T14:16:27.978Z |
5502162 | 5502162 | 20241107173355_Bp3if | BG0009 | 2024-11-09T14:11:00.447Z | 2024-11-09T14:16:27.969Z |
5497485 | 5497485 | 20241107034943_fwIMD | BG0009 | 2024-11-08T14:13:52.115Z | 2024-11-09T14:18:44.465Z |
5497287 | 5497287 | 20241107031415_95eWB | BG0009 | 2024-11-08T14:13:29.995Z | 2024-11-09T14:18:40.085Z |
5497272 | 5497272 | 20241107031218_yrQbf | BG0009 | 2024-11-08T14:13:28.280Z | 2024-11-09T14:18:39.620Z |
5497126 | 5497126 | 20241107024531_Ulvma | BG0009 | 2024-11-08T14:13:12.682Z | 2024-11-09T14:18:35.796Z |
5497125 | 5497125 | 20241107024452_AFCFn | BG0009 | 2024-11-08T14:13:12.503Z | 2024-11-09T14:18:35.788Z |
5496940 | 5496940 | 20241107021221_nshtZ | BG0009 | 2024-11-08T14:13:00.008Z | 2024-11-09T14:18:33.356Z |
5496804 | 5496804 | 20241107014231_mBm3y | BG0009 | 2024-11-08T14:12:52.385Z | 2024-11-09T14:18:30.513Z |
5496776 | 5496776 | 20241107013739_YMY2i | BG0009 | 2024-11-08T14:12:51.210Z | 2024-11-09T14:18:29.974Z |
5496745 | 5496745 | 20241107012846_pAXg3 | BG0009 | 2024-11-08T14:12:49.315Z | 2024-11-09T14:18:29.430Z |
5496714 | 5496714 | 20241107012309_TH2ah | BG0009 | 2024-11-08T14:12:46.423Z | 2024-11-09T14:18:28.794Z |
5496395 | 5496395 | 20241107001338_wDC1p | BG0009 | 2024-11-08T14:12:06.473Z | 2024-11-09T14:18:21.699Z |
5496374 | 5496374 | 20241107000651_8kqyR | BG0009 | 2024-11-08T14:12:04.244Z | 2024-11-09T14:18:21.191Z |
5496121 | 5496121 | 20241106230023_rt5sn | BG0009 | 2024-11-08T14:11:36.386Z | 2024-11-09T14:18:16.423Z |
5496112 | 5496112 | 20241106225737_FqdSM | BG0009 | 2024-11-08T14:11:35.536Z | 2024-11-09T14:18:16.329Z |
5496044 | 5496044 | 20241106224459_WAzE3 | BG0009 | 2024-11-08T14:11:26.434Z | 2024-11-09T14:18:15.007Z |
5496042 | 5496042 | 20241106224448_O0K22 | BG0009 | 2024-11-08T14:11:26.382Z | 2024-11-09T14:18:15.004Z |
5496029 | 5496029 | 20241106224114_MsH0H | BG0009 | 2024-11-08T14:11:24.766Z | 2024-11-09T14:18:14.711Z |
5496002 | 5496002 | 20241106223437_x35go | BG0009 | 2024-11-08T14:11:22.045Z | 2024-11-09T14:18:14.246Z |
5495888 | 5495888 | 20241106215703_585D7 | BG0009 | 2024-11-08T14:11:04.070Z | 2024-11-09T14:18:10.719Z |
5495818 | 5495818 | 20241106214040_dP3cX | BG0009 | 2024-11-08T14:10:56.110Z | 2024-11-09T14:18:09.735Z |
5495769 | 5495769 | 20241106212839_3b57M | BG0009 | 2024-11-08T14:10:50.411Z | 2024-11-09T14:18:07.658Z |
5495744 | 5495744 | 20241106211904_063ve | BG0009 | 2024-11-08T14:10:45.032Z | 2024-11-09T14:18:06.386Z |
5495731 | 5495731 | 20241106211731_OrIHj | BG0009 | 2024-11-08T14:10:43.146Z | 2024-11-09T14:18:06.189Z |
5495686 | 5495686 | 20241106210332_yIYjG | BG0009 | 2024-11-08T14:10:37.599Z | 2024-11-09T14:18:04.477Z |
5495583 | 5495583 | 20241106202624_xnWTr | BG0009 | 2024-11-08T14:10:26.001Z | 2024-11-09T14:17:59.839Z |
5495552 | 5495552 | 20241106201754_N1rtn | BG0009 | 2024-11-08T14:10:23.556Z | 2024-11-09T14:17:57.645Z |
5495503 | 5495503 | 20241106200438_ZoyEx | BG0009 | 2024-11-08T14:10:18.920Z | 2024-11-09T14:17:56.067Z |
5495357 | 5495357 | 20241106193539_79V2J | BG0009 | 2024-11-08T14:10:07.135Z | 2024-11-09T14:17:51.896Z |
5495322 | 5495322 | 20241106192427_3GFx2 | BG0009 | 2024-11-08T14:09:57.827Z | 2024-11-09T14:17:50.626Z |
5495209 | 5495209 | 20241106185916_xAhjQ | BG0009 | 2024-11-08T14:09:39.883Z | 2024-11-09T14:17:45.656Z |
5494733 | 5494733 | 20241106170758_yf5w0 | BG0009 | 2024-11-08T14:08:30.613Z | 2024-11-09T14:17:27.009Z |
5494626 | 5494626 | 20241106162338_2N8TV | BG0009 | 2024-11-08T14:08:07.162Z | 2024-11-09T14:17:23.408Z |
5491537 | 5491537 | 20241106034100_Eoedo | BG0009 | 2024-11-07T14:16:20.711Z | 2024-11-09T14:20:10.532Z |
5491491 | 5491491 | 20241106032650_Ac8gk | BG0009 | 2024-11-07T14:16:14.236Z | 2024-11-09T14:20:09.660Z |
5491459 | 5491459 | 20241106032114_22XuT | BG0009 | 2024-11-07T14:16:10.720Z | 2024-11-09T14:20:08.724Z |
5491449 | 5491449 | 20241106031934_06djR | BG0009 | 2024-11-07T14:16:09.860Z | 2024-11-09T14:20:08.678Z |
5491439 | 5491439 | 20241106031645_Le5Be | BG0009 | 2024-11-07T14:16:07.669Z | 2024-11-09T14:20:07.670Z |
5491402 | 5491402 | 20241106031201_u5pmh | BG0009 | 2024-11-07T14:16:03.448Z | 2024-11-09T14:20:07.366Z |
5491377 | 5491377 | 20241106030853_aa3JT | BG0009 | 2024-11-07T14:16:00.690Z | 2024-11-09T14:20:07.262Z |
5491134 | 5491134 | 20241106020519_AYbii | BG0009 | 2024-11-07T14:15:22.063Z | 2024-11-09T14:20:04.337Z |
5491078 | 5491078 | 20241106015056_JM72c | BG0009 | 2024-11-07T14:15:17.452Z | 2024-11-09T14:20:03.781Z |
5491067 | 5491067 | 20241106014919_rUS3S | BG0009 | 2024-11-07T14:15:16.940Z | 2024-11-09T14:20:03.752Z |
5490956 | 5490956 | 20241106012256_f9Rwd | BG0009 | 2024-11-07T14:15:08.034Z | 2024-11-09T14:20:02.343Z |
5490674 | 5490674 | 20241106000352_l9Qpz | BG0009 | 2024-11-07T14:14:28.488Z | 2024-11-09T14:19:57.869Z |
5490284 | 5490284 | 20241105220232_w3w7M | BG0009 | 2024-11-07T14:13:48.894Z | 2024-11-09T14:19:53.426Z |
5490277 | 5490277 | 20241105215937_7IjZz | BG0009 | 2024-11-07T14:13:48.105Z | 2024-11-09T14:19:53.380Z |
5490147 | 5490147 | 20241105212300_RykqL | BG0009 | 2024-11-07T14:13:20.319Z | 2024-11-09T14:19:51.348Z |
5490050 | 5490050 | 20241105204834_0V2CB | BG0009 | 2024-11-07T14:13:06.538Z | 2024-11-09T14:19:50.334Z |
5489956 | 5489956 | 20241105203346_yp7Y3 | BG0009 | 2024-11-07T14:12:57.802Z | 2024-11-09T14:19:49.502Z |
5489888 | 5489888 | 20241105202424_tyGff | BG0009 | 2024-11-07T14:12:53.145Z | 2024-11-09T14:19:48.709Z |
5489810 | 5489810 | 20241105200819_jK9UF | BG0009 | 2024-11-07T14:12:47.169Z | 2024-11-09T14:19:46.876Z |
5489721 | 5489721 | 20241105195114_oUyhM | BG0009 | 2024-11-07T14:12:41.250Z | 2024-11-09T14:19:46.248Z |
5489675 | 5489675 | 20241105193828_eZTev | BG0009 | 2024-11-07T14:12:32.115Z | 2024-11-09T14:19:45.858Z |
5484381 | 5484381 | 20241105024128_PocmN | BG0009 | 2024-11-06T14:16:51.672Z | 2024-11-09T14:21:13.667Z |
5484374 | 5484374 | 20241105024119_ZkzVq | BG0009 | 2024-11-06T14:16:51.369Z | 2024-11-09T14:21:13.641Z |
5484188 | 5484188 | 20241105021900_3Mq2X | BG0009 | 2024-11-06T14:16:29.745Z | 2024-11-09T14:21:11.737Z |
5483931 | 5483931 | 20241105014615_snNKS | BG0009 | 2024-11-06T14:15:54.759Z | 2024-11-09T14:21:09.524Z |
5483548 | 5483548 | 20241105005614_Fezxz | BG0009 | 2024-11-06T14:15:28.142Z | 2024-11-09T14:21:05.880Z |
5483400 | 5483400 | 20241105003541_tWGE4 | BG0009 | 2024-11-06T14:15:12.120Z | 2024-11-09T14:21:05.215Z |
5483184 | 5483184 | 20241105000755_khYPK | BG0009 | 2024-11-06T14:14:44.944Z | 2024-11-09T14:21:03.987Z |
5483095 | 5483095 | 20241104235800_WfIv6 | BG0009 | 2024-11-06T14:14:39.698Z | 2024-11-09T14:21:03.432Z |
5482880 | 5482880 | 20241104232918_QMYdl | BG0009 | 2024-11-06T14:14:14.759Z | 2024-11-09T14:21:02.134Z |
5482726 | 5482726 | 20241104230850_ZCTHC | BG0009 | 2024-11-06T14:13:43.982Z | 2024-11-09T14:21:01.251Z |
5482535 | 5482535 | 20241104223652_UyIa3 | BG0009 | 2024-11-06T14:13:19.322Z | 2024-11-09T14:21:00.044Z |
5482361 | 5482361 | 20241104215624_IlJ36 | BG0009 | 2024-11-06T14:13:04.950Z | 2024-11-09T14:20:58.517Z |
5482197 | 5482197 | 20241104212419_831ug | BG0009 | 2024-11-06T14:12:35.017Z | 2024-11-09T14:20:56.387Z |
5481985 | 5481985 | 20241104203741_0aENd | BG0009 | 2024-11-06T14:12:12.871Z | 2024-11-09T14:20:53.758Z |
5481883 | 5481883 | 20241104201009_uxqEY | BG0009 | 2024-11-06T14:11:47.081Z | 2024-11-09T14:20:52.235Z |
5481699 | 5481699 | 20241104191804_M6jc2 | BG0009 | 2024-11-06T14:11:25.660Z | 2024-11-09T14:20:49.687Z |
5481683 | 5481683 | 20241104191610_ytsSP | BG0009 | 2024-11-06T14:11:21.386Z | 2024-11-09T14:20:49.449Z |
5481383 | 5481383 | 20241104172350_lBh2F | BG0009 | 2024-11-06T14:10:22.823Z | 2024-11-09T14:20:44.965Z |
5478283 | 5478283 | 20241104034600_MkqqQ | BG0009 | 2024-11-05T14:18:09.255Z | 2024-11-09T14:22:26.618Z |
5477689 | 5477689 | 20241104022142_NwUik | BG0009 | 2024-11-05T14:17:15.496Z | 2024-11-09T14:22:20.933Z |
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);