participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,452 rows where station_code = "UK001H" 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 |
|---|---|---|---|---|---|
| 9609287 | 9609287 | 20260405041314_n4rml | UK001H | 2026-04-06T12:00:53.859Z | 2026-04-06T12:00:53.859Z |
| 9608330 | 9608330 | 20260403215932_cSyF6 | UK001H | 2026-04-05T12:10:02.555Z | 2026-04-06T12:20:06.085Z |
| 9608215 | 9608215 | 20260403205901_83O8v | UK001H | 2026-04-05T12:09:35.199Z | 2026-04-06T12:19:56.449Z |
| 9594607 | 9594607 | 20260328233205_cclW0 | UK001H | 2026-03-30T12:09:57.767Z | 2026-04-06T12:40:01.433Z |
| 9594246 | 9594246 | 20260328203920_Mk13h | UK001H | 2026-03-30T12:09:04.723Z | 2026-04-06T12:39:44.686Z |
| 9592118 | 9592118 | 20260328004122_pV2ex | UK001H | 2026-03-29T12:07:11.549Z | 2026-04-05T12:35:37.508Z |
| 9589162 | 9589162 | 20260328023758_ya5yk | UK001H | 2026-03-29T12:00:48.444Z | 2026-04-06T12:37:04.037Z |
| 9585172 | 9585172 | 20260325233757_EDHcm | UK001H | 2026-03-27T12:16:53.147Z | 2026-04-03T12:39:51.027Z |
| 9584989 | 9584989 | 20260325225817_5EHGm | UK001H | 2026-03-27T12:16:28.940Z | 2026-04-03T12:39:45.803Z |
| 9584849 | 9584849 | 20260325222718_7doEL | UK001H | 2026-03-27T12:16:16.049Z | 2026-04-03T12:39:42.368Z |
| 9584704 | 9584704 | 20260325214828_T5jVL | UK001H | 2026-03-27T12:16:00.000Z | 2026-04-03T12:39:29.113Z |
| 9580850 | 9580850 | 20260326014531_w1oZx | UK001H | 2026-03-27T12:01:33.534Z | 2026-04-04T12:38:31.415Z |
| 9570800 | 9570800 | 20260322225102_JsWfc | UK001H | 2026-03-24T12:23:50.597Z | 2026-03-30T12:30:49.620Z |
| 9530234 | 9530234 | 20260318203000_uJbvq | UK001H | 2026-03-20T12:24:14.265Z | 2026-03-26T12:39:10.635Z |
| 9530226 | 9530226 | 20260318202640_fFWlE | UK001H | 2026-03-20T12:24:13.541Z | 2026-03-26T12:39:10.550Z |
| 9519747 | 9519747 | 20260319023308_V039W | UK001H | 2026-03-20T12:05:01.514Z | 2026-03-27T12:40:35.073Z |
| 9517988 | 9517988 | 20260319001926_dAHJR | UK001H | 2026-03-20T12:01:40.184Z | 2026-03-27T12:40:05.202Z |
| 9516996 | 9516996 | 20260317222503_bqdfI | UK001H | 2026-03-19T12:27:04.867Z | 2026-03-25T12:43:08.042Z |
| 9509380 | 9509380 | 20260318014735_E3ScC | UK001H | 2026-03-19T12:05:14.895Z | 2026-03-26T12:37:05.278Z |
| 9508525 | 9508525 | 20260318010232_dEhu2 | UK001H | 2026-03-19T12:03:17.649Z | 2026-03-26T12:36:59.187Z |
| 9508516 | 9508516 | 20260318010232_7rFYY | UK001H | 2026-03-19T12:03:17.256Z | 2026-03-26T12:36:59.186Z |
| 9507642 | 9507642 | 20260317233012_DAjAO | UK001H | 2026-03-19T12:00:51.623Z | 2026-03-26T12:36:51.461Z |
| 9501518 | 9501518 | 20260315223343_7SZJg | UK001H | 2026-03-17T12:25:11.602Z | 2026-03-23T12:22:44.749Z |
| 9495156 | 9495156 | 20260316042533_oVOOT | UK001H | 2026-03-17T12:06:15.928Z | 2026-03-24T12:41:00.295Z |
| 9495152 | 9495152 | 20260316042322_Jt0tl | UK001H | 2026-03-17T12:06:15.260Z | 2026-03-24T12:41:00.266Z |
| 9494685 | 9494685 | 20260316024630_Ziu8M | UK001H | 2026-03-17T12:04:40.487Z | 2026-03-24T12:40:49.367Z |
| 9493801 | 9493801 | 20260316004015_KHtSk | UK001H | 2026-03-17T12:02:05.632Z | 2026-03-24T12:40:42.130Z |
| 9492350 | 9492350 | 20260314203348_w4LHR | UK001H | 2026-03-16T12:28:28.359Z | 2026-03-22T12:42:51.940Z |
| 9476921 | 9476921 | 20260314035618_VIsx2 | UK001H | 2026-03-15T12:07:14.441Z | 2026-03-22T12:42:00.236Z |
| 9476587 | 9476587 | 20260314031820_vC9Al | UK001H | 2026-03-15T12:06:26.101Z | 2026-03-22T12:41:58.010Z |
| 9476051 | 9476051 | 20260314023500_WbEfU | UK001H | 2026-03-15T12:04:57.768Z | 2026-03-22T12:41:53.957Z |
| 9475693 | 9475693 | 20260314015559_8iOqp | UK001H | 2026-03-15T12:03:53.123Z | 2026-03-22T12:41:49.162Z |
| 9475129 | 9475129 | 20260314004540_jP8b0 | UK001H | 2026-03-15T12:02:20.606Z | 2026-03-22T12:41:27.188Z |
| 9474748 | 9474748 | 20260313234930_uuSil | UK001H | 2026-03-15T12:01:14.203Z | 2026-03-22T12:41:23.873Z |
| 9470225 | 9470225 | 20260313045809_gVHA4 | UK001H | 2026-03-14T12:06:45.208Z | 2026-03-21T12:49:06.899Z |
| 9470132 | 9470132 | 20260313043937_MqNfz | UK001H | 2026-03-14T12:06:32.853Z | 2026-03-21T12:49:06.127Z |
| 9470072 | 9470072 | 20260313042931_ruEQR | UK001H | 2026-03-14T12:06:24.132Z | 2026-03-21T12:49:05.689Z |
| 9469730 | 9469730 | 20260313033617_7rj9c | UK001H | 2026-03-14T12:05:20.462Z | 2026-03-21T12:49:01.635Z |
| 9469488 | 9469488 | 20260313025721_Dg9s7 | UK001H | 2026-03-14T12:04:27.449Z | 2026-03-21T12:48:40.312Z |
| 9457745 | 9457745 | 20260311051019_RtAqm | UK001H | 2026-03-12T12:04:28.513Z | 2026-03-19T12:44:51.590Z |
| 9457657 | 9457657 | 20260311044439_FYOuB | UK001H | 2026-03-12T12:04:19.851Z | 2026-03-19T12:44:50.390Z |
| 9457286 | 9457286 | 20260311032059_CO7Zh | UK001H | 2026-03-12T12:03:28.477Z | 2026-03-19T12:44:36.649Z |
| 9425537 | 9425537 | 20260303224222_I42Ip | UK001H | 2026-03-05T14:15:19.781Z | 2026-03-11T12:29:06.011Z |
| 9415184 | 9415184 | 20260228204329_IIC1m | UK001H | 2026-03-02T14:07:31.826Z | 2026-03-08T12:43:04.900Z |
| 9415180 | 9415180 | 20260228204001_h8oqS | UK001H | 2026-03-02T14:07:31.436Z | 2026-03-08T12:43:04.755Z |
| 9395153 | 9395153 | 20260224230655_2aTeS | UK001H | 2026-02-26T14:21:07.752Z | 2026-03-04T14:19:30.084Z |
| 9394279 | 9394279 | 20260224193925_jFpVY | UK001H | 2026-02-26T14:19:27.432Z | 2026-03-04T14:19:19.645Z |
| 9390105 | 9390105 | 20260224234405_hkAQ1 | UK001H | 2026-02-26T14:00:29.436Z | 2026-03-05T14:35:32.923Z |
| 9390015 | 9390015 | 20260224232809_l5xL5 | UK001H | 2026-02-26T14:00:12.438Z | 2026-03-05T14:35:30.688Z |
| 9373825 | 9373825 | 20260223042934_YRaaQ | UK001H | 2026-02-24T14:04:02.367Z | 2026-03-03T14:31:10.271Z |
| 9337200 | 9337200 | 20260217051808_DVE3m | UK001H | 2026-02-18T14:06:40.612Z | 2026-02-26T14:39:24.888Z |
| 9337080 | 9337080 | 20260217050042_Fd2mc | UK001H | 2026-02-18T14:06:18.664Z | 2026-02-26T14:39:23.933Z |
| 9336565 | 9336565 | 20260217040210_S21SU | UK001H | 2026-02-18T14:04:44.418Z | 2026-02-26T14:39:19.406Z |
| 9336126 | 9336126 | 20260217031430_IDSDK | UK001H | 2026-02-18T14:03:23.848Z | 2026-02-26T14:39:15.815Z |
| 9336014 | 9336014 | 20260217025838_FzBzF | UK001H | 2026-02-18T14:03:02.343Z | 2026-02-26T14:39:07.669Z |
| 9335717 | 9335717 | 20260217023329_F3rFK | UK001H | 2026-02-18T14:02:07.564Z | 2026-02-26T14:38:58.143Z |
| 9335689 | 9335689 | 20260217022955_Q3XNw | UK001H | 2026-02-18T14:02:02.947Z | 2026-02-26T14:38:58.013Z |
| 9335609 | 9335609 | 20260217021634_1OWxH | UK001H | 2026-02-18T14:01:43.330Z | 2026-02-26T14:38:57.185Z |
| 9335555 | 9335555 | 20260217020529_YMCC6 | UK001H | 2026-02-18T14:01:30.791Z | 2026-02-26T14:38:55.990Z |
| 9323799 | 9323799 | 20260214060914_p07Km | UK001H | 2026-02-15T14:07:13.829Z | 2026-02-23T14:46:46.954Z |
| 9323321 | 9323321 | 20260214050540_XINqj | UK001H | 2026-02-15T14:05:56.577Z | 2026-02-23T14:46:30.955Z |
| 9323303 | 9323303 | 20260214050258_I2HVQ | UK001H | 2026-02-15T14:05:54.942Z | 2026-02-23T14:46:30.745Z |
| 9323156 | 9323156 | 20260214045246_Yn6K7 | UK001H | 2026-02-15T14:05:28.284Z | 2026-02-23T14:46:28.419Z |
| 9322459 | 9322459 | 20260214030647_Tf2rm | UK001H | 2026-02-15T14:02:29.910Z | 2026-02-23T14:46:17.009Z |
| 9322108 | 9322108 | 20260214014710_tZomj | UK001H | 2026-02-15T14:00:17.184Z | 2026-02-23T14:46:09.582Z |
| 9213767 | 9213767 | 20260116043807_8Pc28 | UK001H | 2026-01-17T14:18:25.435Z | 2026-01-24T15:12:45.894Z |
| 9213749 | 9213749 | 20260116043412_tGNWq | UK001H | 2026-01-17T14:18:21.756Z | 2026-01-24T15:12:33.432Z |
| 9208494 | 9208494 | 20260115054210_LdqlQ | UK001H | 2026-01-16T14:12:54.489Z | 2026-01-22T15:04:31.605Z |
| 9202630 | 9202630 | 20260114035625_Am2Iv | UK001H | 2026-01-15T14:21:52.162Z | 2026-01-22T15:09:23.884Z |
| 9200436 | 9200436 | 20260114001005_oBrBA | UK001H | 2026-01-15T14:15:13.008Z | 2026-01-22T15:08:16.076Z |
| 9200290 | 9200290 | 20260113233643_vJHVi | UK001H | 2026-01-15T14:14:38.233Z | 2026-01-22T15:08:13.370Z |
| 9200112 | 9200112 | 20260113225241_Pnips | UK001H | 2026-01-15T14:13:49.818Z | 2026-01-22T15:08:09.807Z |
| 9199906 | 9199906 | 20260113215336_26oDr | UK001H | 2026-01-15T14:13:01.400Z | 2026-01-22T15:08:05.243Z |
| 9199796 | 9199796 | 20260113211907_oDsEw | UK001H | 2026-01-15T14:12:32.377Z | 2026-01-22T15:08:02.148Z |
| 9194095 | 9194095 | 20260112174715_Id8F2 | UK001H | 2026-01-14T14:07:15.483Z | 2026-01-21T15:03:30.135Z |
| 9188419 | 9188419 | 20260111232716_bdBpr | UK001H | 2026-01-13T14:12:10.914Z | 2026-01-20T15:21:41.214Z |
| 9176984 | 9176984 | 20260110065320_88ZHV | UK001H | 2026-01-11T14:10:32.854Z | 2026-01-18T15:09:10.016Z |
| 9176906 | 9176906 | 20260110063825_5FP3G | UK001H | 2026-01-11T14:10:19.180Z | 2026-01-18T15:09:07.088Z |
| 9176407 | 9176407 | 20260110052839_mXuza | UK001H | 2026-01-11T14:08:55.719Z | 2026-01-18T15:08:38.176Z |
| 9176403 | 9176403 | 20260110052838_W2NO9 | UK001H | 2026-01-11T14:08:55.304Z | 2026-01-18T15:08:38.035Z |
| 9176044 | 9176044 | 20260110043531_YcYIj | UK001H | 2026-01-11T14:08:05.419Z | 2026-01-18T15:08:17.745Z |
| 9175892 | 9175892 | 20260110040854_vmIIw | UK001H | 2026-01-11T14:07:41.848Z | 2026-01-18T15:08:12.502Z |
| 9175809 | 9175809 | 20260110035046_kexeX | UK001H | 2026-01-11T14:07:25.841Z | 2026-01-18T15:08:09.124Z |
| 9175685 | 9175685 | 20260110032417_4I28Z | UK001H | 2026-01-11T14:07:05.953Z | 2026-01-18T15:07:56.453Z |
| 9175071 | 9175071 | 20260110010124_djB84 | UK001H | 2026-01-11T14:05:19.425Z | 2026-01-18T15:07:25.015Z |
| 9167880 | 9167880 | 20260108060333_vh02h | UK001H | 2026-01-09T14:09:39.980Z | 2026-01-16T15:11:58.351Z |
| 9167837 | 9167837 | 20260108053513_qWZt9 | UK001H | 2026-01-09T14:09:27.233Z | 2026-01-16T15:11:54.829Z |
| 9167203 | 9167203 | 20260107233328_tLc24 | UK001H | 2026-01-09T14:06:42.490Z | 2026-01-16T15:10:55.721Z |
| 9166562 | 9166562 | 20260107191854_uyzc3 | UK001H | 2026-01-09T14:03:51.239Z | 2026-01-16T15:10:02.313Z |
| 9163406 | 9163406 | 20260107063227_CzZIk | UK001H | 2026-01-08T14:09:03.879Z | 2026-01-13T15:03:14.201Z |
| 9163234 | 9163234 | 20260107061021_I41iz | UK001H | 2026-01-08T14:08:35.446Z | 2026-01-13T15:03:06.820Z |
| 9163143 | 9163143 | 20260107055400_6fqLy | UK001H | 2026-01-08T14:08:14.470Z | 2026-01-13T15:03:02.953Z |
| 9162642 | 9162642 | 20260107035138_LZdNQ | UK001H | 2026-01-08T14:06:07.015Z | 2026-01-13T15:02:30.648Z |
| 9162558 | 9162558 | 20260107032811_h28Fb | UK001H | 2026-01-08T14:05:44.529Z | 2026-01-13T15:02:18.801Z |
| 9162364 | 9162364 | 20260107023222_8xsx8 | UK001H | 2026-01-08T14:04:47.023Z | 2026-01-13T15:02:04.474Z |
| 9162354 | 9162354 | 20260107022914_wpQoo | UK001H | 2026-01-08T14:04:44.647Z | 2026-01-13T15:02:03.913Z |
| 9162337 | 9162337 | 20260107021241_Qh7pI | UK001H | 2026-01-08T14:04:37.701Z | 2026-01-13T15:02:02.593Z |
| 9162152 | 9162152 | 20260106232212_7Lb39 | UK001H | 2026-01-08T14:03:13.607Z | 2026-01-13T15:01:40.818Z |
| 9159431 | 9159431 | 20260106024106_PlKYQ | UK001H | 2026-01-07T14:09:19.559Z | 2026-01-13T15:08:25.979Z |
| 9158130 | 9158130 | 20260105201615_Ydl1J | UK001H | 2026-01-07T14:04:58.140Z | 2026-01-13T15:06:56.905Z |
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);