participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,190 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 |
---|---|---|---|---|---|
5584093 | 5584093 | 20241117230855_3ucuB | BG0009 | 2024-11-23T14:25:27.841Z | 2024-11-24T14:25:20.551Z |
5583929 | 5583929 | 20241119041214_ns10s | BG0009 | 2024-11-23T14:25:10.478Z | 2024-11-24T14:25:06.009Z |
5583925 | 5583925 | 20241119040440_4Oqf3 | BG0009 | 2024-11-23T14:25:10.295Z | 2024-11-24T14:25:05.876Z |
5583916 | 5583916 | 20241119031646_bZpSy | BG0009 | 2024-11-23T14:25:09.574Z | 2024-11-24T14:25:05.356Z |
5580282 | 5580282 | 20241122002550_4VO18 | BG0009 | 2024-11-23T14:19:15.616Z | 2024-11-24T14:22:27.838Z |
5580268 | 5580268 | 20241122002408_R8hBT | BG0009 | 2024-11-23T14:19:14.823Z | 2024-11-24T14:22:27.791Z |
5580194 | 5580194 | 20241122001540_RAjFT | BG0009 | 2024-11-23T14:19:10.755Z | 2024-11-24T14:22:27.640Z |
5580156 | 5580156 | 20241122000750_ExrDv | BG0009 | 2024-11-23T14:19:08.064Z | 2024-11-24T14:22:27.507Z |
5579888 | 5579888 | 20241121233250_7s7f4 | BG0009 | 2024-11-23T14:18:54.876Z | 2024-11-24T14:22:26.433Z |
5579781 | 5579781 | 20241121232008_GC2r3 | BG0009 | 2024-11-23T14:18:50.868Z | 2024-11-24T14:22:26.136Z |
5579257 | 5579257 | 20241121221515_OxUdZ | BG0009 | 2024-11-23T14:18:05.556Z | 2024-11-24T14:22:24.222Z |
5579144 | 5579144 | 20241121215138_tzSqU | BG0009 | 2024-11-23T14:17:55.162Z | 2024-11-24T14:22:23.686Z |
5578965 | 5578965 | 20241121212603_4ZlDz | BG0009 | 2024-11-23T14:17:41.734Z | 2024-11-24T14:22:23.014Z |
5578955 | 5578955 | 20241121212542_KNhz3 | BG0009 | 2024-11-23T14:17:41.383Z | 2024-11-24T14:22:22.992Z |
5578596 | 5578596 | 20241121202750_sSwAZ | BG0009 | 2024-11-23T14:17:23.911Z | 2024-11-24T14:22:21.203Z |
5578335 | 5578335 | 20241121193130_wIZtB | BG0009 | 2024-11-23T14:16:49.511Z | 2024-11-24T14:22:19.820Z |
5577469 | 5577469 | 20241121161836_26BNk | BG0009 | 2024-11-23T14:15:17.718Z | 2024-11-24T14:22:15.144Z |
5565221 | 5565221 | 20241120040535_MBi1f | BG0009 | 2024-11-21T14:18:42.675Z | 2024-11-24T14:24:46.385Z |
5565092 | 5565092 | 20241120035139_lsOzb | BG0009 | 2024-11-21T14:18:29.106Z | 2024-11-24T14:24:45.798Z |
5557146 | 5557146 | 20241119041001_fLemW | BG0009 | 2024-11-20T14:12:21.975Z | 2024-11-24T14:25:05.919Z |
5557139 | 5557139 | 20241119040842_zDsVD | BG0009 | 2024-11-20T14:12:21.189Z | 2024-11-24T14:25:05.911Z |
5557020 | 5557020 | 20241119032542_l42yA | BG0009 | 2024-11-20T14:12:00.800Z | 2024-11-24T14:25:05.412Z |
5556788 | 5556788 | 20241119014958_qwf39 | BG0009 | 2024-11-20T14:11:28.335Z | 2024-11-24T14:25:03.921Z |
5556776 | 5556776 | 20241119014833_5PvQf | BG0009 | 2024-11-20T14:11:27.338Z | 2024-11-24T14:25:03.903Z |
5556742 | 5556742 | 20241119013637_2qh8j | BG0009 | 2024-11-20T14:11:24.595Z | 2024-11-24T14:25:03.851Z |
5556579 | 5556579 | 20241118234256_mHLtF | BG0009 | 2024-11-20T14:10:47.024Z | 2024-11-24T14:25:02.547Z |
5556570 | 5556570 | 20241118233920_jcy2z | BG0009 | 2024-11-20T14:10:45.812Z | 2024-11-24T14:25:02.499Z |
5556546 | 5556546 | 20241118232126_Fe4Da | BG0009 | 2024-11-20T14:10:42.164Z | 2024-11-24T14:25:02.239Z |
5556492 | 5556492 | 20241118222258_BdCAm | BG0009 | 2024-11-20T14:10:36.940Z | 2024-11-24T14:25:01.807Z |
5556486 | 5556486 | 20241118221824_sqF1q | BG0009 | 2024-11-20T14:10:36.495Z | 2024-11-24T14:25:01.798Z |
5553721 | 5553721 | 20241118035859_iQTsI | BG0009 | 2024-11-19T14:11:21.015Z | 2024-11-24T14:25:22.960Z |
5553584 | 5553584 | 20241118032758_vOA2L | BG0009 | 2024-11-19T14:10:58.771Z | 2024-11-24T14:25:22.468Z |
5553566 | 5553566 | 20241118032104_E4i9T | BG0009 | 2024-11-19T14:10:53.410Z | 2024-11-24T14:25:22.440Z |
5553530 | 5553530 | 20241118030923_pMBN8 | BG0009 | 2024-11-19T14:10:46.970Z | 2024-11-24T14:25:22.325Z |
5553518 | 5553518 | 20241118030538_ht5q9 | BG0009 | 2024-11-19T14:10:45.493Z | 2024-11-24T14:25:22.321Z |
5553514 | 5553514 | 20241118030507_53Rqx | BG0009 | 2024-11-19T14:10:45.154Z | 2024-11-24T14:25:22.320Z |
5553372 | 5553372 | 20241118021531_G53Uc | BG0009 | 2024-11-19T14:10:24.584Z | 2024-11-24T14:25:21.802Z |
5553320 | 5553320 | 20241118020354_WB90o | BG0009 | 2024-11-19T14:10:18.287Z | 2024-11-24T14:25:21.759Z |
5553301 | 5553301 | 20241118020104_Bws6B | BG0009 | 2024-11-19T14:10:15.890Z | 2024-11-24T14:25:21.726Z |
5553263 | 5553263 | 20241118015338_ywS0i | BG0009 | 2024-11-19T14:10:13.406Z | 2024-11-24T14:25:21.680Z |
5553257 | 5553257 | 20241118015156_zSbIg | BG0009 | 2024-11-19T14:10:12.940Z | 2024-11-24T14:25:21.668Z |
5553240 | 5553240 | 20241118014639_ZSD3U | BG0009 | 2024-11-19T14:10:11.944Z | 2024-11-24T14:25:21.650Z |
5553214 | 5553214 | 20241118013922_23OwE | BG0009 | 2024-11-19T14:10:10.024Z | 2024-11-24T14:25:21.475Z |
5553136 | 5553136 | 20241118005914_aDiI2 | BG0009 | 2024-11-19T14:10:05.598Z | 2024-11-24T14:25:21.306Z |
5553121 | 5553121 | 20241118005328_jjLa8 | BG0009 | 2024-11-19T14:10:04.578Z | 2024-11-24T14:25:21.291Z |
5553057 | 5553057 | 20241118003503_cM0sq | BG0009 | 2024-11-19T14:10:00.511Z | 2024-11-24T14:25:20.961Z |
5552936 | 5552936 | 20241117233157_z6QPE | BG0009 | 2024-11-19T14:09:51.602Z | 2024-11-24T14:25:20.671Z |
5549277 | 5549277 | 20241117040752_829fV | BG0009 | 2024-11-18T14:11:24.596Z | 2024-11-24T14:25:35.698Z |
5549273 | 5549273 | 20241117040751_E6k9p | BG0009 | 2024-11-18T14:11:24.343Z | 2024-11-24T14:25:35.697Z |
5549266 | 5549266 | 20241117040447_OrYEZ | BG0009 | 2024-11-18T14:11:23.459Z | 2024-11-24T14:25:35.683Z |
5549216 | 5549216 | 20241117035038_sXCD5 | BG0009 | 2024-11-18T14:11:17.927Z | 2024-11-24T14:25:35.548Z |
5549096 | 5549096 | 20241117030649_OON5B | BG0009 | 2024-11-18T14:10:54.626Z | 2024-11-24T14:25:35.026Z |
5549052 | 5549052 | 20241117025226_WEigw | BG0009 | 2024-11-18T14:10:47.038Z | 2024-11-24T14:25:34.873Z |
5549018 | 5549018 | 20241117024428_jnCyD | BG0009 | 2024-11-18T14:10:40.274Z | 2024-11-24T14:25:34.757Z |
5549012 | 5549012 | 20241117024355_dL7v2 | BG0009 | 2024-11-18T14:10:38.831Z | 2024-11-24T14:25:34.754Z |
5548788 | 5548788 | 20241117014111_Oxr5i | BG0009 | 2024-11-18T14:10:12.923Z | 2024-11-24T14:25:33.515Z |
5548777 | 5548777 | 20241117013909_FAfvg | BG0009 | 2024-11-18T14:10:12.142Z | 2024-11-24T14:25:33.486Z |
5548727 | 5548727 | 20241117012224_am9yw | BG0009 | 2024-11-18T14:10:06.945Z | 2024-11-24T14:25:33.225Z |
5548619 | 5548619 | 20241117003839_RlQHv | BG0009 | 2024-11-18T14:09:36.610Z | 2024-11-24T14:25:32.493Z |
5548530 | 5548530 | 20241117000957_1iRzl | BG0009 | 2024-11-18T14:09:25.010Z | 2024-11-24T14:25:32.064Z |
5548515 | 5548515 | 20241117000653_4vGUb | BG0009 | 2024-11-18T14:09:23.301Z | 2024-11-24T14:25:32.009Z |
5548406 | 5548406 | 20241116231317_Vn9Hl | BG0009 | 2024-11-18T14:09:09.374Z | 2024-11-24T14:25:31.510Z |
5548366 | 5548366 | 20241116225049_2HtHo | BG0009 | 2024-11-18T14:08:58.859Z | 2024-11-24T14:25:31.389Z |
5548338 | 5548338 | 20241116223730_589Mu | BG0009 | 2024-11-18T14:08:48.952Z | 2024-11-24T14:25:31.186Z |
5548309 | 5548309 | 20241116222141_xBn8Y | BG0009 | 2024-11-18T14:08:43.140Z | 2024-11-24T14:25:30.782Z |
5524376 | 5524376 | 20241111040306_2sA8C | BG0009 | 2024-11-12T14:17:11.273Z | 2024-11-19T14:22:20.793Z |
5521788 | 5521788 | 20241110181539_F0jtk | BG0009 | 2024-11-12T14:11:58.870Z | 2024-11-19T14:21:54.936Z |
5515066 | 5515066 | 20241109191313_rO5ix | BG0009 | 2024-11-11T14:09:58.646Z | 2024-11-18T14:26:24.087Z |
5515024 | 5515024 | 20241109190416_zmY1E | BG0009 | 2024-11-11T14:09:54.888Z | 2024-11-18T14:26:23.880Z |
5505053 | 5505053 | 20241108034622_ULOxf | BG0009 | 2024-11-09T14:15:39.996Z | 2024-11-16T14:28:25.939Z |
5505044 | 5505044 | 20241108034446_yvE7m | BG0009 | 2024-11-09T14:15:38.708Z | 2024-11-16T14:28:25.851Z |
5505026 | 5505026 | 20241108033629_3tyDQ | BG0009 | 2024-11-09T14:15:36.961Z | 2024-11-16T14:28:25.796Z |
5504885 | 5504885 | 20241108031215_uH9by | BG0009 | 2024-11-09T14:15:19.733Z | 2024-11-16T14:28:24.390Z |
5504883 | 5504883 | 20241108031215_BwNr8 | BG0009 | 2024-11-09T14:15:19.632Z | 2024-11-16T14:28:24.389Z |
5504803 | 5504803 | 20241108030007_DNfNA | BG0009 | 2024-11-09T14:15:12.385Z | 2024-11-16T14:28:23.586Z |
5504756 | 5504756 | 20241108025300_ewLMc | BG0009 | 2024-11-09T14:15:09.258Z | 2024-11-16T14:28:23.205Z |
5504646 | 5504646 | 20241108023245_jWR6e | BG0009 | 2024-11-09T14:15:00.545Z | 2024-11-16T14:28:21.922Z |
5504418 | 5504418 | 20241108015622_NZgQG | BG0009 | 2024-11-09T14:14:36.443Z | 2024-11-16T14:28:19.830Z |
5504175 | 5504175 | 20241108010932_wKfAH | BG0009 | 2024-11-09T14:14:11.613Z | 2024-11-16T14:28:16.769Z |
5504107 | 5504107 | 20241108005544_Ivn5o | BG0009 | 2024-11-09T14:14:05.048Z | 2024-11-16T14:28:16.074Z |
5504024 | 5504024 | 20241108004137_cfXKh | BG0009 | 2024-11-09T14:13:59.091Z | 2024-11-16T14:28:15.043Z |
5503897 | 5503897 | 20241108000634_w2ep1 | BG0009 | 2024-11-09T14:13:50.278Z | 2024-11-16T14:28:13.524Z |
5503873 | 5503873 | 20241108000420_WHuIU | BG0009 | 2024-11-09T14:13:49.058Z | 2024-11-16T14:28:13.454Z |
5503657 | 5503657 | 20241107231843_n9swq | BG0009 | 2024-11-09T14:13:29.793Z | 2024-11-16T14:28:10.709Z |
5503653 | 5503653 | 20241107231709_GB2LM | BG0009 | 2024-11-09T14:13:29.595Z | 2024-11-16T14:28:10.643Z |
5503555 | 5503555 | 20241107224935_U8zCb | BG0009 | 2024-11-09T14:13:17.771Z | 2024-11-16T14:28:08.784Z |
5503486 | 5503486 | 20241107223100_DOx3X | BG0009 | 2024-11-09T14:13:10.226Z | 2024-11-16T14:28:07.723Z |
5503277 | 5503277 | 20241107212019_8yA39 | BG0009 | 2024-11-09T14:12:43.111Z | 2024-11-16T14:28:05.655Z |
5503252 | 5503252 | 20241107211053_LpY22 | BG0009 | 2024-11-09T14:12:39.268Z | 2024-11-16T14:28:05.096Z |
5503106 | 5503106 | 20241107204215_Wxj0X | BG0009 | 2024-11-09T14:12:25.274Z | 2024-11-16T14:28:02.924Z |
5502895 | 5502895 | 20241107200853_LHlR0 | BG0009 | 2024-11-09T14:12:11.140Z | 2024-11-16T14:28:00.396Z |
5502564 | 5502564 | 20241107190806_GcA81 | BG0009 | 2024-11-09T14:11:44.935Z | 2024-11-16T14:27:57.569Z |
5502462 | 5502462 | 20241107183919_gIX9Y | BG0009 | 2024-11-09T14:11:25.019Z | 2024-11-16T14:27:56.059Z |
5502431 | 5502431 | 20241107183256_yWcR5 | BG0009 | 2024-11-09T14:11:21.523Z | 2024-11-16T14:27:55.549Z |
5502186 | 5502186 | 20241107173717_k8BG8 | BG0009 | 2024-11-09T14:11:03.065Z | 2024-11-16T14:27:51.422Z |
5502162 | 5502162 | 20241107173355_Bp3if | BG0009 | 2024-11-09T14:11:00.447Z | 2024-11-16T14:27:50.994Z |
5497485 | 5497485 | 20241107034943_fwIMD | BG0009 | 2024-11-08T14:13:52.115Z | 2024-11-15T14:25:04.379Z |
5497287 | 5497287 | 20241107031415_95eWB | BG0009 | 2024-11-08T14:13:29.995Z | 2024-11-15T14:25:02.478Z |
5497272 | 5497272 | 20241107031218_yrQbf | BG0009 | 2024-11-08T14:13:28.280Z | 2024-11-15T14:25:02.458Z |
5497126 | 5497126 | 20241107024531_Ulvma | BG0009 | 2024-11-08T14:13:12.682Z | 2024-11-15T14:25:01.879Z |
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);