participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
60 rows where station_code = "UK00CS" 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 |
---|---|---|---|---|---|
5532663 | 5532663 | 20241112054849_AsD3P | UK00CS | 2024-11-13T14:17:07.448Z | 2024-11-13T14:17:18.695Z |
5532636 | 5532636 | 20241112054725_sQUK8 | UK00CS | 2024-11-13T14:17:05.160Z | 2024-11-13T14:17:18.690Z |
5532586 | 5532586 | 20241112054022_OY9A2 | UK00CS | 2024-11-13T14:17:01.619Z | 2024-11-13T14:17:18.682Z |
5532324 | 5532324 | 20241112050747_aWseW | UK00CS | 2024-11-13T14:16:36.724Z | 2024-11-13T14:17:18.634Z |
5532319 | 5532319 | 20241112050732_YgQUS | UK00CS | 2024-11-13T14:16:36.540Z | 2024-11-13T14:17:18.633Z |
5532256 | 5532256 | 20241112045831_KVVm8 | UK00CS | 2024-11-13T14:16:31.729Z | 2024-11-13T14:17:18.624Z |
5532166 | 5532166 | 20241112044700_qYVPy | UK00CS | 2024-11-13T14:16:24.026Z | 2024-11-13T14:17:18.609Z |
5532152 | 5532152 | 20241112044311_XfFMK | UK00CS | 2024-11-13T14:16:22.711Z | 2024-11-13T14:17:18.607Z |
5532066 | 5532066 | 20241112043353_oKPOV | UK00CS | 2024-11-13T14:16:13.947Z | 2024-11-13T14:17:18.590Z |
5531967 | 5531967 | 20241112042319_0ieDG | UK00CS | 2024-11-13T14:16:04.717Z | 2024-11-13T14:17:18.574Z |
5531869 | 5531869 | 20241112041521_V5B1f | UK00CS | 2024-11-13T14:15:59.981Z | 2024-11-13T14:17:18.553Z |
5531662 | 5531662 | 20241112035819_vj9D2 | UK00CS | 2024-11-13T14:15:49.191Z | 2024-11-13T14:17:18.493Z |
5531399 | 5531399 | 20241112033715_4UJyT | UK00CS | 2024-11-13T14:15:37.551Z | 2024-11-13T14:17:18.441Z |
5531353 | 5531353 | 20241112033259_iBI7F | UK00CS | 2024-11-13T14:15:35.472Z | 2024-11-13T14:17:18.434Z |
5531223 | 5531223 | 20241112032323_Dlabd | UK00CS | 2024-11-13T14:15:26.063Z | 2024-11-13T14:17:18.409Z |
5530814 | 5530814 | 20241112025020_UrA2x | UK00CS | 2024-11-13T14:14:41.440Z | 2024-11-13T14:17:18.332Z |
5530783 | 5530783 | 20241112024612_RE5YJ | UK00CS | 2024-11-13T14:14:37.694Z | 2024-11-13T14:17:18.323Z |
5530452 | 5530452 | 20241112021846_NWJT6 | UK00CS | 2024-11-13T14:14:16.201Z | 2024-11-13T14:17:18.226Z |
5530340 | 5530340 | 20241112021003_H422f | UK00CS | 2024-11-13T14:14:09.919Z | 2024-11-13T14:17:18.188Z |
5530302 | 5530302 | 20241112020639_UDDIo | UK00CS | 2024-11-13T14:14:07.654Z | 2024-11-13T14:17:18.175Z |
5530094 | 5530094 | 20241112014224_kW3VR | UK00CS | 2024-11-13T14:13:50.988Z | 2024-11-13T14:17:18.106Z |
5530059 | 5530059 | 20241112013817_upqhC | UK00CS | 2024-11-13T14:13:47.646Z | 2024-11-13T14:17:18.098Z |
5529878 | 5529878 | 20241112011514_GK6a3 | UK00CS | 2024-11-13T14:13:17.338Z | 2024-11-13T14:17:18.026Z |
5529641 | 5529641 | 20241112004728_86541 | UK00CS | 2024-11-13T14:13:03.671Z | 2024-11-13T14:17:17.900Z |
5529635 | 5529635 | 20241112004626_vrwXL | UK00CS | 2024-11-13T14:13:03.307Z | 2024-11-13T14:17:17.895Z |
5529575 | 5529575 | 20241112003643_BQ39d | UK00CS | 2024-11-13T14:12:58.927Z | 2024-11-13T14:17:17.835Z |
5529543 | 5529543 | 20241112003248_71xjP | UK00CS | 2024-11-13T14:12:57.154Z | 2024-11-13T14:17:17.821Z |
5529130 | 5529130 | 20241111233312_19era | UK00CS | 2024-11-13T14:12:07.472Z | 2024-11-13T14:17:17.537Z |
5529077 | 5529077 | 20241111232616_oonEd | UK00CS | 2024-11-13T14:12:02.920Z | 2024-11-13T14:17:17.512Z |
5529056 | 5529056 | 20241111232441_f52Lm | UK00CS | 2024-11-13T14:12:01.363Z | 2024-11-13T14:17:17.504Z |
5528995 | 5528995 | 20241111231635_lGpV8 | UK00CS | 2024-11-13T14:11:55.363Z | 2024-11-13T14:17:17.480Z |
5528899 | 5528899 | 20241111230343_Nk9x0 | UK00CS | 2024-11-13T14:11:37.484Z | 2024-11-13T14:17:17.414Z |
5528892 | 5528892 | 20241111230152_qiypT | UK00CS | 2024-11-13T14:11:36.356Z | 2024-11-13T14:17:17.411Z |
5528890 | 5528890 | 20241111230147_qOdaM | UK00CS | 2024-11-13T14:11:35.971Z | 2024-11-13T14:17:17.409Z |
5528888 | 5528888 | 20241111230121_Pat2u | UK00CS | 2024-11-13T14:11:35.668Z | 2024-11-13T14:17:17.408Z |
5528872 | 5528872 | 20241111225932_ZHWwC | UK00CS | 2024-11-13T14:11:33.855Z | 2024-11-13T14:17:17.388Z |
5528759 | 5528759 | 20241111223307_oHglu | UK00CS | 2024-11-13T14:11:23.656Z | 2024-11-13T14:17:17.250Z |
5528688 | 5528688 | 20241111221826_Eytpo | UK00CS | 2024-11-13T14:11:16.837Z | 2024-11-13T14:17:17.207Z |
5528663 | 5528663 | 20241111220941_fN3PY | UK00CS | 2024-11-13T14:11:14.630Z | 2024-11-13T14:17:17.196Z |
5528578 | 5528578 | 20241111213820_c4n2I | UK00CS | 2024-11-13T14:11:07.600Z | 2024-11-13T14:17:17.151Z |
5528571 | 5528571 | 20241111213746_VCiBJ | UK00CS | 2024-11-13T14:11:07.329Z | 2024-11-13T14:17:17.138Z |
5528390 | 5528390 | 20241111203715_g2qY3 | UK00CS | 2024-11-13T14:10:34.166Z | 2024-11-13T14:17:17.033Z |
5528373 | 5528373 | 20241111203311_r3HUV | UK00CS | 2024-11-13T14:10:32.834Z | 2024-11-13T14:17:17.007Z |
5525693 | 5525693 | 20241112060719_7vjIE | UK00CS | 2024-11-13T14:00:22.103Z | 2024-11-13T14:00:22.103Z |
5525652 | 5525652 | 20241112055922_7pCSH | UK00CS | 2024-11-13T14:00:12.272Z | 2024-11-13T14:00:12.272Z |
5523263 | 5523263 | 20241111004806_6dXfF | UK00CS | 2024-11-12T14:15:11.202Z | 2024-11-13T14:20:19.970Z |
5522275 | 5522275 | 20241110193244_hvtHe | UK00CS | 2024-11-12T14:13:02.189Z | 2024-11-13T14:19:56.879Z |
5502360 | 5502360 | 20241107181248_7UhMk | UK00CS | 2024-11-09T14:11:13.145Z | 2024-11-13T14:25:46.274Z |
5502176 | 5502176 | 20241107173512_4oD9t | UK00CS | 2024-11-09T14:11:01.384Z | 2024-11-13T14:25:44.162Z |
5497887 | 5497887 | 20241107054949_66jT6 | UK00CS | 2024-11-08T14:14:29.027Z | 2024-11-13T14:26:55.605Z |
5497878 | 5497878 | 20241107054039_Oc9A1 | UK00CS | 2024-11-08T14:14:28.639Z | 2024-11-13T14:26:55.584Z |
5497851 | 5497851 | 20241107053454_cHXOH | UK00CS | 2024-11-08T14:14:27.570Z | 2024-11-13T14:26:55.415Z |
5497837 | 5497837 | 20241107052923_yC719 | UK00CS | 2024-11-08T14:14:25.712Z | 2024-11-13T14:26:55.355Z |
5497825 | 5497825 | 20241107052331_hGOyG | UK00CS | 2024-11-08T14:14:25.261Z | 2024-11-13T14:26:55.216Z |
5497800 | 5497800 | 20241107051855_gTdAQ | UK00CS | 2024-11-08T14:14:22.935Z | 2024-11-13T14:26:55.072Z |
5497747 | 5497747 | 20241107045536_SZLzh | UK00CS | 2024-11-08T14:14:17.860Z | 2024-11-13T14:26:54.681Z |
5497682 | 5497682 | 20241107042808_WZk8x | UK00CS | 2024-11-08T14:14:10.493Z | 2024-11-13T14:26:54.095Z |
5497666 | 5497666 | 20241107042142_pGWnR | UK00CS | 2024-11-08T14:14:09.361Z | 2024-11-13T14:26:53.888Z |
5497537 | 5497537 | 20241107035735_Wba42 | UK00CS | 2024-11-08T14:13:56.718Z | 2024-11-13T14:26:52.969Z |
5442790 | 5442790 | 20241030023537_EMduW | UK00CS | 2024-11-01T12:20:08.488Z | 2024-11-07T14:26:48.342Z |
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);