participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
718 rows where station_code = "UK00CH" 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 |
---|---|---|---|---|---|
5562516 | 5562516 | 20241119234654_vu1Ot | UK00CH | 2024-11-21T14:15:04.064Z | 2024-11-21T14:18:53.696Z |
5561833 | 5561833 | 20241119221514_CIGAA | UK00CH | 2024-11-21T14:14:08.993Z | 2024-11-21T14:18:53.588Z |
5561693 | 5561693 | 20241119214056_G7WpM | UK00CH | 2024-11-21T14:13:45.748Z | 2024-11-21T14:18:53.562Z |
5561675 | 5561675 | 20241119212819_WQebg | UK00CH | 2024-11-21T14:13:42.196Z | 2024-11-21T14:18:53.559Z |
5561147 | 5561147 | 20241119183511_cDd2I | UK00CH | 2024-11-21T14:12:28.441Z | 2024-11-21T14:18:53.415Z |
5558545 | 5558545 | 20241120062705_PX2o4 | UK00CH | 2024-11-21T14:03:33.631Z | 2024-11-21T14:03:33.631Z |
5558178 | 5558178 | 20241120054212_4oc2A | UK00CH | 2024-11-21T14:02:39.462Z | 2024-11-21T14:02:39.462Z |
5552630 | 5552630 | 20241117193019_2qjWq | UK00CH | 2024-11-19T14:08:47.971Z | 2024-11-21T14:21:51.651Z |
5543062 | 5543062 | 20241114193706_j3HPp | UK00CH | 2024-11-16T14:05:28.501Z | 2024-11-21T14:24:22.741Z |
5539087 | 5539087 | 20241113054130_DJc5z | UK00CH | 2024-11-14T14:14:12.861Z | 2024-11-21T14:26:31.592Z |
5539084 | 5539084 | 20241113054117_OtVyS | UK00CH | 2024-11-14T14:14:11.869Z | 2024-11-21T14:26:31.590Z |
5539055 | 5539055 | 20241113053816_9o3fo | UK00CH | 2024-11-14T14:14:10.163Z | 2024-11-21T14:26:31.082Z |
5538941 | 5538941 | 20241113052252_36M8F | UK00CH | 2024-11-14T14:14:04.648Z | 2024-11-21T14:26:30.081Z |
5538824 | 5538824 | 20241113050235_MwxOZ | UK00CH | 2024-11-14T14:13:59.193Z | 2024-11-21T14:26:28.829Z |
5538813 | 5538813 | 20241113050136_NiA5p | UK00CH | 2024-11-14T14:13:58.765Z | 2024-11-21T14:26:28.822Z |
5538806 | 5538806 | 20241113050018_y7Yl2 | UK00CH | 2024-11-14T14:13:58.301Z | 2024-11-21T14:26:28.771Z |
5538746 | 5538746 | 20241113044941_tQ0Jl | UK00CH | 2024-11-14T14:13:54.506Z | 2024-11-21T14:26:28.683Z |
5538694 | 5538694 | 20241113043723_ZCTg3 | UK00CH | 2024-11-14T14:13:49.514Z | 2024-11-21T14:26:28.533Z |
5538666 | 5538666 | 20241113043227_wTvLw | UK00CH | 2024-11-14T14:13:48.047Z | 2024-11-21T14:26:28.470Z |
5538576 | 5538576 | 20241113041428_0fg1l | UK00CH | 2024-11-14T14:13:39.332Z | 2024-11-21T14:26:27.221Z |
5538562 | 5538562 | 20241113041119_ZHTFp | UK00CH | 2024-11-14T14:13:38.350Z | 2024-11-21T14:26:27.181Z |
5538557 | 5538557 | 20241113041009_ujwtG | UK00CH | 2024-11-14T14:13:37.732Z | 2024-11-21T14:26:27.136Z |
5538464 | 5538464 | 20241113034947_B0ak3 | UK00CH | 2024-11-14T14:13:30.023Z | 2024-11-21T14:26:26.102Z |
5538388 | 5538388 | 20241113032505_zqJ6Y | UK00CH | 2024-11-14T14:13:22.011Z | 2024-11-21T14:26:25.071Z |
5538284 | 5538284 | 20241113025758_ZPn9w | UK00CH | 2024-11-14T14:13:11.199Z | 2024-11-21T14:26:22.931Z |
5538278 | 5538278 | 20241113025758_bmRB2 | UK00CH | 2024-11-14T14:13:11.036Z | 2024-11-21T14:26:22.921Z |
5538160 | 5538160 | 20241113022508_i8ut7 | UK00CH | 2024-11-14T14:12:57.807Z | 2024-11-21T14:26:21.150Z |
5538077 | 5538077 | 20241113020637_lFoUa | UK00CH | 2024-11-14T14:12:49.515Z | 2024-11-21T14:26:20.326Z |
5538013 | 5538013 | 20241113015329_3WC07 | UK00CH | 2024-11-14T14:12:42.857Z | 2024-11-21T14:26:18.701Z |
5537936 | 5537936 | 20241113013741_gEVC4 | UK00CH | 2024-11-14T14:12:38.675Z | 2024-11-21T14:26:17.370Z |
5537371 | 5537371 | 20241112222416_u7sUz | UK00CH | 2024-11-14T14:11:41.203Z | 2024-11-21T14:26:11.516Z |
5537330 | 5537330 | 20241112220850_ekY8o | UK00CH | 2024-11-14T14:11:35.869Z | 2024-11-21T14:26:11.267Z |
5537264 | 5537264 | 20241112213937_SYlaR | UK00CH | 2024-11-14T14:11:28.712Z | 2024-11-21T14:26:10.716Z |
5532201 | 5532201 | 20241112045157_suJov | UK00CH | 2024-11-13T14:16:26.831Z | 2024-11-20T14:26:20.873Z |
5531791 | 5531791 | 20241112040906_atty8 | UK00CH | 2024-11-13T14:15:55.054Z | 2024-11-20T14:26:14.329Z |
5531750 | 5531750 | 20241112040702_fgKQ8 | UK00CH | 2024-11-13T14:15:53.565Z | 2024-11-20T14:26:13.779Z |
5531686 | 5531686 | 20241112040002_LgjzV | UK00CH | 2024-11-13T14:15:50.552Z | 2024-11-20T14:26:13.433Z |
5531434 | 5531434 | 20241112033905_I5rSH | UK00CH | 2024-11-13T14:15:39.170Z | 2024-11-20T14:26:11.261Z |
5530854 | 5530854 | 20241112025253_dgKqr | UK00CH | 2024-11-13T14:14:43.711Z | 2024-11-20T14:26:04.029Z |
5530480 | 5530480 | 20241112022232_8mADr | UK00CH | 2024-11-13T14:14:17.789Z | 2024-11-20T14:26:00.649Z |
5530429 | 5530429 | 20241112021620_3ziRH | UK00CH | 2024-11-13T14:14:14.989Z | 2024-11-20T14:25:58.913Z |
5529984 | 5529984 | 20241112013231_2fAAn | UK00CH | 2024-11-13T14:13:33.586Z | 2024-11-20T14:25:52.008Z |
5529968 | 5529968 | 20241112012939_pQEH8 | UK00CH | 2024-11-13T14:13:30.364Z | 2024-11-20T14:25:51.639Z |
5529819 | 5529819 | 20241112010642_KPmD6 | UK00CH | 2024-11-13T14:13:13.225Z | 2024-11-20T14:25:48.592Z |
5529176 | 5529176 | 20241111234114_YHhpC | UK00CH | 2024-11-13T14:12:10.909Z | 2024-11-20T14:25:41.281Z |
5529040 | 5529040 | 20241111232149_d73hP | UK00CH | 2024-11-13T14:12:00.203Z | 2024-11-20T14:25:39.182Z |
5528780 | 5528780 | 20241111223808_qpVMP | UK00CH | 2024-11-13T14:11:25.763Z | 2024-11-20T14:25:35.646Z |
5524579 | 5524579 | 20241111044035_7r3Al | UK00CH | 2024-11-12T14:17:42.839Z | 2024-11-19T14:22:22.472Z |
5523837 | 5523837 | 20241111023210_fe9B3 | UK00CH | 2024-11-12T14:16:16.183Z | 2024-11-19T14:22:15.474Z |
5462168 | 5462168 | 20241101231513_0QhGQ | UK00CH | 2024-11-03T14:17:01.278Z | 2024-11-10T14:26:31.834Z |
5462134 | 5462134 | 20241101230807_dbdvC | UK00CH | 2024-11-03T14:16:58.865Z | 2024-11-10T14:26:31.593Z |
5410630 | 5410630 | 20241027052423_dD6oi | UK00CH | 2024-10-29T12:17:59.829Z | 2024-11-04T14:29:05.126Z |
5410618 | 5410618 | 20241027052324_C8RfW | UK00CH | 2024-10-29T12:17:59.573Z | 2024-11-04T14:29:05.099Z |
5410533 | 5410533 | 20241027051642_RUiax | UK00CH | 2024-10-29T12:17:57.618Z | 2024-11-04T14:29:04.734Z |
5410501 | 5410501 | 20241027051544_zFtsH | UK00CH | 2024-10-29T12:17:56.983Z | 2024-11-04T14:29:04.651Z |
5410206 | 5410206 | 20241027045939_2YCSm | UK00CH | 2024-10-29T12:17:50.640Z | 2024-11-04T14:29:04.040Z |
5410053 | 5410053 | 20241027044921_a0NsN | UK00CH | 2024-10-29T12:17:46.601Z | 2024-11-04T14:29:03.633Z |
5409479 | 5409479 | 20241027042008_j3uvR | UK00CH | 2024-10-29T12:17:25.662Z | 2024-11-04T14:29:01.853Z |
5408612 | 5408612 | 20241027033204_cQPv8 | UK00CH | 2024-10-29T12:16:39.109Z | 2024-11-04T14:28:59.674Z |
5408549 | 5408549 | 20241027033015_S6h1q | UK00CH | 2024-10-29T12:16:35.713Z | 2024-11-04T14:28:59.614Z |
5408442 | 5408442 | 20241027032712_IWPFD | UK00CH | 2024-10-29T12:16:29.522Z | 2024-11-04T14:28:59.407Z |
5408304 | 5408304 | 20241027032207_Qopv8 | UK00CH | 2024-10-29T12:16:21.841Z | 2024-11-04T14:28:59.069Z |
5408281 | 5408281 | 20241027032105_aDNOt | UK00CH | 2024-10-29T12:16:20.916Z | 2024-11-04T14:28:59.046Z |
5408267 | 5408267 | 20241027032005_7ZZ5U | UK00CH | 2024-10-29T12:16:20.248Z | 2024-11-04T14:28:59.040Z |
5407680 | 5407680 | 20241027024651_HAmtv | UK00CH | 2024-10-29T12:15:33.997Z | 2024-11-04T14:28:58.026Z |
5406525 | 5406525 | 20241027014237_CZ3Fi | UK00CH | 2024-10-29T12:14:17.407Z | 2024-11-04T14:28:55.822Z |
5404572 | 5404572 | 20241026233857_e3y63 | UK00CH | 2024-10-29T12:11:43.817Z | 2024-11-04T14:28:51.341Z |
5402311 | 5402311 | 20241026191456_5R3ez | UK00CH | 2024-10-29T12:06:58.376Z | 2024-11-04T14:28:43.688Z |
5401976 | 5401976 | 20241026181457_aC9Wg | UK00CH | 2024-10-29T12:05:57.221Z | 2024-11-04T14:28:41.177Z |
5401965 | 5401965 | 20241026181218_X4ZK6 | UK00CH | 2024-10-29T12:05:55.390Z | 2024-11-04T14:28:41.133Z |
5401963 | 5401963 | 20241026181210_XZPqg | UK00CH | 2024-10-29T12:05:54.992Z | 2024-11-04T14:28:41.121Z |
5399327 | 5399327 | 20241026041019_VVEFi | UK00CH | 2024-10-28T12:19:54.718Z | 2024-11-03T14:27:39.448Z |
5398940 | 5398940 | 20241026033936_W3sJg | UK00CH | 2024-10-28T12:19:40.644Z | 2024-11-03T14:27:38.663Z |
5398728 | 5398728 | 20241026032150_7NVzB | UK00CH | 2024-10-28T12:19:29.672Z | 2024-11-03T14:27:37.899Z |
5396536 | 5396536 | 20241026000955_0KhG3 | UK00CH | 2024-10-28T12:17:48.938Z | 2024-11-03T14:27:30.157Z |
5395873 | 5395873 | 20241025231656_HM7e3 | UK00CH | 2024-10-28T12:17:02.129Z | 2024-11-03T14:27:27.445Z |
5395596 | 5395596 | 20241025225743_SQKAS | UK00CH | 2024-10-28T12:16:30.636Z | 2024-11-03T14:27:26.084Z |
5395341 | 5395341 | 20241025223350_fUqTD | UK00CH | 2024-10-28T12:16:09.981Z | 2024-11-03T14:27:25.154Z |
5395285 | 5395285 | 20241025222924_jrEqm | UK00CH | 2024-10-28T12:16:04.448Z | 2024-11-03T14:27:24.575Z |
5384951 | 5384951 | 20241024212057_UR2Q4 | UK00CH | 2024-10-27T12:18:02.604Z | 2024-11-02T12:28:28.778Z |
5384847 | 5384847 | 20241024210324_0pQ2Q | UK00CH | 2024-10-27T12:17:49.466Z | 2024-11-02T12:28:28.456Z |
5383436 | 5383436 | 20241024182103_raDWA | UK00CH | 2024-10-27T12:15:27.478Z | 2024-11-02T12:28:25.308Z |
5377311 | 5377311 | 20241024044311_yabLv | UK00CH | 2024-10-26T12:22:33.629Z | 2024-11-01T12:27:02.357Z |
5376344 | 5376344 | 20241024035152_wesRX | UK00CH | 2024-10-26T12:21:58.170Z | 2024-11-01T12:27:01.505Z |
5374437 | 5374437 | 20241024022649_6CLTw | UK00CH | 2024-10-26T12:20:48.459Z | 2024-11-01T12:26:59.366Z |
5374346 | 5374346 | 20241024022310_jJ1Fx | UK00CH | 2024-10-26T12:20:45.600Z | 2024-11-01T12:26:58.853Z |
5371921 | 5371921 | 20241024002326_vhYNi | UK00CH | 2024-10-26T12:18:58.142Z | 2024-11-01T12:26:57.000Z |
5366330 | 5366330 | 20241024001619_G22Wg | UK00CH | 2024-10-25T12:18:23.419Z | 2024-11-01T12:26:56.872Z |
5366249 | 5366249 | 20241024001039_Skxjt | UK00CH | 2024-10-25T12:18:19.877Z | 2024-11-01T12:26:56.819Z |
5366241 | 5366241 | 20241024001003_5c7Rn | UK00CH | 2024-10-25T12:18:19.784Z | 2024-11-01T12:26:56.815Z |
5366040 | 5366040 | 20241024000215_5XyOC | UK00CH | 2024-10-25T12:18:14.957Z | 2024-11-01T12:26:56.550Z |
5365144 | 5365144 | 20241023231628_o67Ak | UK00CH | 2024-10-25T12:17:47.442Z | 2024-11-01T12:26:55.891Z |
5365074 | 5365074 | 20241023231209_4HC1j | UK00CH | 2024-10-25T12:17:44.952Z | 2024-11-01T12:26:55.848Z |
5364571 | 5364571 | 20241023223829_Q3TOu | UK00CH | 2024-10-25T12:17:25.075Z | 2024-11-01T12:26:55.221Z |
5364407 | 5364407 | 20241023222624_1OVvW | UK00CH | 2024-10-25T12:17:19.771Z | 2024-11-01T12:26:55.042Z |
5364312 | 5364312 | 20241023222008_HWaSf | UK00CH | 2024-10-25T12:17:16.239Z | 2024-11-01T12:26:54.665Z |
5363638 | 5363638 | 20241023212918_83DBZ | UK00CH | 2024-10-25T12:16:30.666Z | 2024-11-01T12:26:53.474Z |
5363624 | 5363624 | 20241023212822_0pzHN | UK00CH | 2024-10-25T12:16:28.680Z | 2024-11-01T12:26:53.470Z |
5363530 | 5363530 | 20241023211640_z6uzg | UK00CH | 2024-10-25T12:16:20.305Z | 2024-11-01T12:26:53.349Z |
5363269 | 5363269 | 20241023204044_aP4ZA | UK00CH | 2024-10-25T12:15:49.121Z | 2024-11-01T12:26:53.011Z |
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);