participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,558 rows where station_code = "IL0004" 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 |
---|---|---|---|---|---|
5428406 | 5428406 | 20241028170732_Gnpdr | IL0004 | 2024-10-31T12:15:07.805Z | 2024-11-06T14:27:13.585Z |
4983323 | 4983323 | 20240812004322_gR3VR | IL0004 | 2024-09-06T12:15:26.888Z | 2024-09-06T12:15:26.888Z |
4982766 | 4982766 | 20240812003716_xL3GS | IL0004 | 2024-09-06T12:15:01.220Z | 2024-09-06T12:15:01.220Z |
4979259 | 4979259 | 20240812000042_6PwFs | IL0004 | 2024-09-06T12:13:07.407Z | 2024-09-06T12:13:07.407Z |
4969163 | 4969163 | 20240811220715_rJpcH | IL0004 | 2024-09-05T12:08:36.224Z | 2024-09-06T12:07:43.309Z |
4968651 | 4968651 | 20240811220046_bUuMO | IL0004 | 2024-09-05T12:08:23.900Z | 2024-09-06T12:07:33.718Z |
4965060 | 4965060 | 20240811210804_ZN2cM | IL0004 | 2024-09-04T12:06:46.217Z | 2024-09-06T12:05:46.833Z |
4964970 | 4964970 | 20240811210636_GBKqc | IL0004 | 2024-09-04T12:06:40.411Z | 2024-09-06T12:05:44.554Z |
4963793 | 4963793 | 20240811203526_wBCmd | IL0004 | 2024-09-04T12:05:55.847Z | 2024-09-06T12:04:56.181Z |
4963332 | 4963332 | 20240811200027_mzPJr | IL0004 | 2024-09-04T12:05:27.861Z | 2024-09-06T12:04:31.659Z |
4962594 | 4962594 | 20240811191101_faHRU | IL0004 | 2024-09-04T12:04:42.597Z | 2024-09-06T12:03:52.697Z |
4961720 | 4961720 | 20240811175843_G33Ps | IL0004 | 2024-09-04T12:03:52.153Z | 2024-09-06T12:03:11.701Z |
4946088 | 4946088 | 20240811005623_McwYo | IL0004 | 2024-09-02T12:13:35.062Z | 2024-09-06T12:26:14.254Z |
4944871 | 4944871 | 20240811003800_Sr9EP | IL0004 | 2024-09-02T12:12:53.224Z | 2024-09-06T12:25:40.674Z |
4940618 | 4940618 | 20240810231608_5BF6B | IL0004 | 2024-09-01T12:10:38.430Z | 2024-09-06T12:23:37.293Z |
4939611 | 4939611 | 20240810225116_N73il | IL0004 | 2024-09-01T12:09:56.433Z | 2024-09-06T12:23:25.239Z |
4935953 | 4935953 | 20240810205441_bZexA | IL0004 | 2024-09-01T12:07:02.248Z | 2024-09-06T12:21:09.589Z |
4935188 | 4935188 | 20240810194858_vop8k | IL0004 | 2024-09-01T12:06:11.167Z | 2024-09-06T12:20:31.077Z |
4926951 | 4926951 | 20240810020203_gOCVJ | IL0004 | 2024-08-31T12:20:10.850Z | 2024-09-02T12:28:12.940Z |
4926569 | 4926569 | 20240810015227_aKokZ | IL0004 | 2024-08-31T12:19:44.275Z | 2024-09-02T12:27:55.686Z |
4923162 | 4923162 | 20240810013428_B4Jir | IL0004 | 2024-08-30T12:15:10.103Z | 2024-09-02T12:27:36.597Z |
4915166 | 4915166 | 20240809224030_Gs7yk | IL0004 | 2024-08-30T12:09:44.089Z | 2024-09-02T12:23:51.256Z |
4911400 | 4911400 | 20240809200201_Zz15u | IL0004 | 2024-08-29T12:07:22.631Z | 2024-09-02T12:21:39.202Z |
4901248 | 4901248 | 20240808011710_5HN6y | IL0004 | 2024-08-28T12:18:39.051Z | 2024-08-28T12:18:39.051Z |
4900710 | 4900710 | 20240808004004_aqQKV | IL0004 | 2024-08-28T12:18:10.507Z | 2024-08-28T12:18:10.507Z |
4900529 | 4900529 | 20240808002748_v0pVt | IL0004 | 2024-08-28T12:18:06.111Z | 2024-08-28T12:18:06.111Z |
4899682 | 4899682 | 20240807231234_wpm5W | IL0004 | 2024-08-28T12:17:25.647Z | 2024-08-28T12:17:25.647Z |
4898352 | 4898352 | 20240807212855_U7StB | IL0004 | 2024-08-28T12:16:34.806Z | 2024-08-28T12:16:34.806Z |
4898162 | 4898162 | 20240807210452_ggqgw | IL0004 | 2024-08-28T12:16:19.089Z | 2024-08-28T12:16:19.089Z |
4897968 | 4897968 | 20240807202318_XUdmi | IL0004 | 2024-08-28T12:16:07.808Z | 2024-08-28T12:16:07.808Z |
4897949 | 4897949 | 20240807201404_AhfEi | IL0004 | 2024-08-28T12:16:07.095Z | 2024-08-28T12:16:07.095Z |
4891853 | 4891853 | 20240809014232_pngpp | IL0004 | 2024-08-28T12:09:31.251Z | 2024-08-30T12:21:27.111Z |
4891780 | 4891780 | 20240809013713_n2E5w | IL0004 | 2024-08-28T12:09:24.723Z | 2024-08-30T12:21:24.640Z |
4891532 | 4891532 | 20240809010952_zhy9q | IL0004 | 2024-08-28T12:09:08.705Z | 2024-08-30T12:21:17.152Z |
4891329 | 4891329 | 20240809004840_3mPyZ | IL0004 | 2024-08-28T12:08:53.186Z | 2024-08-30T12:21:09.546Z |
4890853 | 4890853 | 20240808235638_W0hys | IL0004 | 2024-08-28T12:08:14.093Z | 2024-08-30T12:20:35.646Z |
4889737 | 4889737 | 20240808214241_lIkX0 | IL0004 | 2024-08-28T12:06:40.508Z | 2024-08-30T12:19:33.994Z |
4889267 | 4889267 | 20240808203206_stla7 | IL0004 | 2024-08-28T12:05:52.726Z | 2024-08-30T12:19:01.490Z |
4881120 | 4881120 | 20240807013648_YTKpO | IL0004 | 2024-08-20T12:13:46.624Z | 2024-08-27T12:15:01.770Z |
4880389 | 4880389 | 20240807011907_NJHUm | IL0004 | 2024-08-20T12:13:25.015Z | 2024-08-27T12:14:42.430Z |
4879608 | 4879608 | 20240807005900_T4211 | IL0004 | 2024-08-20T12:12:57.106Z | 2024-08-27T12:14:17.069Z |
4878462 | 4878462 | 20240807002848_j7NZu | IL0004 | 2024-08-19T12:14:13.075Z | 2024-08-27T12:13:42.916Z |
4877468 | 4877468 | 20240807000432_Jhroz | IL0004 | 2024-08-19T12:13:34.828Z | 2024-08-27T12:13:12.351Z |
4876984 | 4876984 | 20240806235146_gHKhr | IL0004 | 2024-08-19T12:13:07.108Z | 2024-08-27T12:12:56.258Z |
4875015 | 4875015 | 20240806230326_1NQ4G | IL0004 | 2024-08-19T12:11:58.279Z | 2024-08-27T12:12:01.078Z |
4872250 | 4872250 | 20240806213745_KrUuf | IL0004 | 2024-08-19T12:09:55.182Z | 2024-08-27T12:10:24.040Z |
4856383 | 4856383 | 20240806012921_Y8XYG | IL0004 | 2024-08-17T12:21:07.840Z | 2024-08-19T12:27:23.475Z |
4855012 | 4855012 | 20240806001743_lS6lz | IL0004 | 2024-08-17T12:19:24.478Z | 2024-08-19T12:26:20.412Z |
4854918 | 4854918 | 20240806001225_Nj8Aw | IL0004 | 2024-08-17T12:19:19.961Z | 2024-08-19T12:26:15.792Z |
4851698 | 4851698 | 20240805212102_YXoDk | IL0004 | 2024-08-17T12:15:11.745Z | 2024-08-19T12:24:08.723Z |
4851655 | 4851655 | 20240805211903_SYqUI | IL0004 | 2024-08-17T12:15:08.383Z | 2024-08-19T12:24:07.649Z |
4835641 | 4835641 | 20240805014745_ANxge | IL0004 | 2024-08-15T12:15:33.629Z | 2024-08-17T12:32:14.363Z |
4834204 | 4834204 | 20240805004927_5yOld | IL0004 | 2024-08-15T12:14:35.014Z | 2024-08-17T12:31:52.322Z |
4832937 | 4832937 | 20240804235710_45MLR | IL0004 | 2024-08-15T12:13:19.146Z | 2024-08-17T12:31:18.314Z |
4832425 | 4832425 | 20240804233317_NZ0hl | IL0004 | 2024-08-15T12:13:00.067Z | 2024-08-17T12:31:03.933Z |
4829605 | 4829605 | 20240804201906_MzU2y | IL0004 | 2024-08-15T12:09:04.916Z | 2024-08-17T12:29:13.940Z |
4825664 | 4825664 | 20240804013347_SmZPE | IL0004 | 2024-08-14T12:20:17.266Z | 2024-08-15T12:25:57.253Z |
4824309 | 4824309 | 20240803234414_8hRZ6 | IL0004 | 2024-08-14T12:18:59.221Z | 2024-08-15T12:25:22.286Z |
4823237 | 4823237 | 20240803222838_qgV20 | IL0004 | 2024-08-14T12:18:01.865Z | 2024-08-15T12:24:51.343Z |
4823077 | 4823077 | 20240803221032_iX7GV | IL0004 | 2024-08-14T12:17:51.405Z | 2024-08-15T12:24:45.582Z |
4822109 | 4822109 | 20240803210150_EBoBb | IL0004 | 2024-08-14T12:16:38.870Z | 2024-08-15T12:24:10.114Z |
4821849 | 4821849 | 20240803203520_1cwiy | IL0004 | 2024-08-14T12:16:08.242Z | 2024-08-15T12:23:58.906Z |
4821326 | 4821326 | 20240803194357_ZNaZf | IL0004 | 2024-08-14T12:15:22.343Z | 2024-08-15T12:23:37.584Z |
4817220 | 4817220 | 20240803184849_Zj8KW | IL0004 | 2024-08-13T12:14:55.539Z | 2024-08-15T12:23:17.616Z |
4805081 | 4805081 | 20240802233512_DpPaG | IL0004 | 2024-08-12T12:17:22.451Z | 2024-08-13T12:17:08.711Z |
4804806 | 4804806 | 20240802231030_nJKgq | IL0004 | 2024-08-12T12:17:01.103Z | 2024-08-13T12:17:03.144Z |
4804483 | 4804483 | 20240802223622_RrI2j | IL0004 | 2024-08-12T12:16:30.864Z | 2024-08-13T12:16:57.522Z |
4795327 | 4795327 | 20240802012202_sCAqF | IL0004 | 2024-08-11T12:15:22.794Z | 2024-08-11T12:15:22.794Z |
4784405 | 4784405 | 20240801232609_Y9xAI | IL0004 | 2024-08-10T12:15:00.981Z | 2024-08-11T12:14:28.698Z |
4782975 | 4782975 | 20240801215130_rNRfv | IL0004 | 2024-08-10T12:13:05.942Z | 2024-08-11T12:13:58.064Z |
4782734 | 4782734 | 20240801212718_EjlZ0 | IL0004 | 2024-08-10T12:12:38.369Z | 2024-08-11T12:13:52.260Z |
4779692 | 4779692 | 20240801010731_ULVjQ | IL0004 | 2024-08-07T12:14:36.554Z | 2024-08-10T12:21:36.431Z |
4779595 | 4779595 | 20240801005347_MDmGp | IL0004 | 2024-08-07T12:14:33.624Z | 2024-08-10T12:21:33.715Z |
4779222 | 4779222 | 20240801002047_VBwCC | IL0004 | 2024-08-07T12:14:21.003Z | 2024-08-10T12:21:24.521Z |
4779219 | 4779219 | 20240801002042_GGJWY | IL0004 | 2024-08-07T12:14:20.999Z | 2024-08-10T12:21:24.499Z |
4769756 | 4769756 | 20240731212334_klOfB | IL0004 | 2024-08-06T12:11:10.983Z | 2024-08-10T12:20:42.857Z |
4761236 | 4761236 | 20240731001153_VTeHU | IL0004 | 2024-08-05T12:16:29.694Z | 2024-08-08T12:25:02.218Z |
4759869 | 4759869 | 20240730231241_wuxw0 | IL0004 | 2024-08-05T12:15:38.131Z | 2024-08-08T12:24:17.556Z |
4758977 | 4758977 | 20240730222823_qU82g | IL0004 | 2024-08-05T12:14:50.460Z | 2024-08-08T12:23:47.504Z |
4758075 | 4758075 | 20240730213728_kS3Lj | IL0004 | 2024-08-05T12:14:02.238Z | 2024-08-08T12:23:13.696Z |
4757635 | 4757635 | 20240730210148_4HoIi | IL0004 | 2024-08-05T12:13:32.458Z | 2024-08-08T12:22:56.378Z |
4757541 | 4757541 | 20240730205121_qtcwj | IL0004 | 2024-08-05T12:13:27.022Z | 2024-08-08T12:22:52.258Z |
4757450 | 4757450 | 20240730204008_2q62F | IL0004 | 2024-08-05T12:13:19.065Z | 2024-08-08T12:22:47.280Z |
4757149 | 4757149 | 20240730195628_ibwdb | IL0004 | 2024-08-05T12:12:55.860Z | 2024-08-08T12:22:34.016Z |
4748004 | 4748004 | 20240729215814_bDWJ9 | IL0004 | 2024-08-04T12:14:59.158Z | 2024-08-06T12:15:23.640Z |
4747259 | 4747259 | 20240729210746_qY0A4 | IL0004 | 2024-08-04T12:14:37.668Z | 2024-08-06T12:15:20.246Z |
4742637 | 4742637 | 20240730005650_286Q7 | IL0004 | 2024-08-04T12:03:36.117Z | 2024-08-08T12:17:17.743Z |
4740741 | 4740741 | 20240729204959_j0r04 | IL0004 | 2024-08-03T12:12:46.245Z | 2024-08-06T12:15:19.354Z |
4730918 | 4730918 | 20240729002315_822LR | IL0004 | 2024-08-01T12:01:55.048Z | 2024-08-06T12:14:39.011Z |
4730513 | 4730513 | 20240729001320_W257t | IL0004 | 2024-08-01T12:01:29.870Z | 2024-08-06T12:14:36.932Z |
4729886 | 4729886 | 20240728230005_JbJv7 | IL0004 | 2024-07-31T12:13:59.684Z | 2024-08-05T12:20:33.026Z |
4726944 | 4726944 | 20240728191958_VUPGm | IL0004 | 2024-07-31T12:12:41.896Z | 2024-08-05T12:20:24.528Z |
4726702 | 4726702 | 20240728182740_UWeQ5 | IL0004 | 2024-07-31T12:12:36.699Z | 2024-08-05T12:20:24.101Z |
4720973 | 4720973 | 20240728234042_avGk1 | IL0004 | 2024-07-31T12:01:53.337Z | 2024-08-06T12:14:34.008Z |
4714680 | 4714680 | 20240728004419_eI5S3 | IL0004 | 2024-07-30T12:05:22.367Z | 2024-08-05T12:19:41.078Z |
4712137 | 4712137 | 20240727201924_ITf9F | IL0004 | 2024-07-29T12:12:51.678Z | 2024-08-04T12:20:06.965Z |
4711983 | 4711983 | 20240727185431_a77Xv | IL0004 | 2024-07-29T12:12:34.066Z | 2024-08-04T12:20:04.072Z |
4706388 | 4706388 | 20240727234517_24bti | IL0004 | 2024-07-29T12:03:12.226Z | 2024-08-05T12:19:34.511Z |
4695142 | 4695142 | 20240726212822_vPchD | IL0004 | 2024-07-28T12:00:40.814Z | 2024-08-04T12:19:06.368Z |
4695019 | 4695019 | 20240726205656_C3cgH | IL0004 | 2024-07-28T12:00:20.189Z | 2024-08-04T12:19:05.750Z |
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);