participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,257 rows where station_code = "DE0003" 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 |
---|---|---|---|---|---|
5175373 | 5175373 | 20240926222635_pkB7C | DE0003 | 2024-09-28T12:17:02.612Z | 2024-10-04T12:25:35.651Z |
5169734 | 5169734 | 20240927025832_PnAYW | DE0003 | 2024-09-28T12:03:54.724Z | 2024-10-05T12:28:33.559Z |
5169009 | 5169009 | 20240926234750_t8y8p | DE0003 | 2024-09-28T12:00:53.751Z | 2024-10-05T12:28:28.289Z |
5143193 | 5143193 | 20240921033055_KrjP8 | DE0003 | 2024-09-22T12:04:19.317Z | 2024-09-29T12:22:06.396Z |
5142574 | 5142574 | 20240921013009_2vY5E | DE0003 | 2024-09-22T12:02:46.903Z | 2024-09-29T12:22:03.621Z |
5138712 | 5138712 | 20240919215825_1fTxk | DE0003 | 2024-09-21T12:00:50.459Z | 2024-09-28T12:23:10.033Z |
5136775 | 5136775 | 20240919040629_pRFMs | DE0003 | 2024-09-20T12:03:05.215Z | 2024-09-27T12:19:50.835Z |
5132061 | 5132061 | 20240915225813_WFDsU | DE0003 | 2024-09-19T12:15:47.478Z | 2024-09-24T12:15:39.747Z |
5125752 | 5125752 | 20240918034125_4Zfnu | DE0003 | 2024-09-19T12:04:01.835Z | 2024-09-26T12:18:43.498Z |
5115443 | 5115443 | 20240915023845_9EhUI | DE0003 | 2024-09-18T12:06:14.537Z | 2024-09-23T12:16:17.224Z |
5111839 | 5111839 | 20240914212052_WPu3q | DE0003 | 2024-09-18T12:02:19.349Z | 2024-09-23T12:16:00.373Z |
5110863 | 5110863 | 20240914191624_RgIpB | DE0003 | 2024-09-18T12:01:06.786Z | 2024-09-23T12:15:51.997Z |
5090923 | 5090923 | 20240912015058_IUyt4 | DE0003 | 2024-09-16T12:12:42.558Z | 2024-09-20T12:21:45.999Z |
5090361 | 5090361 | 20240912012242_IgJ08 | DE0003 | 2024-09-16T12:12:15.791Z | 2024-09-20T12:21:44.897Z |
5087153 | 5087153 | 20240912231144_5ZLf7 | DE0003 | 2024-09-16T12:06:42.270Z | 2024-09-21T12:16:14.290Z |
5086756 | 5086756 | 20240912224656_5yrKI | DE0003 | 2024-09-16T12:06:01.108Z | 2024-09-21T12:16:11.343Z |
5086487 | 5086487 | 20240912223640_uuZ6S | DE0003 | 2024-09-16T12:05:48.327Z | 2024-09-21T12:16:10.726Z |
5085715 | 5085715 | 20240912214657_UOI8U | DE0003 | 2024-09-16T12:04:48.974Z | 2024-09-21T12:16:07.901Z |
5084226 | 5084226 | 20240912190051_VvMqI | DE0003 | 2024-09-16T12:01:36.531Z | 2024-09-21T12:15:56.656Z |
5073625 | 5073625 | 20240911213458_pr8K6 | DE0003 | 2024-09-15T12:07:24.172Z | 2024-09-20T12:21:33.082Z |
4963342 | 4963342 | 20240811200137_0aBmD | DE0003 | 2024-09-04T12:05:28.317Z | 2024-09-06T12:04:33.207Z |
4883797 | 4883797 | 20240807024856_dG52J | DE0003 | 2024-08-20T12:15:11.305Z | 2024-08-27T12:16:00.704Z |
4850918 | 4850918 | 20240805201300_xYvP4 | DE0003 | 2024-08-17T12:13:57.680Z | 2024-08-19T12:23:33.711Z |
4684435 | 4684435 | 20240725013838_NpnZR | DE0003 | 2024-07-26T12:03:13.465Z | 2024-08-02T12:24:18.710Z |
4604383 | 4604383 | 20240709020139_OmLg7 | DE0003 | 2024-07-12T12:02:30.947Z | 2024-07-18T12:16:25.133Z |
4578127 | 4578127 | 20240707001356_fbGLO | DE0003 | 2024-07-09T12:01:20.529Z | 2024-07-15T12:11:55.895Z |
4562595 | 4562595 | 20240705004541_4Oa03 | DE0003 | 2024-07-07T12:03:40.215Z | 2024-07-13T12:12:48.115Z |
4562356 | 4562356 | 20240704235930_n5tjw | DE0003 | 2024-07-07T12:03:02.368Z | 2024-07-13T12:12:46.992Z |
4562250 | 4562250 | 20240704234916_rmYmA | DE0003 | 2024-07-07T12:02:53.110Z | 2024-07-13T12:12:46.637Z |
4561894 | 4561894 | 20240704224445_Q0OKD | DE0003 | 2024-07-07T12:01:53.218Z | 2024-07-13T12:12:44.179Z |
4496550 | 4496550 | 20240623211321_4Y7T9 | DE0003 | 2024-06-25T12:02:25.411Z | 2024-07-02T12:10:14.494Z |
2269646 | 2269646 | 20230210192913_CPqzF | DE0003 | 2024-01-05T23:55:12.746Z | 2024-01-05T23:55:12.746Z |
2263688 | 2263688 | 20230208022926_EOIbg | DE0003 | 2024-01-05T23:55:05.316Z | 2024-01-05T23:55:05.316Z |
2263584 | 2263584 | 20230208013048_paNwj | DE0003 | 2024-01-05T23:55:05.302Z | 2024-01-05T23:55:05.302Z |
2263403 | 2263403 | 20230208001619_HYcyu | DE0003 | 2024-01-05T23:55:05.280Z | 2024-01-05T23:55:05.280Z |
2263212 | 2263212 | 20230207214059_FOj1S | DE0003 | 2024-01-05T23:55:05.252Z | 2024-01-05T23:55:05.252Z |
2261409 | 2261409 | 20230206203230_G20zB | DE0003 | 2024-01-05T23:55:03.835Z | 2024-01-05T23:55:03.835Z |
2245551 | 2245551 | 20230129051503_5e73L | DE0003 | 2024-01-05T23:54:48.957Z | 2024-01-05T23:54:48.957Z |
2227828 | 2227828 | 20230124015059_2Gk7S | DE0003 | 2024-01-05T23:54:38.621Z | 2024-01-05T23:54:38.621Z |
2207109 | 2207109 | 20230119013412_3J1g3 | DE0003 | 2024-01-05T23:54:24.447Z | 2024-01-05T23:54:24.447Z |
2205943 | 2205943 | 20230118193006_aObAH | DE0003 | 2024-01-05T23:54:23.978Z | 2024-01-05T23:54:23.978Z |
2205638 | 2205638 | 20230118173230_5Qgq2 | DE0003 | 2024-01-05T23:54:23.889Z | 2024-01-05T23:54:23.889Z |
2194384 | 2194384 | 20230113183146_n2vtc | DE0003 | 2024-01-05T23:54:15.237Z | 2024-01-05T23:54:15.237Z |
2189750 | 2189750 | 20230111180107_hrtEC | DE0003 | 2024-01-05T23:54:12.490Z | 2024-01-05T23:54:12.490Z |
2174085 | 2174085 | 20230101003847_mPF9q | DE0003 | 2024-01-05T23:53:59.234Z | 2024-01-05T23:53:59.234Z |
2171683 | 2171683 | 20221230013833_svS5h | DE0003 | 2024-01-05T23:53:57.800Z | 2024-01-05T23:53:57.800Z |
2164552 | 2164552 | 20221227042627_shyrc | DE0003 | 2024-01-05T23:53:53.475Z | 2024-01-05T23:53:53.475Z |
2161929 | 2161929 | 20221226230214_LPJqy | DE0003 | 2024-01-05T23:53:52.067Z | 2024-01-05T23:53:52.067Z |
2121477 | 2121477 | 20221217051000_w7lMy | DE0003 | 2024-01-05T23:53:35.074Z | 2024-01-05T23:53:35.074Z |
2121376 | 2121376 | 20221217045320_UVy3M | DE0003 | 2024-01-05T23:53:35.063Z | 2024-01-05T23:53:35.063Z |
2120894 | 2120894 | 20221217034745_RNv6d | DE0003 | 2024-01-05T23:53:35.016Z | 2024-01-05T23:53:35.016Z |
2120839 | 2120839 | 20221217032853_mt2B0 | DE0003 | 2024-01-05T23:53:35.010Z | 2024-01-05T23:53:35.010Z |
2119813 | 2119813 | 20221217000531_2nBOw | DE0003 | 2024-01-05T23:53:34.909Z | 2024-01-05T23:53:34.909Z |
2119749 | 2119749 | 20221216235248_uBk1S | DE0003 | 2024-01-05T23:53:34.904Z | 2024-01-05T23:53:34.904Z |
2119095 | 2119095 | 20221216201847_a4Gdn | DE0003 | 2024-01-05T23:53:34.844Z | 2024-01-05T23:53:34.844Z |
2115395 | 2115395 | 20221216044907_h0und | DE0003 | 2024-01-05T23:53:33.105Z | 2024-01-05T23:53:33.105Z |
2115006 | 2115006 | 20221216042113_7KJF1 | DE0003 | 2024-01-05T23:53:33.077Z | 2024-01-05T23:53:33.077Z |
2113336 | 2113336 | 20221216020807_086VH | DE0003 | 2024-01-05T23:53:32.951Z | 2024-01-05T23:53:32.951Z |
2113159 | 2113159 | 20221216015036_CPJKU | DE0003 | 2024-01-05T23:53:32.936Z | 2024-01-05T23:53:32.936Z |
2112994 | 2112994 | 20221216013556_9JdKd | DE0003 | 2024-01-05T23:53:32.926Z | 2024-01-05T23:53:32.926Z |
2110180 | 2110180 | 20221215201616_EqJld | DE0003 | 2024-01-05T23:53:32.707Z | 2024-01-05T23:53:32.707Z |
2045523 | 2045523 | 20221213045941_N3HmY | DE0003 | 2024-01-05T23:53:19.858Z | 2024-01-05T23:53:19.858Z |
2044887 | 2044887 | 20221213040912_UjRqe | DE0003 | 2024-01-05T23:53:19.767Z | 2024-01-05T23:53:19.767Z |
2043392 | 2043392 | 20221213021908_d3epf | DE0003 | 2024-01-05T23:53:19.581Z | 2024-01-05T23:53:19.581Z |
2043260 | 2043260 | 20221213021116_9sVii | DE0003 | 2024-01-05T23:53:19.566Z | 2024-01-05T23:53:19.566Z |
2043001 | 2043001 | 20221213015456_jkEAx | DE0003 | 2024-01-05T23:53:19.535Z | 2024-01-05T23:53:19.535Z |
2042274 | 2042274 | 20221213010343_vsi1q | DE0003 | 2024-01-05T23:53:19.447Z | 2024-01-05T23:53:19.447Z |
2042085 | 2042085 | 20221213004948_EDUok | DE0003 | 2024-01-05T23:53:19.425Z | 2024-01-05T23:53:19.425Z |
2042054 | 2042054 | 20221213004802_3NLVc | DE0003 | 2024-01-05T23:53:19.421Z | 2024-01-05T23:53:19.421Z |
2041926 | 2041926 | 20221213003854_452nO | DE0003 | 2024-01-05T23:53:19.406Z | 2024-01-05T23:53:19.406Z |
2041632 | 2041632 | 20221213001629_slTwB | DE0003 | 2024-01-05T23:53:19.371Z | 2024-01-05T23:53:19.371Z |
2041480 | 2041480 | 20221213000345_r3hBn | DE0003 | 2024-01-05T23:53:19.351Z | 2024-01-05T23:53:19.351Z |
2041105 | 2041105 | 20221212233358_iVJaa | DE0003 | 2024-01-05T23:53:19.305Z | 2024-01-05T23:53:19.305Z |
2040873 | 2040873 | 20221212231530_3Fan7 | DE0003 | 2024-01-05T23:53:19.277Z | 2024-01-05T23:53:19.277Z |
2040288 | 2040288 | 20221212221040_BXpLu | DE0003 | 2024-01-05T23:53:19.206Z | 2024-01-05T23:53:19.206Z |
1988367 | 1988367 | 20221126010642_nLW8V | DE0003 | 2024-01-05T23:52:47.481Z | 2024-01-05T23:52:47.481Z |
1988208 | 1988208 | 20221125235538_aagyS | DE0003 | 2024-01-05T23:52:47.456Z | 2024-01-05T23:52:47.456Z |
1988074 | 1988074 | 20221125230842_jetyg | DE0003 | 2024-01-05T23:52:47.435Z | 2024-01-05T23:52:47.435Z |
1988021 | 1988021 | 20221125224634_3q2Ol | DE0003 | 2024-01-05T23:52:47.426Z | 2024-01-05T23:52:47.426Z |
1987998 | 1987998 | 20221125224128_1Or6M | DE0003 | 2024-01-05T23:52:47.423Z | 2024-01-05T23:52:47.423Z |
1987968 | 1987968 | 20221125223151_tJ3z5 | DE0003 | 2024-01-05T23:52:47.419Z | 2024-01-05T23:52:47.419Z |
1980404 | 1980404 | 20221124224607_mGMX2 | DE0003 | 2024-01-05T23:52:45.369Z | 2024-01-05T23:52:45.369Z |
1979408 | 1979408 | 20221124165126_aG6EP | DE0003 | 2024-01-05T23:52:45.243Z | 2024-01-05T23:52:45.243Z |
1975040 | 1975040 | 20221124034634_3lKcX | DE0003 | 2024-01-05T23:52:43.423Z | 2024-01-05T23:52:43.423Z |
1974539 | 1974539 | 20221124030721_9T8TB | DE0003 | 2024-01-05T23:52:43.376Z | 2024-01-05T23:52:43.376Z |
1943175 | 1943175 | 20221117204056_ER6of | DE0003 | 2024-01-05T23:52:27.429Z | 2024-01-05T23:52:27.429Z |
1942680 | 1942680 | 20221117165907_WLvme | DE0003 | 2024-01-05T23:52:27.288Z | 2024-01-05T23:52:27.288Z |
1928411 | 1928411 | 20221114015551_BniEQ | DE0003 | 2024-01-05T23:52:15.683Z | 2024-01-05T23:52:15.683Z |
1928158 | 1928158 | 20221114003724_WcQJ3 | DE0003 | 2024-01-05T23:52:15.529Z | 2024-01-05T23:52:15.529Z |
1928126 | 1928126 | 20221114002805_prbRj | DE0003 | 2024-01-05T23:52:15.522Z | 2024-01-05T23:52:15.522Z |
1927699 | 1927699 | 20221113215453_lSUYx | DE0003 | 2024-01-05T23:52:15.391Z | 2024-01-05T23:52:15.391Z |
1927597 | 1927597 | 20221113211615_B3nlX | DE0003 | 2024-01-05T23:52:15.341Z | 2024-01-05T23:52:15.341Z |
1925245 | 1925245 | 20221113042512_emV30 | DE0003 | 2024-01-05T23:52:13.302Z | 2024-01-05T23:52:13.302Z |
1924989 | 1924989 | 20221113031408_boSf2 | DE0003 | 2024-01-05T23:52:13.266Z | 2024-01-05T23:52:13.266Z |
1924446 | 1924446 | 20221112235958_9uyci | DE0003 | 2024-01-05T23:52:13.181Z | 2024-01-05T23:52:13.181Z |
1899013 | 1899013 | 20221103045246_k1k6J | DE0003 | 2024-01-05T23:51:53.665Z | 2024-01-05T23:51:53.665Z |
1898526 | 1898526 | 20221103014037_yA0bL | DE0003 | 2024-01-05T23:51:53.591Z | 2024-01-05T23:51:53.591Z |
1898269 | 1898269 | 20221102235728_a4eSv | DE0003 | 2024-01-05T23:51:53.550Z | 2024-01-05T23:51:53.550Z |
1898181 | 1898181 | 20221102231426_3a2AL | DE0003 | 2024-01-05T23:51:53.536Z | 2024-01-05T23:51:53.536Z |
1898055 | 1898055 | 20221102213229_LIjJC | DE0003 | 2024-01-05T23:51:53.515Z | 2024-01-05T23:51:53.515Z |
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);