participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,298 rows where station_code = "UK002J" 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 |
---|---|---|---|---|---|
5129794 | 5129794 | 20240917043123_m7HA3 | UK002J | 2024-09-19T12:12:05.535Z | 2024-09-19T12:12:05.535Z |
5129436 | 5129436 | 20240917035609_0Sfo9 | UK002J | 2024-09-19T12:11:37.165Z | 2024-09-19T12:11:37.165Z |
5129395 | 5129395 | 20240917035457_VPmvh | UK002J | 2024-09-19T12:11:34.640Z | 2024-09-19T12:11:34.640Z |
5128872 | 5128872 | 20240917024913_tCBKt | UK002J | 2024-09-19T12:11:04.427Z | 2024-09-19T12:11:04.427Z |
5128741 | 5128741 | 20240917023112_gpYjQ | UK002J | 2024-09-19T12:10:59.755Z | 2024-09-19T12:10:59.755Z |
5127276 | 5127276 | 20240916211259_3j3gG | UK002J | 2024-09-19T12:08:47.030Z | 2024-09-19T12:08:47.030Z |
5127032 | 5127032 | 20240916201356_2oguW | UK002J | 2024-09-19T12:07:55.163Z | 2024-09-19T12:07:55.163Z |
5127014 | 5127014 | 20240916201243_mOrwJ | UK002J | 2024-09-19T12:07:53.136Z | 2024-09-19T12:07:53.136Z |
5126972 | 5126972 | 20240916200135_rzLZ6 | UK002J | 2024-09-19T12:07:49.259Z | 2024-09-19T12:07:49.259Z |
5124666 | 5124666 | 20240917214605_w34ej | UK002J | 2024-09-19T12:01:18.321Z | 2024-09-19T12:06:41.923Z |
5124320 | 5124320 | 20240917193253_dDDn1 | UK002J | 2024-09-19T12:00:34.140Z | 2024-09-19T12:06:41.877Z |
5122173 | 5122173 | 20240914044427_G92Nh | UK002J | 2024-09-18T12:11:08.491Z | 2024-09-19T12:20:02.923Z |
5122124 | 5122124 | 20240914043816_SE29n | UK002J | 2024-09-18T12:11:07.582Z | 2024-09-19T12:20:02.862Z |
5122023 | 5122023 | 20240914042820_mJEfX | UK002J | 2024-09-18T12:11:05.022Z | 2024-09-19T12:20:02.705Z |
5122016 | 5122016 | 20240914042741_PpMon | UK002J | 2024-09-18T12:11:04.993Z | 2024-09-19T12:20:02.705Z |
5121973 | 5121973 | 20240914042323_4l1UM | UK002J | 2024-09-18T12:11:03.681Z | 2024-09-19T12:20:02.557Z |
5121948 | 5121948 | 20240914042253_2LDId | UK002J | 2024-09-18T12:11:03.436Z | 2024-09-19T12:20:02.534Z |
5121890 | 5121890 | 20240914042027_UwaLG | UK002J | 2024-09-18T12:11:02.834Z | 2024-09-19T12:20:02.482Z |
5121832 | 5121832 | 20240914041453_vvmAX | UK002J | 2024-09-18T12:11:01.722Z | 2024-09-19T12:20:02.390Z |
5121234 | 5121234 | 20240914035618_03B7Q | UK002J | 2024-09-18T12:10:52.843Z | 2024-09-19T12:20:01.520Z |
5121198 | 5121198 | 20240914035523_kP3a1 | UK002J | 2024-09-18T12:10:52.371Z | 2024-09-19T12:20:01.490Z |
5120489 | 5120489 | 20240914032427_CUlG2 | UK002J | 2024-09-18T12:10:42.070Z | 2024-09-19T12:20:00.494Z |
5120421 | 5120421 | 20240914032020_biyKl | UK002J | 2024-09-18T12:10:39.710Z | 2024-09-19T12:20:00.207Z |
5120181 | 5120181 | 20240914030406_bq1eN | UK002J | 2024-09-18T12:10:33.621Z | 2024-09-19T12:19:59.538Z |
5120084 | 5120084 | 20240914025930_rIbm3 | UK002J | 2024-09-18T12:10:31.837Z | 2024-09-19T12:19:59.384Z |
5119962 | 5119962 | 20240914025452_2jk3k | UK002J | 2024-09-18T12:10:30.091Z | 2024-09-19T12:19:59.202Z |
5119925 | 5119925 | 20240914025403_iRxM3 | UK002J | 2024-09-18T12:10:29.593Z | 2024-09-19T12:19:59.170Z |
5119865 | 5119865 | 20240914025122_ie63A | UK002J | 2024-09-18T12:10:28.275Z | 2024-09-19T12:19:59.033Z |
5119729 | 5119729 | 20240914024608_v3ZnX | UK002J | 2024-09-18T12:10:24.624Z | 2024-09-19T12:19:58.797Z |
5119572 | 5119572 | 20240914023927_OhmTT | UK002J | 2024-09-18T12:10:22.439Z | 2024-09-19T12:19:58.542Z |
5119443 | 5119443 | 20240914023429_3r0OL | UK002J | 2024-09-18T12:10:21.364Z | 2024-09-19T12:19:58.255Z |
5117257 | 5117257 | 20240915041543_32kqX | UK002J | 2024-09-18T12:07:36.387Z | 2024-09-19T12:19:14.055Z |
5117210 | 5117210 | 20240915041252_4Zis3 | UK002J | 2024-09-18T12:07:35.679Z | 2024-09-19T12:19:13.901Z |
5117161 | 5117161 | 20240915040711_ETWrb | UK002J | 2024-09-18T12:07:34.309Z | 2024-09-19T12:19:13.674Z |
5117027 | 5117027 | 20240915035722_FmXt7 | UK002J | 2024-09-18T12:07:30.349Z | 2024-09-19T12:19:13.126Z |
5116696 | 5116696 | 20240915033705_ixQop | UK002J | 2024-09-18T12:07:17.107Z | 2024-09-19T12:19:12.086Z |
5116493 | 5116493 | 20240915032951_21KzE | UK002J | 2024-09-18T12:07:06.949Z | 2024-09-19T12:19:11.360Z |
5116448 | 5116448 | 20240915032640_CI2LX | UK002J | 2024-09-18T12:07:03.972Z | 2024-09-19T12:19:11.202Z |
5116288 | 5116288 | 20240915032022_XfqN3 | UK002J | 2024-09-18T12:06:55.249Z | 2024-09-19T12:19:10.255Z |
5116093 | 5116093 | 20240915030817_fn6LA | UK002J | 2024-09-18T12:06:39.428Z | 2024-09-19T12:19:08.692Z |
5114798 | 5114798 | 20240915015831_iQYsV | UK002J | 2024-09-18T12:05:34.746Z | 2024-09-19T12:18:59.962Z |
5114668 | 5114668 | 20240915015324_Xb4qe | UK002J | 2024-09-18T12:05:28.076Z | 2024-09-19T12:18:59.202Z |
5114528 | 5114528 | 20240915014649_fdMaf | UK002J | 2024-09-18T12:05:20.940Z | 2024-09-19T12:18:58.750Z |
5114396 | 5114396 | 20240915014101_hZoLI | UK002J | 2024-09-18T12:05:14.305Z | 2024-09-19T12:18:57.938Z |
5114273 | 5114273 | 20240915013446_9wt2n | UK002J | 2024-09-18T12:05:09.195Z | 2024-09-19T12:18:57.346Z |
5114023 | 5114023 | 20240915012337_AGBJ0 | UK002J | 2024-09-18T12:04:59.007Z | 2024-09-19T12:18:55.316Z |
5113844 | 5113844 | 20240915011543_gYMsi | UK002J | 2024-09-18T12:04:52.719Z | 2024-09-19T12:18:53.294Z |
5113202 | 5113202 | 20240915003144_fsUq3 | UK002J | 2024-09-18T12:04:02.988Z | 2024-09-19T12:18:47.997Z |
5112562 | 5112562 | 20240914232945_zEWSh | UK002J | 2024-09-18T12:03:14.838Z | 2024-09-19T12:18:41.478Z |
5112400 | 5112400 | 20240914230809_UazIM | UK002J | 2024-09-18T12:03:02.621Z | 2024-09-19T12:18:40.822Z |
5112223 | 5112223 | 20240914223819_rd33g | UK002J | 2024-09-18T12:02:54.225Z | 2024-09-19T12:18:39.837Z |
5108259 | 5108259 | 20240913043759_THDwJ | UK002J | 2024-09-17T12:13:34.232Z | 2024-09-19T12:20:47.977Z |
5108204 | 5108204 | 20240913043131_d3Xeq | UK002J | 2024-09-17T12:13:32.534Z | 2024-09-19T12:20:47.917Z |
5108090 | 5108090 | 20240913042246_PcaE2 | UK002J | 2024-09-17T12:13:30.364Z | 2024-09-19T12:20:47.843Z |
5108063 | 5108063 | 20240913042227_zWWmq | UK002J | 2024-09-17T12:13:30.150Z | 2024-09-19T12:20:47.834Z |
5107887 | 5107887 | 20240913041400_b8zTH | UK002J | 2024-09-17T12:13:25.507Z | 2024-09-19T12:20:47.630Z |
5107210 | 5107210 | 20240913034703_eaT0T | UK002J | 2024-09-17T12:13:10.607Z | 2024-09-19T12:20:46.907Z |
5107193 | 5107193 | 20240913034700_OF89q | UK002J | 2024-09-17T12:13:10.532Z | 2024-09-19T12:20:46.900Z |
5106506 | 5106506 | 20240913032819_BGeiB | UK002J | 2024-09-17T12:12:56.691Z | 2024-09-19T12:20:46.164Z |
5106324 | 5106324 | 20240913031901_iekuD | UK002J | 2024-09-17T12:12:50.061Z | 2024-09-19T12:20:45.845Z |
5106028 | 5106028 | 20240913030724_n3pRc | UK002J | 2024-09-17T12:12:38.856Z | 2024-09-19T12:20:45.354Z |
5105965 | 5105965 | 20240913030414_3Cc2F | UK002J | 2024-09-17T12:12:34.557Z | 2024-09-19T12:20:45.090Z |
5105894 | 5105894 | 20240913030210_5vnyB | UK002J | 2024-09-17T12:12:32.213Z | 2024-09-19T12:20:45.038Z |
5105731 | 5105731 | 20240913025617_2nmQb | UK002J | 2024-09-17T12:12:28.127Z | 2024-09-19T12:20:44.861Z |
5105666 | 5105666 | 20240913025456_vtBVi | UK002J | 2024-09-17T12:12:25.624Z | 2024-09-19T12:20:44.791Z |
5105343 | 5105343 | 20240913024217_lH8wJ | UK002J | 2024-09-17T12:12:10.507Z | 2024-09-19T12:20:44.309Z |
5105121 | 5105121 | 20240913023157_iEiTZ | UK002J | 2024-09-17T12:11:57.298Z | 2024-09-19T12:20:43.741Z |
5104830 | 5104830 | 20240913022150_GxWTn | UK002J | 2024-09-17T12:11:45.237Z | 2024-09-19T12:20:42.920Z |
5104745 | 5104745 | 20240913022011_3wdyn | UK002J | 2024-09-17T12:11:43.763Z | 2024-09-19T12:20:42.838Z |
5104725 | 5104725 | 20240913021954_cot1K | UK002J | 2024-09-17T12:11:43.630Z | 2024-09-19T12:20:42.836Z |
5103741 | 5103741 | 20240913013839_MgwIZ | UK002J | 2024-09-17T12:11:09.652Z | 2024-09-19T12:20:40.445Z |
5103604 | 5103604 | 20240913013431_c3daU | UK002J | 2024-09-17T12:11:06.077Z | 2024-09-19T12:20:40.379Z |
5103474 | 5103474 | 20240913013113_8DvbC | UK002J | 2024-09-17T12:10:59.110Z | 2024-09-19T12:20:40.202Z |
5102967 | 5102967 | 20240914015551_ZQths | UK002J | 2024-09-17T12:07:45.569Z | 2024-09-19T12:19:56.228Z |
5102711 | 5102711 | 20240914013942_mSflV | UK002J | 2024-09-17T12:07:32.700Z | 2024-09-19T12:19:55.433Z |
5102685 | 5102685 | 20240914013752_rN9a2 | UK002J | 2024-09-17T12:07:31.646Z | 2024-09-19T12:19:55.406Z |
5102521 | 5102521 | 20240914013033_3gEnZ | UK002J | 2024-09-17T12:07:19.202Z | 2024-09-19T12:19:54.725Z |
5102395 | 5102395 | 20240914012355_rrY0Z | UK002J | 2024-09-17T12:07:07.330Z | 2024-09-19T12:19:54.057Z |
5102376 | 5102376 | 20240914012318_R4SVA | UK002J | 2024-09-17T12:07:05.965Z | 2024-09-19T12:19:53.915Z |
5102078 | 5102078 | 20240914010522_m1qbx | UK002J | 2024-09-17T12:06:47.105Z | 2024-09-19T12:19:52.409Z |
5101911 | 5101911 | 20240914005527_NzMrf | UK002J | 2024-09-17T12:06:24.077Z | 2024-09-19T12:19:51.861Z |
5101739 | 5101739 | 20240914004422_UBJy3 | UK002J | 2024-09-17T12:06:10.744Z | 2024-09-19T12:19:51.351Z |
5101723 | 5101723 | 20240914004411_A1rfk | UK002J | 2024-09-17T12:06:10.254Z | 2024-09-19T12:19:51.321Z |
5101692 | 5101692 | 20240914004336_GtBY7 | UK002J | 2024-09-17T12:06:09.316Z | 2024-09-19T12:19:51.297Z |
5101578 | 5101578 | 20240914003602_2fXVD | UK002J | 2024-09-17T12:06:02.831Z | 2024-09-19T12:19:50.976Z |
5101311 | 5101311 | 20240914001913_y13qc | UK002J | 2024-09-17T12:05:34.769Z | 2024-09-19T12:19:50.251Z |
5101112 | 5101112 | 20240914000512_hOC8P | UK002J | 2024-09-17T12:05:21.078Z | 2024-09-19T12:19:49.821Z |
5100821 | 5100821 | 20240913234635_px7iK | UK002J | 2024-09-17T12:04:58.035Z | 2024-09-19T12:19:48.798Z |
5100652 | 5100652 | 20240913233935_feois | UK002J | 2024-09-17T12:04:47.689Z | 2024-09-19T12:19:48.364Z |
5100637 | 5100637 | 20240913233852_lkxuf | UK002J | 2024-09-17T12:04:46.953Z | 2024-09-19T12:19:48.345Z |
5100560 | 5100560 | 20240913233108_ZjsC2 | UK002J | 2024-09-17T12:04:38.941Z | 2024-09-19T12:19:48.124Z |
5100106 | 5100106 | 20240913225247_Ezjry | UK002J | 2024-09-17T12:03:58.011Z | 2024-09-19T12:19:46.925Z |
5100038 | 5100038 | 20240913224236_0TX2A | UK002J | 2024-09-17T12:03:53.402Z | 2024-09-19T12:19:46.768Z |
5099730 | 5099730 | 20240913215035_MCQLj | UK002J | 2024-09-17T12:03:26.409Z | 2024-09-19T12:19:45.750Z |
5099637 | 5099637 | 20240913214413_NYLuO | UK002J | 2024-09-17T12:03:17.396Z | 2024-09-19T12:19:45.546Z |
5099287 | 5099287 | 20240913205605_cIAgm | UK002J | 2024-09-17T12:02:41.705Z | 2024-09-19T12:19:44.419Z |
5097865 | 5097865 | 20240913010724_qMWhj | UK002J | 2024-09-16T12:17:16.296Z | 2024-09-19T12:20:39.151Z |
5097817 | 5097817 | 20240913010511_PskUa | UK002J | 2024-09-16T12:17:15.284Z | 2024-09-19T12:20:39.040Z |
5097629 | 5097629 | 20240913005726_z907T | UK002J | 2024-09-16T12:17:13.812Z | 2024-09-19T12:20:38.855Z |
5097513 | 5097513 | 20240913005218_90IdC | UK002J | 2024-09-16T12:17:13.223Z | 2024-09-19T12:20:38.685Z |
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);