participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,144 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 |
---|---|---|---|---|---|
5565315 | 5565315 | 20241120041857_Nmtz0 | BG000K | 2024-11-21T14:18:46.391Z | 2024-11-21T14:18:54.192Z |
5565094 | 5565094 | 20241120035139_lsOzb | BG000K | 2024-11-21T14:18:29.227Z | 2024-11-21T14:18:54.153Z |
5564971 | 5564971 | 20241120034320_JrZ2i | BG000K | 2024-11-21T14:18:17.022Z | 2024-11-21T14:18:54.132Z |
5557172 | 5557172 | 20241119041926_SkUh2 | BG000K | 2024-11-20T14:12:24.631Z | 2024-11-21T14:20:48.804Z |
5557157 | 5557157 | 20241119041214_3OmW2 | BG000K | 2024-11-20T14:12:22.948Z | 2024-11-21T14:20:48.536Z |
5557035 | 5557035 | 20241119033005_p5eUP | BG000K | 2024-11-20T14:12:03.010Z | 2024-11-21T14:20:44.151Z |
5557015 | 5557015 | 20241119032309_CSmWN | BG000K | 2024-11-20T14:12:00.111Z | 2024-11-21T14:20:43.250Z |
5556984 | 5556984 | 20241119031604_XaPfO | BG000K | 2024-11-20T14:11:54.173Z | 2024-11-21T14:20:42.481Z |
5556960 | 5556960 | 20241119030735_tBE2d | BG000K | 2024-11-20T14:11:50.276Z | 2024-11-21T14:20:42.194Z |
5556909 | 5556909 | 20241119024552_6ZHC1 | BG000K | 2024-11-20T14:11:40.734Z | 2024-11-21T14:20:39.457Z |
5556888 | 5556888 | 20241119023639_s4pcV | BG000K | 2024-11-20T14:11:37.180Z | 2024-11-21T14:20:38.863Z |
5556883 | 5556883 | 20241119023155_DFy2Q | BG000K | 2024-11-20T14:11:37.070Z | 2024-11-21T14:20:38.844Z |
5556686 | 5556686 | 20241119010532_Y0g57 | BG000K | 2024-11-20T14:11:18.079Z | 2024-11-21T14:20:32.656Z |
5556669 | 5556669 | 20241119005532_LYNtR | BG000K | 2024-11-20T14:11:08.869Z | 2024-11-21T14:20:32.194Z |
5556644 | 5556644 | 20241119003646_dMhax | BG000K | 2024-11-20T14:11:02.917Z | 2024-11-21T14:20:30.761Z |
5556642 | 5556642 | 20241119003620_NpaYZ | BG000K | 2024-11-20T14:11:02.328Z | 2024-11-21T14:20:30.689Z |
5556637 | 5556637 | 20241119003257_SLqNA | BG000K | 2024-11-20T14:11:00.983Z | 2024-11-21T14:20:30.318Z |
5556633 | 5556633 | 20241119003134_NIMP8 | BG000K | 2024-11-20T14:10:59.066Z | 2024-11-21T14:20:30.177Z |
5556553 | 5556553 | 20241118232144_OgOzK | BG000K | 2024-11-20T14:10:42.476Z | 2024-11-21T14:20:27.431Z |
5556541 | 5556541 | 20241118231722_RIAFZ | BG000K | 2024-11-20T14:10:41.906Z | 2024-11-21T14:20:27.390Z |
5556528 | 5556528 | 20241118225723_vj1P2 | BG000K | 2024-11-20T14:10:40.610Z | 2024-11-21T14:20:27.128Z |
5556514 | 5556514 | 20241118224614_dyILA | BG000K | 2024-11-20T14:10:39.070Z | 2024-11-21T14:20:26.692Z |
5556510 | 5556510 | 20241118224549_mF5pN | BG000K | 2024-11-20T14:10:38.699Z | 2024-11-21T14:20:26.595Z |
5556485 | 5556485 | 20241118221815_CCcfW | BG000K | 2024-11-20T14:10:36.258Z | 2024-11-21T14:20:25.997Z |
5556463 | 5556463 | 20241118215753_nLskY | BG000K | 2024-11-20T14:10:33.329Z | 2024-11-21T14:20:25.243Z |
5556459 | 5556459 | 20241118215647_23bDf | BG000K | 2024-11-20T14:10:33.060Z | 2024-11-21T14:20:25.038Z |
5556435 | 5556435 | 20241118213004_c0co8 | BG000K | 2024-11-20T14:10:30.202Z | 2024-11-21T14:20:24.152Z |
5556398 | 5556398 | 20241118205757_oJxAa | BG000K | 2024-11-20T14:10:24.764Z | 2024-11-21T14:20:23.014Z |
5556384 | 5556384 | 20241118202647_YAfqu | BG000K | 2024-11-20T14:10:20.004Z | 2024-11-21T14:20:20.678Z |
5556375 | 5556375 | 20241118202007_OxqDj | BG000K | 2024-11-20T14:10:15.730Z | 2024-11-21T14:20:20.308Z |
5556360 | 5556360 | 20241118195003_qSUrZ | BG000K | 2024-11-20T14:10:04.445Z | 2024-11-21T14:20:19.263Z |
5556357 | 5556357 | 20241118194003_IewT9 | BG000K | 2024-11-20T14:10:03.376Z | 2024-11-21T14:20:19.115Z |
5556328 | 5556328 | 20241118185117_3t9D2 | BG000K | 2024-11-20T14:09:56.699Z | 2024-11-21T14:20:17.066Z |
5556318 | 5556318 | 20241118183045_H6gRz | BG000K | 2024-11-20T14:09:53.153Z | 2024-11-21T14:20:16.323Z |
5556298 | 5556298 | 20241118181208_AtVKP | BG000K | 2024-11-20T14:09:49.189Z | 2024-11-21T14:20:15.336Z |
5556290 | 5556290 | 20241118174904_jbL60 | BG000K | 2024-11-20T14:09:47.419Z | 2024-11-21T14:20:13.898Z |
5556268 | 5556268 | 20241118172013_XsMqe | BG000K | 2024-11-20T14:09:42.438Z | 2024-11-21T14:20:11.551Z |
5556259 | 5556259 | 20241118171031_mKOwB | BG000K | 2024-11-20T14:09:40.795Z | 2024-11-21T14:20:10.920Z |
5556257 | 5556257 | 20241118170557_y3naR | BG000K | 2024-11-20T14:09:40.190Z | 2024-11-21T14:20:10.163Z |
5553782 | 5553782 | 20241118041552_lrUmw | BG000K | 2024-11-19T14:11:26.360Z | 2024-11-21T14:22:21.164Z |
5553778 | 5553778 | 20241118041440_ajNoA | BG000K | 2024-11-19T14:11:25.977Z | 2024-11-21T14:22:21.111Z |
5553742 | 5553742 | 20241118040858_3KdP3 | BG000K | 2024-11-19T14:11:24.416Z | 2024-11-21T14:22:20.747Z |
5553724 | 5553724 | 20241118035859_iQTsI | BG000K | 2024-11-19T14:11:21.015Z | 2024-11-21T14:22:20.507Z |
5553720 | 5553720 | 20241118035829_jpb5X | BG000K | 2024-11-19T14:11:20.787Z | 2024-11-21T14:22:20.494Z |
5553706 | 5553706 | 20241118035416_WiGOA | BG000K | 2024-11-19T14:11:18.433Z | 2024-11-21T14:22:20.231Z |
5553609 | 5553609 | 20241118033122_KImyt | BG000K | 2024-11-19T14:11:04.212Z | 2024-11-21T14:22:17.873Z |
5553587 | 5553587 | 20241118032758_vOA2L | BG000K | 2024-11-19T14:10:58.771Z | 2024-11-21T14:22:17.149Z |
5553571 | 5553571 | 20241118032139_tjVp6 | BG000K | 2024-11-19T14:10:55.445Z | 2024-11-21T14:22:16.891Z |
5553545 | 5553545 | 20241118031448_dwksT | BG000K | 2024-11-19T14:10:49.070Z | 2024-11-21T14:22:16.550Z |
5553481 | 5553481 | 20241118025357_bqOPi | BG000K | 2024-11-19T14:10:40.878Z | 2024-11-21T14:22:15.551Z |
5553404 | 5553404 | 20241118022138_Uiv51 | BG000K | 2024-11-19T14:10:28.880Z | 2024-11-21T14:22:13.557Z |
5553368 | 5553368 | 20241118021457_G6Ruz | BG000K | 2024-11-19T14:10:23.868Z | 2024-11-21T14:22:12.724Z |
5553319 | 5553319 | 20241118020315_VfOdm | BG000K | 2024-11-19T14:10:17.756Z | 2024-11-21T14:22:11.609Z |
5553300 | 5553300 | 20241118020042_D3wLW | BG000K | 2024-11-19T14:10:15.660Z | 2024-11-21T14:22:11.032Z |
5553298 | 5553298 | 20241118020007_tN2N1 | BG000K | 2024-11-19T14:10:15.460Z | 2024-11-21T14:22:11.031Z |
5553281 | 5553281 | 20241118015545_TB5s0 | BG000K | 2024-11-19T14:10:14.743Z | 2024-11-21T14:22:10.839Z |
5553262 | 5553262 | 20241118015227_9MjqJ | BG000K | 2024-11-19T14:10:13.172Z | 2024-11-21T14:22:09.852Z |
5553249 | 5553249 | 20241118014930_b1N2J | BG000K | 2024-11-19T14:10:12.418Z | 2024-11-21T14:22:09.639Z |
5553167 | 5553167 | 20241118011201_njNcb | BG000K | 2024-11-19T14:10:07.331Z | 2024-11-21T14:22:08.199Z |
5553161 | 5553161 | 20241118011042_3VZDh | BG000K | 2024-11-19T14:10:07.089Z | 2024-11-21T14:22:08.191Z |
5553124 | 5553124 | 20241118005422_VsRpy | BG000K | 2024-11-19T14:10:04.689Z | 2024-11-21T14:22:07.655Z |
5553105 | 5553105 | 20241118004406_3M93Z | BG000K | 2024-11-19T14:10:03.617Z | 2024-11-21T14:22:07.305Z |
5553088 | 5553088 | 20241118003920_DTsAz | BG000K | 2024-11-19T14:10:02.225Z | 2024-11-21T14:22:06.885Z |
5553076 | 5553076 | 20241118003807_DlENO | BG000K | 2024-11-19T14:10:01.531Z | 2024-11-21T14:22:06.651Z |
5553060 | 5553060 | 20241118003503_cM0sq | BG000K | 2024-11-19T14:10:00.511Z | 2024-11-21T14:22:06.441Z |
5553054 | 5553054 | 20241118003331_f2hdt | BG000K | 2024-11-19T14:09:59.744Z | 2024-11-21T14:22:06.336Z |
5553044 | 5553044 | 20241118002841_8TuAd | BG000K | 2024-11-19T14:09:58.891Z | 2024-11-21T14:22:06.265Z |
5553040 | 5553040 | 20241118002600_6siit | BG000K | 2024-11-19T14:09:58.516Z | 2024-11-21T14:22:06.208Z |
5552992 | 5552992 | 20241117235538_unleR | BG000K | 2024-11-19T14:09:55.140Z | 2024-11-21T14:22:05.411Z |
5552982 | 5552982 | 20241117235357_D3kIN | BG000K | 2024-11-19T14:09:54.686Z | 2024-11-21T14:22:05.376Z |
5552957 | 5552957 | 20241117234058_7tOd9 | BG000K | 2024-11-19T14:09:53.204Z | 2024-11-21T14:22:05.052Z |
5552949 | 5552949 | 20241117233810_MflSP | BG000K | 2024-11-19T14:09:52.569Z | 2024-11-21T14:22:04.921Z |
5552899 | 5552899 | 20241117231119_O3Lkx | BG000K | 2024-11-19T14:09:40.009Z | 2024-11-21T14:22:03.590Z |
5552892 | 5552892 | 20241117230855_N2DQ9 | BG000K | 2024-11-19T14:09:37.614Z | 2024-11-21T14:22:03.464Z |
5552869 | 5552869 | 20241117225254_8md3u | BG000K | 2024-11-19T14:09:30.305Z | 2024-11-21T14:22:02.755Z |
5552848 | 5552848 | 20241117223756_ZxmJp | BG000K | 2024-11-19T14:09:25.413Z | 2024-11-21T14:22:01.695Z |
5552797 | 5552797 | 20241117215814_n62xH | BG000K | 2024-11-19T14:09:14.920Z | 2024-11-21T14:22:00.623Z |
5552772 | 5552772 | 20241117212042_Spf37 | BG000K | 2024-11-19T14:09:09.642Z | 2024-11-21T14:21:59.866Z |
5552653 | 5552653 | 20241117195028_EsCGy | BG000K | 2024-11-19T14:08:51.282Z | 2024-11-21T14:21:53.361Z |
5552634 | 5552634 | 20241117193930_yH5kX | BG000K | 2024-11-19T14:08:48.905Z | 2024-11-21T14:21:51.917Z |
5552603 | 5552603 | 20241117190929_QxC8n | BG000K | 2024-11-19T14:08:44.562Z | 2024-11-21T14:21:50.329Z |
5552585 | 5552585 | 20241117185910_iSTxP | BG000K | 2024-11-19T14:08:42.681Z | 2024-11-21T14:21:49.437Z |
5552560 | 5552560 | 20241117184315_vsBCf | BG000K | 2024-11-19T14:08:39.160Z | 2024-11-21T14:21:48.024Z |
5552551 | 5552551 | 20241117183753_IhOys | BG000K | 2024-11-19T14:08:38.131Z | 2024-11-21T14:21:47.774Z |
5552499 | 5552499 | 20241117174501_ordLe | BG000K | 2024-11-19T14:08:16.757Z | 2024-11-21T14:21:43.881Z |
5552478 | 5552478 | 20241117165719_4uTNG | BG000K | 2024-11-19T14:08:07.063Z | 2024-11-21T14:21:41.445Z |
5552468 | 5552468 | 20241117163609_nnUHf | BG000K | 2024-11-19T14:08:04.377Z | 2024-11-21T14:21:40.972Z |
5552460 | 5552460 | 20241117161257_DH3Tx | BG000K | 2024-11-19T14:08:03.102Z | 2024-11-21T14:21:40.624Z |
5552454 | 5552454 | 20241117161130_d2PAd | BG000K | 2024-11-19T14:08:02.769Z | 2024-11-21T14:21:40.524Z |
5549218 | 5549218 | 20241117035115_rwaxE | BG000K | 2024-11-18T14:11:18.264Z | 2024-11-21T14:23:14.064Z |
5549178 | 5549178 | 20241117033720_ZGQZB | BG000K | 2024-11-18T14:11:13.597Z | 2024-11-21T14:23:12.479Z |
5549162 | 5549162 | 20241117033441_xGCKu | BG000K | 2024-11-18T14:11:11.898Z | 2024-11-21T14:23:11.735Z |
5549037 | 5549037 | 20241117024613_PCzlW | BG000K | 2024-11-18T14:10:44.378Z | 2024-11-21T14:23:09.103Z |
5548989 | 5548989 | 20241117023514_A4s8I | BG000K | 2024-11-18T14:10:35.745Z | 2024-11-21T14:23:07.893Z |
5548974 | 5548974 | 20241117023318_4e92C | BG000K | 2024-11-18T14:10:34.287Z | 2024-11-21T14:23:07.673Z |
5548953 | 5548953 | 20241117022733_doSSb | BG000K | 2024-11-18T14:10:32.450Z | 2024-11-21T14:23:07.093Z |
5548947 | 5548947 | 20241117022557_90oHZ | BG000K | 2024-11-18T14:10:31.713Z | 2024-11-21T14:23:06.869Z |
5548928 | 5548928 | 20241117022114_aYCGk | BG000K | 2024-11-18T14:10:27.685Z | 2024-11-21T14:23:06.479Z |
5548911 | 5548911 | 20241117021253_vAvaW | BG000K | 2024-11-18T14:10:25.552Z | 2024-11-21T14:23:05.944Z |
5548890 | 5548890 | 20241117020835_Xpz3t | BG000K | 2024-11-18T14:10:23.834Z | 2024-11-21T14:23:05.753Z |
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);