participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,003 rows where station_code = "UK0083" 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 |
---|---|---|---|---|---|
5432588 | 5432588 | 20241029035551_K6bCW | UK0083 | 2024-10-31T12:21:27.957Z | 2024-11-06T14:27:28.137Z |
5432545 | 5432545 | 20241029035135_9wrcS | UK0083 | 2024-10-31T12:21:26.667Z | 2024-11-06T14:27:27.817Z |
5410699 | 5410699 | 20241027052903_M1m7L | UK0083 | 2024-10-29T12:18:02.744Z | 2024-11-04T14:29:05.236Z |
5410612 | 5410612 | 20241027052324_C8RfW | UK0083 | 2024-10-29T12:17:59.573Z | 2024-11-04T14:29:05.099Z |
5410497 | 5410497 | 20241027051544_zFtsH | UK0083 | 2024-10-29T12:17:56.983Z | 2024-11-04T14:29:04.651Z |
5410446 | 5410446 | 20241027051311_2TBK8 | UK0083 | 2024-10-29T12:17:55.799Z | 2024-11-04T14:29:04.602Z |
5410202 | 5410202 | 20241027045939_2YCSm | UK0083 | 2024-10-29T12:17:50.640Z | 2024-11-04T14:29:04.040Z |
5410169 | 5410169 | 20241027045832_yZY1r | UK0083 | 2024-10-29T12:17:49.746Z | 2024-11-04T14:29:03.980Z |
5410051 | 5410051 | 20241027044921_a0NsN | UK0083 | 2024-10-29T12:17:46.601Z | 2024-11-04T14:29:03.633Z |
5409697 | 5409697 | 20241027043055_OcZwY | UK0083 | 2024-10-29T12:17:38.061Z | 2024-11-04T14:29:02.157Z |
5409682 | 5409682 | 20241027043024_nzHgl | UK0083 | 2024-10-29T12:17:37.562Z | 2024-11-04T14:29:02.149Z |
5409668 | 5409668 | 20241027042959_eyu1f | UK0083 | 2024-10-29T12:17:36.363Z | 2024-11-04T14:29:02.061Z |
5409595 | 5409595 | 20241027042736_61ERe | UK0083 | 2024-10-29T12:17:32.048Z | 2024-11-04T14:29:01.970Z |
5409189 | 5409189 | 20241027040511_pf95o | UK0083 | 2024-10-29T12:17:10.694Z | 2024-11-04T14:29:01.357Z |
5409171 | 5409171 | 20241027040355_02mPc | UK0083 | 2024-10-29T12:17:09.544Z | 2024-11-04T14:29:01.235Z |
5408858 | 5408858 | 20241027034647_9Rrkv | UK0083 | 2024-10-29T12:16:55.008Z | 2024-11-04T14:29:00.733Z |
5406858 | 5406858 | 20241027020439_0A7AZ | UK0083 | 2024-10-29T12:14:50.745Z | 2024-11-04T14:28:56.519Z |
5406522 | 5406522 | 20241027014237_CZ3Fi | UK0083 | 2024-10-29T12:14:17.407Z | 2024-11-04T14:28:55.822Z |
5403776 | 5403776 | 20241026223014_JBCOm | UK0083 | 2024-10-29T12:10:13.221Z | 2024-11-04T14:28:49.652Z |
5403654 | 5403654 | 20241026222121_uQvh2 | UK0083 | 2024-10-29T12:10:05.187Z | 2024-11-04T14:28:49.400Z |
5403323 | 5403323 | 20241026214045_GDS6I | UK0083 | 2024-10-29T12:09:21.896Z | 2024-11-04T14:28:48.330Z |
5378057 | 5378057 | 20241024052542_Uh2EC | UK0083 | 2024-10-26T12:22:53.814Z | 2024-11-01T12:27:03.268Z |
5377903 | 5377903 | 20241024051709_aQMcx | UK0083 | 2024-10-26T12:22:49.418Z | 2024-11-01T12:27:03.158Z |
5377826 | 5377826 | 20241024051243_Hn47e | UK0083 | 2024-10-26T12:22:47.850Z | 2024-11-01T12:27:03.080Z |
5376686 | 5376686 | 20241024040833_Ga2b6 | UK0083 | 2024-10-26T12:22:10.289Z | 2024-11-01T12:27:01.741Z |
5376534 | 5376534 | 20241024035912_Z9JHc | UK0083 | 2024-10-26T12:22:04.646Z | 2024-11-01T12:27:01.591Z |
5376388 | 5376388 | 20241024035306_WJG2e | UK0083 | 2024-10-26T12:22:00.212Z | 2024-11-01T12:27:01.520Z |
5376341 | 5376341 | 20241024035152_wesRX | UK0083 | 2024-10-26T12:21:58.170Z | 2024-11-01T12:27:01.505Z |
5376306 | 5376306 | 20241024035030_pLWSq | UK0083 | 2024-10-26T12:21:56.015Z | 2024-11-01T12:27:01.488Z |
5376193 | 5376193 | 20241024034509_9Ahpq | UK0083 | 2024-10-26T12:21:53.063Z | 2024-11-01T12:27:01.447Z |
5376174 | 5376174 | 20241024034449_RVzJc | UK0083 | 2024-10-26T12:21:52.690Z | 2024-11-01T12:27:01.417Z |
5376084 | 5376084 | 20241024034034_awEbb | UK0083 | 2024-10-26T12:21:50.023Z | 2024-11-01T12:27:01.384Z |
5376044 | 5376044 | 20241024033904_9DYTP | UK0083 | 2024-10-26T12:21:48.130Z | 2024-11-01T12:27:01.343Z |
5375438 | 5375438 | 20241024031333_r0yrd | UK0083 | 2024-10-26T12:21:25.784Z | 2024-11-01T12:27:00.690Z |
5365070 | 5365070 | 20241023231209_4HC1j | UK0083 | 2024-10-25T12:17:44.952Z | 2024-11-01T12:26:55.848Z |
5364774 | 5364774 | 20241023225211_o2Fbj | UK0083 | 2024-10-25T12:17:33.874Z | 2024-11-01T12:26:55.624Z |
5364567 | 5364567 | 20241023223829_Q3TOu | UK0083 | 2024-10-25T12:17:25.075Z | 2024-11-01T12:26:55.221Z |
5364004 | 5364004 | 20241023220211_PbYxQ | UK0083 | 2024-10-25T12:17:05.393Z | 2024-11-01T12:26:54.304Z |
5363621 | 5363621 | 20241023212822_0pzHN | UK0083 | 2024-10-25T12:16:28.680Z | 2024-11-01T12:26:53.470Z |
5363500 | 5363500 | 20241023211443_QFGkG | UK0083 | 2024-10-25T12:16:16.838Z | 2024-11-01T12:26:53.327Z |
5363266 | 5363266 | 20241023204044_aP4ZA | UK0083 | 2024-10-25T12:15:49.121Z | 2024-11-01T12:26:53.011Z |
5362689 | 5362689 | 20241023195432_3O64H | UK0083 | 2024-10-25T12:15:01.885Z | 2024-11-01T12:26:52.269Z |
5351412 | 5351412 | 20241022232626_FvPt5 | UK0083 | 2024-10-24T12:17:30.614Z | 2024-10-31T12:30:00.313Z |
5350803 | 5350803 | 20241022222942_PwnI1 | UK0083 | 2024-10-24T12:16:34.114Z | 2024-10-31T12:29:58.804Z |
5350794 | 5350794 | 20241022222933_dHIFA | UK0083 | 2024-10-24T12:16:33.557Z | 2024-10-31T12:29:58.792Z |
5349874 | 5349874 | 20241022204356_AL0rS | UK0083 | 2024-10-24T12:14:44.857Z | 2024-10-31T12:29:56.812Z |
5348845 | 5348845 | 20241022190236_a2oxR | UK0083 | 2024-10-24T12:12:25.702Z | 2024-10-31T12:29:53.860Z |
5348399 | 5348399 | 20241022181438_oi2vj | UK0083 | 2024-10-24T12:11:20.886Z | 2024-10-31T12:29:52.375Z |
5342782 | 5342782 | 20241022024601_uAydV | UK0083 | 2024-10-23T12:17:23.094Z | 2024-10-30T12:26:48.906Z |
5342492 | 5342492 | 20241022022934_rSur8 | UK0083 | 2024-10-23T12:16:58.546Z | 2024-10-30T12:26:48.549Z |
5342299 | 5342299 | 20241022022020_gTiy2 | UK0083 | 2024-10-23T12:16:46.688Z | 2024-10-30T12:26:48.260Z |
5341979 | 5341979 | 20241022020236_OC6jQ | UK0083 | 2024-10-23T12:16:26.815Z | 2024-10-30T12:26:47.771Z |
5341953 | 5341953 | 20241022020115_WyaRd | UK0083 | 2024-10-23T12:16:24.913Z | 2024-10-30T12:26:47.756Z |
5341725 | 5341725 | 20241022015009_1Qlzf | UK0083 | 2024-10-23T12:16:09.839Z | 2024-10-30T12:26:47.401Z |
5341630 | 5341630 | 20241022014459_vdwmy | UK0083 | 2024-10-23T12:16:03.106Z | 2024-10-30T12:26:47.244Z |
5341540 | 5341540 | 20241022013948_5QgXQ | UK0083 | 2024-10-23T12:15:57.329Z | 2024-10-30T12:26:47.158Z |
5341338 | 5341338 | 20241022012752_86hUF | UK0083 | 2024-10-23T12:15:40.898Z | 2024-10-30T12:26:46.933Z |
5341206 | 5341206 | 20241022012026_urh07 | UK0083 | 2024-10-23T12:15:28.525Z | 2024-10-30T12:26:46.663Z |
5340792 | 5340792 | 20241022004757_xIkcS | UK0083 | 2024-10-23T12:14:54.450Z | 2024-10-30T12:26:46.307Z |
5340488 | 5340488 | 20241022001945_dOwmW | UK0083 | 2024-10-23T12:14:35.549Z | 2024-10-30T12:26:45.929Z |
5340371 | 5340371 | 20241022000844_U1aBq | UK0083 | 2024-10-23T12:14:30.077Z | 2024-10-30T12:26:45.700Z |
5340180 | 5340180 | 20241021235307_FmD4X | UK0083 | 2024-10-23T12:14:21.860Z | 2024-10-30T12:26:45.465Z |
5338910 | 5338910 | 20241021211758_O4zRc | UK0083 | 2024-10-23T12:12:13.577Z | 2024-10-30T12:26:43.224Z |
5326494 | 5326494 | 20241019184236_HzILy | UK0083 | 2024-10-21T12:09:36.345Z | 2024-10-28T12:26:41.767Z |
5320338 | 5320338 | 20241018012541_3ttpi | UK0083 | 2024-10-19T12:05:07.344Z | 2024-10-26T12:27:54.427Z |
5319880 | 5319880 | 20241017214340_SJH4S | UK0083 | 2024-10-19T12:04:02.889Z | 2024-10-26T12:27:53.491Z |
5304282 | 5304282 | 20241013043347_XCxnN | UK0083 | 2024-10-14T12:17:47.076Z | 2024-10-21T12:24:24.597Z |
5304260 | 5304260 | 20241013043241_NaZi2 | UK0083 | 2024-10-14T12:17:46.435Z | 2024-10-21T12:24:24.553Z |
5304250 | 5304250 | 20241013043216_YteW3 | UK0083 | 2024-10-14T12:17:46.034Z | 2024-10-21T12:24:24.496Z |
5303710 | 5303710 | 20241013032657_XEYv4 | UK0083 | 2024-10-14T12:17:32.569Z | 2024-10-21T12:24:20.103Z |
5303399 | 5303399 | 20241013025629_gPbnQ | UK0083 | 2024-10-14T12:17:23.597Z | 2024-10-21T12:24:17.839Z |
5303325 | 5303325 | 20241013025001_vLFdR | UK0083 | 2024-10-14T12:17:20.905Z | 2024-10-21T12:24:17.040Z |
5302090 | 5302090 | 20241013002916_KRp36 | UK0083 | 2024-10-14T12:15:52.306Z | 2024-10-21T12:24:04.358Z |
5301682 | 5301682 | 20241012235418_smXbs | UK0083 | 2024-10-14T12:15:34.596Z | 2024-10-21T12:23:59.950Z |
5301602 | 5301602 | 20241012234849_p8gKG | UK0083 | 2024-10-14T12:15:32.115Z | 2024-10-21T12:23:59.548Z |
5301367 | 5301367 | 20241012231513_OGx3n | UK0083 | 2024-10-14T12:15:21.784Z | 2024-10-21T12:23:57.856Z |
5300953 | 5300953 | 20241012221718_sX2Jz | UK0083 | 2024-10-14T12:14:38.731Z | 2024-10-21T12:23:54.105Z |
5300685 | 5300685 | 20241012212353_EmtQZ | UK0083 | 2024-10-14T12:14:22.422Z | 2024-10-21T12:23:51.734Z |
5300544 | 5300544 | 20241012205146_rMXpW | UK0083 | 2024-10-14T12:14:14.886Z | 2024-10-21T12:23:49.799Z |
5300212 | 5300212 | 20241012201236_X96ut | UK0083 | 2024-10-14T12:13:37.833Z | 2024-10-21T12:23:47.375Z |
5294793 | 5294793 | 20241013044907_IGgqk | UK0083 | 2024-10-14T12:00:20.943Z | 2024-10-22T12:24:05.461Z |
5294758 | 5294758 | 20241013044509_WPptQ | UK0083 | 2024-10-14T12:00:17.576Z | 2024-10-22T12:24:05.198Z |
5285287 | 5285287 | 20241011034706_5WZqh | UK0083 | 2024-10-12T12:18:02.285Z | 2024-10-19T12:28:01.811Z |
5284659 | 5284659 | 20241011025954_GZDW7 | UK0083 | 2024-10-12T12:17:32.048Z | 2024-10-19T12:27:57.003Z |
5284570 | 5284570 | 20241011025412_N76aQ | UK0083 | 2024-10-12T12:17:28.050Z | 2024-10-19T12:27:56.198Z |
5284272 | 5284272 | 20241011023339_o4K4C | UK0083 | 2024-10-12T12:17:15.819Z | 2024-10-19T12:27:54.893Z |
5284265 | 5284265 | 20241011023339_w2JV1 | UK0083 | 2024-10-12T12:17:15.783Z | 2024-10-19T12:27:54.891Z |
5284155 | 5284155 | 20241011022326_3Cjhr | UK0083 | 2024-10-12T12:17:10.512Z | 2024-10-19T12:27:54.139Z |
5284095 | 5284095 | 20241011022050_tdRPQ | UK0083 | 2024-10-12T12:17:07.988Z | 2024-10-19T12:27:53.956Z |
5284048 | 5284048 | 20241011021712_kf33w | UK0083 | 2024-10-12T12:17:06.011Z | 2024-10-19T12:27:53.884Z |
5283854 | 5283854 | 20241011015854_kKb2R | UK0083 | 2024-10-12T12:16:59.451Z | 2024-10-19T12:27:52.903Z |
5283627 | 5283627 | 20241011014004_9wmjq | UK0083 | 2024-10-12T12:16:48.547Z | 2024-10-19T12:27:52.260Z |
5283594 | 5283594 | 20241011013740_IhdNj | UK0083 | 2024-10-12T12:16:47.769Z | 2024-10-19T12:27:52.240Z |
5283249 | 5283249 | 20241011010732_JN6c4 | UK0083 | 2024-10-12T12:16:31.911Z | 2024-10-19T12:27:49.872Z |
5283003 | 5283003 | 20241011002822_r7ys7 | UK0083 | 2024-10-12T12:16:17.914Z | 2024-10-19T12:27:48.134Z |
5282905 | 5282905 | 20241011000606_365zI | UK0083 | 2024-10-12T12:16:10.845Z | 2024-10-19T12:27:47.287Z |
5282179 | 5282179 | 20241010202716_VFF9J | UK0083 | 2024-10-12T12:15:16.151Z | 2024-10-19T12:27:42.171Z |
5281938 | 5281938 | 20241010195634_0Wu5w | UK0083 | 2024-10-12T12:15:01.495Z | 2024-10-19T12:27:38.923Z |
5276209 | 5276209 | 20241011042448_9cwHc | UK0083 | 2024-10-12T12:00:37.367Z | 2024-10-20T12:23:06.576Z |
5268767 | 5268767 | 20241009030802_IZwBq | UK0083 | 2024-10-10T12:16:26.279Z | 2024-10-17T12:20:18.732Z |
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);