participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,488 rows where station_code = "UK006C" 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 |
---|---|---|---|---|---|
5452918 | 5452918 | 20241101052641_bBmHf | UK006C | 2024-11-02T12:19:33.570Z | 2024-11-09T14:24:36.040Z |
5442999 | 5442999 | 20241030031027_jAWg3 | UK006C | 2024-11-01T12:20:15.301Z | 2024-11-07T14:26:49.250Z |
5442985 | 5442985 | 20241030030846_thtrz | UK006C | 2024-11-01T12:20:14.935Z | 2024-11-07T14:26:49.094Z |
5442887 | 5442887 | 20241030025130_7wRF2 | UK006C | 2024-11-01T12:20:11.835Z | 2024-11-07T14:26:48.671Z |
5442764 | 5442764 | 20241030023045_86YXF | UK006C | 2024-11-01T12:20:07.729Z | 2024-11-07T14:26:48.275Z |
5442755 | 5442755 | 20241030022911_tgeKH | UK006C | 2024-11-01T12:20:07.498Z | 2024-11-07T14:26:48.249Z |
5442666 | 5442666 | 20241030021145_a9qFI | UK006C | 2024-11-01T12:20:04.629Z | 2024-11-07T14:26:47.619Z |
5441909 | 5441909 | 20241030000203_Mk8n1 | UK006C | 2024-11-01T12:19:12.099Z | 2024-11-07T14:26:44.332Z |
5441897 | 5441897 | 20241029235818_1Bfvs | UK006C | 2024-11-01T12:19:11.530Z | 2024-11-07T14:26:44.252Z |
5441852 | 5441852 | 20241029235241_3H8V0 | UK006C | 2024-11-01T12:19:06.608Z | 2024-11-07T14:26:43.816Z |
5441810 | 5441810 | 20241029234120_JhBuC | UK006C | 2024-11-01T12:19:03.330Z | 2024-11-07T14:26:43.585Z |
5441807 | 5441807 | 20241029234053_o9cN8 | UK006C | 2024-11-01T12:19:03.110Z | 2024-11-07T14:26:43.476Z |
5441805 | 5441805 | 20241029234044_xySBZ | UK006C | 2024-11-01T12:19:02.798Z | 2024-11-07T14:26:43.449Z |
5441673 | 5441673 | 20241029230956_cjrM8 | UK006C | 2024-11-01T12:18:52.632Z | 2024-11-07T14:26:42.915Z |
5441654 | 5441654 | 20241029230132_0FSP4 | UK006C | 2024-11-01T12:18:51.327Z | 2024-11-07T14:26:42.841Z |
5441650 | 5441650 | 20241029225850_hBsO7 | UK006C | 2024-11-01T12:18:50.741Z | 2024-11-07T14:26:42.820Z |
5441548 | 5441548 | 20241029223520_qrrYT | UK006C | 2024-11-01T12:18:44.472Z | 2024-11-07T14:26:42.648Z |
5441501 | 5441501 | 20241029222648_pn5PO | UK006C | 2024-11-01T12:18:41.381Z | 2024-11-07T14:26:42.490Z |
5441461 | 5441461 | 20241029221913_HS9oh | UK006C | 2024-11-01T12:18:38.068Z | 2024-11-07T14:26:42.249Z |
5423080 | 5423080 | 20241026034134_v9JPh | UK006C | 2024-10-30T12:24:20.536Z | 2024-11-03T14:27:38.740Z |
5422960 | 5422960 | 20241026230214_JhQYp | UK006C | 2024-10-30T12:22:15.926Z | 2024-11-04T14:28:50.367Z |
5410847 | 5410847 | 20241027054041_FrvUt | UK006C | 2024-10-29T12:18:06.124Z | 2024-11-04T14:29:05.648Z |
5410707 | 5410707 | 20241027053045_mGjcq | UK006C | 2024-10-29T12:18:03.145Z | 2024-11-04T14:29:05.283Z |
5410347 | 5410347 | 20241027050722_IVqa8 | UK006C | 2024-10-29T12:17:53.669Z | 2024-11-04T14:29:04.352Z |
5410026 | 5410026 | 20241027044823_ghseC | UK006C | 2024-10-29T12:17:46.139Z | 2024-11-04T14:29:03.597Z |
5409920 | 5409920 | 20241027044208_vyY9l | UK006C | 2024-10-29T12:17:44.146Z | 2024-11-04T14:29:02.940Z |
5409851 | 5409851 | 20241027043844_8Mukd | UK006C | 2024-10-29T12:17:42.453Z | 2024-11-04T14:29:02.818Z |
5409364 | 5409364 | 20241027041246_JhiK7 | UK006C | 2024-10-29T12:17:18.060Z | 2024-11-04T14:29:01.600Z |
5409324 | 5409324 | 20241027041059_J5NIY | UK006C | 2024-10-29T12:17:16.585Z | 2024-11-04T14:29:01.580Z |
5409149 | 5409149 | 20241027040309_rAfv2 | UK006C | 2024-10-29T12:17:09.162Z | 2024-11-04T14:29:01.225Z |
5409137 | 5409137 | 20241027040208_6TNCq | UK006C | 2024-10-29T12:17:08.766Z | 2024-11-04T14:29:01.213Z |
5408995 | 5408995 | 20241027035239_2BWQy | UK006C | 2024-10-29T12:17:00.522Z | 2024-11-04T14:29:00.899Z |
5408907 | 5408907 | 20241027034914_LxxHL | UK006C | 2024-10-29T12:16:56.270Z | 2024-11-04T14:29:00.778Z |
5408893 | 5408893 | 20241027034852_gOPoc | UK006C | 2024-10-29T12:16:55.983Z | 2024-11-04T14:29:00.771Z |
5408745 | 5408745 | 20241027034112_pgBUI | UK006C | 2024-10-29T12:16:48.081Z | 2024-11-04T14:29:00.378Z |
5408462 | 5408462 | 20241027032801_7qn1R | UK006C | 2024-10-29T12:16:31.455Z | 2024-11-04T14:28:59.542Z |
5408447 | 5408447 | 20241027032722_aIcUH | UK006C | 2024-10-29T12:16:29.799Z | 2024-11-04T14:28:59.499Z |
5408334 | 5408334 | 20241027032219_9WlBw | UK006C | 2024-10-29T12:16:23.378Z | 2024-11-04T14:28:59.181Z |
5407794 | 5407794 | 20241027025259_wtpJD | UK006C | 2024-10-29T12:15:42.036Z | 2024-11-04T14:28:58.156Z |
5407564 | 5407564 | 20241027024202_yBC3A | UK006C | 2024-10-29T12:15:29.411Z | 2024-11-04T14:28:57.869Z |
5407473 | 5407473 | 20241027023830_WjmaM | UK006C | 2024-10-29T12:15:26.065Z | 2024-11-04T14:28:57.655Z |
5407364 | 5407364 | 20241027023334_ExEFz | UK006C | 2024-10-29T12:15:22.463Z | 2024-11-04T14:28:57.406Z |
5406938 | 5406938 | 20241027021112_8gAjx | UK006C | 2024-10-29T12:15:01.678Z | 2024-11-04T14:28:56.713Z |
5406864 | 5406864 | 20241027020507_Do6P0 | UK006C | 2024-10-29T12:14:51.891Z | 2024-11-04T14:28:56.527Z |
5404421 | 5404421 | 20241026232451_kT7dE | UK006C | 2024-10-29T12:11:22.838Z | 2024-11-04T14:28:50.985Z |
5404264 | 5404264 | 20241026231306_OAwVo | UK006C | 2024-10-29T12:11:03.760Z | 2024-11-04T14:28:50.560Z |
5403414 | 5403414 | 20241026215430_J17PA | UK006C | 2024-10-29T12:09:28.016Z | 2024-11-04T14:28:48.741Z |
5403024 | 5403024 | 20241026210501_0hl4E | UK006C | 2024-10-29T12:08:45.092Z | 2024-11-04T14:28:47.385Z |
5402782 | 5402782 | 20241026202414_l3re5 | UK006C | 2024-10-29T12:08:07.947Z | 2024-11-04T14:28:46.520Z |
5402287 | 5402287 | 20241026191011_L8XOc | UK006C | 2024-10-29T12:06:53.435Z | 2024-11-04T14:28:43.603Z |
5402097 | 5402097 | 20241026184325_FaJJ8 | UK006C | 2024-10-29T12:06:24.904Z | 2024-11-04T14:28:42.275Z |
5400022 | 5400022 | 20241026052238_facmO | UK006C | 2024-10-28T12:20:19.233Z | 2024-11-03T14:27:41.114Z |
5399880 | 5399880 | 20241026050841_DiBeL | UK006C | 2024-10-28T12:20:14.310Z | 2024-11-03T14:27:40.671Z |
5399832 | 5399832 | 20241026050536_PZNc5 | UK006C | 2024-10-28T12:20:12.914Z | 2024-11-03T14:27:40.587Z |
5399815 | 5399815 | 20241026050454_1PhzF | UK006C | 2024-10-28T12:20:12.077Z | 2024-11-03T14:27:40.572Z |
5399589 | 5399589 | 20241026043626_JNeic | UK006C | 2024-10-28T12:20:03.408Z | 2024-11-03T14:27:40.018Z |
5399509 | 5399509 | 20241026043005_k27FB | UK006C | 2024-10-28T12:20:01.340Z | 2024-11-03T14:27:39.889Z |
5399492 | 5399492 | 20241026042815_B2uil | UK006C | 2024-10-28T12:20:00.785Z | 2024-11-03T14:27:39.860Z |
5399240 | 5399240 | 20241026040414_ynvjL | UK006C | 2024-10-28T12:19:52.316Z | 2024-11-03T14:27:39.277Z |
5398870 | 5398870 | 20241026033425_gjJXo | UK006C | 2024-10-28T12:19:38.150Z | 2024-11-03T14:27:38.313Z |
5398015 | 5398015 | 20241026021623_Ve53R | UK006C | 2024-10-28T12:18:56.219Z | 2024-11-03T14:27:34.877Z |
5397131 | 5397131 | 20241026010349_FwwD2 | UK006C | 2024-10-28T12:18:08.837Z | 2024-11-03T14:27:32.066Z |
5397079 | 5397079 | 20241026010055_K6C2S | UK006C | 2024-10-28T12:18:06.938Z | 2024-11-03T14:27:32.002Z |
5396935 | 5396935 | 20241026004802_sGpgW | UK006C | 2024-10-28T12:18:00.011Z | 2024-11-03T14:27:31.438Z |
5396798 | 5396798 | 20241026003545_CXrVT | UK006C | 2024-10-28T12:17:56.013Z | 2024-11-03T14:27:30.928Z |
5396756 | 5396756 | 20241026003053_MeuLc | UK006C | 2024-10-28T12:17:55.143Z | 2024-11-03T14:27:30.859Z |
5396391 | 5396391 | 20241026000117_FDKD6 | UK006C | 2024-10-28T12:17:38.088Z | 2024-11-03T14:27:29.696Z |
5395795 | 5395795 | 20241025231045_QUAt2 | UK006C | 2024-10-28T12:16:52.127Z | 2024-11-03T14:27:26.696Z |
5395600 | 5395600 | 20241025225850_20Buk | UK006C | 2024-10-28T12:16:31.658Z | 2024-11-03T14:27:26.105Z |
5395569 | 5395569 | 20241025225522_2pqft | UK006C | 2024-10-28T12:16:28.107Z | 2024-11-03T14:27:26.062Z |
5385955 | 5385955 | 20241024234700_U8OZf | UK006C | 2024-10-27T12:19:39.758Z | 2024-11-02T12:28:30.526Z |
5384572 | 5384572 | 20241024202152_xVFNF | UK006C | 2024-10-27T12:17:11.958Z | 2024-11-02T12:28:27.331Z |
5384562 | 5384562 | 20241024202130_qaUi4 | UK006C | 2024-10-27T12:17:11.181Z | 2024-11-02T12:28:27.321Z |
5383983 | 5383983 | 20241024192030_cXR2f | UK006C | 2024-10-27T12:16:37.127Z | 2024-11-02T12:28:26.625Z |
5383222 | 5383222 | 20241024175743_pv0lW | UK006C | 2024-10-27T12:14:57.231Z | 2024-11-02T12:28:24.807Z |
5376102 | 5376102 | 20241024034157_QAFA5 | UK006C | 2024-10-26T12:21:50.525Z | 2024-11-01T12:27:01.390Z |
5374367 | 5374367 | 20241024022441_KyAu1 | UK006C | 2024-10-26T12:20:46.592Z | 2024-11-01T12:26:58.862Z |
5373943 | 5373943 | 20241024020127_agnus | UK006C | 2024-10-26T12:20:31.557Z | 2024-11-01T12:26:58.577Z |
5373535 | 5373535 | 20241024014304_VUcFJ | UK006C | 2024-10-26T12:20:16.378Z | 2024-11-01T12:26:58.319Z |
5373256 | 5373256 | 20241024013014_QuUiC | UK006C | 2024-10-26T12:20:03.156Z | 2024-11-01T12:26:58.200Z |
5373238 | 5373238 | 20241024012852_Y6XEU | UK006C | 2024-10-26T12:20:02.540Z | 2024-11-01T12:26:58.187Z |
5373139 | 5373139 | 20241024012616_H629l | UK006C | 2024-10-26T12:19:59.338Z | 2024-11-01T12:26:58.145Z |
5373069 | 5373069 | 20241024012218_YgEIG | UK006C | 2024-10-26T12:19:55.669Z | 2024-11-01T12:26:58.111Z |
5372990 | 5372990 | 20241024011743_32VbZ | UK006C | 2024-10-26T12:19:51.321Z | 2024-11-01T12:26:58.060Z |
5372666 | 5372666 | 20241024010126_Gexp8 | UK006C | 2024-10-26T12:19:37.231Z | 2024-11-01T12:26:57.803Z |
5372478 | 5372478 | 20241024005020_6RYaa | UK006C | 2024-10-26T12:19:26.156Z | 2024-11-01T12:26:57.475Z |
5372394 | 5372394 | 20241024004639_zmXa2 | UK006C | 2024-10-26T12:19:23.238Z | 2024-11-01T12:26:57.428Z |
5372166 | 5372166 | 20241024003537_4tKDe | UK006C | 2024-10-26T12:19:12.174Z | 2024-11-01T12:26:57.175Z |
5372103 | 5372103 | 20241024003322_Bc774 | UK006C | 2024-10-26T12:19:09.092Z | 2024-11-01T12:26:57.147Z |
5371997 | 5371997 | 20241024002638_wd0xj | UK006C | 2024-10-26T12:19:02.947Z | 2024-11-01T12:26:57.058Z |
5366451 | 5366451 | 20241024002202_nqBDY | UK006C | 2024-10-25T12:18:27.263Z | 2024-11-01T12:26:56.983Z |
5366294 | 5366294 | 20241024001422_B02mt | UK006C | 2024-10-25T12:18:20.580Z | 2024-11-01T12:26:56.839Z |
5366169 | 5366169 | 20241024000825_CnI2a | UK006C | 2024-10-25T12:18:18.540Z | 2024-11-01T12:26:56.778Z |
5366001 | 5366001 | 20241024000029_1HyoQ | UK006C | 2024-10-25T12:18:14.015Z | 2024-11-01T12:26:56.526Z |
5365619 | 5365619 | 20241023234115_09L9W | UK006C | 2024-10-25T12:18:03.211Z | 2024-11-01T12:26:56.291Z |
5365600 | 5365600 | 20241023233937_XRNbO | UK006C | 2024-10-25T12:18:02.513Z | 2024-11-01T12:26:56.273Z |
5365397 | 5365397 | 20241023233008_lRHh7 | UK006C | 2024-10-25T12:17:57.180Z | 2024-11-01T12:26:56.080Z |
5364897 | 5364897 | 20241023230012_ce2sJ | UK006C | 2024-10-25T12:17:39.368Z | 2024-11-01T12:26:55.743Z |
5364666 | 5364666 | 20241023224535_3czGB | UK006C | 2024-10-25T12:17:29.062Z | 2024-11-01T12:26:55.351Z |
5364141 | 5364141 | 20241023220940_Qklis | UK006C | 2024-10-25T12:17:10.432Z | 2024-11-01T12:26:54.560Z |
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);