participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,557 rows where station_code = "IL0002" 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 |
---|---|---|---|---|---|
5128578 | 5128578 | 20240917020705_mdbrC | IL0002 | 2024-09-19T12:10:45.568Z | 2024-09-19T12:10:45.568Z |
5104331 | 5104331 | 20240913020522_vQwo9 | IL0002 | 2024-09-17T12:11:33.424Z | 2024-09-19T12:20:41.404Z |
5104249 | 5104249 | 20240913020102_7vdO8 | IL0002 | 2024-09-17T12:11:30.815Z | 2024-09-19T12:20:41.293Z |
5099369 | 5099369 | 20240913210557_mF3lG | IL0002 | 2024-09-17T12:02:49.496Z | 2024-09-19T12:19:44.619Z |
5099335 | 5099335 | 20240913210337_EWyjm | IL0002 | 2024-09-17T12:02:47.749Z | 2024-09-19T12:19:44.558Z |
5098751 | 5098751 | 20240913192004_3PIfr | IL0002 | 2024-09-17T12:01:30.324Z | 2024-09-19T12:19:40.522Z |
5091928 | 5091928 | 20240912022850_IBY9T | IL0002 | 2024-09-16T12:13:31.528Z | 2024-09-19T12:21:13.492Z |
5087242 | 5087242 | 20240912231728_oec1Z | IL0002 | 2024-09-16T12:06:48.430Z | 2024-09-19T12:20:34.366Z |
5087178 | 5087178 | 20240912231423_kX1cb | IL0002 | 2024-09-16T12:06:45.399Z | 2024-09-19T12:20:34.136Z |
5084849 | 5084849 | 20240912202128_cn1jA | IL0002 | 2024-09-16T12:03:01.724Z | 2024-09-19T12:20:27.324Z |
5078533 | 5078533 | 20240911020310_4U8Ny | IL0002 | 2024-09-15T12:15:42.879Z | 2024-09-19T12:21:40.497Z |
5077668 | 5077668 | 20240911010934_wHKyc | IL0002 | 2024-09-15T12:14:57.390Z | 2024-09-19T12:21:39.491Z |
5076662 | 5076662 | 20240910235755_CPuWL | IL0002 | 2024-09-15T12:13:53.201Z | 2024-09-19T12:21:37.447Z |
5076127 | 5076127 | 20240910230816_GFKjn | IL0002 | 2024-09-15T12:13:18.746Z | 2024-09-19T12:21:36.471Z |
5075800 | 5075800 | 20240912000805_FGwEd | IL0002 | 2024-09-15T12:10:14.555Z | 2024-09-19T12:21:09.527Z |
5075353 | 5075353 | 20240911234239_tm3cG | IL0002 | 2024-09-15T12:09:37.482Z | 2024-09-19T12:21:09.154Z |
5074898 | 5074898 | 20240911231444_PC6US | IL0002 | 2024-09-15T12:09:12.192Z | 2024-09-19T12:21:07.897Z |
5074611 | 5074611 | 20240911224910_NBRrq | IL0002 | 2024-09-15T12:08:39.447Z | 2024-09-19T12:21:07.532Z |
5073666 | 5073666 | 20240911213845_k2GzS | IL0002 | 2024-09-15T12:07:32.016Z | 2024-09-19T12:21:06.136Z |
5073220 | 5073220 | 20240911210623_XbI2j | IL0002 | 2024-09-15T12:06:55.771Z | 2024-09-19T12:21:05.256Z |
5072041 | 5072041 | 20240911192544_lNCiP | IL0002 | 2024-09-15T12:04:31.448Z | 2024-09-19T12:21:03.354Z |
5064764 | 5064764 | 20240910015948_ZVZlE | IL0002 | 2024-09-14T12:16:00.321Z | 2024-09-18T12:15:17.291Z |
5064195 | 5064195 | 20240910001749_eGT3A | IL0002 | 2024-09-14T12:15:03.129Z | 2024-09-18T12:15:15.771Z |
5063992 | 5063992 | 20240909231643_HqFJi | IL0002 | 2024-09-14T12:14:37.777Z | 2024-09-18T12:15:15.152Z |
5063979 | 5063979 | 20240909231341_Nt3cy | IL0002 | 2024-09-14T12:14:35.634Z | 2024-09-18T12:15:15.103Z |
5063625 | 5063625 | 20240909220007_8m09o | IL0002 | 2024-09-14T12:14:09.635Z | 2024-09-18T12:15:14.308Z |
5063599 | 5063599 | 20240909215508_9E7lx | IL0002 | 2024-09-14T12:14:08.413Z | 2024-09-18T12:15:14.287Z |
5062915 | 5062915 | 20240909190125_6Rn4t | IL0002 | 2024-09-14T12:13:02.770Z | 2024-09-18T12:15:12.494Z |
5062851 | 5062851 | 20240909184202_nqTWC | IL0002 | 2024-09-14T12:12:58.673Z | 2024-09-18T12:15:12.309Z |
5060395 | 5060395 | 20240910202707_SEzts | IL0002 | 2024-09-14T12:08:44.429Z | 2024-09-19T12:21:32.337Z |
5054091 | 5054091 | 20240908020856_m3RtX | IL0002 | 2024-09-13T12:16:29.247Z | 2024-09-16T12:21:13.942Z |
5053493 | 5053493 | 20240908004537_Zh3hQ | IL0002 | 2024-09-13T12:16:06.382Z | 2024-09-16T12:21:11.642Z |
5052843 | 5052843 | 20240907221957_LomOv | IL0002 | 2024-09-13T12:15:31.715Z | 2024-09-16T12:21:08.216Z |
5052204 | 5052204 | 20240907195834_LdwxP | IL0002 | 2024-09-13T12:14:59.946Z | 2024-09-16T12:21:04.536Z |
5047004 | 5047004 | 20240909021317_2Eer0 | IL0002 | 2024-09-13T12:08:07.192Z | 2024-09-17T12:19:00.704Z |
5046868 | 5046868 | 20240909014242_U72y0 | IL0002 | 2024-09-13T12:07:45.456Z | 2024-09-17T12:19:00.525Z |
5046302 | 5046302 | 20240908223728_Ik7xh | IL0002 | 2024-09-13T12:06:20.491Z | 2024-09-17T12:18:59.020Z |
5046263 | 5046263 | 20240908222515_dc65i | IL0002 | 2024-09-13T12:06:15.915Z | 2024-09-17T12:18:58.834Z |
5046241 | 5046241 | 20240908220911_Z9jjl | IL0002 | 2024-09-13T12:06:11.083Z | 2024-09-17T12:18:58.789Z |
5045793 | 5045793 | 20240908192658_tq6pH | IL0002 | 2024-09-13T12:04:58.272Z | 2024-09-17T12:18:57.366Z |
5039622 | 5039622 | 20240906013542_K29Q2 | IL0002 | 2024-09-12T12:15:39.240Z | 2024-09-14T12:23:03.790Z |
5039473 | 5039473 | 20240906010722_OXbvC | IL0002 | 2024-09-12T12:15:34.168Z | 2024-09-14T12:23:02.377Z |
5039112 | 5039112 | 20240905232256_zW2DE | IL0002 | 2024-09-12T12:15:15.951Z | 2024-09-14T12:23:00.115Z |
5039086 | 5039086 | 20240905231832_4K2GB | IL0002 | 2024-09-12T12:15:15.036Z | 2024-09-14T12:23:00.063Z |
5039030 | 5039030 | 20240905230828_taGix | IL0002 | 2024-09-12T12:15:13.295Z | 2024-09-14T12:22:59.881Z |
5038944 | 5038944 | 20240905224433_5kmJB | IL0002 | 2024-09-12T12:15:08.463Z | 2024-09-14T12:22:59.511Z |
5038869 | 5038869 | 20240905222402_YI2eM | IL0002 | 2024-09-12T12:15:05.560Z | 2024-09-14T12:22:58.899Z |
5038394 | 5038394 | 20240905195504_EoOUV | IL0002 | 2024-09-12T12:14:38.088Z | 2024-09-14T12:22:55.930Z |
5032998 | 5032998 | 20240907021231_Xo0hC | IL0002 | 2024-09-12T12:08:42.280Z | 2024-09-15T12:21:28.771Z |
5032968 | 5032968 | 20240907020809_CcsID | IL0002 | 2024-09-12T12:08:39.701Z | 2024-09-15T12:21:28.656Z |
5032627 | 5032627 | 20240907012250_ca2MN | IL0002 | 2024-09-12T12:07:46.329Z | 2024-09-15T12:21:27.166Z |
5032277 | 5032277 | 20240907003923_gy6bD | IL0002 | 2024-09-12T12:07:02.794Z | 2024-09-15T12:21:25.789Z |
5032183 | 5032183 | 20240907002430_uqTtN | IL0002 | 2024-09-12T12:06:42.583Z | 2024-09-15T12:21:25.468Z |
5031795 | 5031795 | 20240906231839_Zc2Hg | IL0002 | 2024-09-12T12:05:49.209Z | 2024-09-15T12:21:24.322Z |
5031403 | 5031403 | 20240906214253_0mrDO | IL0002 | 2024-09-12T12:04:42.641Z | 2024-09-15T12:21:22.217Z |
5031206 | 5031206 | 20240906205313_oa93z | IL0002 | 2024-09-12T12:04:17.922Z | 2024-09-15T12:21:21.723Z |
5030816 | 5030816 | 20240906185151_qynUq | IL0002 | 2024-09-12T12:03:09.328Z | 2024-09-15T12:21:19.879Z |
5025281 | 5025281 | 20240906013542_Ia52g | IL0002 | 2024-09-11T12:06:08.565Z | 2024-09-11T12:16:32.557Z |
5025123 | 5025123 | 20240906010722_Q8fEK | IL0002 | 2024-09-11T12:05:40.133Z | 2024-09-11T12:16:32.484Z |
5024705 | 5024705 | 20240905232256_YmoQf | IL0002 | 2024-09-11T12:04:32.057Z | 2024-09-11T12:16:32.271Z |
5024676 | 5024676 | 20240905231832_cuj2P | IL0002 | 2024-09-11T12:04:25.033Z | 2024-09-11T12:16:32.258Z |
5024613 | 5024613 | 20240905230828_9SwmJ | IL0002 | 2024-09-11T12:04:14.715Z | 2024-09-11T12:16:32.228Z |
5024525 | 5024525 | 20240905224433_wKJEB | IL0002 | 2024-09-11T12:04:00.824Z | 2024-09-11T12:16:32.180Z |
5024448 | 5024448 | 20240905222402_bh7Gb | IL0002 | 2024-09-11T12:03:45.003Z | 2024-09-11T12:16:32.142Z |
5019729 | 5019729 | 20240904234325_cFDhs | IL0002 | 2024-09-10T12:13:20.582Z | 2024-09-13T12:19:53.624Z |
5019322 | 5019322 | 20240904223203_PxQY7 | IL0002 | 2024-09-10T12:12:37.049Z | 2024-09-13T12:19:51.390Z |
5018672 | 5018672 | 20240904192958_EhKz3 | IL0002 | 2024-09-10T12:11:10.739Z | 2024-09-13T12:19:48.470Z |
5008422 | 5008422 | 20240903234220_Hq13u | IL0002 | 2024-09-09T12:06:43.683Z | 2024-09-12T12:19:17.546Z |
5007579 | 5007579 | 20240903214717_Mj2G5 | IL0002 | 2024-09-09T12:05:54.818Z | 2024-09-12T12:19:13.946Z |
5006512 | 5006512 | 20240903174522_Bq6VH | IL0002 | 2024-09-09T12:04:43.448Z | 2024-09-12T12:19:08.521Z |
4998128 | 4998128 | 20240903021705_ReZ0u | IL0002 | 2024-09-08T12:07:16.209Z | 2024-09-11T12:21:11.084Z |
4998025 | 4998025 | 20240903020535_0YcQG | IL0002 | 2024-09-08T12:07:04.647Z | 2024-09-11T12:21:10.597Z |
4998017 | 4998017 | 20240903020357_AsIn6 | IL0002 | 2024-09-08T12:07:04.220Z | 2024-09-11T12:21:10.560Z |
4997939 | 4997939 | 20240903014824_4k6Sy | IL0002 | 2024-09-08T12:06:59.112Z | 2024-09-11T12:21:10.056Z |
4997799 | 4997799 | 20240903012928_xiToz | IL0002 | 2024-09-08T12:06:49.516Z | 2024-09-11T12:21:09.037Z |
4997725 | 4997725 | 20240903011454_2jmHu | IL0002 | 2024-09-08T12:06:43.707Z | 2024-09-11T12:21:08.013Z |
4997231 | 4997231 | 20240902232927_hnGqP | IL0002 | 2024-09-08T12:05:55.631Z | 2024-09-11T12:21:02.387Z |
4997016 | 4997016 | 20240902223418_icQy8 | IL0002 | 2024-09-08T12:05:36.021Z | 2024-09-11T12:21:00.136Z |
4996726 | 4996726 | 20240902204341_E9Sah | IL0002 | 2024-09-08T12:05:12.753Z | 2024-09-11T12:20:57.597Z |
4996487 | 4996487 | 20240902194643_Bo1uP | IL0002 | 2024-09-08T12:04:51.936Z | 2024-09-11T12:20:54.877Z |
4995817 | 4995817 | 20240902175735_RAHPw | IL0002 | 2024-09-08T12:04:06.096Z | 2024-09-11T12:20:48.612Z |
4983322 | 4983322 | 20240812004322_gR3VR | IL0002 | 2024-09-06T12:15:26.888Z | 2024-09-06T12:15:26.888Z |
4982765 | 4982765 | 20240812003716_xL3GS | IL0002 | 2024-09-06T12:15:01.220Z | 2024-09-06T12:15:01.220Z |
4979258 | 4979258 | 20240812000042_6PwFs | IL0002 | 2024-09-06T12:13:07.407Z | 2024-09-06T12:13:07.407Z |
4969162 | 4969162 | 20240811220715_rJpcH | IL0002 | 2024-09-05T12:08:36.224Z | 2024-09-06T12:07:43.309Z |
4965059 | 4965059 | 20240811210804_ZN2cM | IL0002 | 2024-09-04T12:06:46.217Z | 2024-09-06T12:05:46.833Z |
4964969 | 4964969 | 20240811210636_GBKqc | IL0002 | 2024-09-04T12:06:40.411Z | 2024-09-06T12:05:44.554Z |
4963792 | 4963792 | 20240811203526_wBCmd | IL0002 | 2024-09-04T12:05:55.847Z | 2024-09-06T12:04:56.181Z |
4963331 | 4963331 | 20240811200027_mzPJr | IL0002 | 2024-09-04T12:05:27.861Z | 2024-09-06T12:04:31.659Z |
4962593 | 4962593 | 20240811191101_faHRU | IL0002 | 2024-09-04T12:04:42.597Z | 2024-09-06T12:03:52.697Z |
4946087 | 4946087 | 20240811005623_McwYo | IL0002 | 2024-09-02T12:13:35.050Z | 2024-09-06T12:26:14.254Z |
4944870 | 4944870 | 20240811003800_Sr9EP | IL0002 | 2024-09-02T12:12:53.218Z | 2024-09-06T12:25:40.674Z |
4939610 | 4939610 | 20240810225116_N73il | IL0002 | 2024-09-01T12:09:56.433Z | 2024-09-06T12:23:25.239Z |
4935952 | 4935952 | 20240810205441_bZexA | IL0002 | 2024-09-01T12:07:02.248Z | 2024-09-06T12:21:09.589Z |
4935187 | 4935187 | 20240810194858_vop8k | IL0002 | 2024-09-01T12:06:11.158Z | 2024-09-06T12:20:31.077Z |
4926950 | 4926950 | 20240810020203_gOCVJ | IL0002 | 2024-08-31T12:20:10.850Z | 2024-09-02T12:28:12.940Z |
4926568 | 4926568 | 20240810015227_aKokZ | IL0002 | 2024-08-31T12:19:44.253Z | 2024-09-02T12:27:55.686Z |
4923161 | 4923161 | 20240810013428_B4Jir | IL0002 | 2024-08-30T12:15:10.103Z | 2024-09-02T12:27:36.597Z |
4915165 | 4915165 | 20240809224030_Gs7yk | IL0002 | 2024-08-30T12:09:44.086Z | 2024-09-02T12:23:51.256Z |
4911399 | 4911399 | 20240809200201_Zz15u | IL0002 | 2024-08-29T12:07:22.623Z | 2024-09-02T12:21:39.201Z |
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);