participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,131 rows where station_code = "RU0012" 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 |
---|---|---|---|---|---|
2226695 | 2226695 | 20230123174322_fkEyK | RU0012 | 2024-01-05T23:54:38.103Z | 2024-01-05T23:54:38.103Z |
1763311 | 1763311 | 20221012201544_vyz0S | RU0012 | 2024-01-05T23:51:01.771Z | 2024-01-05T23:51:01.771Z |
1760848 | 1760848 | 20221011194809_lSUh4 | RU0012 | 2024-01-05T23:51:00.296Z | 2024-01-05T23:51:00.296Z |
1760769 | 1760769 | 20221011191055_dl1CD | RU0012 | 2024-01-05T23:51:00.287Z | 2024-01-05T23:51:00.287Z |
1750745 | 1750745 | 20221007215550_xx5uK | RU0012 | 2024-01-05T23:50:53.055Z | 2024-01-05T23:50:53.055Z |
1750666 | 1750666 | 20221007212659_KirPE | RU0012 | 2024-01-05T23:50:53.047Z | 2024-01-05T23:50:53.047Z |
1750310 | 1750310 | 20221007184905_LqFUU | RU0012 | 2024-01-05T23:50:53.010Z | 2024-01-05T23:50:53.010Z |
1750312 | 1750312 | 20221007185038_OACBy | RU0012 | 2024-01-05T23:50:53.010Z | 2024-01-05T23:50:53.010Z |
1750248 | 1750248 | 20221007163404_bU97J | RU0012 | 2024-01-05T23:50:53.002Z | 2024-01-05T23:50:53.002Z |
1750253 | 1750253 | 20221007165403_7vX94 | RU0012 | 2024-01-05T23:50:53.002Z | 2024-01-05T23:50:53.002Z |
1750242 | 1750242 | 20221007162515_mIYOV | RU0012 | 2024-01-05T23:50:53.001Z | 2024-01-05T23:50:53.001Z |
1747999 | 1747999 | 20221007011514_s2YeS | RU0012 | 2024-01-05T23:50:51.192Z | 2024-01-05T23:50:51.192Z |
1747940 | 1747940 | 20221007010105_ZLL8O | RU0012 | 2024-01-05T23:50:51.184Z | 2024-01-05T23:50:51.184Z |
1747826 | 1747826 | 20221007002625_8G5oM | RU0012 | 2024-01-05T23:50:51.169Z | 2024-01-05T23:50:51.169Z |
1721247 | 1721247 | 20221001011822_2Wtzy | RU0012 | 2024-01-05T23:50:39.097Z | 2024-01-05T23:50:39.097Z |
1721106 | 1721106 | 20221001004844_b8sjo | RU0012 | 2024-01-05T23:50:39.084Z | 2024-01-05T23:50:39.084Z |
1720682 | 1720682 | 20220930231321_aSEfc | RU0012 | 2024-01-05T23:50:39.044Z | 2024-01-05T23:50:39.044Z |
1720289 | 1720289 | 20220930204737_pPqwe | RU0012 | 2024-01-05T23:50:38.998Z | 2024-01-05T23:50:38.998Z |
1720121 | 1720121 | 20220930185641_KsHIs | RU0012 | 2024-01-05T23:50:38.973Z | 2024-01-05T23:50:38.973Z |
1720101 | 1720101 | 20220930182855_Lt9zw | RU0012 | 2024-01-05T23:50:38.970Z | 2024-01-05T23:50:38.970Z |
1714990 | 1714990 | 20220930003539_encZw | RU0012 | 2024-01-05T23:50:37.242Z | 2024-01-05T23:50:37.242Z |
1714144 | 1714144 | 20220929225817_Nq2qo | RU0012 | 2024-01-05T23:50:37.168Z | 2024-01-05T23:50:37.168Z |
1713630 | 1713630 | 20220929215248_oLFK4 | RU0012 | 2024-01-05T23:50:37.121Z | 2024-01-05T23:50:37.121Z |
1713561 | 1713561 | 20220929214319_Bsxct | RU0012 | 2024-01-05T23:50:37.115Z | 2024-01-05T23:50:37.115Z |
1713326 | 1713326 | 20220929205103_i6ttM | RU0012 | 2024-01-05T23:50:37.091Z | 2024-01-05T23:50:37.091Z |
1700439 | 1700439 | 20220926222712_B4Jb7 | RU0012 | 2024-01-05T23:50:31.183Z | 2024-01-05T23:50:31.183Z |
1700269 | 1700269 | 20220926205236_oVv6Y | RU0012 | 2024-01-05T23:50:31.149Z | 2024-01-05T23:50:31.149Z |
1700187 | 1700187 | 20220926202020_0flrp | RU0012 | 2024-01-05T23:50:31.108Z | 2024-01-05T23:50:31.108Z |
1699982 | 1699982 | 20220926180625_yPBUJ | RU0012 | 2024-01-05T23:50:31.038Z | 2024-01-05T23:50:31.038Z |
1699942 | 1699942 | 20220926170641_WCaS1 | RU0012 | 2024-01-05T23:50:31.028Z | 2024-01-05T23:50:31.028Z |
1697446 | 1697446 | 20220925212050_7chqf | RU0012 | 2024-01-05T23:50:28.956Z | 2024-01-05T23:50:28.956Z |
1674190 | 1674190 | 20220920005601_I25v9 | RU0012 | 2024-01-05T23:50:17.247Z | 2024-01-05T23:50:17.247Z |
1652694 | 1652694 | 20220913181607_SIwRP | RU0012 | 2024-01-05T23:50:07.108Z | 2024-01-05T23:50:07.108Z |
1650897 | 1650897 | 20220911235723_isM2E | RU0012 | 2024-01-05T23:50:04.533Z | 2024-01-05T23:50:04.533Z |
1650733 | 1650733 | 20220911221849_YLmWh | RU0012 | 2024-01-05T23:50:04.511Z | 2024-01-05T23:50:04.511Z |
1650585 | 1650585 | 20220911202004_ws6HR | RU0012 | 2024-01-05T23:50:04.489Z | 2024-01-05T23:50:04.489Z |
1650515 | 1650515 | 20220911190444_vDyke | RU0012 | 2024-01-05T23:50:04.478Z | 2024-01-05T23:50:04.478Z |
1650505 | 1650505 | 20220911185210_0BLLO | RU0012 | 2024-01-05T23:50:04.477Z | 2024-01-05T23:50:04.477Z |
1650497 | 1650497 | 20220911183524_GqFQ4 | RU0012 | 2024-01-05T23:50:04.475Z | 2024-01-05T23:50:04.475Z |
1650484 | 1650484 | 20220911164144_UGNHs | RU0012 | 2024-01-05T23:50:04.473Z | 2024-01-05T23:50:04.473Z |
1649660 | 1649660 | 20220910222722_YloCu | RU0012 | 2024-01-05T23:50:03.241Z | 2024-01-05T23:50:03.241Z |
1649524 | 1649524 | 20220910204814_qrBjw | RU0012 | 2024-01-05T23:50:03.226Z | 2024-01-05T23:50:03.226Z |
1649391 | 1649391 | 20220910194635_eUpSF | RU0012 | 2024-01-05T23:50:03.215Z | 2024-01-05T23:50:03.215Z |
1647891 | 1647891 | 20220909001933_9wzUG | RU0012 | 2024-01-05T23:50:01.809Z | 2024-01-05T23:50:01.809Z |
1647752 | 1647752 | 20220908204110_c8uBI | RU0012 | 2024-01-05T23:50:00.622Z | 2024-01-05T23:50:00.622Z |
1647743 | 1647743 | 20220908202259_uJcU5 | RU0012 | 2024-01-05T23:50:00.620Z | 2024-01-05T23:50:00.620Z |
1647699 | 1647699 | 20220908185915_nvG9J | RU0012 | 2024-01-05T23:50:00.614Z | 2024-01-05T23:50:00.614Z |
1646851 | 1646851 | 20220908003849_a6cYC | RU0012 | 2024-01-05T23:50:00.499Z | 2024-01-05T23:50:00.499Z |
1646717 | 1646717 | 20220907225655_gWgif | RU0012 | 2024-01-05T23:49:59.331Z | 2024-01-05T23:49:59.331Z |
1646708 | 1646708 | 20220907225025_mnXpy | RU0012 | 2024-01-05T23:49:59.330Z | 2024-01-05T23:49:59.330Z |
1633035 | 1633035 | 20220903194427_1Ge3H | RU0012 | 2024-01-05T23:49:50.052Z | 2024-01-05T23:49:50.052Z |
1625819 | 1625819 | 20220901204657_xRcAt | RU0012 | 2024-01-05T23:49:47.826Z | 2024-01-05T23:49:47.826Z |
1625738 | 1625738 | 20220901190948_3vTwq | RU0012 | 2024-01-05T23:49:47.813Z | 2024-01-05T23:49:47.813Z |
1625720 | 1625720 | 20220901184214_b9ww1 | RU0012 | 2024-01-05T23:49:47.809Z | 2024-01-05T23:49:47.809Z |
1625702 | 1625702 | 20220901173927_AtPYR | RU0012 | 2024-01-05T23:49:46.559Z | 2024-01-05T23:49:46.559Z |
1622785 | 1622785 | 20220901011131_281iy | RU0012 | 2024-01-05T23:49:46.219Z | 2024-01-05T23:49:46.219Z |
1622698 | 1622698 | 20220901010429_MSlk0 | RU0012 | 2024-01-05T23:49:46.211Z | 2024-01-05T23:49:46.211Z |
1621617 | 1621617 | 20220831223000_lyKf6 | RU0012 | 2024-01-05T23:49:46.069Z | 2024-01-05T23:49:46.069Z |
1621490 | 1621490 | 20220831220535_tw2MD | RU0012 | 2024-01-05T23:49:46.054Z | 2024-01-05T23:49:46.054Z |
1620901 | 1620901 | 20220831182236_SCnJ4 | RU0012 | 2024-01-05T23:49:45.986Z | 2024-01-05T23:49:45.986Z |
1612909 | 1612909 | 20220830013025_xD2CX | RU0012 | 2024-01-05T23:49:40.734Z | 2024-01-05T23:49:40.734Z |
1612074 | 1612074 | 20220829234335_DJijT | RU0012 | 2024-01-05T23:49:40.636Z | 2024-01-05T23:49:40.636Z |
1611826 | 1611826 | 20220829231350_3Oa0w | RU0012 | 2024-01-05T23:49:40.611Z | 2024-01-05T23:49:40.611Z |
1611289 | 1611289 | 20220829214129_98DKN | RU0012 | 2024-01-05T23:49:40.548Z | 2024-01-05T23:49:40.548Z |
1610848 | 1610848 | 20220829202533_h99Qu | RU0012 | 2024-01-05T23:49:40.504Z | 2024-01-05T23:49:40.504Z |
1610771 | 1610771 | 20220829194403_n6IEA | RU0012 | 2024-01-05T23:49:40.492Z | 2024-01-05T23:49:40.492Z |
1610717 | 1610717 | 20220829185256_E5byu | RU0012 | 2024-01-05T23:49:40.483Z | 2024-01-05T23:49:40.483Z |
1607951 | 1607951 | 20220828232953_G1tIR | RU0012 | 2024-01-05T23:49:38.593Z | 2024-01-05T23:49:38.593Z |
1607745 | 1607745 | 20220828220158_eGrhT | RU0012 | 2024-01-05T23:49:38.561Z | 2024-01-05T23:49:38.561Z |
1607444 | 1607444 | 20220828194823_Y3Q92 | RU0012 | 2024-01-05T23:49:38.519Z | 2024-01-05T23:49:38.519Z |
1602480 | 1602480 | 20220827200029_rJ0Tz | RU0012 | 2024-01-05T23:49:36.632Z | 2024-01-05T23:49:36.632Z |
1598644 | 1598644 | 20220826212836_H33E3 | RU0012 | 2024-01-05T23:49:33.103Z | 2024-01-05T23:49:33.103Z |
1598389 | 1598389 | 20220826175959_ngZWq | RU0012 | 2024-01-05T23:49:33.020Z | 2024-01-05T23:49:33.020Z |
1598383 | 1598383 | 20220826173352_WwpNH | RU0012 | 2024-01-05T23:49:33.018Z | 2024-01-05T23:49:33.018Z |
1594413 | 1594413 | 20220825182203_TpLDR | RU0012 | 2024-01-05T23:49:30.083Z | 2024-01-05T23:49:30.083Z |
1592788 | 1592788 | 20220824235947_ONuA4 | RU0012 | 2024-01-05T23:49:27.248Z | 2024-01-05T23:49:27.248Z |
1592677 | 1592677 | 20220824232239_UmCUn | RU0012 | 2024-01-05T23:49:27.191Z | 2024-01-05T23:49:27.191Z |
1592596 | 1592596 | 20220824230017_OQgMR | RU0012 | 2024-01-05T23:49:27.139Z | 2024-01-05T23:49:27.139Z |
1592459 | 1592459 | 20220824222418_Gg3UO | RU0012 | 2024-01-05T23:49:27.051Z | 2024-01-05T23:49:27.051Z |
1592349 | 1592349 | 20220824215838_bOYCn | RU0012 | 2024-01-05T23:49:26.997Z | 2024-01-05T23:49:26.997Z |
1592215 | 1592215 | 20220824211934_TGByk | RU0012 | 2024-01-05T23:49:26.928Z | 2024-01-05T23:49:26.928Z |
1591954 | 1591954 | 20220824184548_Sef4i | RU0012 | 2024-01-05T23:49:26.752Z | 2024-01-05T23:49:26.752Z |
1591943 | 1591943 | 20220824180757_4o2F3 | RU0012 | 2024-01-05T23:49:26.748Z | 2024-01-05T23:49:26.748Z |
1590038 | 1590038 | 20220823235437_B9gPu | RU0012 | 2024-01-05T23:49:24.466Z | 2024-01-05T23:49:24.466Z |
1590026 | 1590026 | 20220823235302_og2rP | RU0012 | 2024-01-05T23:49:24.465Z | 2024-01-05T23:49:24.465Z |
1589722 | 1589722 | 20220823224454_8JlEJ | RU0012 | 2024-01-05T23:49:24.422Z | 2024-01-05T23:49:24.422Z |
1589613 | 1589613 | 20220823220149_f4L3K | RU0012 | 2024-01-05T23:49:24.407Z | 2024-01-05T23:49:24.407Z |
1589500 | 1589500 | 20220823212434_J2ETV | RU0012 | 2024-01-05T23:49:24.389Z | 2024-01-05T23:49:24.389Z |
1586754 | 1586754 | 20220822213442_nHCX3 | RU0012 | 2024-01-05T23:49:22.537Z | 2024-01-05T23:49:22.537Z |
1586526 | 1586526 | 20220822185842_JRGfN | RU0012 | 2024-01-05T23:49:22.504Z | 2024-01-05T23:49:22.504Z |
1586511 | 1586511 | 20220822182646_QWx40 | RU0012 | 2024-01-05T23:49:22.501Z | 2024-01-05T23:49:22.501Z |
1583811 | 1583811 | 20220821200107_1i3Dd | RU0012 | 2024-01-05T23:49:20.437Z | 2024-01-05T23:49:20.437Z |
1583802 | 1583802 | 20220821195749_2NulB | RU0012 | 2024-01-05T23:49:20.436Z | 2024-01-05T23:49:20.436Z |
1583695 | 1583695 | 20220821172638_BswUb | RU0012 | 2024-01-05T23:49:20.421Z | 2024-01-05T23:49:20.421Z |
1575674 | 1575674 | 20220819185013_0Nmwl | RU0012 | 2024-01-05T23:49:16.203Z | 2024-01-05T23:49:16.203Z |
1575655 | 1575655 | 20220819181959_NxKns | RU0012 | 2024-01-05T23:49:16.200Z | 2024-01-05T23:49:16.200Z |
1570692 | 1570692 | 20220816235617_2Bupq | RU0012 | 2024-01-05T23:49:11.644Z | 2024-01-05T23:49:11.644Z |
1570290 | 1570290 | 20220816220436_PAZIt | RU0012 | 2024-01-05T23:49:11.590Z | 2024-01-05T23:49:11.590Z |
1569980 | 1569980 | 20220816203600_2Mr1c | RU0012 | 2024-01-05T23:49:11.550Z | 2024-01-05T23:49:11.550Z |
1569803 | 1569803 | 20220816192523_psByy | RU0012 | 2024-01-05T23:49:11.527Z | 2024-01-05T23:49:11.527Z |
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);