participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
605 rows where station_code = "IL0001" 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 |
---|---|---|---|---|---|
5104248 | 5104248 | 20240913020102_7vdO8 | IL0001 | 2024-09-17T12:11:30.805Z | 2024-09-20T12:20:33.575Z |
5087241 | 5087241 | 20240912231728_oec1Z | IL0001 | 2024-09-16T12:06:48.421Z | 2024-09-20T12:20:15.294Z |
5074897 | 5074897 | 20240911231444_PC6US | IL0001 | 2024-09-15T12:09:12.192Z | 2024-09-20T12:21:37.367Z |
5074610 | 5074610 | 20240911224910_NBRrq | IL0001 | 2024-09-15T12:08:39.447Z | 2024-09-20T12:21:36.620Z |
5073665 | 5073665 | 20240911213845_k2GzS | IL0001 | 2024-09-15T12:07:32.016Z | 2024-09-20T12:21:33.237Z |
5073219 | 5073219 | 20240911210623_XbI2j | IL0001 | 2024-09-15T12:06:55.771Z | 2024-09-20T12:21:31.940Z |
5072040 | 5072040 | 20240911192544_lNCiP | IL0001 | 2024-09-15T12:04:31.428Z | 2024-09-20T12:21:24.857Z |
5064194 | 5064194 | 20240910001749_eGT3A | IL0001 | 2024-09-14T12:15:03.112Z | 2024-09-18T12:15:15.771Z |
5052203 | 5052203 | 20240907195834_LdwxP | IL0001 | 2024-09-13T12:14:59.946Z | 2024-09-16T12:21:04.536Z |
5046301 | 5046301 | 20240908223728_Ik7xh | IL0001 | 2024-09-13T12:06:20.491Z | 2024-09-17T12:18:59.020Z |
5046240 | 5046240 | 20240908220911_Z9jjl | IL0001 | 2024-09-13T12:06:11.064Z | 2024-09-17T12:18:58.789Z |
5039472 | 5039472 | 20240906010722_OXbvC | IL0001 | 2024-09-12T12:15:34.167Z | 2024-09-14T12:23:02.377Z |
5039085 | 5039085 | 20240905231832_4K2GB | IL0001 | 2024-09-12T12:15:15.035Z | 2024-09-14T12:23:00.063Z |
5038943 | 5038943 | 20240905224433_5kmJB | IL0001 | 2024-09-12T12:15:08.463Z | 2024-09-14T12:22:59.511Z |
5038868 | 5038868 | 20240905222402_YI2eM | IL0001 | 2024-09-12T12:15:05.560Z | 2024-09-14T12:22:58.899Z |
5032967 | 5032967 | 20240907020809_CcsID | IL0001 | 2024-09-12T12:08:39.701Z | 2024-09-15T12:21:28.656Z |
5031794 | 5031794 | 20240906231839_Zc2Hg | IL0001 | 2024-09-12T12:05:49.209Z | 2024-09-15T12:21:24.322Z |
5031205 | 5031205 | 20240906205313_oa93z | IL0001 | 2024-09-12T12:04:17.922Z | 2024-09-15T12:21:21.723Z |
5030815 | 5030815 | 20240906185151_qynUq | IL0001 | 2024-09-12T12:03:09.328Z | 2024-09-15T12:21:19.878Z |
5025122 | 5025122 | 20240906010722_Q8fEK | IL0001 | 2024-09-11T12:05:40.133Z | 2024-09-11T12:16:32.484Z |
5024675 | 5024675 | 20240905231832_cuj2P | IL0001 | 2024-09-11T12:04:25.033Z | 2024-09-11T12:16:32.258Z |
5024524 | 5024524 | 20240905224433_wKJEB | IL0001 | 2024-09-11T12:04:00.824Z | 2024-09-11T12:16:32.180Z |
5024447 | 5024447 | 20240905222402_bh7Gb | IL0001 | 2024-09-11T12:03:45.003Z | 2024-09-11T12:16:32.142Z |
4998016 | 4998016 | 20240903020357_AsIn6 | IL0001 | 2024-09-08T12:07:04.220Z | 2024-09-11T12:21:10.560Z |
4997938 | 4997938 | 20240903014824_4k6Sy | IL0001 | 2024-09-08T12:06:59.112Z | 2024-09-11T12:21:10.056Z |
4997230 | 4997230 | 20240902232927_hnGqP | IL0001 | 2024-09-08T12:05:55.631Z | 2024-09-11T12:21:02.387Z |
4996486 | 4996486 | 20240902194643_Bo1uP | IL0001 | 2024-09-08T12:04:51.916Z | 2024-09-11T12:20:54.877Z |
2437906 | 2437906 | 20230505003842_3QGp5 | IL0001 | 2024-01-05T23:57:25.860Z | 2024-01-05T23:57:25.860Z |
2432226 | 2432226 | 20230501004949_3qDHg | IL0001 | 2024-01-05T23:57:21.774Z | 2024-01-05T23:57:21.774Z |
2422588 | 2422588 | 20230426223712_pitgX | IL0001 | 2024-01-05T23:57:15.922Z | 2024-01-05T23:57:15.922Z |
2420017 | 2420017 | 20230426004223_OChda | IL0001 | 2024-01-05T23:57:14.431Z | 2024-01-05T23:57:14.431Z |
2401374 | 2401374 | 20230421003046_rvXhU | IL0001 | 2024-01-05T23:57:05.708Z | 2024-01-05T23:57:05.708Z |
2364230 | 2364230 | 20230403234129_hXeqq | IL0001 | 2024-01-05T23:56:36.751Z | 2024-01-05T23:56:36.751Z |
2332825 | 2332825 | 20230318013948_40DOJ | IL0001 | 2024-01-05T23:56:11.730Z | 2024-01-05T23:56:11.730Z |
2332802 | 2332802 | 20230318011919_DRoYa | IL0001 | 2024-01-05T23:56:11.726Z | 2024-01-05T23:56:11.726Z |
2330667 | 2330667 | 20230316221101_XUDwR | IL0001 | 2024-01-05T23:56:10.271Z | 2024-01-05T23:56:10.271Z |
2321625 | 2321625 | 20230312024141_4D5Ye | IL0001 | 2024-01-05T23:56:01.914Z | 2024-01-05T23:56:01.914Z |
2317293 | 2317293 | 20230305021918_a92CZ | IL0001 | 2024-01-05T23:55:51.133Z | 2024-01-05T23:55:51.133Z |
2317271 | 2317271 | 20230305001349_uL1E2 | IL0001 | 2024-01-05T23:55:51.129Z | 2024-01-05T23:55:51.129Z |
2313172 | 2313172 | 20230301222759_X1cdY | IL0001 | 2024-01-05T23:55:47.276Z | 2024-01-05T23:55:47.276Z |
2311685 | 2311685 | 20230301031656_trW29 | IL0001 | 2024-01-05T23:55:45.974Z | 2024-01-05T23:55:45.974Z |
2296463 | 2296463 | 20230223232329_cEHpP | IL0001 | 2024-01-05T23:55:38.153Z | 2024-01-05T23:55:38.153Z |
2289455 | 2289455 | 20230220020359_aRrJ1 | IL0001 | 2024-01-05T23:55:32.756Z | 2024-01-05T23:55:32.756Z |
2289009 | 2289009 | 20230219220818_wgYyi | IL0001 | 2024-01-05T23:55:32.710Z | 2024-01-05T23:55:32.710Z |
2285229 | 2285229 | 20230218032255_h7vW2 | IL0001 | 2024-01-05T23:55:29.971Z | 2024-01-05T23:55:29.971Z |
2285176 | 2285176 | 20230218005544_xAngG | IL0001 | 2024-01-05T23:55:29.960Z | 2024-01-05T23:55:29.960Z |
2275889 | 2275889 | 20230213235834_Zhgrv | IL0001 | 2024-01-05T23:55:20.365Z | 2024-01-05T23:55:20.365Z |
2255805 | 2255805 | 20230202015824_I9Ywy | IL0001 | 2024-01-05T23:54:57.343Z | 2024-01-05T23:54:57.343Z |
2238343 | 2238343 | 20230127030009_8bMwo | IL0001 | 2024-01-05T23:54:45.499Z | 2024-01-05T23:54:45.499Z |
2234382 | 2234382 | 20230126021945_KMCpf | IL0001 | 2024-01-05T23:54:43.624Z | 2024-01-05T23:54:43.624Z |
2234235 | 2234235 | 20230126012520_0ebJp | IL0001 | 2024-01-05T23:54:43.591Z | 2024-01-05T23:54:43.591Z |
2230836 | 2230836 | 20230125032659_TbtGU | IL0001 | 2024-01-05T23:54:41.394Z | 2024-01-05T23:54:41.394Z |
2230733 | 2230733 | 20230125020756_chICt | IL0001 | 2024-01-05T23:54:41.363Z | 2024-01-05T23:54:41.363Z |
2221387 | 2221387 | 20230121235936_LWo1w | IL0001 | 2024-01-05T23:54:33.864Z | 2024-01-05T23:54:33.864Z |
2216737 | 2216737 | 20230121001554_3wrNn | IL0001 | 2024-01-05T23:54:30.863Z | 2024-01-05T23:54:30.863Z |
2216139 | 2216139 | 20230120213715_qgt1e | IL0001 | 2024-01-05T23:54:30.693Z | 2024-01-05T23:54:30.693Z |
2212443 | 2212443 | 20230120025347_glJcj | IL0001 | 2024-01-05T23:54:28.159Z | 2024-01-05T23:54:28.159Z |
2212035 | 2212035 | 20230120014443_yABIH | IL0001 | 2024-01-05T23:54:28.041Z | 2024-01-05T23:54:28.041Z |
2211910 | 2211910 | 20230120012735_2QiXf | IL0001 | 2024-01-05T23:54:28.018Z | 2024-01-05T23:54:28.018Z |
2211028 | 2211028 | 20230119220833_ItYHE | IL0001 | 2024-01-05T23:54:27.783Z | 2024-01-05T23:54:27.783Z |
2210821 | 2210821 | 20230119201821_yxDqx | IL0001 | 2024-01-05T23:54:27.689Z | 2024-01-05T23:54:27.689Z |
2207834 | 2207834 | 20230119033243_irxcM | IL0001 | 2024-01-05T23:54:24.759Z | 2024-01-05T23:54:24.759Z |
2203654 | 2203654 | 20230118030653_LOBV3 | IL0001 | 2024-01-05T23:54:21.949Z | 2024-01-05T23:54:21.949Z |
2203200 | 2203200 | 20230118015818_9ids5 | IL0001 | 2024-01-05T23:54:21.910Z | 2024-01-05T23:54:21.910Z |
2203177 | 2203177 | 20230118015350_y6OBX | IL0001 | 2024-01-05T23:54:21.907Z | 2024-01-05T23:54:21.907Z |
2189867 | 2189867 | 20230111222704_RV42T | IL0001 | 2024-01-05T23:54:13.627Z | 2024-01-05T23:54:13.627Z |
2188285 | 2188285 | 20230111004128_DvS7e | IL0001 | 2024-01-05T23:54:12.330Z | 2024-01-05T23:54:12.330Z |
2188275 | 2188275 | 20230111003153_a9Je8 | IL0001 | 2024-01-05T23:54:12.329Z | 2024-01-05T23:54:12.329Z |
2179260 | 2179260 | 20230104024412_qA8y9 | IL0001 | 2024-01-05T23:54:03.260Z | 2024-01-05T23:54:03.260Z |
2170987 | 2170987 | 20221229213411_Dkok8 | IL0001 | 2024-01-05T23:53:56.578Z | 2024-01-05T23:53:56.578Z |
2168925 | 2168925 | 20221229025925_He84P | IL0001 | 2024-01-05T23:53:56.341Z | 2024-01-05T23:53:56.341Z |
2168919 | 2168919 | 20221229025535_bvjQQ | IL0001 | 2024-01-05T23:53:56.340Z | 2024-01-05T23:53:56.340Z |
2168863 | 2168863 | 20221229022603_i4XnP | IL0001 | 2024-01-05T23:53:56.334Z | 2024-01-05T23:53:56.334Z |
2166586 | 2166586 | 20221228012624_H7yjq | IL0001 | 2024-01-05T23:53:53.715Z | 2024-01-05T23:53:53.715Z |
2132667 | 2132667 | 20221219213349_w5u9g | IL0001 | 2024-01-05T23:53:40.141Z | 2024-01-05T23:53:40.141Z |
2128804 | 2128804 | 20221219022236_a7O88 | IL0001 | 2024-01-05T23:53:38.564Z | 2024-01-05T23:53:38.564Z |
2128621 | 2128621 | 20221219000136_QCHot | IL0001 | 2024-01-05T23:53:38.539Z | 2024-01-05T23:53:38.539Z |
2128563 | 2128563 | 20221218224850_2QQe1 | IL0001 | 2024-01-05T23:53:38.530Z | 2024-01-05T23:53:38.530Z |
2126273 | 2126273 | 20221218020849_JeYXB | IL0001 | 2024-01-05T23:53:36.975Z | 2024-01-05T23:53:36.975Z |
2126114 | 2126114 | 20221218013135_nBxx5 | IL0001 | 2024-01-05T23:53:36.958Z | 2024-01-05T23:53:36.958Z |
2126100 | 2126100 | 20221218013133_W2iKf | IL0001 | 2024-01-05T23:53:36.957Z | 2024-01-05T23:53:36.957Z |
2120550 | 2120550 | 20221217023844_wYVdm | IL0001 | 2024-01-05T23:53:34.980Z | 2024-01-05T23:53:34.980Z |
2120464 | 2120464 | 20221217021646_3VuhG | IL0001 | 2024-01-05T23:53:34.971Z | 2024-01-05T23:53:34.971Z |
2119672 | 2119672 | 20221216233553_vx4wz | IL0001 | 2024-01-05T23:53:34.896Z | 2024-01-05T23:53:34.896Z |
2112540 | 2112540 | 20221216003726_NZiK5 | IL0001 | 2024-01-05T23:53:32.884Z | 2024-01-05T23:53:32.884Z |
2111594 | 2111594 | 20221215231649_dcC3F | IL0001 | 2024-01-05T23:53:32.816Z | 2024-01-05T23:53:32.816Z |
2098568 | 2098568 | 20221215032937_3hRui | IL0001 | 2024-01-05T23:53:30.012Z | 2024-01-05T23:53:30.012Z |
2098487 | 2098487 | 20221215032851_iybei | IL0001 | 2024-01-05T23:53:30.007Z | 2024-01-05T23:53:30.007Z |
2098399 | 2098399 | 20221215032622_Vp23g | IL0001 | 2024-01-05T23:53:30.001Z | 2024-01-05T23:53:30.001Z |
2083753 | 2083753 | 20221214215744_lx9R2 | IL0001 | 2024-01-05T23:53:28.045Z | 2024-01-05T23:53:28.045Z |
2081611 | 2081611 | 20221214210324_N7kDn | IL0001 | 2024-01-05T23:53:27.893Z | 2024-01-05T23:53:27.893Z |
2017979 | 2017979 | 20221203232118_i2xgF | IL0001 | 2024-01-05T23:53:05.792Z | 2024-01-05T23:53:05.792Z |
2017850 | 2017850 | 20221203204141_yWndC | IL0001 | 2024-01-05T23:53:05.775Z | 2024-01-05T23:53:05.775Z |
2016501 | 2016501 | 20221203022142_mwEnY | IL0001 | 2024-01-05T23:53:04.418Z | 2024-01-05T23:53:04.418Z |
2016412 | 2016412 | 20221203012643_wP2iP | IL0001 | 2024-01-05T23:53:04.404Z | 2024-01-05T23:53:04.404Z |
2016408 | 2016408 | 20221203012327_u5I8o | IL0001 | 2024-01-05T23:53:04.403Z | 2024-01-05T23:53:04.403Z |
2016224 | 2016224 | 20221202210754_AeOb6 | IL0001 | 2024-01-05T23:53:04.371Z | 2024-01-05T23:53:04.371Z |
2014982 | 2014982 | 20221202014210_7cxtH | IL0001 | 2024-01-05T23:53:02.895Z | 2024-01-05T23:53:02.895Z |
2010134 | 2010134 | 20221201015801_oHd5I | IL0001 | 2024-01-05T23:53:00.901Z | 2024-01-05T23:53:00.901Z |
2009938 | 2009938 | 20221201001300_B7267 | IL0001 | 2024-01-05T23:53:00.839Z | 2024-01-05T23:53:00.839Z |
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);