participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
862 rows where station_code = "RU0011" 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 |
---|---|---|---|---|---|
2258590 | 2258590 | 20230203225730_D1Yr2 | RU0011 | 2024-01-05T23:55:00.170Z | 2024-01-05T23:55:00.170Z |
1763359 | 1763359 | 20221012205334_T0dHF | RU0011 | 2024-01-05T23:51:01.779Z | 2024-01-05T23:51:01.779Z |
1763185 | 1763185 | 20221012161836_wRCSP | RU0011 | 2024-01-05T23:51:01.754Z | 2024-01-05T23:51:01.754Z |
1760940 | 1760940 | 20221011202924_ayFEp | RU0011 | 2024-01-05T23:51:00.306Z | 2024-01-05T23:51:00.306Z |
1750609 | 1750609 | 20221007210535_AKHHB | RU0011 | 2024-01-05T23:50:53.041Z | 2024-01-05T23:50:53.041Z |
1750438 | 1750438 | 20221007200704_P8VSX | RU0011 | 2024-01-05T23:50:53.024Z | 2024-01-05T23:50:53.024Z |
1750354 | 1750354 | 20221007192158_7ABFH | RU0011 | 2024-01-05T23:50:53.015Z | 2024-01-05T23:50:53.015Z |
1750343 | 1750343 | 20221007191047_tnsoL | RU0011 | 2024-01-05T23:50:53.014Z | 2024-01-05T23:50:53.014Z |
1750255 | 1750255 | 20221007165734_F3yJS | RU0011 | 2024-01-05T23:50:53.003Z | 2024-01-05T23:50:53.003Z |
1747963 | 1747963 | 20221007010724_QpZdX | RU0011 | 2024-01-05T23:50:51.188Z | 2024-01-05T23:50:51.188Z |
1747838 | 1747838 | 20221007003049_b27hi | RU0011 | 2024-01-05T23:50:51.171Z | 2024-01-05T23:50:51.171Z |
1747276 | 1747276 | 20221006211328_HcbCg | RU0011 | 2024-01-05T23:50:51.106Z | 2024-01-05T23:50:51.106Z |
1747212 | 1747212 | 20221006202432_HANf5 | RU0011 | 2024-01-05T23:50:51.098Z | 2024-01-05T23:50:51.098Z |
1725433 | 1725433 | 20221001184404_0T6jd | RU0011 | 2024-01-05T23:50:40.815Z | 2024-01-05T23:50:40.815Z |
1725351 | 1725351 | 20221001163936_Z9PrR | RU0011 | 2024-01-05T23:50:40.803Z | 2024-01-05T23:50:40.803Z |
1720094 | 1720094 | 20220930181919_Vplt8 | RU0011 | 2024-01-05T23:50:38.969Z | 2024-01-05T23:50:38.969Z |
1714474 | 1714474 | 20220929234037_lsbdJ | RU0011 | 2024-01-05T23:50:37.198Z | 2024-01-05T23:50:37.198Z |
1713825 | 1713825 | 20220929221657_2S1W3 | RU0011 | 2024-01-05T23:50:37.140Z | 2024-01-05T23:50:37.140Z |
1713348 | 1713348 | 20220929205428_XO4Wt | RU0011 | 2024-01-05T23:50:37.093Z | 2024-01-05T23:50:37.093Z |
1713241 | 1713241 | 20220929203313_UdR7h | RU0011 | 2024-01-05T23:50:37.081Z | 2024-01-05T23:50:37.081Z |
1700661 | 1700661 | 20220926235103_0PeuN | RU0011 | 2024-01-05T23:50:31.213Z | 2024-01-05T23:50:31.213Z |
1700052 | 1700052 | 20220926192918_xgCYX | RU0011 | 2024-01-05T23:50:31.056Z | 2024-01-05T23:50:31.056Z |
1699915 | 1699915 | 20220926161312_CuZDy | RU0011 | 2024-01-05T23:50:31.021Z | 2024-01-05T23:50:31.021Z |
1697632 | 1697632 | 20220926005416_3XX6x | RU0011 | 2024-01-05T23:50:28.983Z | 2024-01-05T23:50:28.983Z |
1697448 | 1697448 | 20220925212107_nNDsW | RU0011 | 2024-01-05T23:50:28.957Z | 2024-01-05T23:50:28.957Z |
1692569 | 1692569 | 20220924232228_Uii9t | RU0011 | 2024-01-05T23:50:27.027Z | 2024-01-05T23:50:27.027Z |
1692463 | 1692463 | 20220924230434_lCqBN | RU0011 | 2024-01-05T23:50:27.017Z | 2024-01-05T23:50:27.017Z |
1676196 | 1676196 | 20220920170431_2Qvvl | RU0011 | 2024-01-05T23:50:19.029Z | 2024-01-05T23:50:19.029Z |
1676188 | 1676188 | 20220920161055_G4O4S | RU0011 | 2024-01-05T23:50:19.027Z | 2024-01-05T23:50:19.027Z |
1669135 | 1669135 | 20220918191603_ZHczn | RU0011 | 2024-01-05T23:50:15.269Z | 2024-01-05T23:50:15.269Z |
1669128 | 1669128 | 20220918190059_MO3OI | RU0011 | 2024-01-05T23:50:15.268Z | 2024-01-05T23:50:15.268Z |
1666382 | 1666382 | 20220918003702_CTNTr | RU0011 | 2024-01-05T23:50:13.598Z | 2024-01-05T23:50:13.598Z |
1666065 | 1666065 | 20220917224510_xFI5a | RU0011 | 2024-01-05T23:50:13.559Z | 2024-01-05T23:50:13.559Z |
1661243 | 1661243 | 20220917005705_ya7Sa | RU0011 | 2024-01-05T23:50:11.769Z | 2024-01-05T23:50:11.769Z |
1661108 | 1661108 | 20220917004249_2AS3W | RU0011 | 2024-01-05T23:50:11.758Z | 2024-01-05T23:50:11.758Z |
1654216 | 1654216 | 20220914232720_um9Ni | RU0011 | 2024-01-05T23:50:08.481Z | 2024-01-05T23:50:08.481Z |
1652729 | 1652729 | 20220913192436_kohgP | RU0011 | 2024-01-05T23:50:07.114Z | 2024-01-05T23:50:07.114Z |
1651562 | 1651562 | 20220912172800_m6Rvs | RU0011 | 2024-01-05T23:50:05.818Z | 2024-01-05T23:50:05.818Z |
1651559 | 1651559 | 20220912172218_2DkJV | RU0011 | 2024-01-05T23:50:05.817Z | 2024-01-05T23:50:05.817Z |
1651553 | 1651553 | 20220912165212_NXD7M | RU0011 | 2024-01-05T23:50:05.816Z | 2024-01-05T23:50:05.816Z |
1650863 | 1650863 | 20220911233709_F2O60 | RU0011 | 2024-01-05T23:50:04.528Z | 2024-01-05T23:50:04.528Z |
1650732 | 1650732 | 20220911221849_YLmWh | RU0011 | 2024-01-05T23:50:04.511Z | 2024-01-05T23:50:04.511Z |
1650738 | 1650738 | 20220911222016_bX7VZ | RU0011 | 2024-01-05T23:50:04.511Z | 2024-01-05T23:50:04.511Z |
1650606 | 1650606 | 20220911203434_yt5WO | RU0011 | 2024-01-05T23:50:04.492Z | 2024-01-05T23:50:04.492Z |
1649363 | 1649363 | 20220910190156_I3jCO | RU0011 | 2024-01-05T23:50:03.211Z | 2024-01-05T23:50:03.211Z |
1647866 | 1647866 | 20220909000425_QiILz | RU0011 | 2024-01-05T23:50:01.806Z | 2024-01-05T23:50:01.806Z |
1647742 | 1647742 | 20220908202259_uJcU5 | RU0011 | 2024-01-05T23:50:00.620Z | 2024-01-05T23:50:00.620Z |
1621981 | 1621981 | 20220831232759_wVBGj | RU0011 | 2024-01-05T23:49:46.130Z | 2024-01-05T23:49:46.130Z |
1621783 | 1621783 | 20220831225948_bRua7 | RU0011 | 2024-01-05T23:49:46.097Z | 2024-01-05T23:49:46.097Z |
1621030 | 1621030 | 20220831202348_UUT9J | RU0011 | 2024-01-05T23:49:46.003Z | 2024-01-05T23:49:46.003Z |
1620919 | 1620919 | 20220831184633_FneTc | RU0011 | 2024-01-05T23:49:45.988Z | 2024-01-05T23:49:45.988Z |
1617831 | 1617831 | 20220831012845_sXBiz | RU0011 | 2024-01-05T23:49:44.071Z | 2024-01-05T23:49:44.071Z |
1616993 | 1616993 | 20220830232800_6emIC | RU0011 | 2024-01-05T23:49:43.867Z | 2024-01-05T23:49:43.867Z |
1616773 | 1616773 | 20220830225109_xq9z2 | RU0011 | 2024-01-05T23:49:43.826Z | 2024-01-05T23:49:43.826Z |
1616565 | 1616565 | 20220830220206_uzlD4 | RU0011 | 2024-01-05T23:49:43.785Z | 2024-01-05T23:49:43.785Z |
1616380 | 1616380 | 20220830210936_h7DYj | RU0011 | 2024-01-05T23:49:43.745Z | 2024-01-05T23:49:43.745Z |
1611627 | 1611627 | 20220829225128_6VHVI | RU0011 | 2024-01-05T23:49:40.587Z | 2024-01-05T23:49:40.587Z |
1610707 | 1610707 | 20220829184840_moePl | RU0011 | 2024-01-05T23:49:40.482Z | 2024-01-05T23:49:40.482Z |
1607872 | 1607872 | 20220828230304_drvEs | RU0011 | 2024-01-05T23:49:38.581Z | 2024-01-05T23:49:38.581Z |
1607806 | 1607806 | 20220828223221_VAEqp | RU0011 | 2024-01-05T23:49:38.571Z | 2024-01-05T23:49:38.571Z |
1607793 | 1607793 | 20220828222536_8gaGI | RU0011 | 2024-01-05T23:49:38.569Z | 2024-01-05T23:49:38.569Z |
1607521 | 1607521 | 20220828202431_N50bd | RU0011 | 2024-01-05T23:49:38.529Z | 2024-01-05T23:49:38.529Z |
1607424 | 1607424 | 20220828193656_CsLN8 | RU0011 | 2024-01-05T23:49:38.515Z | 2024-01-05T23:49:38.515Z |
1603171 | 1603171 | 20220827225306_eMqV2 | RU0011 | 2024-01-05T23:49:36.709Z | 2024-01-05T23:49:36.709Z |
1602871 | 1602871 | 20220827215348_RCzlt | RU0011 | 2024-01-05T23:49:36.678Z | 2024-01-05T23:49:36.678Z |
1598661 | 1598661 | 20220826213519_8cZRV | RU0011 | 2024-01-05T23:49:33.106Z | 2024-01-05T23:49:33.106Z |
1598395 | 1598395 | 20220826182420_D01Mj | RU0011 | 2024-01-05T23:49:33.022Z | 2024-01-05T23:49:33.022Z |
1598385 | 1598385 | 20220826174749_H89q4 | RU0011 | 2024-01-05T23:49:33.019Z | 2024-01-05T23:49:33.019Z |
1594478 | 1594478 | 20220825194427_7flW2 | RU0011 | 2024-01-05T23:49:30.103Z | 2024-01-05T23:49:30.103Z |
1594371 | 1594371 | 20220825171321_lI8SZ | RU0011 | 2024-01-05T23:49:30.069Z | 2024-01-05T23:49:30.069Z |
1592868 | 1592868 | 20220825001916_4FPen | RU0011 | 2024-01-05T23:49:27.279Z | 2024-01-05T23:49:27.279Z |
1592736 | 1592736 | 20220824234344_udaw2 | RU0011 | 2024-01-05T23:49:27.226Z | 2024-01-05T23:49:27.226Z |
1590256 | 1590256 | 20220824003700_XRSos | RU0011 | 2024-01-05T23:49:24.497Z | 2024-01-05T23:49:24.497Z |
1587179 | 1587179 | 20220823000137_3Lrc3 | RU0011 | 2024-01-05T23:49:22.600Z | 2024-01-05T23:49:22.600Z |
1587079 | 1587079 | 20220822233446_CVmM3 | RU0011 | 2024-01-05T23:49:22.587Z | 2024-01-05T23:49:22.587Z |
1584456 | 1584456 | 20220821231754_nI39V | RU0011 | 2024-01-05T23:49:20.509Z | 2024-01-05T23:49:20.509Z |
1583815 | 1583815 | 20220821201002_3IEhH | RU0011 | 2024-01-05T23:49:20.438Z | 2024-01-05T23:49:20.438Z |
1583780 | 1583780 | 20220821193950_5rsI2 | RU0011 | 2024-01-05T23:49:20.433Z | 2024-01-05T23:49:20.433Z |
1583769 | 1583769 | 20220821193030_3P0PE | RU0011 | 2024-01-05T23:49:20.431Z | 2024-01-05T23:49:20.431Z |
1583759 | 1583759 | 20220821191256_9e0GF | RU0011 | 2024-01-05T23:49:20.430Z | 2024-01-05T23:49:20.430Z |
1583749 | 1583749 | 20220821184241_MmYrM | RU0011 | 2024-01-05T23:49:20.428Z | 2024-01-05T23:49:20.428Z |
1583751 | 1583751 | 20220821184829_RdThS | RU0011 | 2024-01-05T23:49:20.428Z | 2024-01-05T23:49:20.428Z |
1583738 | 1583738 | 20220821183218_L9Acj | RU0011 | 2024-01-05T23:49:20.427Z | 2024-01-05T23:49:20.427Z |
1570186 | 1570186 | 20220816214132_nvP1u | RU0011 | 2024-01-05T23:49:11.576Z | 2024-01-05T23:49:11.576Z |
1569978 | 1569978 | 20220816203440_F13OI | RU0011 | 2024-01-05T23:49:11.549Z | 2024-01-05T23:49:11.549Z |
1564224 | 1564224 | 20220814195008_0qg3w | RU0011 | 2024-01-05T23:49:08.442Z | 2024-01-05T23:49:08.442Z |
1564197 | 1564197 | 20220814192607_hNWJ3 | RU0011 | 2024-01-05T23:49:08.439Z | 2024-01-05T23:49:08.439Z |
1559903 | 1559903 | 20220814010827_moHrU | RU0011 | 2024-01-05T23:49:06.683Z | 2024-01-05T23:49:06.683Z |
1559244 | 1559244 | 20220814003517_n3pc3 | RU0011 | 2024-01-05T23:49:06.611Z | 2024-01-05T23:49:06.611Z |
1557461 | 1557461 | 20220813225837_ssQLN | RU0011 | 2024-01-05T23:49:06.422Z | 2024-01-05T23:49:06.422Z |
1557138 | 1557138 | 20220813223819_zPx33 | RU0011 | 2024-01-05T23:49:06.375Z | 2024-01-05T23:49:06.375Z |
1556899 | 1556899 | 20220813222742_iPC9T | RU0011 | 2024-01-05T23:49:06.347Z | 2024-01-05T23:49:06.347Z |
1556514 | 1556514 | 20220813220740_H0o2X | RU0011 | 2024-01-05T23:49:06.293Z | 2024-01-05T23:49:06.293Z |
1556321 | 1556321 | 20220813215545_i1TQH | RU0011 | 2024-01-05T23:49:06.260Z | 2024-01-05T23:49:06.260Z |
1555401 | 1555401 | 20220813211123_X0Tgb | RU0011 | 2024-01-05T23:49:06.160Z | 2024-01-05T23:49:06.160Z |
1554780 | 1554780 | 20220813185600_FdFku | RU0011 | 2024-01-05T23:49:06.080Z | 2024-01-05T23:49:06.080Z |
1554772 | 1554772 | 20220813184409_203VX | RU0011 | 2024-01-05T23:49:06.079Z | 2024-01-05T23:49:06.079Z |
1526594 | 1526594 | 20220810220706_ABZpG | RU0011 | 2024-01-05T23:48:57.791Z | 2024-01-05T23:48:57.791Z |
1525879 | 1525879 | 20220810193042_MuOXJ | RU0011 | 2024-01-05T23:48:57.621Z | 2024-01-05T23:48:57.621Z |
1520405 | 1520405 | 20220810011248_JtPCj | RU0011 | 2024-01-05T23:48:57.033Z | 2024-01-05T23:48:57.033Z |
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);