participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,074 rows where station_code = "UK0025" 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 |
---|---|---|---|---|---|
5562835 | 5562835 | 20241120001600_880iv | UK0025 | 2024-11-21T14:15:24.485Z | 2024-11-22T14:21:05.354Z |
5562667 | 5562667 | 20241120000303_2SduA | UK0025 | 2024-11-21T14:15:15.997Z | 2024-11-22T14:21:01.939Z |
5562485 | 5562485 | 20241119234338_7vitt | UK0025 | 2024-11-21T14:14:59.862Z | 2024-11-22T14:20:59.302Z |
5562149 | 5562149 | 20241119230300_duU6r | UK0025 | 2024-11-21T14:14:28.917Z | 2024-11-22T14:20:53.448Z |
5562101 | 5562101 | 20241119225935_w92gR | UK0025 | 2024-11-21T14:14:24.608Z | 2024-11-22T14:20:52.688Z |
5561648 | 5561648 | 20241119212444_LBasp | UK0025 | 2024-11-21T14:13:39.944Z | 2024-11-22T14:20:42.538Z |
5561610 | 5561610 | 20241119211253_QQPWr | UK0025 | 2024-11-21T14:13:34.475Z | 2024-11-22T14:20:41.968Z |
5561567 | 5561567 | 20241119210548_OUF9o | UK0025 | 2024-11-21T14:13:28.105Z | 2024-11-22T14:20:40.993Z |
5561450 | 5561450 | 20241119203745_iGHLV | UK0025 | 2024-11-21T14:13:18.123Z | 2024-11-22T14:20:37.008Z |
5557807 | 5557807 | 20241120051338_57azv | UK0025 | 2024-11-21T14:01:48.549Z | 2024-11-22T14:19:21.131Z |
5552530 | 5552530 | 20241117182305_mOv3g | UK0025 | 2024-11-19T14:08:32.097Z | 2024-11-22T14:22:41.584Z |
5532708 | 5532708 | 20241112055403_3xb33 | UK0025 | 2024-11-13T14:17:11.209Z | 2024-11-20T14:26:25.754Z |
5532618 | 5532618 | 20241112054437_LYIkN | UK0025 | 2024-11-13T14:17:03.777Z | 2024-11-20T14:26:25.171Z |
5532301 | 5532301 | 20241112050428_IOn3Y | UK0025 | 2024-11-13T14:16:35.496Z | 2024-11-20T14:26:21.727Z |
5532204 | 5532204 | 20241112045206_TbtmD | UK0025 | 2024-11-13T14:16:27.088Z | 2024-11-20T14:26:20.883Z |
5532017 | 5532017 | 20241112042835_iiSrA | UK0025 | 2024-11-13T14:16:10.657Z | 2024-11-20T14:26:17.327Z |
5531752 | 5531752 | 20241112040735_hP8MG | UK0025 | 2024-11-13T14:15:53.794Z | 2024-11-20T14:26:14.007Z |
5531108 | 5531108 | 20241112031510_3UDCM | UK0025 | 2024-11-13T14:15:15.554Z | 2024-11-20T14:26:07.976Z |
5531096 | 5531096 | 20241112031358_2OB6D | UK0025 | 2024-11-13T14:15:12.757Z | 2024-11-20T14:26:07.828Z |
5531088 | 5531088 | 20241112031256_TuWV3 | UK0025 | 2024-11-13T14:15:12.034Z | 2024-11-20T14:26:07.492Z |
5531064 | 5531064 | 20241112031008_2oDeT | UK0025 | 2024-11-13T14:15:07.579Z | 2024-11-20T14:26:06.942Z |
5530917 | 5530917 | 20241112025947_puJ4C | UK0025 | 2024-11-13T14:14:50.900Z | 2024-11-20T14:26:05.298Z |
5530526 | 5530526 | 20241112022553_QNeG1 | UK0025 | 2024-11-13T14:14:20.410Z | 2024-11-20T14:26:01.133Z |
5530343 | 5530343 | 20241112021013_KyJUS | UK0025 | 2024-11-13T14:14:10.024Z | 2024-11-20T14:25:57.341Z |
5530150 | 5530150 | 20241112015020_02zZW | UK0025 | 2024-11-13T14:13:58.730Z | 2024-11-20T14:25:54.875Z |
5530062 | 5530062 | 20241112013857_ArZX7 | UK0025 | 2024-11-13T14:13:47.786Z | 2024-11-20T14:25:54.002Z |
5529290 | 5529290 | 20241111235743_41M5j | UK0025 | 2024-11-13T14:12:19.441Z | 2024-11-20T14:25:42.580Z |
5528545 | 5528545 | 20241111213107_mYNrN | UK0025 | 2024-11-13T14:11:05.211Z | 2024-11-20T14:25:32.080Z |
5454259 | 5454259 | 20241031040354_hkiBg | UK0025 | 2024-11-02T12:22:56.908Z | 2024-11-08T14:23:21.765Z |
5454062 | 5454062 | 20241031033821_PBtx3 | UK0025 | 2024-11-02T12:22:49.869Z | 2024-11-08T14:23:20.229Z |
5453980 | 5453980 | 20241031032441_Gyu6L | UK0025 | 2024-11-02T12:22:46.779Z | 2024-11-08T14:23:19.826Z |
5453835 | 5453835 | 20241031030755_6KDsY | UK0025 | 2024-11-02T12:22:43.461Z | 2024-11-08T14:23:19.263Z |
5453339 | 5453339 | 20241031020400_pjgDD | UK0025 | 2024-11-02T12:22:32.081Z | 2024-11-08T14:23:16.773Z |
5453264 | 5453264 | 20241031015500_oTEaF | UK0025 | 2024-11-02T12:22:30.566Z | 2024-11-08T14:23:16.282Z |
5453184 | 5453184 | 20241031014900_5Hnfu | UK0025 | 2024-11-02T12:22:29.301Z | 2024-11-08T14:23:16.145Z |
5444497 | 5444497 | 20241031012628_qILci | UK0025 | 2024-11-01T12:21:20.487Z | 2024-11-08T14:23:15.758Z |
5444440 | 5444440 | 20241031012200_Jm3Wr | UK0025 | 2024-11-01T12:21:18.129Z | 2024-11-08T14:23:15.594Z |
5444380 | 5444380 | 20241031011512_wIvKY | UK0025 | 2024-11-01T12:21:15.126Z | 2024-11-08T14:23:15.210Z |
5444350 | 5444350 | 20241031011055_yg9YQ | UK0025 | 2024-11-01T12:21:13.729Z | 2024-11-08T14:23:14.617Z |
5444184 | 5444184 | 20241031005630_k22LO | UK0025 | 2024-11-01T12:21:08.370Z | 2024-11-08T14:23:14.070Z |
5444119 | 5444119 | 20241031004941_pD2Nm | UK0025 | 2024-11-01T12:21:06.666Z | 2024-11-08T14:23:13.991Z |
5444065 | 5444065 | 20241031004354_dLm70 | UK0025 | 2024-11-01T12:21:04.380Z | 2024-11-08T14:23:13.777Z |
5444045 | 5444045 | 20241031004148_suqGe | UK0025 | 2024-11-01T12:21:03.312Z | 2024-11-08T14:23:13.616Z |
5443993 | 5443993 | 20241031003623_LZIfw | UK0025 | 2024-11-01T12:21:00.891Z | 2024-11-08T14:23:13.444Z |
5443785 | 5443785 | 20241031001540_C7KQu | UK0025 | 2024-11-01T12:20:51.491Z | 2024-11-08T14:23:12.451Z |
5443692 | 5443692 | 20241031000525_nXwxN | UK0025 | 2024-11-01T12:20:46.488Z | 2024-11-08T14:23:11.997Z |
5440954 | 5440954 | 20241030233013_klOD0 | UK0025 | 2024-11-01T12:16:04.317Z | 2024-11-08T14:23:11.331Z |
5440881 | 5440881 | 20241030231813_X4ksq | UK0025 | 2024-11-01T12:15:56.966Z | 2024-11-08T14:23:10.863Z |
5440863 | 5440863 | 20241030231622_fZXTr | UK0025 | 2024-11-01T12:15:55.684Z | 2024-11-08T14:23:10.838Z |
5440798 | 5440798 | 20241030230826_lrVfR | UK0025 | 2024-11-01T12:15:52.092Z | 2024-11-08T14:23:10.739Z |
5440747 | 5440747 | 20241030230026_oWN2D | UK0025 | 2024-11-01T12:15:48.625Z | 2024-11-08T14:23:10.609Z |
5440722 | 5440722 | 20241030225503_aqQ4K | UK0025 | 2024-11-01T12:15:47.550Z | 2024-11-08T14:23:10.531Z |
5440651 | 5440651 | 20241030224044_Z0Yo1 | UK0025 | 2024-11-01T12:15:41.922Z | 2024-11-08T14:23:10.209Z |
5440458 | 5440458 | 20241030221503_tYKjD | UK0025 | 2024-11-01T12:15:31.934Z | 2024-11-08T14:23:09.517Z |
5440205 | 5440205 | 20241030214320_2wrRa | UK0025 | 2024-11-01T12:14:58.114Z | 2024-11-08T14:23:07.709Z |
5440141 | 5440141 | 20241030213007_kgq9c | UK0025 | 2024-11-01T12:14:53.913Z | 2024-11-08T14:23:07.574Z |
5440007 | 5440007 | 20241030210651_l7aCB | UK0025 | 2024-11-01T12:14:44.262Z | 2024-11-08T14:23:06.789Z |
5432960 | 5432960 | 20241029052633_da7Oy | UK0025 | 2024-10-31T12:21:41.144Z | 2024-11-06T14:27:29.395Z |
5432827 | 5432827 | 20241029045056_1DtDu | UK0025 | 2024-10-31T12:21:36.195Z | 2024-11-06T14:27:28.835Z |
5432807 | 5432807 | 20241029044145_TUeLS | UK0025 | 2024-10-31T12:21:35.724Z | 2024-11-06T14:27:28.769Z |
5432485 | 5432485 | 20241029034015_qC56m | UK0025 | 2024-10-31T12:21:24.195Z | 2024-11-06T14:27:27.610Z |
5432475 | 5432475 | 20241029033808_4b9aN | UK0025 | 2024-10-31T12:21:23.922Z | 2024-11-06T14:27:27.602Z |
5432447 | 5432447 | 20241029033626_Xd2Vh | UK0025 | 2024-10-31T12:21:22.881Z | 2024-11-06T14:27:27.499Z |
5432395 | 5432395 | 20241029032606_zoc4V | UK0025 | 2024-10-31T12:21:20.709Z | 2024-11-06T14:27:26.805Z |
5430985 | 5430985 | 20241029001206_1NNQs | UK0025 | 2024-10-31T12:19:25.507Z | 2024-11-06T14:27:22.404Z |
5430713 | 5430713 | 20241028232751_u1sYA | UK0025 | 2024-10-31T12:18:54.432Z | 2024-11-06T14:27:21.156Z |
5430697 | 5430697 | 20241028232451_2y3Ux | UK0025 | 2024-10-31T12:18:53.366Z | 2024-11-06T14:27:21.094Z |
5430650 | 5430650 | 20241028231504_u7rvA | UK0025 | 2024-10-31T12:18:46.548Z | 2024-11-06T14:27:20.944Z |
5430613 | 5430613 | 20241028231203_O9CJ4 | UK0025 | 2024-10-31T12:18:43.161Z | 2024-11-06T14:27:20.702Z |
5422978 | 5422978 | 20241027011550_xMiev | UK0025 | 2024-10-30T12:22:35.750Z | 2024-11-04T14:28:55.116Z |
5421212 | 5421212 | 20241028050700_D2Alj | UK0025 | 2024-10-30T12:19:43.242Z | 2024-11-05T14:27:17.791Z |
5410746 | 5410746 | 20241027053357_oQ1Ry | UK0025 | 2024-10-29T12:18:04.086Z | 2024-11-04T14:29:05.376Z |
5410568 | 5410568 | 20241027051839_CHur0 | UK0025 | 2024-10-29T12:17:58.376Z | 2024-11-04T14:29:04.981Z |
5410460 | 5410460 | 20241027051425_j4kW6 | UK0025 | 2024-10-29T12:17:56.381Z | 2024-11-04T14:29:04.630Z |
5410385 | 5410385 | 20241027051052_4qk7q | UK0025 | 2024-10-29T12:17:55.061Z | 2024-11-04T14:29:04.493Z |
5408809 | 5408809 | 20241027034408_gEJys | UK0025 | 2024-10-29T12:16:53.312Z | 2024-11-04T14:29:00.559Z |
5406439 | 5406439 | 20241027013754_krzSl | UK0025 | 2024-10-29T12:14:09.697Z | 2024-11-04T14:28:55.705Z |
5406435 | 5406435 | 20241027013747_3HORs | UK0025 | 2024-10-29T12:14:09.554Z | 2024-11-04T14:28:55.703Z |
5406261 | 5406261 | 20241027012412_L73YV | UK0025 | 2024-10-29T12:13:59.720Z | 2024-11-04T14:28:55.270Z |
5406228 | 5406228 | 20241027012253_zpjxk | UK0025 | 2024-10-29T12:13:58.236Z | 2024-11-04T14:28:55.230Z |
5406200 | 5406200 | 20241027012125_S2pCb | UK0025 | 2024-10-29T12:13:57.098Z | 2024-11-04T14:28:55.205Z |
5406047 | 5406047 | 20241027011309_Rq9zL | UK0025 | 2024-10-29T12:13:49.103Z | 2024-11-04T14:28:54.901Z |
5406014 | 5406014 | 20241027011214_RRwA9 | UK0025 | 2024-10-29T12:13:48.051Z | 2024-11-04T14:28:54.885Z |
5405144 | 5405144 | 20241027001553_rKOVQ | UK0025 | 2024-10-29T12:12:32.800Z | 2024-11-04T14:28:52.726Z |
5405082 | 5405082 | 20241027001237_FwTiD | UK0025 | 2024-10-29T12:12:24.161Z | 2024-11-04T14:28:52.662Z |
5405063 | 5405063 | 20241027001145_y2Fmy | UK0025 | 2024-10-29T12:12:22.362Z | 2024-11-04T14:28:52.653Z |
5404674 | 5404674 | 20241026234317_3YANw | UK0025 | 2024-10-29T12:11:50.014Z | 2024-11-04T14:28:51.508Z |
5404235 | 5404235 | 20241026231116_rTsn3 | UK0025 | 2024-10-29T12:11:02.883Z | 2024-11-04T14:28:50.549Z |
5404214 | 5404214 | 20241026230945_88JPM | UK0025 | 2024-10-29T12:11:01.102Z | 2024-11-04T14:28:50.460Z |
5404123 | 5404123 | 20241026230041_5n5Mx | UK0025 | 2024-10-29T12:10:54.861Z | 2024-11-04T14:28:50.344Z |
5403999 | 5403999 | 20241026225239_Xz8bw | UK0025 | 2024-10-29T12:10:46.897Z | 2024-11-04T14:28:50.194Z |
5403689 | 5403689 | 20241026222336_MH2h4 | UK0025 | 2024-10-29T12:10:07.836Z | 2024-11-04T14:28:49.488Z |
5402944 | 5402944 | 20241026204844_fz5J3 | UK0025 | 2024-10-29T12:08:37.848Z | 2024-11-04T14:28:47.014Z |
5402928 | 5402928 | 20241026204806_7euYi | UK0025 | 2024-10-29T12:08:36.807Z | 2024-11-04T14:28:46.995Z |
5402917 | 5402917 | 20241026204627_2JJ8H | UK0025 | 2024-10-29T12:08:36.208Z | 2024-11-04T14:28:46.986Z |
5402709 | 5402709 | 20241026201613_ywkCu | UK0025 | 2024-10-29T12:07:59.186Z | 2024-11-04T14:28:46.309Z |
5402599 | 5402599 | 20241026200406_4C2r1 | UK0025 | 2024-10-29T12:07:47.306Z | 2024-11-04T14:28:45.521Z |
5402449 | 5402449 | 20241026193916_qskDx | UK0025 | 2024-10-29T12:07:19.739Z | 2024-11-04T14:28:44.496Z |
5402249 | 5402249 | 20241026190615_7Ca0D | UK0025 | 2024-10-29T12:06:44.434Z | 2024-11-04T14:28:43.331Z |
5402193 | 5402193 | 20241026185632_mtqOR | UK0025 | 2024-10-29T12:06:36.406Z | 2024-11-04T14:28:42.832Z |
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);