participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,038 rows where station_code = "UK000R" 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 |
---|---|---|---|---|---|
5321800 | 5321800 | 20241012204414_cgSrw | UK000R | 2024-10-19T12:23:11.977Z | 2024-10-21T12:23:49.505Z |
5321697 | 5321697 | 20241018020813_oCh7d | UK000R | 2024-10-19T12:08:08.016Z | 2024-10-26T12:27:54.947Z |
5321695 | 5321695 | 20241018020259_cEQ5P | UK000R | 2024-10-19T12:08:07.712Z | 2024-10-26T12:27:54.903Z |
5321682 | 5321682 | 20241017235413_cgW1I | UK000R | 2024-10-19T12:08:06.299Z | 2024-10-26T12:27:54.041Z |
5239973 | 5239973 | 20241005044728_63yMP | UK000R | 2024-10-07T12:07:26.763Z | 2024-10-14T12:24:21.049Z |
5236732 | 5236732 | 20241003190639_1TWFw | UK000R | 2024-10-06T12:20:27.896Z | 2024-10-12T12:25:06.709Z |
5235308 | 5235308 | 20241004231714_0hXla | UK000R | 2024-10-06T12:15:59.401Z | 2024-10-13T12:26:24.102Z |
5233715 | 5233715 | 20241004201155_vwb5c | UK000R | 2024-10-06T12:13:52.237Z | 2024-10-13T12:26:21.510Z |
5233707 | 5233707 | 20241004201145_egj2b | UK000R | 2024-10-06T12:13:52.029Z | 2024-10-13T12:26:21.507Z |
5165125 | 5165125 | 20240924200218_22H2P | UK000R | 2024-09-26T12:13:20.985Z | 2024-10-02T12:19:03.570Z |
5165114 | 5165114 | 20240924195859_0t1AS | UK000R | 2024-09-26T12:13:19.996Z | 2024-10-02T12:19:03.552Z |
5132093 | 5132093 | 20240915231621_OvCW9 | UK000R | 2024-09-19T12:15:49.968Z | 2024-09-24T12:15:40.109Z |
5129626 | 5129626 | 20240917041506_fEk1Z | UK000R | 2024-09-19T12:11:54.886Z | 2024-09-25T12:22:32.039Z |
5128976 | 5128976 | 20240917030348_39vM3 | UK000R | 2024-09-19T12:11:10.147Z | 2024-09-25T12:22:28.158Z |
5128958 | 5128958 | 20240917030254_NjTz1 | UK000R | 2024-09-19T12:11:09.512Z | 2024-09-25T12:22:28.005Z |
5128374 | 5128374 | 20240917013230_Aq7D3 | UK000R | 2024-09-19T12:10:29.740Z | 2024-09-25T12:22:24.709Z |
5128328 | 5128328 | 20240917012738_7wLoW | UK000R | 2024-09-19T12:10:27.439Z | 2024-09-25T12:22:24.468Z |
5127802 | 5127802 | 20240916233717_9IYIS | UK000R | 2024-09-19T12:09:40.301Z | 2024-09-25T12:22:20.136Z |
5127744 | 5127744 | 20240916231742_DoQH3 | UK000R | 2024-09-19T12:09:35.762Z | 2024-09-25T12:22:19.309Z |
5127578 | 5127578 | 20240916223019_rW72I | UK000R | 2024-09-19T12:09:24.602Z | 2024-09-25T12:22:16.561Z |
5127369 | 5127369 | 20240916213800_XYuxG | UK000R | 2024-09-19T12:09:00.371Z | 2024-09-25T12:22:13.018Z |
5127323 | 5127323 | 20240916212352_NFCZz | UK000R | 2024-09-19T12:08:51.564Z | 2024-09-25T12:22:11.819Z |
5127294 | 5127294 | 20240916211807_In4Lp | UK000R | 2024-09-19T12:08:48.607Z | 2024-09-25T12:22:11.503Z |
5127128 | 5127128 | 20240916203043_QBYvG | UK000R | 2024-09-19T12:08:16.791Z | 2024-09-25T12:22:08.281Z |
5125107 | 5125107 | 20240918001712_ZD7Qx | UK000R | 2024-09-19T12:02:20.596Z | 2024-09-26T12:18:38.617Z |
5124712 | 5124712 | 20240917215351_FwYEc | UK000R | 2024-09-19T12:01:22.075Z | 2024-09-26T12:18:34.818Z |
5112644 | 5112644 | 20240914233857_oFHQB | UK000R | 2024-09-18T12:03:19.363Z | 2024-09-23T12:16:04.674Z |
5112186 | 5112186 | 20240914223507_7Nj2G | UK000R | 2024-09-18T12:02:52.253Z | 2024-09-23T12:16:02.987Z |
5111888 | 5111888 | 20240914213134_Iov9u | UK000R | 2024-09-18T12:02:28.887Z | 2024-09-23T12:16:01.120Z |
5106230 | 5106230 | 20240913031554_OvOOU | UK000R | 2024-09-17T12:12:45.346Z | 2024-09-21T12:16:33.025Z |
5099316 | 5099316 | 20240913205922_9oFBJ | UK000R | 2024-09-17T12:02:46.001Z | 2024-09-22T12:17:47.143Z |
5099111 | 5099111 | 20240913202736_I4ryO | UK000R | 2024-09-17T12:02:22.288Z | 2024-09-22T12:17:46.195Z |
5098944 | 5098944 | 20240913195847_dt6ZV | UK000R | 2024-09-17T12:02:04.171Z | 2024-09-22T12:17:45.349Z |
5087703 | 5087703 | 20240912234049_fFc3Y | UK000R | 2024-09-16T12:07:18.432Z | 2024-09-21T12:16:16.318Z |
5086183 | 5086183 | 20240912221657_GtjyB | UK000R | 2024-09-16T12:05:19.521Z | 2024-09-21T12:16:09.799Z |
5086167 | 5086167 | 20240912221518_b7Wo1 | UK000R | 2024-09-16T12:05:18.606Z | 2024-09-21T12:16:09.788Z |
5085263 | 5085263 | 20240912210528_D2HOo | UK000R | 2024-09-16T12:03:48.952Z | 2024-09-21T12:16:05.156Z |
5074913 | 5074913 | 20240911231611_V6zMw | UK000R | 2024-09-15T12:09:13.749Z | 2024-09-20T12:21:37.578Z |
5074892 | 5074892 | 20240911231427_yENHJ | UK000R | 2024-09-15T12:09:11.834Z | 2024-09-20T12:21:37.347Z |
5073824 | 5073824 | 20240911214558_gXyZJ | UK000R | 2024-09-15T12:07:39.505Z | 2024-09-20T12:21:33.836Z |
5072939 | 5072939 | 20240911204824_Bg1Uj | UK000R | 2024-09-15T12:06:20.275Z | 2024-09-20T12:21:30.504Z |
5069975 | 5069975 | 20240910222035_ryjfF | UK000R | 2024-09-14T12:20:10.298Z | 2024-09-19T12:21:35.546Z |
5038888 | 5038888 | 20240905222741_osNSD | UK000R | 2024-09-12T12:15:06.265Z | 2024-09-14T12:22:59.133Z |
5038852 | 5038852 | 20240905221805_E9fYj | UK000R | 2024-09-12T12:15:04.756Z | 2024-09-14T12:22:58.643Z |
5038685 | 5038685 | 20240905212437_7AFVq | UK000R | 2024-09-12T12:14:54.766Z | 2024-09-14T12:22:57.240Z |
5031800 | 5031800 | 20240906232033_BrgT6 | UK000R | 2024-09-12T12:05:50.187Z | 2024-09-15T12:21:24.335Z |
5024467 | 5024467 | 20240905222741_pOvFA | UK000R | 2024-09-11T12:03:52.808Z | 2024-09-11T12:16:32.152Z |
5024431 | 5024431 | 20240905221805_AeYBw | UK000R | 2024-09-11T12:03:41.354Z | 2024-09-11T12:16:32.134Z |
5024259 | 5024259 | 20240905212437_tlFrl | UK000R | 2024-09-11T12:03:08.444Z | 2024-09-11T12:16:32.039Z |
5019675 | 5019675 | 20240904233106_8PjGQ | UK000R | 2024-09-10T12:13:09.257Z | 2024-09-13T12:19:53.346Z |
5019457 | 5019457 | 20240904225355_VquHY | UK000R | 2024-09-10T12:12:46.531Z | 2024-09-13T12:19:52.125Z |
5019419 | 5019419 | 20240904224353_fbmBT | UK000R | 2024-09-10T12:12:43.301Z | 2024-09-13T12:19:51.847Z |
5019150 | 5019150 | 20240904215655_zBBQ7 | UK000R | 2024-09-10T12:12:12.583Z | 2024-09-13T12:19:50.751Z |
5019126 | 5019126 | 20240904215346_I4OPf | UK000R | 2024-09-10T12:12:10.519Z | 2024-09-13T12:19:50.610Z |
5019031 | 5019031 | 20240904212816_YhAQL | UK000R | 2024-09-10T12:11:56.773Z | 2024-09-13T12:19:50.176Z |
5018868 | 5018868 | 20240904205613_L2n0g | UK000R | 2024-09-10T12:11:41.660Z | 2024-09-13T12:19:49.634Z |
5007833 | 5007833 | 20240903222957_6s3SZ | UK000R | 2024-09-09T12:06:09.611Z | 2024-09-12T12:19:15.074Z |
5007815 | 5007815 | 20240903222929_OCFB2 | UK000R | 2024-09-09T12:06:09.422Z | 2024-09-12T12:19:15.051Z |
5007794 | 5007794 | 20240903222504_GvKLq | UK000R | 2024-09-09T12:06:08.556Z | 2024-09-12T12:19:14.997Z |
5007672 | 5007672 | 20240903220027_ap2Ap | UK000R | 2024-09-09T12:06:01.623Z | 2024-09-12T12:19:14.424Z |
5007562 | 5007562 | 20240903214412_Kqvtv | UK000R | 2024-09-09T12:05:54.139Z | 2024-09-12T12:19:13.899Z |
5007527 | 5007527 | 20240903213359_WIR4i | UK000R | 2024-09-09T12:05:52.065Z | 2024-09-12T12:19:13.698Z |
5007444 | 5007444 | 20240903211020_R35E6 | UK000R | 2024-09-09T12:05:46.723Z | 2024-09-12T12:19:13.000Z |
4983052 | 4983052 | 20240812004054_1I9gZ | UK000R | 2024-09-06T12:15:14.249Z | 2024-09-06T12:15:14.249Z |
4982392 | 4982392 | 20240812003313_rja08 | UK000R | 2024-09-06T12:14:50.535Z | 2024-09-06T12:14:50.535Z |
4981629 | 4981629 | 20240812002442_AdKGl | UK000R | 2024-09-06T12:14:34.643Z | 2024-09-06T12:14:34.643Z |
4979976 | 4979976 | 20240812000703_mi3b5 | UK000R | 2024-09-06T12:13:40.066Z | 2024-09-06T12:13:40.066Z |
4979754 | 4979754 | 20240812000430_Hgrvl | UK000R | 2024-09-06T12:13:27.011Z | 2024-09-06T12:13:27.011Z |
4978009 | 4978009 | 20240811234710_YwKBZ | UK000R | 2024-09-06T12:12:27.834Z | 2024-09-06T12:12:27.834Z |
4976988 | 4976988 | 20240811233540_Z37lv | UK000R | 2024-09-06T12:12:01.294Z | 2024-09-06T12:12:01.294Z |
4973005 | 4973005 | 20240811225237_H33ux | UK000R | 2024-09-05T12:10:40.716Z | 2024-09-06T12:09:39.141Z |
4971663 | 4971663 | 20240811223827_ieSYj | UK000R | 2024-09-05T12:09:53.113Z | 2024-09-06T12:08:56.361Z |
4971132 | 4971132 | 20240811223219_oC2eZ | UK000R | 2024-09-05T12:09:40.229Z | 2024-09-06T12:08:49.874Z |
4970435 | 4970435 | 20240811222533_xI2If | UK000R | 2024-09-05T12:09:26.400Z | 2024-09-06T12:08:40.130Z |
4970016 | 4970016 | 20240811222004_hrR7L | UK000R | 2024-09-05T12:09:16.730Z | 2024-09-06T12:08:17.088Z |
4968854 | 4968854 | 20240811220314_2Mbuk | UK000R | 2024-09-05T12:08:28.459Z | 2024-09-06T12:07:37.481Z |
4967406 | 4967406 | 20240811214406_x9jDJ | UK000R | 2024-09-05T12:07:38.288Z | 2024-09-06T12:06:59.217Z |
4967094 | 4967094 | 20240811213826_MGjXj | UK000R | 2024-09-05T12:07:30.154Z | 2024-09-06T12:06:53.087Z |
4966740 | 4966740 | 20240811213327_trpFy | UK000R | 2024-09-04T12:07:33.861Z | 2024-09-06T12:06:44.822Z |
4964515 | 4964515 | 20240811205703_MSNm6 | UK000R | 2024-09-04T12:06:25.678Z | 2024-09-06T12:05:24.200Z |
4954483 | 4954483 | 20240811030247_RNkwZ | UK000R | 2024-09-03T12:18:14.561Z | 2024-09-06T12:29:01.651Z |
4954152 | 4954152 | 20240811025308_370z3 | UK000R | 2024-09-03T12:18:08.573Z | 2024-09-06T12:28:51.840Z |
4953149 | 4953149 | 20240811023349_4GUnn | UK000R | 2024-09-03T12:17:21.531Z | 2024-09-06T12:28:20.173Z |
4952911 | 4952911 | 20240811022850_0iS2Z | UK000R | 2024-09-03T12:17:09.037Z | 2024-09-06T12:28:12.475Z |
4948214 | 4948214 | 20240811013040_MjPT3 | UK000R | 2024-09-02T12:14:57.707Z | 2024-09-06T12:27:11.676Z |
4915689 | 4915689 | 20240809225511_r9gBV | UK000R | 2024-08-30T12:10:12.400Z | 2024-09-02T12:24:01.216Z |
4915343 | 4915343 | 20240809224626_rBTdG | UK000R | 2024-08-30T12:09:50.975Z | 2024-09-02T12:23:54.367Z |
4914932 | 4914932 | 20240809223418_b7eoz | UK000R | 2024-08-30T12:09:36.957Z | 2024-09-02T12:23:47.857Z |
4914701 | 4914701 | 20240809222614_xkw5v | UK000R | 2024-08-30T12:09:22.707Z | 2024-09-02T12:23:41.712Z |
4914339 | 4914339 | 20240809221616_uyZwB | UK000R | 2024-08-30T12:09:07.869Z | 2024-09-02T12:23:25.291Z |
4912386 | 4912386 | 20240809211325_BKXS2 | UK000R | 2024-08-29T12:08:27.491Z | 2024-09-02T12:22:31.359Z |
4912307 | 4912307 | 20240809210947_ke0yq | UK000R | 2024-08-29T12:08:23.982Z | 2024-09-02T12:22:23.979Z |
4877996 | 4877996 | 20240807001717_w92AN | UK000R | 2024-08-19T12:14:01.767Z | 2024-08-27T12:13:31.833Z |
4877509 | 4877509 | 20240807000702_QitHq | UK000R | 2024-08-19T12:13:38.036Z | 2024-08-27T12:13:13.603Z |
4876652 | 4876652 | 20240806234411_u40P2 | UK000R | 2024-08-19T12:12:58.155Z | 2024-08-27T12:12:46.981Z |
4875723 | 4875723 | 20240806232330_Dxlu6 | UK000R | 2024-08-19T12:12:18.234Z | 2024-08-27T12:12:21.437Z |
4875594 | 4875594 | 20240806232005_G5ZdH | UK000R | 2024-08-19T12:12:13.173Z | 2024-08-27T12:12:19.168Z |
4875262 | 4875262 | 20240806231051_6SpwQ | UK000R | 2024-08-19T12:12:05.030Z | 2024-08-27T12:12:11.213Z |
4874842 | 4874842 | 20240806225854_907ng | UK000R | 2024-08-19T12:11:50.676Z | 2024-08-27T12:11:54.487Z |
4873142 | 4873142 | 20240806221304_042Is | UK000R | 2024-08-19T12:10:37.324Z | 2024-08-27T12:10:59.192Z |
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);