participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
10,236 rows where station_code = "RU0002" 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 |
---|---|---|---|---|---|
2675137 | 2675137 | 20230729181103_8BMO2 | RU0002 | 2024-01-06T00:00:05.285Z | 2024-01-06T00:00:05.285Z |
2671131 | 2671131 | 20230728231340_v2VTO | RU0002 | 2024-01-06T00:00:03.467Z | 2024-01-06T00:00:03.467Z |
2245102 | 2245102 | 20230129002639_iShdz | RU0002 | 2024-01-05T23:54:48.895Z | 2024-01-05T23:54:48.895Z |
2245090 | 2245090 | 20230128234624_0cIYC | RU0002 | 2024-01-05T23:54:48.893Z | 2024-01-05T23:54:48.893Z |
2241691 | 2241691 | 20230127231158_AF9mH | RU0002 | 2024-01-05T23:54:47.148Z | 2024-01-05T23:54:47.148Z |
2241658 | 2241658 | 20230127222124_GXukB | RU0002 | 2024-01-05T23:54:47.140Z | 2024-01-05T23:54:47.140Z |
2241136 | 2241136 | 20230127175632_RpsTV | RU0002 | 2024-01-05T23:54:47.040Z | 2024-01-05T23:54:47.040Z |
2241073 | 2241073 | 20230127165742_PGY3D | RU0002 | 2024-01-05T23:54:47.023Z | 2024-01-05T23:54:47.023Z |
2240961 | 2240961 | 20230127154036_WYLo5 | RU0002 | 2024-01-05T23:54:46.995Z | 2024-01-05T23:54:46.995Z |
2234594 | 2234594 | 20230126030838_5CA7j | RU0002 | 2024-01-05T23:54:43.663Z | 2024-01-05T23:54:43.663Z |
2234528 | 2234528 | 20230126025814_yyLIz | RU0002 | 2024-01-05T23:54:43.653Z | 2024-01-05T23:54:43.653Z |
2234425 | 2234425 | 20230126023712_KpIRc | RU0002 | 2024-01-05T23:54:43.635Z | 2024-01-05T23:54:43.635Z |
2233862 | 2233862 | 20230125233745_12DBr | RU0002 | 2024-01-05T23:54:43.518Z | 2024-01-05T23:54:43.518Z |
2233814 | 2233814 | 20230125231628_53Ded | RU0002 | 2024-01-05T23:54:43.507Z | 2024-01-05T23:54:43.507Z |
2233796 | 2233796 | 20230125225714_TGsPN | RU0002 | 2024-01-05T23:54:43.501Z | 2024-01-05T23:54:43.501Z |
2233649 | 2233649 | 20230125215215_aIfCn | RU0002 | 2024-01-05T23:54:43.469Z | 2024-01-05T23:54:43.469Z |
2233614 | 2233614 | 20230125213444_Nl3wo | RU0002 | 2024-01-05T23:54:43.460Z | 2024-01-05T23:54:43.460Z |
2233519 | 2233519 | 20230125204638_z7tEI | RU0002 | 2024-01-05T23:54:43.443Z | 2024-01-05T23:54:43.443Z |
2233497 | 2233497 | 20230125202412_e049P | RU0002 | 2024-01-05T23:54:43.436Z | 2024-01-05T23:54:43.436Z |
2233297 | 2233297 | 20230125181031_AN3aT | RU0002 | 2024-01-05T23:54:43.386Z | 2024-01-05T23:54:43.386Z |
2233293 | 2233293 | 20230125181002_xCTrY | RU0002 | 2024-01-05T23:54:43.385Z | 2024-01-05T23:54:43.385Z |
2230852 | 2230852 | 20230125033916_UfHG5 | RU0002 | 2024-01-05T23:54:41.398Z | 2024-01-05T23:54:41.398Z |
2230831 | 2230831 | 20230125032517_TaPiv | RU0002 | 2024-01-05T23:54:41.392Z | 2024-01-05T23:54:41.392Z |
2230821 | 2230821 | 20230125031358_6ZdCm | RU0002 | 2024-01-05T23:54:41.389Z | 2024-01-05T23:54:41.389Z |
2230809 | 2230809 | 20230125030535_EcgpE | RU0002 | 2024-01-05T23:54:41.386Z | 2024-01-05T23:54:41.386Z |
2230779 | 2230779 | 20230125024723_CRlBR | RU0002 | 2024-01-05T23:54:41.377Z | 2024-01-05T23:54:41.377Z |
2230757 | 2230757 | 20230125023707_gpVXB | RU0002 | 2024-01-05T23:54:41.370Z | 2024-01-05T23:54:41.370Z |
2230685 | 2230685 | 20230125013134_1Vw1H | RU0002 | 2024-01-05T23:54:41.349Z | 2024-01-05T23:54:41.349Z |
2230643 | 2230643 | 20230125002923_9YErI | RU0002 | 2024-01-05T23:54:41.335Z | 2024-01-05T23:54:41.335Z |
2230634 | 2230634 | 20230125002108_pBEXz | RU0002 | 2024-01-05T23:54:41.332Z | 2024-01-05T23:54:41.332Z |
2230613 | 2230613 | 20230124235032_8bZm2 | RU0002 | 2024-01-05T23:54:41.326Z | 2024-01-05T23:54:41.326Z |
2230615 | 2230615 | 20230124235537_LdXG1 | RU0002 | 2024-01-05T23:54:41.326Z | 2024-01-05T23:54:41.326Z |
2230581 | 2230581 | 20230124223534_Npe86 | RU0002 | 2024-01-05T23:54:41.315Z | 2024-01-05T23:54:41.315Z |
2230572 | 2230572 | 20230124221327_DXTom | RU0002 | 2024-01-05T23:54:41.312Z | 2024-01-05T23:54:41.312Z |
2230570 | 2230570 | 20230124221154_RlA4Q | RU0002 | 2024-01-05T23:54:41.311Z | 2024-01-05T23:54:41.311Z |
2230298 | 2230298 | 20230124200554_B8CQg | RU0002 | 2024-01-05T23:54:41.252Z | 2024-01-05T23:54:41.252Z |
2228146 | 2228146 | 20230124032604_0ZkWQ | RU0002 | 2024-01-05T23:54:38.877Z | 2024-01-05T23:54:38.877Z |
2228127 | 2228127 | 20230124032203_VgY4l | RU0002 | 2024-01-05T23:54:38.870Z | 2024-01-05T23:54:38.870Z |
2228041 | 2228041 | 20230124025734_KNGPE | RU0002 | 2024-01-05T23:54:38.744Z | 2024-01-05T23:54:38.744Z |
2228013 | 2228013 | 20230124025117_IPQHN | RU0002 | 2024-01-05T23:54:38.726Z | 2024-01-05T23:54:38.726Z |
2227914 | 2227914 | 20230124021928_j7zhk | RU0002 | 2024-01-05T23:54:38.673Z | 2024-01-05T23:54:38.673Z |
2227887 | 2227887 | 20230124020632_vXFXW | RU0002 | 2024-01-05T23:54:38.655Z | 2024-01-05T23:54:38.655Z |
2227609 | 2227609 | 20230124004532_273nF | RU0002 | 2024-01-05T23:54:38.533Z | 2024-01-05T23:54:38.533Z |
2227578 | 2227578 | 20230124003551_tsG3B | RU0002 | 2024-01-05T23:54:38.511Z | 2024-01-05T23:54:38.511Z |
2227466 | 2227466 | 20230123234957_sEot2 | RU0002 | 2024-01-05T23:54:38.474Z | 2024-01-05T23:54:38.474Z |
2227369 | 2227369 | 20230123231522_nWlvC | RU0002 | 2024-01-05T23:54:38.414Z | 2024-01-05T23:54:38.414Z |
2227342 | 2227342 | 20230123230523_XZuDB | RU0002 | 2024-01-05T23:54:38.389Z | 2024-01-05T23:54:38.389Z |
2227308 | 2227308 | 20230123225420_Y5DUA | RU0002 | 2024-01-05T23:54:38.378Z | 2024-01-05T23:54:38.378Z |
2227291 | 2227291 | 20230123224846_gFv63 | RU0002 | 2024-01-05T23:54:38.362Z | 2024-01-05T23:54:38.362Z |
2227255 | 2227255 | 20230123223037_WM2Do | RU0002 | 2024-01-05T23:54:38.351Z | 2024-01-05T23:54:38.351Z |
2227110 | 2227110 | 20230123212408_8TzJd | RU0002 | 2024-01-05T23:54:38.265Z | 2024-01-05T23:54:38.265Z |
2227050 | 2227050 | 20230123205531_zpZjd | RU0002 | 2024-01-05T23:54:38.240Z | 2024-01-05T23:54:38.240Z |
2226986 | 2226986 | 20230123201703_YMxhP | RU0002 | 2024-01-05T23:54:38.218Z | 2024-01-05T23:54:38.218Z |
2226941 | 2226941 | 20230123200034_H501I | RU0002 | 2024-01-05T23:54:38.193Z | 2024-01-05T23:54:38.193Z |
2226833 | 2226833 | 20230123190239_22038 | RU0002 | 2024-01-05T23:54:38.154Z | 2024-01-05T23:54:38.154Z |
2226673 | 2226673 | 20230123172135_36Va1 | RU0002 | 2024-01-05T23:54:38.094Z | 2024-01-05T23:54:38.094Z |
2225856 | 2225856 | 20230123032409_b37ps | RU0002 | 2024-01-05T23:54:36.290Z | 2024-01-05T23:54:36.290Z |
2225674 | 2225674 | 20230123022817_23cWW | RU0002 | 2024-01-05T23:54:36.233Z | 2024-01-05T23:54:36.233Z |
2225374 | 2225374 | 20230123004018_ORGCg | RU0002 | 2024-01-05T23:54:36.159Z | 2024-01-05T23:54:36.159Z |
2225333 | 2225333 | 20230123002204_1ZvB1 | RU0002 | 2024-01-05T23:54:36.150Z | 2024-01-05T23:54:36.150Z |
2224914 | 2224914 | 20230122191626_89fTG | RU0002 | 2024-01-05T23:54:36.061Z | 2024-01-05T23:54:36.061Z |
2221896 | 2221896 | 20230122022817_4mSuz | RU0002 | 2024-01-05T23:54:33.966Z | 2024-01-05T23:54:33.966Z |
2221618 | 2221618 | 20230122011836_dUW0x | RU0002 | 2024-01-05T23:54:33.911Z | 2024-01-05T23:54:33.911Z |
2221537 | 2221537 | 20230122005718_pvmLG | RU0002 | 2024-01-05T23:54:33.893Z | 2024-01-05T23:54:33.893Z |
2221539 | 2221539 | 20230122005822_7lRu4 | RU0002 | 2024-01-05T23:54:33.893Z | 2024-01-05T23:54:33.893Z |
2221372 | 2221372 | 20230121235343_EoStq | RU0002 | 2024-01-05T23:54:33.859Z | 2024-01-05T23:54:33.859Z |
2221297 | 2221297 | 20230121232016_J2KEb | RU0002 | 2024-01-05T23:54:33.845Z | 2024-01-05T23:54:33.845Z |
2221185 | 2221185 | 20230121222716_50u2c | RU0002 | 2024-01-05T23:54:33.822Z | 2024-01-05T23:54:33.822Z |
2221160 | 2221160 | 20230121222002_WumG1 | RU0002 | 2024-01-05T23:54:33.818Z | 2024-01-05T23:54:33.818Z |
2221097 | 2221097 | 20230121212455_s32tA | RU0002 | 2024-01-05T23:54:33.801Z | 2024-01-05T23:54:33.801Z |
2216094 | 2216094 | 20230120213219_gqeua | RU0002 | 2024-01-05T23:54:30.688Z | 2024-01-05T23:54:30.688Z |
2212762 | 2212762 | 20230120033848_IqItt | RU0002 | 2024-01-05T23:54:28.272Z | 2024-01-05T23:54:28.272Z |
2212625 | 2212625 | 20230120031712_eGq7P | RU0002 | 2024-01-05T23:54:28.229Z | 2024-01-05T23:54:28.229Z |
2212616 | 2212616 | 20230120031641_kAZsd | RU0002 | 2024-01-05T23:54:28.211Z | 2024-01-05T23:54:28.211Z |
2212205 | 2212205 | 20230120020902_IHBZL | RU0002 | 2024-01-05T23:54:28.074Z | 2024-01-05T23:54:28.074Z |
2211616 | 2211616 | 20230120004736_opP6S | RU0002 | 2024-01-05T23:54:27.954Z | 2024-01-05T23:54:27.954Z |
2211408 | 2211408 | 20230120001627_B2xeQ | RU0002 | 2024-01-05T23:54:27.914Z | 2024-01-05T23:54:27.914Z |
2211370 | 2211370 | 20230120000804_iuoTa | RU0002 | 2024-01-05T23:54:27.904Z | 2024-01-05T23:54:27.904Z |
2211230 | 2211230 | 20230119232017_F9uzF | RU0002 | 2024-01-05T23:54:27.873Z | 2024-01-05T23:54:27.873Z |
2211212 | 2211212 | 20230119231707_g3gml | RU0002 | 2024-01-05T23:54:27.869Z | 2024-01-05T23:54:27.869Z |
2211179 | 2211179 | 20230119230347_bjJ1C | RU0002 | 2024-01-05T23:54:27.846Z | 2024-01-05T23:54:27.846Z |
2211120 | 2211120 | 20230119225049_CvgKE | RU0002 | 2024-01-05T23:54:27.817Z | 2024-01-05T23:54:27.817Z |
2211068 | 2211068 | 20230119222317_fANeh | RU0002 | 2024-01-05T23:54:27.806Z | 2024-01-05T23:54:27.806Z |
2210903 | 2210903 | 20230119210940_jnErP | RU0002 | 2024-01-05T23:54:27.722Z | 2024-01-05T23:54:27.722Z |
2210732 | 2210732 | 20230119192954_ojjNw | RU0002 | 2024-01-05T23:54:27.650Z | 2024-01-05T23:54:27.650Z |
2210692 | 2210692 | 20230119190904_uCA3C | RU0002 | 2024-01-05T23:54:27.626Z | 2024-01-05T23:54:27.626Z |
2210659 | 2210659 | 20230119184406_hVBJy | RU0002 | 2024-01-05T23:54:27.618Z | 2024-01-05T23:54:27.618Z |
2210568 | 2210568 | 20230119180155_3ByHy | RU0002 | 2024-01-05T23:54:27.591Z | 2024-01-05T23:54:27.591Z |
2207723 | 2207723 | 20230119031036_vRUW9 | RU0002 | 2024-01-05T23:54:24.722Z | 2024-01-05T23:54:24.722Z |
2206935 | 2206935 | 20230119005114_83rrp | RU0002 | 2024-01-05T23:54:24.361Z | 2024-01-05T23:54:24.361Z |
2202827 | 2202827 | 20230118003038_CdULT | RU0002 | 2024-01-05T23:54:21.878Z | 2024-01-05T23:54:21.878Z |
2202668 | 2202668 | 20230117235315_GTrFI | RU0002 | 2024-01-05T23:54:21.864Z | 2024-01-05T23:54:21.864Z |
2202579 | 2202579 | 20230117232735_yQ6ZL | RU0002 | 2024-01-05T23:54:21.856Z | 2024-01-05T23:54:21.856Z |
2202543 | 2202543 | 20230117232219_qQHVv | RU0002 | 2024-01-05T23:54:21.853Z | 2024-01-05T23:54:21.853Z |
2202535 | 2202535 | 20230117231917_zTw2O | RU0002 | 2024-01-05T23:54:21.852Z | 2024-01-05T23:54:21.852Z |
2202503 | 2202503 | 20230117230253_NBdQN | RU0002 | 2024-01-05T23:54:21.848Z | 2024-01-05T23:54:21.848Z |
2202344 | 2202344 | 20230117221325_u58qh | RU0002 | 2024-01-05T23:54:21.833Z | 2024-01-05T23:54:21.833Z |
2202346 | 2202346 | 20230117221614_ggFqX | RU0002 | 2024-01-05T23:54:21.833Z | 2024-01-05T23:54:21.833Z |
2202296 | 2202296 | 20230117215449_YJwLO | RU0002 | 2024-01-05T23:54:21.828Z | 2024-01-05T23:54:21.828Z |
2201863 | 2201863 | 20230117190945_QCiMb | RU0002 | 2024-01-05T23:54:21.790Z | 2024-01-05T23:54:21.790Z |
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);