participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
790 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 |
---|---|---|---|---|---|
5573119 | 5573119 | 20241121035501_Ilk2S | UK00AZ | 2024-11-22T14:19:10.393Z | 2024-11-22T14:19:22.453Z |
5572592 | 5572592 | 20241121024508_3Qb3I | UK00AZ | 2024-11-22T14:18:38.510Z | 2024-11-22T14:19:22.357Z |
5572400 | 5572400 | 20241121021753_U444G | UK00AZ | 2024-11-22T14:18:22.972Z | 2024-11-22T14:19:22.323Z |
5571842 | 5571842 | 20241121005405_EXVjC | UK00AZ | 2024-11-22T14:17:42.249Z | 2024-11-22T14:19:22.205Z |
5571710 | 5571710 | 20241121003544_DZFM1 | UK00AZ | 2024-11-22T14:17:35.741Z | 2024-11-22T14:19:22.179Z |
5571523 | 5571523 | 20241121000025_51w2D | UK00AZ | 2024-11-22T14:17:13.767Z | 2024-11-22T14:19:22.141Z |
5571295 | 5571295 | 20241120231703_YCwUT | UK00AZ | 2024-11-22T14:16:48.659Z | 2024-11-22T14:19:22.093Z |
5571188 | 5571188 | 20241120224551_EESpK | UK00AZ | 2024-11-22T14:16:35.369Z | 2024-11-22T14:19:22.059Z |
5570924 | 5570924 | 20241120213139_ZT8Uv | UK00AZ | 2024-11-22T14:16:12.166Z | 2024-11-22T14:19:22.005Z |
5570761 | 5570761 | 20241120205052_QA9Hj | UK00AZ | 2024-11-22T14:16:04.197Z | 2024-11-22T14:19:21.976Z |
5570737 | 5570737 | 20241120204758_2aoA9 | UK00AZ | 2024-11-22T14:16:02.915Z | 2024-11-22T14:19:21.971Z |
5570623 | 5570623 | 20241120203029_g4ZHT | UK00AZ | 2024-11-22T14:15:56.899Z | 2024-11-22T14:19:21.952Z |
5566364 | 5566364 | 20241121060456_XgBBH | UK00AZ | 2024-11-22T14:02:32.121Z | 2024-11-22T14:02:32.121Z |
5566301 | 5566301 | 20241121055757_GEBWj | UK00AZ | 2024-11-22T14:02:23.956Z | 2024-11-22T14:02:23.956Z |
5566007 | 5566007 | 20241121051655_klAIN | UK00AZ | 2024-11-22T14:01:33.889Z | 2024-11-22T14:01:33.889Z |
5565889 | 5565889 | 20241121050112_dNvFA | UK00AZ | 2024-11-22T14:01:20.450Z | 2024-11-22T14:01:20.450Z |
5565742 | 5565742 | 20241121044108_gQ3ph | UK00AZ | 2024-11-22T14:00:50.319Z | 2024-11-22T14:00:50.319Z |
5565521 | 5565521 | 20241121041843_CZkw4 | UK00AZ | 2024-11-22T14:00:10.060Z | 2024-11-22T14:00:10.060Z |
5561285 | 5561285 | 20241119193428_4QRf2 | UK00AZ | 2024-11-21T14:13:00.215Z | 2024-11-22T14:20:30.013Z |
5517831 | 5517831 | 20241110045617_bMK9z | UK00AZ | 2024-11-11T14:14:55.206Z | 2024-11-18T14:26:38.554Z |
5517826 | 5517826 | 20241110045425_3yH9B | UK00AZ | 2024-11-11T14:14:54.969Z | 2024-11-18T14:26:38.546Z |
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-09T14:24:35.774Z |
5452829 | 5452829 | 20241101045809_9Bewn | UK00AZ | 2024-11-02T12:19:26.420Z | 2024-11-09T14:24:34.426Z |
5452819 | 5452819 | 20241101045256_xxsYU | UK00AZ | 2024-11-02T12:19:25.009Z | 2024-11-09T14:24:34.268Z |
5452785 | 5452785 | 20241101043434_Pa93R | UK00AZ | 2024-11-02T12:19:21.786Z | 2024-11-09T14:24:33.827Z |
5452672 | 5452672 | 20241101040629_3nIqa | UK00AZ | 2024-11-02T12:19:12.186Z | 2024-11-09T14:24:32.656Z |
5452661 | 5452661 | 20241101040338_8oTtw | UK00AZ | 2024-11-02T12:19:10.929Z | 2024-11-09T14:24:32.584Z |
5452352 | 5452352 | 20241101025610_AEwDy | UK00AZ | 2024-11-02T12:18:41.729Z | 2024-11-09T14:24:30.725Z |
5452297 | 5452297 | 20241101024355_HWnpE | UK00AZ | 2024-11-02T12:18:35.898Z | 2024-11-09T14:24:30.280Z |
5452152 | 5452152 | 20241101021020_qWddD | UK00AZ | 2024-11-02T12:18:21.100Z | 2024-11-09T14:24:28.491Z |
5452135 | 5452135 | 20241101020602_qgyQp | UK00AZ | 2024-11-02T12:18:18.517Z | 2024-11-09T14:24:28.414Z |
5452093 | 5452093 | 20241101015621_2IDSv | UK00AZ | 2024-11-02T12:18:16.261Z | 2024-11-09T14:24:28.103Z |
5452080 | 5452080 | 20241101015401_bUAH2 | UK00AZ | 2024-11-02T12:18:15.597Z | 2024-11-09T14:24:27.852Z |
5451988 | 5451988 | 20241101014049_Cz3d2 | UK00AZ | 2024-11-02T12:18:09.699Z | 2024-11-09T14:24:27.504Z |
5451844 | 5451844 | 20241101011422_tuD7Z | UK00AZ | 2024-11-02T12:18:01.104Z | 2024-11-09T14:24:26.197Z |
5451829 | 5451829 | 20241101011222_IxSvf | UK00AZ | 2024-11-02T12:18:00.065Z | 2024-11-09T14:24:25.790Z |
5451761 | 5451761 | 20241101005953_GbkHb | UK00AZ | 2024-11-02T12:17:55.809Z | 2024-11-09T14:24:25.355Z |
5451656 | 5451656 | 20241101003920_AqWyI | UK00AZ | 2024-11-02T12:17:44.527Z | 2024-11-09T14:24:24.872Z |
5451532 | 5451532 | 20241101001049_xehHt | UK00AZ | 2024-11-02T12:17:28.054Z | 2024-11-09T14:24:24.059Z |
5451249 | 5451249 | 20241031231358_6Fiz8 | UK00AZ | 2024-11-02T12:16:45.704Z | 2024-11-09T14:24:22.653Z |
5450968 | 5450968 | 20241031220612_Pn9FH | UK00AZ | 2024-11-02T12:16:24.702Z | 2024-11-09T14:24:20.357Z |
5450772 | 5450772 | 20241031205238_MPJxw | UK00AZ | 2024-11-02T12:15:51.830Z | 2024-11-09T14:24:17.880Z |
5450724 | 5450724 | 20241031203509_gQQgG | UK00AZ | 2024-11-02T12:15:48.245Z | 2024-11-09T14:24:17.731Z |
5450186 | 5450186 | 20241031180910_ajl33 | UK00AZ | 2024-11-02T12:14:41.730Z | 2024-11-09T14:24:14.257Z |
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 |
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);