participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
769 rows where station_code = "UK00AZ" 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 |
---|---|---|---|---|---|
5454856 | 5454856 | 20241031053449_9l9ZH | UK00AZ | 2024-11-02T12:23:25.264Z | 2024-11-08T14:23:26.030Z |
5454842 | 5454842 | 20241031052915_PT2Qz | UK00AZ | 2024-11-02T12:23:24.807Z | 2024-11-08T14:23:25.895Z |
5454679 | 5454679 | 20241031045456_RJh0U | UK00AZ | 2024-11-02T12:23:16.701Z | 2024-11-08T14:23:24.748Z |
5454553 | 5454553 | 20241031043810_dkZl6 | UK00AZ | 2024-11-02T12:23:11.438Z | 2024-11-08T14:23:23.895Z |
5454436 | 5454436 | 20241031042131_rR3z1 | UK00AZ | 2024-11-02T12:23:06.242Z | 2024-11-08T14:23:22.969Z |
5454416 | 5454416 | 20241031041756_syGf0 | UK00AZ | 2024-11-02T12:23:05.812Z | 2024-11-08T14:23:22.900Z |
5454076 | 5454076 | 20241031033955_aVdUJ | UK00AZ | 2024-11-02T12:22:50.161Z | 2024-11-08T14:23:20.305Z |
5453978 | 5453978 | 20241031032431_d6E3T | UK00AZ | 2024-11-02T12:22:46.767Z | 2024-11-08T14:23:19.819Z |
5453920 | 5453920 | 20241031031704_Ftp3Y | UK00AZ | 2024-11-02T12:22:45.058Z | 2024-11-08T14:23:19.679Z |
5453445 | 5453445 | 20241031021249_lrTYY | UK00AZ | 2024-11-02T12:22:33.781Z | 2024-11-08T14:23:17.413Z |
5453248 | 5453248 | 20241031015344_ip9Hp | UK00AZ | 2024-11-02T12:22:30.351Z | 2024-11-08T14:23:16.227Z |
5452890 | 5452890 | 20241101051557_adTz0 | UK00AZ | 2024-11-02T12:19:31.965Z | 2024-11-08T14:22:40.259Z |
5452829 | 5452829 | 20241101045809_9Bewn | UK00AZ | 2024-11-02T12:19:26.420Z | 2024-11-08T14:22:39.851Z |
5452819 | 5452819 | 20241101045256_xxsYU | UK00AZ | 2024-11-02T12:19:25.009Z | 2024-11-08T14:22:39.719Z |
5452785 | 5452785 | 20241101043434_Pa93R | UK00AZ | 2024-11-02T12:19:21.786Z | 2024-11-08T14:22:39.372Z |
5452672 | 5452672 | 20241101040629_3nIqa | UK00AZ | 2024-11-02T12:19:12.186Z | 2024-11-08T14:22:38.633Z |
5452661 | 5452661 | 20241101040338_8oTtw | UK00AZ | 2024-11-02T12:19:10.929Z | 2024-11-08T14:22:38.476Z |
5452352 | 5452352 | 20241101025610_AEwDy | UK00AZ | 2024-11-02T12:18:41.729Z | 2024-11-08T14:22:36.642Z |
5452297 | 5452297 | 20241101024355_HWnpE | UK00AZ | 2024-11-02T12:18:35.898Z | 2024-11-08T14:22:35.836Z |
5452152 | 5452152 | 20241101021020_qWddD | UK00AZ | 2024-11-02T12:18:21.100Z | 2024-11-08T14:22:33.532Z |
5452135 | 5452135 | 20241101020602_qgyQp | UK00AZ | 2024-11-02T12:18:18.517Z | 2024-11-08T14:22:33.204Z |
5452093 | 5452093 | 20241101015621_2IDSv | UK00AZ | 2024-11-02T12:18:16.261Z | 2024-11-08T14:22:32.975Z |
5452080 | 5452080 | 20241101015401_bUAH2 | UK00AZ | 2024-11-02T12:18:15.597Z | 2024-11-08T14:22:32.887Z |
5451988 | 5451988 | 20241101014049_Cz3d2 | UK00AZ | 2024-11-02T12:18:09.699Z | 2024-11-08T14:22:32.298Z |
5451844 | 5451844 | 20241101011422_tuD7Z | UK00AZ | 2024-11-02T12:18:01.104Z | 2024-11-08T14:22:31.490Z |
5451829 | 5451829 | 20241101011222_IxSvf | UK00AZ | 2024-11-02T12:18:00.065Z | 2024-11-08T14:22:31.301Z |
5451761 | 5451761 | 20241101005953_GbkHb | UK00AZ | 2024-11-02T12:17:55.809Z | 2024-11-08T14:22:30.996Z |
5451656 | 5451656 | 20241101003920_AqWyI | UK00AZ | 2024-11-02T12:17:44.527Z | 2024-11-08T14:22:30.152Z |
5451532 | 5451532 | 20241101001049_xehHt | UK00AZ | 2024-11-02T12:17:28.054Z | 2024-11-08T14:22:29.842Z |
5451249 | 5451249 | 20241031231358_6Fiz8 | UK00AZ | 2024-11-02T12:16:45.704Z | 2024-11-08T14:22:28.800Z |
5450968 | 5450968 | 20241031220612_Pn9FH | UK00AZ | 2024-11-02T12:16:24.702Z | 2024-11-08T14:22:26.922Z |
5450772 | 5450772 | 20241031205238_MPJxw | UK00AZ | 2024-11-02T12:15:51.830Z | 2024-11-08T14:22:25.932Z |
5450724 | 5450724 | 20241031203509_gQQgG | UK00AZ | 2024-11-02T12:15:48.245Z | 2024-11-08T14:22:25.662Z |
5450186 | 5450186 | 20241031180910_ajl33 | UK00AZ | 2024-11-02T12:14:41.730Z | 2024-11-08T14:22:22.336Z |
5443134 | 5443134 | 20241030033840_OYy3p | UK00AZ | 2024-11-01T12:20:18.897Z | 2024-11-07T14:26:49.671Z |
5443112 | 5443112 | 20241030033445_fSZJw | UK00AZ | 2024-11-01T12:20:18.138Z | 2024-11-07T14:26:49.590Z |
5443086 | 5443086 | 20241030033033_sqNi9 | UK00AZ | 2024-11-01T12:20:17.457Z | 2024-11-07T14:26:49.474Z |
5443063 | 5443063 | 20241030032638_lInmG | UK00AZ | 2024-11-01T12:20:16.885Z | 2024-11-07T14:26:49.331Z |
5443000 | 5443000 | 20241030031027_jAWg3 | UK00AZ | 2024-11-01T12:20:15.301Z | 2024-11-07T14:26:49.250Z |
5442996 | 5442996 | 20241030031024_mAt2n | UK00AZ | 2024-11-01T12:20:15.233Z | 2024-11-07T14:26:49.213Z |
5442986 | 5442986 | 20241030030846_thtrz | UK00AZ | 2024-11-01T12:20:14.935Z | 2024-11-07T14:26:49.094Z |
5442756 | 5442756 | 20241030022911_tgeKH | UK00AZ | 2024-11-01T12:20:07.498Z | 2024-11-07T14:26:48.249Z |
5442693 | 5442693 | 20241030021527_Gvxoh | UK00AZ | 2024-11-01T12:20:05.481Z | 2024-11-07T14:26:47.709Z |
5442676 | 5442676 | 20241030021325_kzoCQ | UK00AZ | 2024-11-01T12:20:04.877Z | 2024-11-07T14:26:47.661Z |
5442576 | 5442576 | 20241030015535_8z23w | UK00AZ | 2024-11-01T12:20:02.349Z | 2024-11-07T14:26:47.044Z |
5442298 | 5442298 | 20241030011121_AVA9W | UK00AZ | 2024-11-01T12:19:40.716Z | 2024-11-07T14:26:46.052Z |
5442286 | 5442286 | 20241030010907_dmhdS | UK00AZ | 2024-11-01T12:19:39.471Z | 2024-11-07T14:26:45.988Z |
5441967 | 5441967 | 20241030001111_S4VTC | UK00AZ | 2024-11-01T12:19:15.117Z | 2024-11-07T14:26:44.438Z |
5441906 | 5441906 | 20241030000151_Midsx | UK00AZ | 2024-11-01T12:19:11.990Z | 2024-11-07T14:26:44.315Z |
5441898 | 5441898 | 20241029235818_1Bfvs | UK00AZ | 2024-11-01T12:19:11.530Z | 2024-11-07T14:26:44.252Z |
5441855 | 5441855 | 20241029235241_3H8V0 | UK00AZ | 2024-11-01T12:19:06.609Z | 2024-11-07T14:26:43.816Z |
5441811 | 5441811 | 20241029234120_JhBuC | UK00AZ | 2024-11-01T12:19:03.330Z | 2024-11-07T14:26:43.585Z |
5441806 | 5441806 | 20241029234044_xySBZ | UK00AZ | 2024-11-01T12:19:02.798Z | 2024-11-07T14:26:43.449Z |
5441682 | 5441682 | 20241029231032_o2pwy | UK00AZ | 2024-11-01T12:18:52.830Z | 2024-11-07T14:26:42.929Z |
5441674 | 5441674 | 20241029230956_cjrM8 | UK00AZ | 2024-11-01T12:18:52.632Z | 2024-11-07T14:26:42.915Z |
5441667 | 5441667 | 20241029230818_JZLyp | UK00AZ | 2024-11-01T12:18:52.303Z | 2024-11-07T14:26:42.896Z |
5441651 | 5441651 | 20241029225850_hBsO7 | UK00AZ | 2024-11-01T12:18:50.741Z | 2024-11-07T14:26:42.820Z |
5441551 | 5441551 | 20241029223520_qrrYT | UK00AZ | 2024-11-01T12:18:44.472Z | 2024-11-07T14:26:42.648Z |
5441474 | 5441474 | 20241029222056_ZjrR5 | UK00AZ | 2024-11-01T12:18:39.199Z | 2024-11-07T14:26:42.277Z |
5441462 | 5441462 | 20241029221913_HS9oh | UK00AZ | 2024-11-01T12:18:38.099Z | 2024-11-07T14:26:42.249Z |
5441446 | 5441446 | 20241029221624_jj33M | UK00AZ | 2024-11-01T12:18:36.766Z | 2024-11-07T14:26:42.135Z |
5441204 | 5441204 | 20241029210920_3Mmws | UK00AZ | 2024-11-01T12:18:17.611Z | 2024-11-07T14:26:41.246Z |
5441193 | 5441193 | 20241029210723_Go3e2 | UK00AZ | 2024-11-01T12:18:16.723Z | 2024-11-07T14:26:41.208Z |
5440941 | 5440941 | 20241030232703_ldx0J | UK00AZ | 2024-11-01T12:16:02.898Z | 2024-11-08T14:23:11.200Z |
5409926 | 5409926 | 20241027044208_vyY9l | UK00AZ | 2024-10-29T12:17:44.147Z | 2024-11-04T14:29:02.940Z |
5409855 | 5409855 | 20241027043844_8Mukd | UK00AZ | 2024-10-29T12:17:42.453Z | 2024-11-04T14:29:02.818Z |
5409574 | 5409574 | 20241027042546_KOBrQ | UK00AZ | 2024-10-29T12:17:30.908Z | 2024-11-04T14:29:01.962Z |
5409366 | 5409366 | 20241027041246_JhiK7 | UK00AZ | 2024-10-29T12:17:18.060Z | 2024-11-04T14:29:01.600Z |
5409139 | 5409139 | 20241027040208_6TNCq | UK00AZ | 2024-10-29T12:17:08.766Z | 2024-11-04T14:29:01.213Z |
5408909 | 5408909 | 20241027034914_LxxHL | UK00AZ | 2024-10-29T12:16:56.270Z | 2024-11-04T14:29:00.778Z |
5408748 | 5408748 | 20241027034112_pgBUI | UK00AZ | 2024-10-29T12:16:48.081Z | 2024-11-04T14:29:00.378Z |
5408465 | 5408465 | 20241027032801_7qn1R | UK00AZ | 2024-10-29T12:16:31.455Z | 2024-11-04T14:28:59.542Z |
5408448 | 5408448 | 20241027032722_aIcUH | UK00AZ | 2024-10-29T12:16:29.799Z | 2024-11-04T14:28:59.499Z |
5407799 | 5407799 | 20241027025259_wtpJD | UK00AZ | 2024-10-29T12:15:42.036Z | 2024-11-04T14:28:58.156Z |
5407002 | 5407002 | 20241027021618_1Lts6 | UK00AZ | 2024-10-29T12:15:07.399Z | 2024-11-04T14:28:56.766Z |
5406963 | 5406963 | 20241027021407_4hW3W | UK00AZ | 2024-10-29T12:15:02.819Z | 2024-11-04T14:28:56.731Z |
5406681 | 5406681 | 20241027015311_9emEf | UK00AZ | 2024-10-29T12:14:31.240Z | 2024-11-04T14:28:56.028Z |
5406647 | 5406647 | 20241027015144_gwnWn | UK00AZ | 2024-10-29T12:14:28.269Z | 2024-11-04T14:28:55.971Z |
5406618 | 5406618 | 20241027014857_VuRt8 | UK00AZ | 2024-10-29T12:14:25.250Z | 2024-11-04T14:28:55.924Z |
5406356 | 5406356 | 20241027013006_mzczi | UK00AZ | 2024-10-29T12:14:03.637Z | 2024-11-04T14:28:55.495Z |
5406306 | 5406306 | 20241027012647_e1hSo | UK00AZ | 2024-10-29T12:14:01.490Z | 2024-11-04T14:28:55.422Z |
5406035 | 5406035 | 20241027011245_Lj2ZT | UK00AZ | 2024-10-29T12:13:48.660Z | 2024-11-04T14:28:54.896Z |
5405748 | 5405748 | 20241027005515_8oM7V | UK00AZ | 2024-10-29T12:13:11.734Z | 2024-11-04T14:28:54.134Z |
5405355 | 5405355 | 20241027002939_uqiDW | UK00AZ | 2024-10-29T12:12:51.136Z | 2024-11-04T14:28:53.334Z |
5405255 | 5405255 | 20241027002547_lNBYz | UK00AZ | 2024-10-29T12:12:46.320Z | 2024-11-04T14:28:53.177Z |
5404946 | 5404946 | 20241027000207_GCmut | UK00AZ | 2024-10-29T12:12:09.287Z | 2024-11-04T14:28:52.440Z |
5404577 | 5404577 | 20241026233905_qFuyg | UK00AZ | 2024-10-29T12:11:43.932Z | 2024-11-04T14:28:51.349Z |
5404530 | 5404530 | 20241026233423_43tt7 | UK00AZ | 2024-10-29T12:11:40.873Z | 2024-11-04T14:28:51.294Z |
5404450 | 5404450 | 20241026232650_31hau | UK00AZ | 2024-10-29T12:11:28.060Z | 2024-11-04T14:28:51.056Z |
5387068 | 5387068 | 20241025015642_bgI99 | UK00AZ | 2024-10-27T12:20:51.147Z | 2024-11-02T12:28:32.069Z |
5386698 | 5386698 | 20241025011614_0fcxl | UK00AZ | 2024-10-27T12:20:19.755Z | 2024-11-02T12:28:31.497Z |
5386684 | 5386684 | 20241025011400_zj0kT | UK00AZ | 2024-10-27T12:20:18.458Z | 2024-11-02T12:28:31.491Z |
5386674 | 5386674 | 20241025011306_aH834 | UK00AZ | 2024-10-27T12:20:17.285Z | 2024-11-02T12:28:31.482Z |
5385825 | 5385825 | 20241024233411_xFw29 | UK00AZ | 2024-10-27T12:19:26.948Z | 2024-11-02T12:28:30.291Z |
5385755 | 5385755 | 20241024232505_HIVZV | UK00AZ | 2024-10-27T12:19:21.232Z | 2024-11-02T12:28:30.151Z |
5385682 | 5385682 | 20241024231754_w3qgE | UK00AZ | 2024-10-27T12:19:16.137Z | 2024-11-02T12:28:30.036Z |
5385177 | 5385177 | 20241024220220_2O3H5 | UK00AZ | 2024-10-27T12:18:32.180Z | 2024-11-02T12:28:29.238Z |
5378051 | 5378051 | 20241024052525_uw2Cu | UK00AZ | 2024-10-26T12:22:53.740Z | 2024-11-01T12:27:03.265Z |
5377262 | 5377262 | 20241024044136_Dbg5m | UK00AZ | 2024-10-26T12:22:32.237Z | 2024-11-01T12:27:02.340Z |
5377044 | 5377044 | 20241024042950_KsDHO | UK00AZ | 2024-10-26T12:22:24.790Z | 2024-11-01T12:27:02.156Z |
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);