participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,808 rows where station_code = "RU0013" 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 |
---|---|---|---|---|---|
1760998 | 1760998 | 20221011210327_eFu4v | RU0013 | 2024-01-05T23:51:00.312Z | 2024-01-05T23:51:00.312Z |
1760656 | 1760656 | 20221011180132_Y9f0C | RU0013 | 2024-01-05T23:51:00.273Z | 2024-01-05T23:51:00.273Z |
1758888 | 1758888 | 20221011012622_ujoqd | RU0013 | 2024-01-05T23:50:58.863Z | 2024-01-05T23:50:58.863Z |
1750759 | 1750759 | 20221007220735_sDuUj | RU0013 | 2024-01-05T23:50:53.057Z | 2024-01-05T23:50:53.057Z |
1750746 | 1750746 | 20221007215550_xx5uK | RU0013 | 2024-01-05T23:50:53.055Z | 2024-01-05T23:50:53.055Z |
1750574 | 1750574 | 20221007205621_uUKdQ | RU0013 | 2024-01-05T23:50:53.038Z | 2024-01-05T23:50:53.038Z |
1750541 | 1750541 | 20221007205113_Cwv2Q | RU0013 | 2024-01-05T23:50:53.036Z | 2024-01-05T23:50:53.036Z |
1750499 | 1750499 | 20221007203150_MPymg | RU0013 | 2024-01-05T23:50:53.032Z | 2024-01-05T23:50:53.032Z |
1750436 | 1750436 | 20221007200629_3mzbl | RU0013 | 2024-01-05T23:50:53.023Z | 2024-01-05T23:50:53.023Z |
1750264 | 1750264 | 20221007173211_YpClV | RU0013 | 2024-01-05T23:50:53.004Z | 2024-01-05T23:50:53.004Z |
1750266 | 1750266 | 20221007173341_I3YrK | RU0013 | 2024-01-05T23:50:53.004Z | 2024-01-05T23:50:53.004Z |
1748211 | 1748211 | 20221007015447_nSwgs | RU0013 | 2024-01-05T23:50:51.218Z | 2024-01-05T23:50:51.218Z |
1748064 | 1748064 | 20221007012800_XIDS7 | RU0013 | 2024-01-05T23:50:51.201Z | 2024-01-05T23:50:51.201Z |
1748068 | 1748068 | 20221007012830_XL9jc | RU0013 | 2024-01-05T23:50:51.201Z | 2024-01-05T23:50:51.201Z |
1748014 | 1748014 | 20221007011634_e0VF4 | RU0013 | 2024-01-05T23:50:51.194Z | 2024-01-05T23:50:51.194Z |
1747865 | 1747865 | 20221007003703_3P5Bx | RU0013 | 2024-01-05T23:50:51.174Z | 2024-01-05T23:50:51.174Z |
1747830 | 1747830 | 20221007003029_oEUfC | RU0013 | 2024-01-05T23:50:51.170Z | 2024-01-05T23:50:51.170Z |
1747789 | 1747789 | 20221007002112_OFo3U | RU0013 | 2024-01-05T23:50:51.164Z | 2024-01-05T23:50:51.164Z |
1747771 | 1747771 | 20221007001334_tu6UY | RU0013 | 2024-01-05T23:50:51.161Z | 2024-01-05T23:50:51.161Z |
1747631 | 1747631 | 20221006234203_UqbJn | RU0013 | 2024-01-05T23:50:51.146Z | 2024-01-05T23:50:51.146Z |
1747270 | 1747270 | 20221006211130_0C37h | RU0013 | 2024-01-05T23:50:51.105Z | 2024-01-05T23:50:51.105Z |
1747274 | 1747274 | 20221006211327_hKJ2G | RU0013 | 2024-01-05T23:50:51.105Z | 2024-01-05T23:50:51.105Z |
1726485 | 1726485 | 20221002011856_2i16E | RU0013 | 2024-01-05T23:50:40.958Z | 2024-01-05T23:50:40.958Z |
1726125 | 1726125 | 20221001234119_vCzBh | RU0013 | 2024-01-05T23:50:40.908Z | 2024-01-05T23:50:40.908Z |
1726025 | 1726025 | 20221001231848_FwbMK | RU0013 | 2024-01-05T23:50:40.896Z | 2024-01-05T23:50:40.896Z |
1725978 | 1725978 | 20221001230908_idtI7 | RU0013 | 2024-01-05T23:50:40.891Z | 2024-01-05T23:50:40.891Z |
1725899 | 1725899 | 20221001223737_x27WB | RU0013 | 2024-01-05T23:50:40.880Z | 2024-01-05T23:50:40.880Z |
1725730 | 1725730 | 20221001214237_cKMF8 | RU0013 | 2024-01-05T23:50:40.857Z | 2024-01-05T23:50:40.857Z |
1725605 | 1725605 | 20221001203538_GkxvD | RU0013 | 2024-01-05T23:50:40.840Z | 2024-01-05T23:50:40.840Z |
1725526 | 1725526 | 20221001200142_Xp6Yv | RU0013 | 2024-01-05T23:50:40.829Z | 2024-01-05T23:50:40.829Z |
1725503 | 1725503 | 20221001193304_wfmWj | RU0013 | 2024-01-05T23:50:40.825Z | 2024-01-05T23:50:40.825Z |
1725401 | 1725401 | 20221001181154_Qfi2N | RU0013 | 2024-01-05T23:50:40.810Z | 2024-01-05T23:50:40.810Z |
1725347 | 1725347 | 20221001163452_0QFMl | RU0013 | 2024-01-05T23:50:40.802Z | 2024-01-05T23:50:40.802Z |
1721393 | 1721393 | 20221001013951_zIDuM | RU0013 | 2024-01-05T23:50:39.109Z | 2024-01-05T23:50:39.109Z |
1720683 | 1720683 | 20220930231321_aSEfc | RU0013 | 2024-01-05T23:50:39.044Z | 2024-01-05T23:50:39.044Z |
1720578 | 1720578 | 20220930224831_TDkto | RU0013 | 2024-01-05T23:50:39.033Z | 2024-01-05T23:50:39.033Z |
1720526 | 1720526 | 20220930222136_2cRRM | RU0013 | 2024-01-05T23:50:39.025Z | 2024-01-05T23:50:39.025Z |
1720291 | 1720291 | 20220930204802_gpomX | RU0013 | 2024-01-05T23:50:38.998Z | 2024-01-05T23:50:38.998Z |
1720148 | 1720148 | 20220930191606_HM3F8 | RU0013 | 2024-01-05T23:50:38.977Z | 2024-01-05T23:50:38.977Z |
1720144 | 1720144 | 20220930191441_cHLpg | RU0013 | 2024-01-05T23:50:38.976Z | 2024-01-05T23:50:38.976Z |
1720009 | 1720009 | 20220930162448_tJYOu | RU0013 | 2024-01-05T23:50:38.956Z | 2024-01-05T23:50:38.956Z |
1715911 | 1715911 | 20220930021326_cF8xS | RU0013 | 2024-01-05T23:50:37.325Z | 2024-01-05T23:50:37.325Z |
1715909 | 1715909 | 20220930021316_X3B5s | RU0013 | 2024-01-05T23:50:37.324Z | 2024-01-05T23:50:37.324Z |
1715643 | 1715643 | 20220930014311_i58ja | RU0013 | 2024-01-05T23:50:37.299Z | 2024-01-05T23:50:37.299Z |
1715263 | 1715263 | 20220930010119_ZnmGR | RU0013 | 2024-01-05T23:50:37.265Z | 2024-01-05T23:50:37.265Z |
1715125 | 1715125 | 20220930004640_gQqfg | RU0013 | 2024-01-05T23:50:37.252Z | 2024-01-05T23:50:37.252Z |
1713821 | 1713821 | 20220929221619_rZEPr | RU0013 | 2024-01-05T23:50:37.139Z | 2024-01-05T23:50:37.139Z |
1713638 | 1713638 | 20220929215327_G3XA5 | RU0013 | 2024-01-05T23:50:37.122Z | 2024-01-05T23:50:37.122Z |
1705382 | 1705382 | 20220928020808_3aBKF | RU0013 | 2024-01-05T23:50:33.326Z | 2024-01-05T23:50:33.326Z |
1700567 | 1700567 | 20220926231751_y3DMD | RU0013 | 2024-01-05T23:50:31.202Z | 2024-01-05T23:50:31.202Z |
1700367 | 1700367 | 20220926214004_tcACQ | RU0013 | 2024-01-05T23:50:31.170Z | 2024-01-05T23:50:31.170Z |
1700286 | 1700286 | 20220926205950_EUzdf | RU0013 | 2024-01-05T23:50:31.152Z | 2024-01-05T23:50:31.152Z |
1700270 | 1700270 | 20220926205236_oVv6Y | RU0013 | 2024-01-05T23:50:31.149Z | 2024-01-05T23:50:31.149Z |
1700245 | 1700245 | 20220926204618_o8WjU | RU0013 | 2024-01-05T23:50:31.129Z | 2024-01-05T23:50:31.129Z |
1700124 | 1700124 | 20220926195848_E32pl | RU0013 | 2024-01-05T23:50:31.092Z | 2024-01-05T23:50:31.092Z |
1699957 | 1699957 | 20220926174317_6blCf | RU0013 | 2024-01-05T23:50:31.032Z | 2024-01-05T23:50:31.032Z |
1699923 | 1699923 | 20220926164856_GM2sz | RU0013 | 2024-01-05T23:50:31.023Z | 2024-01-05T23:50:31.023Z |
1697634 | 1697634 | 20220926010149_HRC81 | RU0013 | 2024-01-05T23:50:28.983Z | 2024-01-05T23:50:28.983Z |
1697449 | 1697449 | 20220925212107_nNDsW | RU0013 | 2024-01-05T23:50:28.957Z | 2024-01-05T23:50:28.957Z |
1697442 | 1697442 | 20220925211728_jrqW9 | RU0013 | 2024-01-05T23:50:28.955Z | 2024-01-05T23:50:28.955Z |
1697395 | 1697395 | 20220925202008_G708w | RU0013 | 2024-01-05T23:50:28.949Z | 2024-01-05T23:50:28.949Z |
1692755 | 1692755 | 20220924235151_GxOhg | RU0013 | 2024-01-05T23:50:27.042Z | 2024-01-05T23:50:27.042Z |
1691857 | 1691857 | 20220924204516_Of5QZ | RU0013 | 2024-01-05T23:50:26.963Z | 2024-01-05T23:50:26.963Z |
1691611 | 1691611 | 20220924184303_M4Rqt | RU0013 | 2024-01-05T23:50:26.936Z | 2024-01-05T23:50:26.936Z |
1691579 | 1691579 | 20220924175226_8R3oZ | RU0013 | 2024-01-05T23:50:26.931Z | 2024-01-05T23:50:26.931Z |
1691575 | 1691575 | 20220924174541_Gy9y8 | RU0013 | 2024-01-05T23:50:26.930Z | 2024-01-05T23:50:26.930Z |
1691577 | 1691577 | 20220924175156_dA02K | RU0013 | 2024-01-05T23:50:26.930Z | 2024-01-05T23:50:26.930Z |
1683271 | 1683271 | 20220922172428_NlhWP | RU0013 | 2024-01-05T23:50:22.896Z | 2024-01-05T23:50:22.896Z |
1676208 | 1676208 | 20220920180807_cv09P | RU0013 | 2024-01-05T23:50:19.031Z | 2024-01-05T23:50:19.031Z |
1674285 | 1674285 | 20220920011757_WILId | RU0013 | 2024-01-05T23:50:17.258Z | 2024-01-05T23:50:17.258Z |
1669819 | 1669819 | 20220918230306_PZNBQ | RU0013 | 2024-01-05T23:50:15.345Z | 2024-01-05T23:50:15.345Z |
1669278 | 1669278 | 20220918203627_GBP2m | RU0013 | 2024-01-05T23:50:15.287Z | 2024-01-05T23:50:15.287Z |
1669232 | 1669232 | 20220918201005_2i8OL | RU0013 | 2024-01-05T23:50:15.280Z | 2024-01-05T23:50:15.280Z |
1666443 | 1666443 | 20220918010346_eGOiC | RU0013 | 2024-01-05T23:50:13.604Z | 2024-01-05T23:50:13.604Z |
1666104 | 1666104 | 20220917225424_WAtOt | RU0013 | 2024-01-05T23:50:13.563Z | 2024-01-05T23:50:13.563Z |
1666106 | 1666106 | 20220917225439_arlcq | RU0013 | 2024-01-05T23:50:13.563Z | 2024-01-05T23:50:13.563Z |
1665814 | 1665814 | 20220917213411_bEmSk | RU0013 | 2024-01-05T23:50:13.533Z | 2024-01-05T23:50:13.533Z |
1665701 | 1665701 | 20220917205750_zBLkq | RU0013 | 2024-01-05T23:50:13.520Z | 2024-01-05T23:50:13.520Z |
1665492 | 1665492 | 20220917184115_02AbN | RU0013 | 2024-01-05T23:50:13.493Z | 2024-01-05T23:50:13.493Z |
1665485 | 1665485 | 20220917182000_prna7 | RU0013 | 2024-01-05T23:50:13.492Z | 2024-01-05T23:50:13.492Z |
1665475 | 1665475 | 20220917165036_sxfOY | RU0013 | 2024-01-05T23:50:13.490Z | 2024-01-05T23:50:13.490Z |
1661245 | 1661245 | 20220917005728_JF3Ny | RU0013 | 2024-01-05T23:50:11.770Z | 2024-01-05T23:50:11.770Z |
1654218 | 1654218 | 20220914233335_PxjNm | RU0013 | 2024-01-05T23:50:08.482Z | 2024-01-05T23:50:08.482Z |
1653964 | 1653964 | 20220914192320_CCMeL | RU0013 | 2024-01-05T23:50:08.454Z | 2024-01-05T23:50:08.454Z |
1649925 | 1649925 | 20220911003205_hiPG9 | RU0013 | 2024-01-05T23:50:03.270Z | 2024-01-05T23:50:03.270Z |
1649792 | 1649792 | 20220910231706_NaLB7 | RU0013 | 2024-01-05T23:50:03.254Z | 2024-01-05T23:50:03.254Z |
1649626 | 1649626 | 20220910215242_BEQKK | RU0013 | 2024-01-05T23:50:03.236Z | 2024-01-05T23:50:03.236Z |
1649392 | 1649392 | 20220910194635_eUpSF | RU0013 | 2024-01-05T23:50:03.215Z | 2024-01-05T23:50:03.215Z |
1649394 | 1649394 | 20220910194712_t620x | RU0013 | 2024-01-05T23:50:03.215Z | 2024-01-05T23:50:03.215Z |
1649372 | 1649372 | 20220910192117_ZlUwp | RU0013 | 2024-01-05T23:50:03.213Z | 2024-01-05T23:50:03.213Z |
1649353 | 1649353 | 20220910172349_lHtZO | RU0013 | 2024-01-05T23:50:03.209Z | 2024-01-05T23:50:03.209Z |
1646820 | 1646820 | 20220908002412_dCufw | RU0013 | 2024-01-05T23:50:00.494Z | 2024-01-05T23:50:00.494Z |
1646736 | 1646736 | 20220907232540_q4NUB | RU0013 | 2024-01-05T23:50:00.480Z | 2024-01-05T23:50:00.480Z |
1646642 | 1646642 | 20220907215959_6d33Z | RU0013 | 2024-01-05T23:49:59.322Z | 2024-01-05T23:49:59.322Z |
1646640 | 1646640 | 20220907215905_MbY8L | RU0013 | 2024-01-05T23:49:59.321Z | 2024-01-05T23:49:59.321Z |
1646508 | 1646508 | 20220907193834_1qRsS | RU0013 | 2024-01-05T23:49:59.302Z | 2024-01-05T23:49:59.302Z |
1646479 | 1646479 | 20220907182614_B3LzM | RU0013 | 2024-01-05T23:49:59.297Z | 2024-01-05T23:49:59.297Z |
1633017 | 1633017 | 20220903190543_2kirl | RU0013 | 2024-01-05T23:49:50.049Z | 2024-01-05T23:49:50.049Z |
1626272 | 1626272 | 20220901232944_n93E4 | RU0013 | 2024-01-05T23:49:47.886Z | 2024-01-05T23:49:47.886Z |
1626128 | 1626128 | 20220901225413_6lH3m | RU0013 | 2024-01-05T23:49:47.867Z | 2024-01-05T23:49:47.867Z |
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);