participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,270 rows where station_code = "UK001U" 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 |
---|---|---|---|---|---|
5124942 | 5124942 | 20240917225608_CRlD2 | UK001U | 2024-09-19T12:01:50.474Z | 2024-09-19T12:06:41.955Z |
5124832 | 5124832 | 20240917221520_RcOc1 | UK001U | 2024-09-19T12:01:39.490Z | 2024-09-19T12:06:41.941Z |
5124705 | 5124705 | 20240917215057_8SuHw | UK001U | 2024-09-19T12:01:21.598Z | 2024-09-19T12:06:41.927Z |
5124620 | 5124620 | 20240917213921_D2aqM | UK001U | 2024-09-19T12:01:14.480Z | 2024-09-19T12:06:41.919Z |
5124462 | 5124462 | 20240917202910_S1vA3 | UK001U | 2024-09-19T12:00:58.335Z | 2024-09-19T12:06:41.898Z |
5113966 | 5113966 | 20240915012116_1VSgb | UK001U | 2024-09-18T12:04:56.776Z | 2024-09-19T12:18:54.884Z |
5113585 | 5113585 | 20240915005955_fLgDB | UK001U | 2024-09-18T12:04:34.180Z | 2024-09-19T12:18:50.510Z |
5113411 | 5113411 | 20240915004805_b42ud | UK001U | 2024-09-18T12:04:15.984Z | 2024-09-19T12:18:49.004Z |
5111387 | 5111387 | 20240914203136_RWVS7 | UK001U | 2024-09-18T12:01:53.659Z | 2024-09-19T12:18:29.788Z |
5111354 | 5111354 | 20240914202700_N5sBV | UK001U | 2024-09-18T12:01:51.851Z | 2024-09-19T12:18:29.324Z |
5111282 | 5111282 | 20240914201839_S28a3 | UK001U | 2024-09-18T12:01:47.156Z | 2024-09-19T12:18:28.365Z |
5104397 | 5104397 | 20240913020713_qcrAj | UK001U | 2024-09-17T12:11:34.557Z | 2024-09-19T12:20:41.444Z |
5101207 | 5101207 | 20240914001349_Agbl2 | UK001U | 2024-09-17T12:05:26.830Z | 2024-09-19T12:19:50.061Z |
5101188 | 5101188 | 20240914001230_N9Vcg | UK001U | 2024-09-17T12:05:25.663Z | 2024-09-19T12:19:50.020Z |
5073461 | 5073461 | 20240911212725_Qytal | UK001U | 2024-09-15T12:07:12.753Z | 2024-09-19T12:21:05.827Z |
4921815 | 4921815 | 20240810010348_RYesG | UK001U | 2024-08-30T12:14:23.056Z | 2024-09-02T12:27:15.092Z |
4903752 | 4903752 | 20240808031309_2sN3B | UK001U | 2024-08-28T12:19:54.433Z | 2024-08-28T12:19:54.433Z |
4903699 | 4903699 | 20240808031037_YTYuW | UK001U | 2024-08-28T12:19:48.874Z | 2024-08-28T12:19:48.874Z |
4903518 | 4903518 | 20240808030058_nu6IQ | UK001U | 2024-08-28T12:19:40.701Z | 2024-08-28T12:19:40.701Z |
4903248 | 4903248 | 20240808024706_XLaVj | UK001U | 2024-08-28T12:19:33.402Z | 2024-08-28T12:19:33.402Z |
4902444 | 4902444 | 20240808021320_tcOkH | UK001U | 2024-08-28T12:19:18.218Z | 2024-08-28T12:19:18.218Z |
4872025 | 4872025 | 20240806212546_3FX40 | UK001U | 2024-08-19T12:09:44.429Z | 2024-08-27T12:10:14.929Z |
4784173 | 4784173 | 20240801231358_Xh3pH | UK001U | 2024-08-10T12:14:39.527Z | 2024-08-11T12:14:25.441Z |
4747914 | 4747914 | 20240729215414_R6lP2 | UK001U | 2024-08-04T12:14:57.567Z | 2024-08-06T12:15:23.378Z |
4736248 | 4736248 | 20240729024023_A4CW3 | UK001U | 2024-08-01T12:05:24.987Z | 2024-08-06T12:14:54.930Z |
4732378 | 4732378 | 20240729005624_4L5EV | UK001U | 2024-08-01T12:03:02.768Z | 2024-08-06T12:14:44.003Z |
4732256 | 4732256 | 20240729005425_FQ9ft | UK001U | 2024-08-01T12:02:56.496Z | 2024-08-06T12:14:43.651Z |
4691278 | 4691278 | 20240726013059_wCuiy | UK001U | 2024-07-27T12:05:11.841Z | 2024-08-03T12:21:18.828Z |
4677445 | 4677445 | 20240722220158_5Oorx | UK001U | 2024-07-24T12:00:58.142Z | 2024-07-31T12:17:50.901Z |
4666746 | 4666746 | 20240719000457_Wj6wW | UK001U | 2024-07-20T12:02:53.447Z | 2024-07-27T12:17:06.791Z |
4488516 | 4488516 | 20240619233409_vGbfV | UK001U | 2024-06-21T12:05:13.332Z | 2024-06-28T12:09:37.034Z |
4437065 | 4437065 | 20240608231541_GLwY9 | UK001U | 2024-06-10T12:00:55.613Z | 2024-06-17T12:15:04.825Z |
4400726 | 4400726 | 20240602002041_OA0g6 | UK001U | 2024-06-03T12:06:21.836Z | 2024-06-10T12:06:46.898Z |
4374622 | 4374622 | 20240520010846_2ydlx | UK001U | 2024-05-27T12:08:46.545Z | 2024-05-28T12:13:20.874Z |
4321992 | 4321992 | 20240508003349_3Ly6a | UK001U | 2024-05-16T12:09:52.305Z | 2024-05-17T12:12:23.243Z |
4191081 | 4191081 | 20240415030723_3ZfOa | UK001U | 2024-04-16T12:05:32.463Z | 2024-04-23T12:24:54.958Z |
4189989 | 4189989 | 20240414225125_sH3h7 | UK001U | 2024-04-16T12:02:39.007Z | 2024-04-23T12:24:40.288Z |
4189938 | 4189938 | 20240414223830_cul2x | UK001U | 2024-04-16T12:02:28.944Z | 2024-04-23T12:24:39.553Z |
4186166 | 4186166 | 20240414032715_XHXg3 | UK001U | 2024-04-15T12:06:10.050Z | 2024-04-22T12:22:27.618Z |
4186148 | 4186148 | 20240414031954_7pv6q | UK001U | 2024-04-15T12:06:05.381Z | 2024-04-22T12:22:27.032Z |
4186129 | 4186129 | 20240414031646_fkBVB | UK001U | 2024-04-15T12:06:03.637Z | 2024-04-22T12:22:26.795Z |
4186063 | 4186063 | 20240414030103_AM6dn | UK001U | 2024-04-15T12:05:54.347Z | 2024-04-22T12:22:25.108Z |
4185835 | 4185835 | 20240414021846_JUevw | UK001U | 2024-04-15T12:05:17.213Z | 2024-04-22T12:22:22.625Z |
4185814 | 4185814 | 20240414021410_BFrOB | UK001U | 2024-04-15T12:05:14.419Z | 2024-04-22T12:22:22.276Z |
4185450 | 4185450 | 20240414011411_28MpE | UK001U | 2024-04-15T12:04:29.020Z | 2024-04-22T12:22:18.825Z |
4185301 | 4185301 | 20240414004959_DgAfj | UK001U | 2024-04-15T12:04:06.620Z | 2024-04-22T12:22:17.208Z |
4185239 | 4185239 | 20240414002853_sg4n0 | UK001U | 2024-04-15T12:03:58.354Z | 2024-04-22T12:22:16.305Z |
4185208 | 4185208 | 20240414002547_UXfus | UK001U | 2024-04-15T12:03:53.627Z | 2024-04-22T12:22:16.038Z |
4185170 | 4185170 | 20240414001541_G2Jk7 | UK001U | 2024-04-15T12:03:45.521Z | 2024-04-22T12:22:14.743Z |
4185073 | 4185073 | 20240413235302_Qwfet | UK001U | 2024-04-15T12:03:31.759Z | 2024-04-22T12:22:13.965Z |
4184728 | 4184728 | 20240413214400_g0i38 | UK001U | 2024-04-15T12:02:30.457Z | 2024-04-22T12:22:09.407Z |
4184496 | 4184496 | 20240413205046_VXLt5 | UK001U | 2024-04-15T12:01:53.444Z | 2024-04-22T12:22:07.116Z |
4184475 | 4184475 | 20240413204614_6rfnN | UK001U | 2024-04-15T12:01:45.721Z | 2024-04-22T12:22:06.867Z |
4171327 | 4171327 | 20240410020752_dm2yH | UK001U | 2024-04-12T12:07:31.160Z | 2024-04-18T12:21:17.305Z |
4170940 | 4170940 | 20240411023945_p0Dlh | UK001U | 2024-04-12T12:04:24.811Z | 2024-04-19T12:13:19.853Z |
4170704 | 4170704 | 20240411005918_P2MS7 | UK001U | 2024-04-12T12:03:33.311Z | 2024-04-19T12:13:19.190Z |
4169605 | 4169605 | 20240410014619_btF1g | UK001U | 2024-04-11T12:14:54.553Z | 2024-04-18T12:21:15.679Z |
4169595 | 4169595 | 20240410014248_xUUlC | UK001U | 2024-04-11T12:14:53.647Z | 2024-04-18T12:21:15.566Z |
4166707 | 4166707 | 20240410000921_1XvK9 | UK001U | 2024-04-11T12:05:57.111Z | 2024-04-18T12:21:11.301Z |
4166597 | 4166597 | 20240409235621_Z6Qnz | UK001U | 2024-04-11T12:05:48.878Z | 2024-04-18T12:21:10.832Z |
4166387 | 4166387 | 20240409232243_oETdq | UK001U | 2024-04-11T12:05:27.391Z | 2024-04-18T12:21:09.426Z |
4155234 | 4155234 | 20240407042143_1XbR1 | UK001U | 2024-04-08T12:07:41.275Z | 2024-04-15T12:19:18.934Z |
4155178 | 4155178 | 20240407035838_dE8qa | UK001U | 2024-04-08T12:07:37.307Z | 2024-04-15T12:19:18.563Z |
4155064 | 4155064 | 20240407033928_L9Zul | UK001U | 2024-04-08T12:07:31.699Z | 2024-04-15T12:19:18.299Z |
4154086 | 4154086 | 20240407004125_T8dad | UK001U | 2024-04-08T12:05:53.768Z | 2024-04-15T12:19:13.982Z |
4130450 | 4130450 | 20240331044429_OWj34 | UK001U | 2024-04-01T12:08:09.666Z | 2024-04-08T12:18:52.388Z |
4129708 | 4129708 | 20240331024558_fZDOu | UK001U | 2024-04-01T12:07:17.310Z | 2024-04-08T12:18:44.149Z |
4129557 | 4129557 | 20240331023123_3ZocA | UK001U | 2024-04-01T12:07:02.948Z | 2024-04-08T12:18:43.198Z |
4129070 | 4129070 | 20240331012332_fTapR | UK001U | 2024-04-01T12:06:27.899Z | 2024-04-08T12:18:40.794Z |
4124156 | 4124156 | 20240330021331_rQ2A3 | UK001U | 2024-03-31T12:07:42.118Z | 2024-04-07T12:24:22.960Z |
4124098 | 4124098 | 20240330020847_FOE3v | UK001U | 2024-03-31T12:07:39.701Z | 2024-04-07T12:24:22.716Z |
4124091 | 4124091 | 20240330020653_7hs98 | UK001U | 2024-03-31T12:07:39.016Z | 2024-04-07T12:24:22.688Z |
4124003 | 4124003 | 20240330015441_DnSlt | UK001U | 2024-03-31T12:07:34.348Z | 2024-04-07T12:24:22.302Z |
4123938 | 4123938 | 20240330014524_12c0M | UK001U | 2024-03-31T12:07:32.029Z | 2024-04-07T12:24:22.135Z |
4123844 | 4123844 | 20240330012756_I1YND | UK001U | 2024-03-31T12:07:17.896Z | 2024-04-07T12:24:21.772Z |
4123640 | 4123640 | 20240330003041_JtlCd | UK001U | 2024-03-31T12:07:04.428Z | 2024-04-07T12:24:20.871Z |
4123633 | 4123633 | 20240330002900_0ffcw | UK001U | 2024-03-31T12:07:03.815Z | 2024-04-07T12:24:20.802Z |
4123549 | 4123549 | 20240330000422_4TNms | UK001U | 2024-03-31T12:06:58.879Z | 2024-04-07T12:24:20.336Z |
4123480 | 4123480 | 20240329235816_Np8c9 | UK001U | 2024-03-31T12:06:57.027Z | 2024-04-07T12:24:20.163Z |
4123303 | 4123303 | 20240329231359_OkS2N | UK001U | 2024-03-31T12:06:48.406Z | 2024-04-07T12:24:19.614Z |
4123023 | 4123023 | 20240329221443_ZnbkY | UK001U | 2024-03-31T12:06:16.682Z | 2024-04-07T12:24:18.542Z |
4123012 | 4123012 | 20240329220910_M3Apg | UK001U | 2024-03-31T12:06:15.365Z | 2024-04-07T12:24:18.379Z |
4122970 | 4122970 | 20240329215606_2UnGT | UK001U | 2024-03-31T12:06:13.305Z | 2024-04-07T12:24:18.195Z |
4122824 | 4122824 | 20240329205027_894vA | UK001U | 2024-03-31T12:06:01.881Z | 2024-04-07T12:24:17.284Z |
4122810 | 4122810 | 20240329204922_nMW5F | UK001U | 2024-03-31T12:06:00.755Z | 2024-04-07T12:24:17.160Z |
4117119 | 4117119 | 20240329025946_weDTP | UK001U | 2024-03-30T12:06:48.057Z | 2024-04-06T12:19:23.489Z |
4117055 | 4117055 | 20240329024658_B8ql6 | UK001U | 2024-03-30T12:06:33.996Z | 2024-04-06T12:19:22.636Z |
4117006 | 4117006 | 20240329023731_aIKVa | UK001U | 2024-03-30T12:06:26.756Z | 2024-04-06T12:19:22.348Z |
4116934 | 4116934 | 20240329022142_riRZi | UK001U | 2024-03-30T12:06:21.697Z | 2024-04-06T12:19:22.087Z |
4116398 | 4116398 | 20240328230710_hIg9l | UK001U | 2024-03-30T12:04:49.038Z | 2024-04-06T12:19:15.638Z |
4116338 | 4116338 | 20240328225044_SeMJz | UK001U | 2024-03-30T12:04:42.244Z | 2024-04-06T12:19:15.121Z |
4109077 | 4109077 | 20240323044640_HaKwr | UK001U | 2024-03-24T12:05:54.747Z | 2024-03-31T12:17:00.957Z |
4108917 | 4108917 | 20240323041918_P3gA9 | UK001U | 2024-03-24T12:05:45.269Z | 2024-03-31T12:17:00.095Z |
4107964 | 4107964 | 20240322222635_Tp1f3 | UK001U | 2024-03-24T12:04:14.615Z | 2024-03-31T12:16:49.688Z |
4086906 | 4086906 | 20240318051207_4ZGkg | UK001U | 2024-03-19T12:09:10.420Z | 2024-03-26T12:21:11.867Z |
4086792 | 4086792 | 20240318044454_RY0qb | UK001U | 2024-03-19T12:09:04.440Z | 2024-03-26T12:21:10.277Z |
4086595 | 4086595 | 20240318040030_d2kHq | UK001U | 2024-03-19T12:08:52.101Z | 2024-03-26T12:21:08.459Z |
4086441 | 4086441 | 20240318032722_owmrY | UK001U | 2024-03-19T12:08:34.866Z | 2024-03-26T12:21:07.236Z |
4086328 | 4086328 | 20240318030744_A0wmp | UK001U | 2024-03-19T12:08:24.358Z | 2024-03-26T12:21:05.366Z |
4086176 | 4086176 | 20240318023251_6YZDU | UK001U | 2024-03-19T12:08:12.049Z | 2024-03-26T12:21:02.425Z |
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);