participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,753 rows where station_code = "RU000L" 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 |
---|---|---|---|---|---|
1183981 | 1183981 | 20220214211710_6i2JO | RU000L | 2024-01-05T23:42:12.271Z | 2024-01-05T23:42:12.271Z |
1183240 | 1183240 | 20220214025305_A22bS | RU000L | 2024-01-05T23:42:12.058Z | 2024-01-05T23:42:12.058Z |
1183215 | 1183215 | 20220214000709_UEwN8 | RU000L | 2024-01-05T23:42:10.603Z | 2024-01-05T23:42:10.603Z |
1183209 | 1183209 | 20220213235615_BZVJB | RU000L | 2024-01-05T23:42:10.601Z | 2024-01-05T23:42:10.601Z |
1183141 | 1183141 | 20220213181133_9I72Y | RU000L | 2024-01-05T23:42:10.575Z | 2024-01-05T23:42:10.575Z |
1171624 | 1171624 | 20220208003201_vx1EX | RU000L | 2024-01-05T23:41:56.471Z | 2024-01-05T23:41:56.471Z |
1171263 | 1171263 | 20220207184050_Csc92 | RU000L | 2024-01-05T23:41:56.219Z | 2024-01-05T23:41:56.219Z |
1159616 | 1159616 | 20220203000938_xTnTm | RU000L | 2024-01-05T23:41:44.846Z | 2024-01-05T23:41:44.846Z |
1159618 | 1159618 | 20220203001107_TxnPI | RU000L | 2024-01-05T23:41:44.846Z | 2024-01-05T23:41:44.846Z |
1159465 | 1159465 | 20220202215524_4ODVj | RU000L | 2024-01-05T23:41:44.819Z | 2024-01-05T23:41:44.819Z |
1153964 | 1153964 | 20220130160210_rNOBL | RU000L | 2024-01-05T23:41:39.209Z | 2024-01-05T23:41:39.209Z |
960329 | 960329 | 20211118031239_4qrfF | RU000L | 2024-01-05T23:38:59.197Z | 2024-01-05T23:38:59.197Z |
960311 | 960311 | 20211118030009_Tlewy | RU000L | 2024-01-05T23:38:59.193Z | 2024-01-05T23:38:59.193Z |
960293 | 960293 | 20211118025110_GpIlt | RU000L | 2024-01-05T23:38:59.188Z | 2024-01-05T23:38:59.188Z |
960259 | 960259 | 20211118023023_RfK1c | RU000L | 2024-01-05T23:38:59.178Z | 2024-01-05T23:38:59.178Z |
960241 | 960241 | 20211118021752_xoreS | RU000L | 2024-01-05T23:38:59.172Z | 2024-01-05T23:38:59.172Z |
959977 | 959977 | 20211117174225_VEpeX | RU000L | 2024-01-05T23:38:59.093Z | 2024-01-05T23:38:59.093Z |
957761 | 957761 | 20211117022026_hXmMv | RU000L | 2024-01-05T23:38:56.861Z | 2024-01-05T23:38:56.861Z |
957747 | 957747 | 20211117021620_WPRDe | RU000L | 2024-01-05T23:38:56.856Z | 2024-01-05T23:38:56.856Z |
957716 | 957716 | 20211117020350_f3sJi | RU000L | 2024-01-05T23:38:56.844Z | 2024-01-05T23:38:56.844Z |
957557 | 957557 | 20211117003408_Bw8Vq | RU000L | 2024-01-05T23:38:56.787Z | 2024-01-05T23:38:56.787Z |
957550 | 957550 | 20211117002256_AB9V5 | RU000L | 2024-01-05T23:38:56.785Z | 2024-01-05T23:38:56.785Z |
957403 | 957403 | 20211116183650_ZAqed | RU000L | 2024-01-05T23:38:56.735Z | 2024-01-05T23:38:56.735Z |
957399 | 957399 | 20211116180901_ikIpx | RU000L | 2024-01-05T23:38:56.733Z | 2024-01-05T23:38:56.733Z |
957370 | 957370 | 20211116154210_0G1fK | RU000L | 2024-01-05T23:38:56.723Z | 2024-01-05T23:38:56.723Z |
895151 | 895151 | 20211030192248_xt5zp | RU000L | 2024-01-05T23:38:16.792Z | 2024-01-05T23:38:16.792Z |
886821 | 886821 | 20211029015337_NZg6J | RU000L | 2024-01-05T23:38:12.727Z | 2024-01-05T23:38:12.727Z |
886708 | 886708 | 20211029013419_W2bCH | RU000L | 2024-01-05T23:38:12.711Z | 2024-01-05T23:38:12.711Z |
885530 | 885530 | 20211028154440_rhWLg | RU000L | 2024-01-05T23:38:12.543Z | 2024-01-05T23:38:12.543Z |
882285 | 882285 | 20211028024854_kPJSK | RU000L | 2024-01-05T23:38:10.714Z | 2024-01-05T23:38:10.714Z |
882224 | 882224 | 20211028024100_v7IGs | RU000L | 2024-01-05T23:38:10.706Z | 2024-01-05T23:38:10.706Z |
882207 | 882207 | 20211028023913_BmeE5 | RU000L | 2024-01-05T23:38:10.704Z | 2024-01-05T23:38:10.704Z |
882209 | 882209 | 20211028023923_aia62 | RU000L | 2024-01-05T23:38:10.704Z | 2024-01-05T23:38:10.704Z |
882068 | 882068 | 20211028021944_XSbFx | RU000L | 2024-01-05T23:38:10.684Z | 2024-01-05T23:38:10.684Z |
881919 | 881919 | 20211028015216_ie1jj | RU000L | 2024-01-05T23:38:10.662Z | 2024-01-05T23:38:10.662Z |
881902 | 881902 | 20211028014753_sc7iz | RU000L | 2024-01-05T23:38:10.660Z | 2024-01-05T23:38:10.660Z |
881796 | 881796 | 20211028013144_LHJya | RU000L | 2024-01-05T23:38:10.645Z | 2024-01-05T23:38:10.645Z |
881770 | 881770 | 20211028012601_lR6oS | RU000L | 2024-01-05T23:38:10.641Z | 2024-01-05T23:38:10.641Z |
881774 | 881774 | 20211028012641_8DneX | RU000L | 2024-01-05T23:38:10.641Z | 2024-01-05T23:38:10.641Z |
881596 | 881596 | 20211028003818_lik3N | RU000L | 2024-01-05T23:38:10.614Z | 2024-01-05T23:38:10.614Z |
881579 | 881579 | 20211028003259_3WBB3 | RU000L | 2024-01-05T23:38:10.612Z | 2024-01-05T23:38:10.612Z |
881508 | 881508 | 20211028001332_JMAzT | RU000L | 2024-01-05T23:38:10.600Z | 2024-01-05T23:38:10.600Z |
881401 | 881401 | 20211027234700_Ym0Rx | RU000L | 2024-01-05T23:38:10.585Z | 2024-01-05T23:38:10.585Z |
881270 | 881270 | 20211027230615_ij0sE | RU000L | 2024-01-05T23:38:10.566Z | 2024-01-05T23:38:10.566Z |
881237 | 881237 | 20211027225515_aUtyi | RU000L | 2024-01-05T23:38:10.561Z | 2024-01-05T23:38:10.561Z |
881102 | 881102 | 20211027221221_THCIV | RU000L | 2024-01-05T23:38:10.542Z | 2024-01-05T23:38:10.542Z |
881058 | 881058 | 20211027220033_0ZgNM | RU000L | 2024-01-05T23:38:10.536Z | 2024-01-05T23:38:10.536Z |
881033 | 881033 | 20211027214725_5buQA | RU000L | 2024-01-05T23:38:10.532Z | 2024-01-05T23:38:10.532Z |
880951 | 880951 | 20211027210122_bXprq | RU000L | 2024-01-05T23:38:10.520Z | 2024-01-05T23:38:10.520Z |
880736 | 880736 | 20211027191502_YbTax | RU000L | 2024-01-05T23:38:10.488Z | 2024-01-05T23:38:10.488Z |
877805 | 877805 | 20211027020306_LBu50 | RU000L | 2024-01-05T23:38:08.777Z | 2024-01-05T23:38:08.777Z |
877685 | 877685 | 20211027011911_ZleZF | RU000L | 2024-01-05T23:38:08.758Z | 2024-01-05T23:38:08.758Z |
877625 | 877625 | 20211027004206_GNmQL | RU000L | 2024-01-05T23:38:08.748Z | 2024-01-05T23:38:08.748Z |
877596 | 877596 | 20211027001936_jbMZE | RU000L | 2024-01-05T23:38:08.744Z | 2024-01-05T23:38:08.744Z |
877566 | 877566 | 20211027000957_OZZPh | RU000L | 2024-01-05T23:38:08.739Z | 2024-01-05T23:38:08.739Z |
877547 | 877547 | 20211026235809_Amks3 | RU000L | 2024-01-05T23:38:08.736Z | 2024-01-05T23:38:08.736Z |
877549 | 877549 | 20211027000050_zQOTP | RU000L | 2024-01-05T23:38:08.736Z | 2024-01-05T23:38:08.736Z |
877342 | 877342 | 20211026211613_wMbGI | RU000L | 2024-01-05T23:38:08.703Z | 2024-01-05T23:38:08.703Z |
877322 | 877322 | 20211026205046_gBHxn | RU000L | 2024-01-05T23:38:08.700Z | 2024-01-05T23:38:08.700Z |
877284 | 877284 | 20211026194349_ukM56 | RU000L | 2024-01-05T23:38:08.694Z | 2024-01-05T23:38:08.694Z |
877276 | 877276 | 20211026193440_D3LxK | RU000L | 2024-01-05T23:38:08.693Z | 2024-01-05T23:38:08.693Z |
854404 | 854404 | 20211017022259_zTuax | RU000L | 2024-01-05T23:37:51.458Z | 2024-01-05T23:37:51.458Z |
854400 | 854400 | 20211017022235_Xoz3U | RU000L | 2024-01-05T23:37:51.457Z | 2024-01-05T23:37:51.457Z |
854287 | 854287 | 20211017014236_rKStX | RU000L | 2024-01-05T23:37:51.424Z | 2024-01-05T23:37:51.424Z |
854230 | 854230 | 20211017012729_uPT6k | RU000L | 2024-01-05T23:37:51.409Z | 2024-01-05T23:37:51.409Z |
854184 | 854184 | 20211017011051_xvtcG | RU000L | 2024-01-05T23:37:51.395Z | 2024-01-05T23:37:51.395Z |
854157 | 854157 | 20211017010247_ogfF9 | RU000L | 2024-01-05T23:37:51.387Z | 2024-01-05T23:37:51.387Z |
854132 | 854132 | 20211017005152_Fi1Xo | RU000L | 2024-01-05T23:37:51.379Z | 2024-01-05T23:37:51.379Z |
854090 | 854090 | 20211017001930_vB0Gs | RU000L | 2024-01-05T23:37:51.366Z | 2024-01-05T23:37:51.366Z |
854057 | 854057 | 20211016235803_mjB8A | RU000L | 2024-01-05T23:37:51.355Z | 2024-01-05T23:37:51.355Z |
854020 | 854020 | 20211016233001_fvbQB | RU000L | 2024-01-05T23:37:51.341Z | 2024-01-05T23:37:51.341Z |
850826 | 850826 | 20211016015758_NpQnZ | RU000L | 2024-01-05T23:37:48.708Z | 2024-01-05T23:37:48.708Z |
850747 | 850747 | 20211016013708_7EZq8 | RU000L | 2024-01-05T23:37:48.673Z | 2024-01-05T23:37:48.673Z |
850658 | 850658 | 20211016011848_sNZwo | RU000L | 2024-01-05T23:37:48.636Z | 2024-01-05T23:37:48.636Z |
850529 | 850529 | 20211016005251_b3Iab | RU000L | 2024-01-05T23:37:48.582Z | 2024-01-05T23:37:48.582Z |
850472 | 850472 | 20211016003710_Y9uq5 | RU000L | 2024-01-05T23:37:48.557Z | 2024-01-05T23:37:48.557Z |
850329 | 850329 | 20211016001424_90rSM | RU000L | 2024-01-05T23:37:48.496Z | 2024-01-05T23:37:48.496Z |
850237 | 850237 | 20211015235141_t9dke | RU000L | 2024-01-05T23:37:48.457Z | 2024-01-05T23:37:48.457Z |
850205 | 850205 | 20211015233921_TYlhO | RU000L | 2024-01-05T23:37:48.444Z | 2024-01-05T23:37:48.444Z |
846810 | 846810 | 20211015020541_6FonV | RU000L | 2024-01-05T23:37:45.303Z | 2024-01-05T23:37:45.303Z |
846736 | 846736 | 20211015014521_e22J2 | RU000L | 2024-01-05T23:37:45.270Z | 2024-01-05T23:37:45.270Z |
846708 | 846708 | 20211015013822_522ez | RU000L | 2024-01-05T23:37:45.258Z | 2024-01-05T23:37:45.258Z |
846699 | 846699 | 20211015013150_xF8Ca | RU000L | 2024-01-05T23:37:45.253Z | 2024-01-05T23:37:45.253Z |
846684 | 846684 | 20211015012645_6KjZS | RU000L | 2024-01-05T23:37:45.246Z | 2024-01-05T23:37:45.246Z |
846678 | 846678 | 20211015012459_2YljJ | RU000L | 2024-01-05T23:37:45.244Z | 2024-01-05T23:37:45.244Z |
846618 | 846618 | 20211015010245_Dairz | RU000L | 2024-01-05T23:37:45.218Z | 2024-01-05T23:37:45.218Z |
846561 | 846561 | 20211015004636_pcE49 | RU000L | 2024-01-05T23:37:45.191Z | 2024-01-05T23:37:45.191Z |
846557 | 846557 | 20211015004513_bjHBp | RU000L | 2024-01-05T23:37:45.189Z | 2024-01-05T23:37:45.189Z |
846372 | 846372 | 20211014233525_CPImB | RU000L | 2024-01-05T23:37:45.112Z | 2024-01-05T23:37:45.112Z |
843763 | 843763 | 20211014021746_FLQk5 | RU000L | 2024-01-05T23:37:42.675Z | 2024-01-05T23:37:42.675Z |
843651 | 843651 | 20211014015723_nKdmT | RU000L | 2024-01-05T23:37:42.645Z | 2024-01-05T23:37:42.645Z |
843087 | 843087 | 20211013232516_atj8a | RU000L | 2024-01-05T23:37:42.372Z | 2024-01-05T23:37:42.372Z |
843012 | 843012 | 20211013230254_LvzXP | RU000L | 2024-01-05T23:37:42.332Z | 2024-01-05T23:37:42.332Z |
842938 | 842938 | 20211013224154_4ucx9 | RU000L | 2024-01-05T23:37:42.290Z | 2024-01-05T23:37:42.290Z |
842902 | 842902 | 20211013222738_qqBg0 | RU000L | 2024-01-05T23:37:42.267Z | 2024-01-05T23:37:42.267Z |
836558 | 836558 | 20211011224103_D6Cjq | RU000L | 2024-01-05T23:37:36.424Z | 2024-01-05T23:37:36.424Z |
836414 | 836414 | 20211011213734_kZv26 | RU000L | 2024-01-05T23:37:36.404Z | 2024-01-05T23:37:36.404Z |
836278 | 836278 | 20211011203532_UKIYQ | RU000L | 2024-01-05T23:37:36.384Z | 2024-01-05T23:37:36.384Z |
836026 | 836026 | 20211011182401_dMg23 | RU000L | 2024-01-05T23:37:36.349Z | 2024-01-05T23:37:36.349Z |
836020 | 836020 | 20211011181438_46136 | RU000L | 2024-01-05T23:37:36.348Z | 2024-01-05T23:37:36.348Z |
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);