participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,804 rows where station_code = "UK0024" 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 |
---|---|---|---|---|---|
5454586 | 5454586 | 20241031044138_E1Lby | UK0024 | 2024-11-02T12:23:13.297Z | 2024-11-08T14:23:24.290Z |
5454339 | 5454339 | 20241031041119_6UlUN | UK0024 | 2024-11-02T12:23:01.626Z | 2024-11-08T14:23:22.411Z |
5453985 | 5453985 | 20241031032552_X64j1 | UK0024 | 2024-11-02T12:22:46.799Z | 2024-11-08T14:23:19.827Z |
5453964 | 5453964 | 20241031032311_a1MQY | UK0024 | 2024-11-02T12:22:46.257Z | 2024-11-08T14:23:19.793Z |
5453917 | 5453917 | 20241031031617_9qK6N | UK0024 | 2024-11-02T12:22:44.935Z | 2024-11-08T14:23:19.663Z |
5453850 | 5453850 | 20241031031011_0uimx | UK0024 | 2024-11-02T12:22:43.735Z | 2024-11-08T14:23:19.541Z |
5453776 | 5453776 | 20241031025835_68J4T | UK0024 | 2024-11-02T12:22:42.472Z | 2024-11-08T14:23:19.036Z |
5453764 | 5453764 | 20241031025737_Azrbe | UK0024 | 2024-11-02T12:22:42.138Z | 2024-11-08T14:23:19.014Z |
5453669 | 5453669 | 20241031024101_xFdXo | UK0024 | 2024-11-02T12:22:39.716Z | 2024-11-08T14:23:18.632Z |
5453621 | 5453621 | 20241031023313_67EM2 | UK0024 | 2024-11-02T12:22:37.303Z | 2024-11-08T14:23:18.269Z |
5453603 | 5453603 | 20241031022946_fJq2a | UK0024 | 2024-11-02T12:22:36.855Z | 2024-11-08T14:23:18.176Z |
5453563 | 5453563 | 20241031022525_5xCyh | UK0024 | 2024-11-02T12:22:36.145Z | 2024-11-08T14:23:18.100Z |
5452522 | 5452522 | 20241101032951_W0ZXq | UK0024 | 2024-11-02T12:18:55.267Z | 2024-11-08T14:22:37.339Z |
5450525 | 5450525 | 20241031193924_YUDc6 | UK0024 | 2024-11-02T12:15:34.227Z | 2024-11-08T14:22:24.367Z |
5450440 | 5450440 | 20241031191901_yzeql | UK0024 | 2024-11-02T12:15:19.082Z | 2024-11-08T14:22:23.977Z |
5444387 | 5444387 | 20241031011530_3Sdwk | UK0024 | 2024-11-01T12:21:15.302Z | 2024-11-08T14:23:15.263Z |
5444313 | 5444313 | 20241031010744_mp9u2 | UK0024 | 2024-11-01T12:21:12.473Z | 2024-11-08T14:23:14.325Z |
5444150 | 5444150 | 20241031005305_TVn3d | UK0024 | 2024-11-01T12:21:07.852Z | 2024-11-08T14:23:14.026Z |
5443892 | 5443892 | 20241031002552_F3uSb | UK0024 | 2024-11-01T12:20:55.866Z | 2024-11-08T14:23:13.032Z |
5443886 | 5443886 | 20241031002414_iY322 | UK0024 | 2024-11-01T12:20:55.362Z | 2024-11-08T14:23:12.997Z |
5443850 | 5443850 | 20241031002028_bRhO6 | UK0024 | 2024-11-01T12:20:54.411Z | 2024-11-08T14:23:12.731Z |
5443792 | 5443792 | 20241031001542_P31Ct | UK0024 | 2024-11-01T12:20:51.767Z | 2024-11-08T14:23:12.476Z |
5443769 | 5443769 | 20241031001224_8FaBC | UK0024 | 2024-11-01T12:20:49.925Z | 2024-11-08T14:23:12.170Z |
5443724 | 5443724 | 20241031000917_gSzIr | UK0024 | 2024-11-01T12:20:47.926Z | 2024-11-08T14:23:12.098Z |
5443704 | 5443704 | 20241031000722_uL24G | UK0024 | 2024-11-01T12:20:47.164Z | 2024-11-08T14:23:12.015Z |
5443691 | 5443691 | 20241031000525_nXwxN | UK0024 | 2024-11-01T12:20:46.488Z | 2024-11-08T14:23:11.997Z |
5443672 | 5443672 | 20241031000253_aR9vF | UK0024 | 2024-11-01T12:20:45.707Z | 2024-11-08T14:23:11.975Z |
5443641 | 5443641 | 20241030235825_rFWTk | UK0024 | 2024-11-01T12:20:43.688Z | 2024-11-08T14:23:11.845Z |
5440901 | 5440901 | 20241030232203_YJQtQ | UK0024 | 2024-11-01T12:15:58.710Z | 2024-11-08T14:23:11.004Z |
5440699 | 5440699 | 20241030225207_cnf2R | UK0024 | 2024-11-01T12:15:45.359Z | 2024-11-08T14:23:10.447Z |
5440684 | 5440684 | 20241030224748_3GSWN | UK0024 | 2024-11-01T12:15:44.162Z | 2024-11-08T14:23:10.323Z |
5440503 | 5440503 | 20241030222117_IjmIG | UK0024 | 2024-11-01T12:15:33.764Z | 2024-11-08T14:23:09.743Z |
5440479 | 5440479 | 20241030221825_QP3OS | UK0024 | 2024-11-01T12:15:32.673Z | 2024-11-08T14:23:09.564Z |
5440382 | 5440382 | 20241030220526_2eN0B | UK0024 | 2024-11-01T12:15:28.122Z | 2024-11-08T14:23:09.300Z |
5440229 | 5440229 | 20241030214503_T1IKv | UK0024 | 2024-11-01T12:15:02.929Z | 2024-11-08T14:23:08.090Z |
5440184 | 5440184 | 20241030213846_GVFSz | UK0024 | 2024-11-01T12:14:56.183Z | 2024-11-08T14:23:07.676Z |
5440090 | 5440090 | 20241030212229_vDP3B | UK0024 | 2024-11-01T12:14:49.654Z | 2024-11-08T14:23:07.318Z |
5440080 | 5440080 | 20241030212150_IFf4W | UK0024 | 2024-11-01T12:14:49.023Z | 2024-11-08T14:23:07.253Z |
5432774 | 5432774 | 20241029043542_lJCK2 | UK0024 | 2024-10-31T12:21:34.559Z | 2024-11-06T14:27:28.678Z |
5432461 | 5432461 | 20241029033647_aQeCR | UK0024 | 2024-10-31T12:21:23.359Z | 2024-11-06T14:27:27.519Z |
5432429 | 5432429 | 20241029033305_6kzP9 | UK0024 | 2024-10-31T12:21:22.239Z | 2024-11-06T14:27:27.000Z |
5432048 | 5432048 | 20241029023523_u3Hvg | UK0024 | 2024-10-31T12:20:58.057Z | 2024-11-06T14:27:25.809Z |
5431908 | 5431908 | 20241029021518_uasN5 | UK0024 | 2024-10-31T12:20:48.466Z | 2024-11-06T14:27:25.287Z |
5431061 | 5431061 | 20241029002125_QATq3 | UK0024 | 2024-10-31T12:19:31.875Z | 2024-11-06T14:27:22.632Z |
5430927 | 5430927 | 20241029000523_3tcRN | UK0024 | 2024-10-31T12:19:19.125Z | 2024-11-06T14:27:22.279Z |
5430764 | 5430764 | 20241028233512_7Tcjg | UK0024 | 2024-10-31T12:18:59.449Z | 2024-11-06T14:27:21.470Z |
5430687 | 5430687 | 20241028232227_LVVEF | UK0024 | 2024-10-31T12:18:51.586Z | 2024-11-06T14:27:21.069Z |
5430597 | 5430597 | 20241028231107_cE292 | UK0024 | 2024-10-31T12:18:41.699Z | 2024-11-06T14:27:20.625Z |
5421076 | 5421076 | 20241028042854_soFKn | UK0024 | 2024-10-30T12:19:35.051Z | 2024-11-05T14:27:17.266Z |
5410927 | 5410927 | 20241027055341_XKj2v | UK0024 | 2024-10-29T12:18:12.379Z | 2024-11-04T14:29:06.381Z |
5410838 | 5410838 | 20241027054026_oAmxG | UK0024 | 2024-10-29T12:18:05.999Z | 2024-11-04T14:29:05.647Z |
5410373 | 5410373 | 20241027050943_oNPpN | UK0024 | 2024-10-29T12:17:54.503Z | 2024-11-04T14:29:04.469Z |
5410291 | 5410291 | 20241027050526_0Wr2Q | UK0024 | 2024-10-29T12:17:52.607Z | 2024-11-04T14:29:04.314Z |
5410262 | 5410262 | 20241027050420_ajY4E | UK0024 | 2024-10-29T12:17:51.874Z | 2024-11-04T14:29:04.272Z |
5410259 | 5410259 | 20241027050420_esUpI | UK0024 | 2024-10-29T12:17:51.831Z | 2024-11-04T14:29:04.271Z |
5410222 | 5410222 | 20241027050029_2hblT | UK0024 | 2024-10-29T12:17:50.921Z | 2024-11-04T14:29:04.202Z |
5410160 | 5410160 | 20241027045831_mqG7Y | UK0024 | 2024-10-29T12:17:49.658Z | 2024-11-04T14:29:03.925Z |
5408987 | 5408987 | 20241027035230_OoKjm | UK0024 | 2024-10-29T12:16:59.827Z | 2024-11-04T14:29:00.898Z |
5408637 | 5408637 | 20241027033405_Yu5Dt | UK0024 | 2024-10-29T12:16:41.913Z | 2024-11-04T14:28:59.711Z |
5408590 | 5408590 | 20241027033120_FgEod | UK0024 | 2024-10-29T12:16:38.400Z | 2024-11-04T14:28:59.668Z |
5408138 | 5408138 | 20241027031140_6MiAb | UK0024 | 2024-10-29T12:16:11.545Z | 2024-11-04T14:28:58.918Z |
5406780 | 5406780 | 20241027015943_0Y222 | UK0024 | 2024-10-29T12:14:41.859Z | 2024-11-04T14:28:56.379Z |
5406735 | 5406735 | 20241027015728_KpCWV | UK0024 | 2024-10-29T12:14:36.903Z | 2024-11-04T14:28:56.326Z |
5406527 | 5406527 | 20241027014240_Kq60m | UK0024 | 2024-10-29T12:14:17.636Z | 2024-11-04T14:28:55.835Z |
5406290 | 5406290 | 20241027012612_kIl9e | UK0024 | 2024-10-29T12:14:01.079Z | 2024-11-04T14:28:55.415Z |
5406167 | 5406167 | 20241027012004_rfrNy | UK0024 | 2024-10-29T12:13:55.302Z | 2024-11-04T14:28:55.175Z |
5406159 | 5406159 | 20241027011956_OYwy8 | UK0024 | 2024-10-29T12:13:54.765Z | 2024-11-04T14:28:55.170Z |
5406098 | 5406098 | 20241027011545_pvwyF | UK0024 | 2024-10-29T12:13:51.608Z | 2024-11-04T14:28:55.113Z |
5406039 | 5406039 | 20241027011257_HfAjS | UK0024 | 2024-10-29T12:13:48.835Z | 2024-11-04T14:28:54.897Z |
5405937 | 5405937 | 20241027010938_ur8m2 | UK0024 | 2024-10-29T12:13:37.395Z | 2024-11-04T14:28:54.628Z |
5405867 | 5405867 | 20241027010413_ZgVta | UK0024 | 2024-10-29T12:13:26.603Z | 2024-11-04T14:28:54.548Z |
5405710 | 5405710 | 20241027005421_2BXHF | UK0024 | 2024-10-29T12:13:10.550Z | 2024-11-04T14:28:53.926Z |
5405703 | 5405703 | 20241027005421_5oB1l | UK0024 | 2024-10-29T12:13:10.325Z | 2024-11-04T14:28:53.923Z |
5405679 | 5405679 | 20241027005303_Gqh3o | UK0024 | 2024-10-29T12:13:09.314Z | 2024-11-04T14:28:53.891Z |
5405636 | 5405636 | 20241027005104_TbB3f | UK0024 | 2024-10-29T12:13:06.571Z | 2024-11-04T14:28:53.737Z |
5405567 | 5405567 | 20241027004554_7kUXO | UK0024 | 2024-10-29T12:13:02.829Z | 2024-11-04T14:28:53.625Z |
5405539 | 5405539 | 20241027004239_dypN2 | UK0024 | 2024-10-29T12:13:00.921Z | 2024-11-04T14:28:53.598Z |
5405427 | 5405427 | 20241027003316_GPrPl | UK0024 | 2024-10-29T12:12:55.430Z | 2024-11-04T14:28:53.467Z |
5405127 | 5405127 | 20241027001501_r8A7I | UK0024 | 2024-10-29T12:12:31.081Z | 2024-11-04T14:28:52.716Z |
5405074 | 5405074 | 20241027001232_mItow | UK0024 | 2024-10-29T12:12:23.562Z | 2024-11-04T14:28:52.660Z |
5405014 | 5405014 | 20241027000921_6ZDWj | UK0024 | 2024-10-29T12:12:17.251Z | 2024-11-04T14:28:52.593Z |
5404916 | 5404916 | 20241027000035_abBGe | UK0024 | 2024-10-29T12:12:07.182Z | 2024-11-04T14:28:52.403Z |
5404859 | 5404859 | 20241026235736_cEHd2 | UK0024 | 2024-10-29T12:12:03.409Z | 2024-11-04T14:28:52.215Z |
5404598 | 5404598 | 20241026234003_k2iKG | UK0024 | 2024-10-29T12:11:45.558Z | 2024-11-04T14:28:51.377Z |
5403808 | 5403808 | 20241026223257_npkrJ | UK0024 | 2024-10-29T12:10:15.250Z | 2024-11-04T14:28:49.784Z |
5403315 | 5403315 | 20241026213952_0pjjR | UK0024 | 2024-10-29T12:09:21.628Z | 2024-11-04T14:28:48.308Z |
5403263 | 5403263 | 20241026213430_kKwiA | UK0024 | 2024-10-29T12:09:17.507Z | 2024-11-04T14:28:48.256Z |
5403207 | 5403207 | 20241026212934_XBX7g | UK0024 | 2024-10-29T12:09:13.090Z | 2024-11-04T14:28:47.964Z |
5403158 | 5403158 | 20241026212450_G520f | UK0024 | 2024-10-29T12:09:07.823Z | 2024-11-04T14:28:47.885Z |
5403031 | 5403031 | 20241026210717_OBaqF | UK0024 | 2024-10-29T12:08:45.866Z | 2024-11-04T14:28:47.449Z |
5402927 | 5402927 | 20241026204806_7euYi | UK0024 | 2024-10-29T12:08:36.807Z | 2024-11-04T14:28:46.995Z |
5402761 | 5402761 | 20241026202223_wo2Vn | UK0024 | 2024-10-29T12:08:06.522Z | 2024-11-04T14:28:46.478Z |
5402369 | 5402369 | 20241026192324_A5y8Y | UK0024 | 2024-10-29T12:07:06.205Z | 2024-11-04T14:28:44.137Z |
5402155 | 5402155 | 20241026185212_uaNdh | UK0024 | 2024-10-29T12:06:32.546Z | 2024-11-04T14:28:42.527Z |
5401931 | 5401931 | 20241026181000_EOdeR | UK0024 | 2024-10-29T12:05:52.183Z | 2024-11-04T14:28:41.076Z |
5401898 | 5401898 | 20241026180251_29qWN | UK0024 | 2024-10-29T12:05:46.300Z | 2024-11-04T14:28:40.847Z |
5400188 | 5400188 | 20241026055149_UUsPW | UK0024 | 2024-10-28T12:20:25.699Z | 2024-11-03T14:27:41.524Z |
5400082 | 5400082 | 20241026053722_jV2o3 | UK0024 | 2024-10-28T12:20:21.857Z | 2024-11-03T14:27:41.269Z |
5400001 | 5400001 | 20241026052135_PHSHr | UK0024 | 2024-10-28T12:20:18.638Z | 2024-11-03T14:27:41.089Z |
5399930 | 5399930 | 20241026051303_oyNEc | UK0024 | 2024-10-28T12:20:17.129Z | 2024-11-03T14:27:40.870Z |
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);