participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
124 rows where station_code = "IL0009" 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 |
---|---|---|---|---|---|
5556783 | 5556783 | 20241119014859_xfSYB | IL0009 | 2024-11-20T14:11:27.900Z | 2024-11-22T14:22:19.926Z |
5504773 | 5504773 | 20241108025507_rOUNr | IL0009 | 2024-11-09T14:15:10.244Z | 2024-11-16T14:28:23.372Z |
5496959 | 5496959 | 20241107021847_LDdlq | IL0009 | 2024-11-08T14:13:00.940Z | 2024-11-15T14:25:01.060Z |
5453523 | 5453523 | 20241031021841_SsD1r | IL0009 | 2024-11-02T12:22:35.171Z | 2024-11-08T14:23:17.852Z |
5387091 | 5387091 | 20241025015920_NzxIm | IL0009 | 2024-10-27T12:20:52.043Z | 2024-11-02T12:28:32.112Z |
5365906 | 5365906 | 20241023235545_22bij | IL0009 | 2024-10-25T12:18:10.257Z | 2024-11-01T12:26:56.483Z |
5351262 | 5351262 | 20241022231154_4q7ux | IL0009 | 2024-10-24T12:17:22.886Z | 2024-10-31T12:29:59.715Z |
5316957 | 5316957 | 20241016021151_Kedb3 | IL0009 | 2024-10-17T12:07:26.523Z | 2024-10-24T12:27:58.457Z |
5191393 | 5191393 | 20240928195747_3qgB2 | IL0009 | 2024-09-30T12:17:44.244Z | 2024-10-06T12:28:22.563Z |
5038395 | 5038395 | 20240905195504_EoOUV | IL0009 | 2024-09-12T12:14:38.088Z | 2024-09-14T12:22:55.930Z |
4968652 | 4968652 | 20240811220046_bUuMO | IL0009 | 2024-09-05T12:08:23.912Z | 2024-09-06T12:07:33.718Z |
4964971 | 4964971 | 20240811210636_GBKqc | IL0009 | 2024-09-04T12:06:40.411Z | 2024-09-06T12:05:44.554Z |
4963794 | 4963794 | 20240811203526_wBCmd | IL0009 | 2024-09-04T12:05:55.847Z | 2024-09-06T12:04:56.181Z |
4961721 | 4961721 | 20240811175843_G33Ps | IL0009 | 2024-09-04T12:03:52.162Z | 2024-09-06T12:03:11.701Z |
4940619 | 4940619 | 20240810231608_5BF6B | IL0009 | 2024-09-01T12:10:38.430Z | 2024-09-06T12:23:37.293Z |
4901249 | 4901249 | 20240808011710_5HN6y | IL0009 | 2024-08-28T12:18:39.051Z | 2024-08-28T12:18:39.051Z |
4899683 | 4899683 | 20240807231234_wpm5W | IL0009 | 2024-08-28T12:17:25.647Z | 2024-08-28T12:17:25.647Z |
4897969 | 4897969 | 20240807202318_XUdmi | IL0009 | 2024-08-28T12:16:07.808Z | 2024-08-28T12:16:07.808Z |
4891330 | 4891330 | 20240809004840_3mPyZ | IL0009 | 2024-08-28T12:08:53.186Z | 2024-08-30T12:21:09.546Z |
4881121 | 4881121 | 20240807013648_YTKpO | IL0009 | 2024-08-20T12:13:46.624Z | 2024-08-27T12:15:01.770Z |
4879609 | 4879609 | 20240807005900_T4211 | IL0009 | 2024-08-20T12:12:57.106Z | 2024-08-27T12:14:17.069Z |
4878463 | 4878463 | 20240807002848_j7NZu | IL0009 | 2024-08-19T12:14:13.075Z | 2024-08-27T12:13:42.916Z |
4872251 | 4872251 | 20240806213745_KrUuf | IL0009 | 2024-08-19T12:09:55.182Z | 2024-08-27T12:10:24.040Z |
4851699 | 4851699 | 20240805212102_YXoDk | IL0009 | 2024-08-17T12:15:11.745Z | 2024-08-19T12:24:08.723Z |
4825665 | 4825665 | 20240804013347_SmZPE | IL0009 | 2024-08-14T12:20:17.266Z | 2024-08-15T12:25:57.253Z |
4823238 | 4823238 | 20240803222838_qgV20 | IL0009 | 2024-08-14T12:18:01.865Z | 2024-08-15T12:24:51.343Z |
4784406 | 4784406 | 20240801232609_Y9xAI | IL0009 | 2024-08-10T12:15:00.981Z | 2024-08-11T12:14:28.698Z |
4779220 | 4779220 | 20240801002042_GGJWY | IL0009 | 2024-08-07T12:14:21.000Z | 2024-08-10T12:21:24.499Z |
4758076 | 4758076 | 20240730213728_kS3Lj | IL0009 | 2024-08-05T12:14:02.238Z | 2024-08-08T12:23:13.696Z |
4757542 | 4757542 | 20240730205121_qtcwj | IL0009 | 2024-08-05T12:13:27.022Z | 2024-08-08T12:22:52.258Z |
4757150 | 4757150 | 20240730195628_ibwdb | IL0009 | 2024-08-05T12:12:55.863Z | 2024-08-08T12:22:34.016Z |
4747260 | 4747260 | 20240729210746_qY0A4 | IL0009 | 2024-08-04T12:14:37.668Z | 2024-08-06T12:15:20.246Z |
4695143 | 4695143 | 20240726212822_vPchD | IL0009 | 2024-07-28T12:00:40.814Z | 2024-08-04T12:19:06.368Z |
4333792 | 4333792 | 20240509003731_AStJk | IL0009 | 2024-05-18T12:10:33.595Z | 2024-05-19T12:15:02.355Z |
4322066 | 4322066 | 20240508005357_IYm51 | IL0009 | 2024-05-16T12:10:03.067Z | 2024-05-17T12:12:27.565Z |
4318211 | 4318211 | 20240507173119_2TBDS | IL0009 | 2024-05-16T12:04:43.958Z | 2024-05-17T12:11:07.404Z |
4303016 | 4303016 | 20240506010913_W82ed | IL0009 | 2024-05-09T12:09:30.738Z | 2024-05-14T12:14:40.425Z |
4303006 | 4303006 | 20240506010633_cyytD | IL0009 | 2024-05-09T12:09:29.871Z | 2024-05-14T12:14:40.421Z |
3807821 | 3807821 | 20240113031318_M6X2N | IL0009 | 2024-01-15T14:01:17.453Z | 2024-01-22T14:21:44.713Z |
3801361 | 3801361 | 20240111023938_CR0LV | IL0009 | 2024-01-14T14:00:38.022Z | 2024-01-20T14:22:36.283Z |
3791159 | 3791159 | 20240110003426_tC3mX | IL0009 | 2024-01-12T14:13:03.039Z | 2024-01-18T14:26:03.520Z |
3790042 | 3790042 | 20240109213143_XdApQ | IL0009 | 2024-01-12T14:11:31.150Z | 2024-01-18T14:25:55.860Z |
3769237 | 3769237 | 20240107013306_cy83q | IL0009 | 2024-01-09T14:13:20.877Z | 2024-01-15T14:24:27.621Z |
3769057 | 3769057 | 20240107010434_fj7Xk | IL0009 | 2024-01-09T14:13:01.876Z | 2024-01-15T14:24:26.060Z |
3767211 | 3767211 | 20240106175414_WuIXk | IL0009 | 2024-01-09T14:09:13.512Z | 2024-01-15T14:24:17.247Z |
3761798 | 3761798 | 20240105191901_L3IMl | IL0009 | 2024-01-08T14:13:35.235Z | 2024-01-14T14:23:16.653Z |
3760737 | 3760737 | 20240105160906_3CKL2 | IL0009 | 2024-01-08T14:11:53.248Z | 2024-01-14T14:23:13.038Z |
3755891 | 3755891 | 20240103025356_9pFQK | IL0009 | 2024-01-07T14:19:21.284Z | 2024-01-11T14:38:39.896Z |
3755809 | 3755809 | 20240103232958_ckkQ3 | IL0009 | 2024-01-07T14:16:11.646Z | 2024-01-12T14:25:24.778Z |
3755807 | 3755807 | 20240103230302_YKZU5 | IL0009 | 2024-01-07T14:16:08.974Z | 2024-01-12T14:25:24.422Z |
3726894 | 3726894 | 20231231210320_O8Nx4 | IL0009 | 2024-01-06T00:06:08.944Z | 2024-01-09T14:31:38.329Z |
3724753 | 3724753 | 20231230205504_XIqVO | IL0009 | 2024-01-06T00:06:07.355Z | 2024-01-08T14:25:26.051Z |
3714442 | 3714442 | 20231225025557_dLM2w | IL0009 | 2024-01-06T00:05:57.216Z | 2024-01-06T00:05:57.216Z |
3704583 | 3704583 | 20231221211350_fumoK | IL0009 | 2024-01-06T00:05:51.982Z | 2024-01-06T00:05:51.982Z |
3704493 | 3704493 | 20231221210637_N96wz | IL0009 | 2024-01-06T00:05:51.971Z | 2024-01-06T00:05:51.971Z |
3692268 | 3692268 | 20231219233505_TrGXx | IL0009 | 2024-01-06T00:05:44.497Z | 2024-01-06T00:05:44.497Z |
3691773 | 3691773 | 20231219224231_uzgL6 | IL0009 | 2024-01-06T00:05:44.330Z | 2024-01-06T00:05:44.330Z |
3691494 | 3691494 | 20231219214849_9eJeA | IL0009 | 2024-01-06T00:05:44.251Z | 2024-01-06T00:05:44.251Z |
3687401 | 3687401 | 20231218232206_O3o6H | IL0009 | 2024-01-06T00:05:40.779Z | 2024-01-06T00:05:40.779Z |
3687328 | 3687328 | 20231218224932_Oe5an | IL0009 | 2024-01-06T00:05:40.756Z | 2024-01-06T00:05:40.756Z |
3682068 | 3682068 | 20231218000236_jKBn6 | IL0009 | 2024-01-06T00:05:38.237Z | 2024-01-06T00:05:38.237Z |
3665019 | 3665019 | 20231216003712_WYxGz | IL0009 | 2024-01-06T00:05:33.667Z | 2024-01-06T00:05:33.667Z |
3664061 | 3664061 | 20231215211801_H35kG | IL0009 | 2024-01-06T00:05:33.542Z | 2024-01-06T00:05:33.542Z |
3617757 | 3617757 | 20231214025829_P2Y0s | IL0009 | 2024-01-06T00:05:23.477Z | 2024-01-06T00:05:23.477Z |
3617190 | 3617190 | 20231214023604_VCTXA | IL0009 | 2024-01-06T00:05:23.408Z | 2024-01-06T00:05:23.408Z |
3616977 | 3616977 | 20231214022849_6yD98 | IL0009 | 2024-01-06T00:05:23.386Z | 2024-01-06T00:05:23.386Z |
3616900 | 3616900 | 20231214022436_LLW48 | IL0009 | 2024-01-06T00:05:23.376Z | 2024-01-06T00:05:23.376Z |
3616856 | 3616856 | 20231214022220_vkr2V | IL0009 | 2024-01-06T00:05:23.371Z | 2024-01-06T00:05:23.371Z |
3616756 | 3616756 | 20231214021958_3Hpmz | IL0009 | 2024-01-06T00:05:23.359Z | 2024-01-06T00:05:23.359Z |
3616750 | 3616750 | 20231214021923_ZuBlL | IL0009 | 2024-01-06T00:05:23.358Z | 2024-01-06T00:05:23.358Z |
3584421 | 3584421 | 20231212171554_ynmTe | IL0009 | 2024-01-06T00:05:17.388Z | 2024-01-06T00:05:17.388Z |
3583312 | 3583312 | 20231212154006_Dnn3w | IL0009 | 2024-01-06T00:05:17.268Z | 2024-01-06T00:05:17.268Z |
3578071 | 3578071 | 20231212023705_TvPHe | IL0009 | 2024-01-06T00:05:15.198Z | 2024-01-06T00:05:15.198Z |
3578011 | 3578011 | 20231212020216_YoW1G | IL0009 | 2024-01-06T00:05:15.189Z | 2024-01-06T00:05:15.189Z |
3577993 | 3577993 | 20231212015404_AjxAE | IL0009 | 2024-01-06T00:05:15.185Z | 2024-01-06T00:05:15.185Z |
3577977 | 3577977 | 20231212013854_k8EJ8 | IL0009 | 2024-01-06T00:05:15.183Z | 2024-01-06T00:05:15.183Z |
3577868 | 3577868 | 20231212004320_6rSj2 | IL0009 | 2024-01-06T00:05:15.165Z | 2024-01-06T00:05:15.165Z |
3577843 | 3577843 | 20231212003355_zARA8 | IL0009 | 2024-01-06T00:05:15.161Z | 2024-01-06T00:05:15.161Z |
3577632 | 3577632 | 20231211232725_KeOvU | IL0009 | 2024-01-06T00:05:15.129Z | 2024-01-06T00:05:15.129Z |
3576992 | 3576992 | 20231211204044_8f6Wz | IL0009 | 2024-01-06T00:05:15.057Z | 2024-01-06T00:05:15.057Z |
3576165 | 3576165 | 20231211182723_3jHhO | IL0009 | 2024-01-06T00:05:14.964Z | 2024-01-06T00:05:14.964Z |
3575812 | 3575812 | 20231211173626_q2J2U | IL0009 | 2024-01-06T00:05:14.924Z | 2024-01-06T00:05:14.924Z |
3213043 | 3213043 | 20231019183814_L7Enn | IL0009 | 2024-01-06T00:03:02.959Z | 2024-01-06T00:03:02.959Z |
3212894 | 3212894 | 20231019172116_SpP3H | IL0009 | 2024-01-06T00:03:02.912Z | 2024-01-06T00:03:02.912Z |
2979947 | 2979947 | 20230911194034_jYWW2 | IL0009 | 2024-01-06T00:01:44.866Z | 2024-01-06T00:01:44.866Z |
2969767 | 2969767 | 20230910001849_xjh3t | IL0009 | 2024-01-06T00:01:41.151Z | 2024-01-06T00:01:41.151Z |
2880568 | 2880568 | 20230822225854_pyfw8 | IL0009 | 2024-01-06T00:01:09.834Z | 2024-01-06T00:01:09.834Z |
2879221 | 2879221 | 20230822204017_yoC7G | IL0009 | 2024-01-06T00:01:09.709Z | 2024-01-06T00:01:09.709Z |
2875841 | 2875841 | 20230822014237_jy3fI | IL0009 | 2024-01-06T00:01:08.002Z | 2024-01-06T00:01:08.002Z |
2867635 | 2867635 | 20230821010921_oEYwb | IL0009 | 2024-01-06T00:01:05.849Z | 2024-01-06T00:01:05.849Z |
2864712 | 2864712 | 20230820223036_0olYu | IL0009 | 2024-01-06T00:01:05.620Z | 2024-01-06T00:01:05.620Z |
2863336 | 2863336 | 20230820203441_6tou9 | IL0009 | 2024-01-06T00:01:05.466Z | 2024-01-06T00:01:05.466Z |
2863250 | 2863250 | 20230820201829_0tWTq | IL0009 | 2024-01-06T00:01:05.454Z | 2024-01-06T00:01:05.454Z |
2845411 | 2845411 | 20230817212001_Qw2hz | IL0009 | 2024-01-06T00:00:59.621Z | 2024-01-06T00:00:59.621Z |
2836083 | 2836083 | 20230816211132_TDpo6 | IL0009 | 2024-01-06T00:00:57.355Z | 2024-01-06T00:00:57.355Z |
2820469 | 2820469 | 20230815192617_QTykc | IL0009 | 2024-01-06T00:00:51.389Z | 2024-01-06T00:00:51.389Z |
2728413 | 2728413 | 20230809004549_HP88i | IL0009 | 2024-01-06T00:00:23.719Z | 2024-01-06T00:00:23.719Z |
2728276 | 2728276 | 20230809003714_Nvaue | IL0009 | 2024-01-06T00:00:23.679Z | 2024-01-06T00:00:23.679Z |
2719664 | 2719664 | 20230808010212_JEadq | IL0009 | 2024-01-06T00:00:20.149Z | 2024-01-06T00:00:20.149Z |
2695543 | 2695543 | 20230804222102_MyARe | IL0009 | 2024-01-06T00:00:13.846Z | 2024-01-06T00:00:13.846Z |
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);