participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,608 rows where station_code = "BG000K" 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 |
---|---|---|---|---|---|
5467984 | 5467984 | 20241102230820_8j8Gn | BG000K | 2024-11-04T14:13:04.554Z | 2024-11-04T14:18:00.831Z |
5467876 | 5467876 | 20241102224827_Q0BC5 | BG000K | 2024-11-04T14:12:52.794Z | 2024-11-04T14:18:00.752Z |
5467756 | 5467756 | 20241102223126_to5px | BG000K | 2024-11-04T14:12:28.041Z | 2024-11-04T14:18:00.637Z |
5467626 | 5467626 | 20241102220623_ISPV3 | BG000K | 2024-11-04T14:12:15.055Z | 2024-11-04T14:18:00.570Z |
5467613 | 5467613 | 20241102220256_VNHvv | BG000K | 2024-11-04T14:12:13.883Z | 2024-11-04T14:18:00.565Z |
5467532 | 5467532 | 20241102213734_vRar5 | BG000K | 2024-11-04T14:11:54.405Z | 2024-11-04T14:18:00.524Z |
5466419 | 5466419 | 20241102173756_aVsWI | BG000K | 2024-11-04T14:08:50.340Z | 2024-11-04T14:17:59.888Z |
5466337 | 5466337 | 20241102171738_M4XMP | BG000K | 2024-11-04T14:08:38.898Z | 2024-11-04T14:17:59.838Z |
5466203 | 5466203 | 20241102164752_k97K8 | BG000K | 2024-11-04T14:08:14.315Z | 2024-11-04T14:17:59.677Z |
5466158 | 5466158 | 20241102163635_X5T58 | BG000K | 2024-11-04T14:08:07.484Z | 2024-11-04T14:17:59.647Z |
5466098 | 5466098 | 20241102161903_xi7dt | BG000K | 2024-11-04T14:08:00.770Z | 2024-11-04T14:17:59.606Z |
5464078 | 5464078 | 20241101010344_IQJDE | BG000K | 2024-11-03T14:21:44.819Z | 2024-11-04T14:23:41.117Z |
5463524 | 5463524 | 20241102035302_YKVZC | BG000K | 2024-11-03T14:18:54.811Z | 2024-11-04T14:21:19.255Z |
5463472 | 5463472 | 20241102034217_8qnYw | BG000K | 2024-11-03T14:18:48.739Z | 2024-11-04T14:21:17.915Z |
5463345 | 5463345 | 20241102032434_lKyGy | BG000K | 2024-11-03T14:18:36.751Z | 2024-11-04T14:21:15.031Z |
5463338 | 5463338 | 20241102032255_UdPrF | BG000K | 2024-11-03T14:18:36.280Z | 2024-11-04T14:21:14.884Z |
5463269 | 5463269 | 20241102030618_qha6f | BG000K | 2024-11-03T14:18:28.866Z | 2024-11-04T14:21:12.769Z |
5463263 | 5463263 | 20241102030526_2mjUX | BG000K | 2024-11-03T14:18:28.438Z | 2024-11-04T14:21:12.715Z |
5463153 | 5463153 | 20241102024437_iK6jy | BG000K | 2024-11-03T14:18:23.957Z | 2024-11-04T14:21:08.931Z |
5463123 | 5463123 | 20241102023732_PaDaz | BG000K | 2024-11-03T14:18:20.380Z | 2024-11-04T14:21:07.830Z |
5463088 | 5463088 | 20241102023311_3f9Cr | BG000K | 2024-11-03T14:18:17.695Z | 2024-11-04T14:21:06.829Z |
5463010 | 5463010 | 20241102021548_9Llyw | BG000K | 2024-11-03T14:18:14.297Z | 2024-11-04T14:21:04.348Z |
5463002 | 5463002 | 20241102021337_VbVWt | BG000K | 2024-11-03T14:18:13.969Z | 2024-11-04T14:21:04.170Z |
5462967 | 5462967 | 20241102020719_fr0RN | BG000K | 2024-11-03T14:18:11.930Z | 2024-11-04T14:21:03.028Z |
5462937 | 5462937 | 20241102015911_l8GJ2 | BG000K | 2024-11-03T14:18:10.525Z | 2024-11-04T14:21:02.196Z |
5462932 | 5462932 | 20241102015905_F7hzG | BG000K | 2024-11-03T14:18:10.394Z | 2024-11-04T14:21:02.146Z |
5462899 | 5462899 | 20241102015303_gVItI | BG000K | 2024-11-03T14:18:09.290Z | 2024-11-04T14:21:01.083Z |
5462877 | 5462877 | 20241102014838_JMZXF | BG000K | 2024-11-03T14:18:08.356Z | 2024-11-04T14:20:59.457Z |
5462848 | 5462848 | 20241102014511_vRlWe | BG000K | 2024-11-03T14:18:07.589Z | 2024-11-04T14:20:59.244Z |
5462791 | 5462791 | 20241102013242_g8Kr3 | BG000K | 2024-11-03T14:18:04.992Z | 2024-11-04T14:20:56.711Z |
5462759 | 5462759 | 20241102012219_ASc6K | BG000K | 2024-11-03T14:18:03.502Z | 2024-11-04T14:20:56.056Z |
5462725 | 5462725 | 20241102011902_CiAIX | BG000K | 2024-11-03T14:17:59.125Z | 2024-11-04T14:20:55.080Z |
5462705 | 5462705 | 20241102011449_yBxkA | BG000K | 2024-11-03T14:17:56.775Z | 2024-11-04T14:20:54.285Z |
5462685 | 5462685 | 20241102011020_ZbFE3 | BG000K | 2024-11-03T14:17:55.109Z | 2024-11-04T14:20:53.133Z |
5462632 | 5462632 | 20241102005759_eEBzO | BG000K | 2024-11-03T14:17:49.263Z | 2024-11-04T14:20:51.052Z |
5462620 | 5462620 | 20241102005502_Ay80v | BG000K | 2024-11-03T14:17:47.894Z | 2024-11-04T14:20:50.785Z |
5462595 | 5462595 | 20241102005022_2Uvga | BG000K | 2024-11-03T14:17:45.696Z | 2024-11-04T14:20:49.176Z |
5462592 | 5462592 | 20241102005011_69w2Y | BG000K | 2024-11-03T14:17:45.405Z | 2024-11-04T14:20:49.145Z |
5462530 | 5462530 | 20241102004144_qY5Jr | BG000K | 2024-11-03T14:17:36.791Z | 2024-11-04T14:20:47.436Z |
5462522 | 5462522 | 20241102004035_CTSDm | BG000K | 2024-11-03T14:17:36.097Z | 2024-11-04T14:20:47.256Z |
5462480 | 5462480 | 20241102002705_At2rt | BG000K | 2024-11-03T14:17:29.139Z | 2024-11-04T14:20:45.874Z |
5462472 | 5462472 | 20241102002638_uB0wu | BG000K | 2024-11-03T14:17:28.695Z | 2024-11-04T14:20:45.730Z |
5462406 | 5462406 | 20241102001156_s7yma | BG000K | 2024-11-03T14:17:23.984Z | 2024-11-04T14:20:44.119Z |
5462379 | 5462379 | 20241102000532_ZRxPH | BG000K | 2024-11-03T14:17:20.855Z | 2024-11-04T14:20:43.470Z |
5462352 | 5462352 | 20241101235605_HWnvP | BG000K | 2024-11-03T14:17:18.250Z | 2024-11-04T14:20:42.390Z |
5462315 | 5462315 | 20241101234444_IokhY | BG000K | 2024-11-03T14:17:14.104Z | 2024-11-04T14:20:40.963Z |
5462221 | 5462221 | 20241101232755_NxuCd | BG000K | 2024-11-03T14:17:04.454Z | 2024-11-04T14:20:38.381Z |
5462154 | 5462154 | 20241101231137_begND | BG000K | 2024-11-03T14:17:00.384Z | 2024-11-04T14:20:36.710Z |
5462130 | 5462130 | 20241101230705_7ciR3 | BG000K | 2024-11-03T14:16:58.424Z | 2024-11-04T14:20:35.736Z |
5462110 | 5462110 | 20241101230441_lZjvh | BG000K | 2024-11-03T14:16:57.247Z | 2024-11-04T14:20:34.955Z |
5462095 | 5462095 | 20241101225943_MthLE | BG000K | 2024-11-03T14:16:56.718Z | 2024-11-04T14:20:34.451Z |
5462086 | 5462086 | 20241101225824_zqACl | BG000K | 2024-11-03T14:16:56.465Z | 2024-11-04T14:20:34.053Z |
5462053 | 5462053 | 20241101225036_KIH27 | BG000K | 2024-11-03T14:16:54.748Z | 2024-11-04T14:20:33.339Z |
5462048 | 5462048 | 20241101225014_hXv2t | BG000K | 2024-11-03T14:16:54.644Z | 2024-11-04T14:20:33.286Z |
5462035 | 5462035 | 20241101224748_9L2JP | BG000K | 2024-11-03T14:16:53.962Z | 2024-11-04T14:20:33.103Z |
5462020 | 5462020 | 20241101224551_ueiT5 | BG000K | 2024-11-03T14:16:53.035Z | 2024-11-04T14:20:32.749Z |
5462016 | 5462016 | 20241101224328_hYdVS | BG000K | 2024-11-03T14:16:52.804Z | 2024-11-04T14:20:32.633Z |
5461927 | 5461927 | 20241101221617_HehnX | BG000K | 2024-11-03T14:16:46.635Z | 2024-11-04T14:20:29.457Z |
5461875 | 5461875 | 20241101215525_Rlwev | BG000K | 2024-11-03T14:16:30.978Z | 2024-11-04T14:20:27.125Z |
5461871 | 5461871 | 20241101215456_NyZTR | BG000K | 2024-11-03T14:16:30.078Z | 2024-11-04T14:20:27.046Z |
5461860 | 5461860 | 20241101215201_Ji8XL | BG000K | 2024-11-03T14:16:28.037Z | 2024-11-04T14:20:26.768Z |
5461856 | 5461856 | 20241101214924_kuhzu | BG000K | 2024-11-03T14:16:27.768Z | 2024-11-04T14:20:26.752Z |
5461844 | 5461844 | 20241101214625_Pf225 | BG000K | 2024-11-03T14:16:26.013Z | 2024-11-04T14:20:26.616Z |
5461811 | 5461811 | 20241101213435_NmMpj | BG000K | 2024-11-03T14:16:20.246Z | 2024-11-04T14:20:24.361Z |
5461790 | 5461790 | 20241101212710_sl3bq | BG000K | 2024-11-03T14:16:16.473Z | 2024-11-04T14:20:23.396Z |
5461784 | 5461784 | 20241101212340_FgMlE | BG000K | 2024-11-03T14:16:16.029Z | 2024-11-04T14:20:23.333Z |
5461767 | 5461767 | 20241101212034_Zffr1 | BG000K | 2024-11-03T14:16:13.764Z | 2024-11-04T14:20:22.914Z |
5461687 | 5461687 | 20241101204916_XrKkP | BG000K | 2024-11-03T14:16:04.016Z | 2024-11-04T14:20:19.585Z |
5461679 | 5461679 | 20241101204824_d45L1 | BG000K | 2024-11-03T14:16:03.640Z | 2024-11-04T14:20:19.183Z |
5461653 | 5461653 | 20241101204213_m4cqB | BG000K | 2024-11-03T14:16:02.011Z | 2024-11-04T14:20:17.750Z |
5461638 | 5461638 | 20241101203603_3ux9r | BG000K | 2024-11-03T14:16:00.305Z | 2024-11-04T14:20:16.522Z |
5461549 | 5461549 | 20241101195239_Onrp8 | BG000K | 2024-11-03T14:15:54.586Z | 2024-11-04T14:20:14.121Z |
5461478 | 5461478 | 20241101191145_lJtMy | BG000K | 2024-11-03T14:15:48.592Z | 2024-11-04T14:20:11.048Z |
5461474 | 5461474 | 20241101191131_JzyKC | BG000K | 2024-11-03T14:15:48.392Z | 2024-11-04T14:20:11.001Z |
5461429 | 5461429 | 20241101185548_SpvrU | BG000K | 2024-11-03T14:15:41.595Z | 2024-11-04T14:20:08.403Z |
5461378 | 5461378 | 20241101183415_UwK5c | BG000K | 2024-11-03T14:15:24.732Z | 2024-11-04T14:20:05.462Z |
5461340 | 5461340 | 20241101180549_obQOL | BG000K | 2024-11-03T14:15:12.819Z | 2024-11-04T14:20:03.647Z |
5461278 | 5461278 | 20241101173005_cM7rS | BG000K | 2024-11-03T14:15:00.220Z | 2024-11-04T14:20:01.451Z |
5461247 | 5461247 | 20241101171907_GF1wm | BG000K | 2024-11-03T14:14:57.166Z | 2024-11-04T14:20:00.385Z |
5461239 | 5461239 | 20241101171103_8xg82 | BG000K | 2024-11-03T14:14:56.165Z | 2024-11-04T14:19:59.564Z |
5461215 | 5461215 | 20241101170151_xwHce | BG000K | 2024-11-03T14:14:52.719Z | 2024-11-04T14:19:58.571Z |
5454080 | 5454080 | 20241031034019_nXvi5 | BG000K | 2024-11-02T12:22:50.215Z | 2024-11-04T14:25:25.740Z |
5453888 | 5453888 | 20241031031241_5ia22 | BG000K | 2024-11-02T12:22:44.319Z | 2024-11-04T14:25:23.552Z |
5453870 | 5453870 | 20241031031048_3W3T4 | BG000K | 2024-11-02T12:22:43.973Z | 2024-11-04T14:25:23.360Z |
5453844 | 5453844 | 20241031030907_3dQmZ | BG000K | 2024-11-02T12:22:43.645Z | 2024-11-04T14:25:23.251Z |
5453802 | 5453802 | 20241031030149_I3cmi | BG000K | 2024-11-02T12:22:42.816Z | 2024-11-04T14:25:22.508Z |
5453676 | 5453676 | 20241031024147_RQ7K7 | BG000K | 2024-11-02T12:22:40.162Z | 2024-11-04T14:25:21.065Z |
5453627 | 5453627 | 20241031023502_cZE4A | BG000K | 2024-11-02T12:22:37.566Z | 2024-11-04T14:25:19.749Z |
5453576 | 5453576 | 20241031022639_iaZQi | BG000K | 2024-11-02T12:22:36.384Z | 2024-11-04T14:25:19.217Z |
5453424 | 5453424 | 20241031021100_fd5L6 | BG000K | 2024-11-02T12:22:33.406Z | 2024-11-04T14:25:17.705Z |
5453202 | 5453202 | 20241031014943_qdBOe | BG000K | 2024-11-02T12:22:29.754Z | 2024-11-04T14:25:16.744Z |
5453180 | 5453180 | 20241031014804_jdpIb | BG000K | 2024-11-02T12:22:29.091Z | 2024-11-04T14:25:16.705Z |
5452654 | 5452654 | 20241101040110_6RiSM | BG000K | 2024-11-02T12:19:10.020Z | 2024-11-04T14:23:48.765Z |
5452527 | 5452527 | 20241101033242_9gCz6 | BG000K | 2024-11-02T12:18:56.138Z | 2024-11-04T14:23:47.541Z |
5452508 | 5452508 | 20241101032712_NTNsL | BG000K | 2024-11-02T12:18:53.727Z | 2024-11-04T14:23:47.268Z |
5452441 | 5452441 | 20241101031319_BonUA | BG000K | 2024-11-02T12:18:49.370Z | 2024-11-04T14:23:46.750Z |
5452399 | 5452399 | 20241101030603_5Cndr | BG000K | 2024-11-02T12:18:46.540Z | 2024-11-04T14:23:46.391Z |
5452342 | 5452342 | 20241101025437_526dA | BG000K | 2024-11-02T12:18:40.213Z | 2024-11-04T14:23:45.960Z |
5452273 | 5452273 | 20241101024048_Q5FCH | BG000K | 2024-11-02T12:18:33.938Z | 2024-11-04T14:23:45.229Z |
5452266 | 5452266 | 20241101024012_MsOal | BG000K | 2024-11-02T12:18:32.658Z | 2024-11-04T14:23:45.087Z |
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);