participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,169 rows where station_code = "UK001Q" 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 |
---|---|---|---|---|---|
5131656 | 5131656 | 20240915204131_ISNkf | UK001Q | 2024-09-19T12:15:12.989Z | 2024-09-19T12:15:12.989Z |
5127729 | 5127729 | 20240916231523_C4vek | UK001Q | 2024-09-19T12:09:34.971Z | 2024-09-19T12:09:34.971Z |
5127366 | 5127366 | 20240916213651_39dUt | UK001Q | 2024-09-19T12:08:59.958Z | 2024-09-19T12:08:59.958Z |
5127302 | 5127302 | 20240916212130_LoVlA | UK001Q | 2024-09-19T12:08:49.488Z | 2024-09-19T12:08:49.488Z |
5127123 | 5127123 | 20240916202939_n3MFH | UK001Q | 2024-09-19T12:08:16.253Z | 2024-09-19T12:08:16.253Z |
5126953 | 5126953 | 20240916200134_DfSMC | UK001Q | 2024-09-19T12:07:48.705Z | 2024-09-19T12:07:48.705Z |
5125023 | 5125023 | 20240917233324_zj5tc | UK001Q | 2024-09-19T12:01:57.513Z | 2024-09-19T12:06:41.963Z |
5124941 | 5124941 | 20240917225608_CRlD2 | UK001Q | 2024-09-19T12:01:50.474Z | 2024-09-19T12:06:41.955Z |
5124838 | 5124838 | 20240917221615_MiuQ5 | UK001Q | 2024-09-19T12:01:39.831Z | 2024-09-19T12:06:41.941Z |
5124798 | 5124798 | 20240917220341_25iBX | UK001Q | 2024-09-19T12:01:35.833Z | 2024-09-19T12:06:41.936Z |
5124680 | 5124680 | 20240917214723_Gu1OG | UK001Q | 2024-09-19T12:01:19.282Z | 2024-09-19T12:06:41.924Z |
5124568 | 5124568 | 20240917211327_fRJG0 | UK001Q | 2024-09-19T12:01:09.248Z | 2024-09-19T12:06:41.912Z |
5124534 | 5124534 | 20240917210104_BN7FQ | UK001Q | 2024-09-19T12:01:05.905Z | 2024-09-19T12:06:41.908Z |
5124436 | 5124436 | 20240917201828_1I1UJ | UK001Q | 2024-09-19T12:00:53.659Z | 2024-09-19T12:06:41.895Z |
5124344 | 5124344 | 20240917193845_X8mlh | UK001Q | 2024-09-19T12:00:37.424Z | 2024-09-19T12:06:41.880Z |
5115298 | 5115298 | 20240915023127_M3S08 | UK001Q | 2024-09-18T12:06:10.387Z | 2024-09-19T12:19:03.788Z |
5111353 | 5111353 | 20240914202700_N5sBV | UK001Q | 2024-09-18T12:01:51.851Z | 2024-09-19T12:18:29.324Z |
5111230 | 5111230 | 20240914201314_Fgem2 | UK001Q | 2024-09-18T12:01:44.632Z | 2024-09-19T12:18:27.914Z |
5099801 | 5099801 | 20240913220625_lZj2O | UK001Q | 2024-09-17T12:03:35.739Z | 2024-09-19T12:19:45.956Z |
5089617 | 5089617 | 20240912005131_GosJq | UK001Q | 2024-09-16T12:11:32.409Z | 2024-09-19T12:21:10.105Z |
5087533 | 5087533 | 20240912233057_Z9CID | UK001Q | 2024-09-16T12:07:03.092Z | 2024-09-19T12:20:35.283Z |
5087427 | 5087427 | 20240912232741_wONYc | UK001Q | 2024-09-16T12:06:55.873Z | 2024-09-19T12:20:34.822Z |
5084706 | 5084706 | 20240912200807_Mxhkl | UK001Q | 2024-09-16T12:02:49.979Z | 2024-09-19T12:20:27.036Z |
5084536 | 5084536 | 20240912194807_MJcJd | UK001Q | 2024-09-16T12:02:18.147Z | 2024-09-19T12:20:26.224Z |
5080236 | 5080236 | 20240911034323_iml67 | UK001Q | 2024-09-15T12:16:54.803Z | 2024-09-19T12:21:43.135Z |
5078759 | 5078759 | 20240911021525_jnz0f | UK001Q | 2024-09-15T12:15:51.427Z | 2024-09-19T12:21:40.704Z |
5078248 | 5078248 | 20240911014536_DU0BS | UK001Q | 2024-09-15T12:15:28.539Z | 2024-09-19T12:21:40.115Z |
5077213 | 5077213 | 20240911003443_YcywZ | UK001Q | 2024-09-15T12:14:31.124Z | 2024-09-19T12:21:38.523Z |
5075152 | 5075152 | 20240911233246_kamDJ | UK001Q | 2024-09-15T12:09:27.904Z | 2024-09-19T12:21:08.643Z |
5073861 | 5073861 | 20240911215216_N6RJh | UK001Q | 2024-09-15T12:07:41.869Z | 2024-09-19T12:21:06.329Z |
5073460 | 5073460 | 20240911212725_Qytal | UK001Q | 2024-09-15T12:07:12.753Z | 2024-09-19T12:21:05.827Z |
5073378 | 5073378 | 20240911211824_ODzYX | UK001Q | 2024-09-15T12:07:07.068Z | 2024-09-19T12:21:05.707Z |
5073128 | 5073128 | 20240911210114_64KPt | UK001Q | 2024-09-15T12:06:47.159Z | 2024-09-19T12:21:05.180Z |
5069176 | 5069176 | 20240910211528_pQ5mz | UK001Q | 2024-09-14T12:19:47.332Z | 2024-09-19T12:21:33.786Z |
5038934 | 5038934 | 20240905224306_NzscH | UK001Q | 2024-09-12T12:15:08.389Z | 2024-09-14T12:22:59.505Z |
5038699 | 5038699 | 20240905212638_VI2vH | UK001Q | 2024-09-12T12:14:55.291Z | 2024-09-14T12:22:57.280Z |
5031462 | 5031462 | 20240906220136_FlD12 | UK001Q | 2024-09-12T12:04:57.361Z | 2024-09-15T12:21:22.538Z |
5026104 | 5026104 | 20240905021719_viedb | UK001Q | 2024-09-11T12:11:55.516Z | 2024-09-13T12:19:56.864Z |
5024515 | 5024515 | 20240905224306_gz1oz | UK001Q | 2024-09-11T12:04:00.010Z | 2024-09-11T12:16:32.176Z |
5024269 | 5024269 | 20240905212638_DAMua | UK001Q | 2024-09-11T12:03:11.549Z | 2024-09-11T12:16:32.042Z |
5020545 | 5020545 | 20240905021719_RCETN | UK001Q | 2024-09-10T12:14:41.106Z | 2024-09-10T12:16:55.176Z |
5019685 | 5019685 | 20240904233509_QFJfm | UK001Q | 2024-09-10T12:13:11.443Z | 2024-09-13T12:19:53.400Z |
5019639 | 5019639 | 20240904232514_PMGYA | UK001Q | 2024-09-10T12:13:03.189Z | 2024-09-13T12:19:53.184Z |
5019633 | 5019633 | 20240904232422_EvQPT | UK001Q | 2024-09-10T12:13:02.057Z | 2024-09-13T12:19:53.159Z |
5019628 | 5019628 | 20240904232356_xsG24 | UK001Q | 2024-09-10T12:13:01.428Z | 2024-09-13T12:19:53.148Z |
5019483 | 5019483 | 20240904225854_SqLIj | UK001Q | 2024-09-10T12:12:48.905Z | 2024-09-13T12:19:52.234Z |
5019264 | 5019264 | 20240904221841_209S1 | UK001Q | 2024-09-10T12:12:31.955Z | 2024-09-13T12:19:51.183Z |
4976347 | 4976347 | 20240811232905_16lT9 | UK001Q | 2024-09-06T12:11:25.981Z | 2024-09-06T12:11:25.981Z |
4975059 | 4975059 | 20240811231421_sKFIx | UK001Q | 2024-09-05T12:11:39.044Z | 2024-09-06T12:10:36.481Z |
4974291 | 4974291 | 20240811230538_cJUrp | UK001Q | 2024-09-05T12:11:22.967Z | 2024-09-06T12:10:25.312Z |
4969760 | 4969760 | 20240811221603_AcNis | UK001Q | 2024-09-05T12:08:59.646Z | 2024-09-06T12:08:03.777Z |
4969665 | 4969665 | 20240811221410_DIxDW | UK001Q | 2024-09-05T12:08:53.846Z | 2024-09-06T12:07:57.951Z |
4968956 | 4968956 | 20240811220511_1cMeg | UK001Q | 2024-09-05T12:08:31.859Z | 2024-09-06T12:07:39.963Z |
4967795 | 4967795 | 20240811214953_UGVW6 | UK001Q | 2024-09-05T12:07:49.000Z | 2024-09-06T12:07:09.124Z |
4967728 | 4967728 | 20240811214842_A0z4T | UK001Q | 2024-09-05T12:07:46.428Z | 2024-09-06T12:07:07.899Z |
4967702 | 4967702 | 20240811214817_yFsLW | UK001Q | 2024-09-05T12:07:45.931Z | 2024-09-06T12:07:07.437Z |
4966733 | 4966733 | 20240811213318_2WNGi | UK001Q | 2024-09-04T12:07:33.686Z | 2024-09-06T12:06:42.585Z |
4966216 | 4966216 | 20240811212545_LJicP | UK001Q | 2024-09-04T12:07:21.087Z | 2024-09-06T12:06:17.852Z |
4965631 | 4965631 | 20240811211738_5OiyG | UK001Q | 2024-09-04T12:07:04.538Z | 2024-09-06T12:06:01.163Z |
4965523 | 4965523 | 20240811211616_v2GAt | UK001Q | 2024-09-04T12:07:00.145Z | 2024-09-06T12:05:58.926Z |
4964739 | 4964739 | 20240811210222_96CYU | UK001Q | 2024-09-04T12:06:32.895Z | 2024-09-06T12:05:33.460Z |
4964715 | 4964715 | 20240811210141_9qao6 | UK001Q | 2024-09-04T12:06:32.139Z | 2024-09-06T12:05:31.236Z |
4964560 | 4964560 | 20240811205816_gKUOX | UK001Q | 2024-09-04T12:06:26.854Z | 2024-09-06T12:05:25.050Z |
4955058 | 4955058 | 20240811033008_zm3bd | UK001Q | 2024-09-03T12:18:39.681Z | 2024-09-06T12:29:16.416Z |
4955044 | 4955044 | 20240811032733_2G5Z3 | UK001Q | 2024-09-03T12:18:37.779Z | 2024-09-06T12:29:15.730Z |
4954960 | 4954960 | 20240811032003_krUR3 | UK001Q | 2024-09-03T12:18:31.345Z | 2024-09-06T12:29:13.507Z |
4954711 | 4954711 | 20240811030929_xaHqk | UK001Q | 2024-09-03T12:18:19.464Z | 2024-09-06T12:29:06.960Z |
4954640 | 4954640 | 20240811030737_KDnGS | UK001Q | 2024-09-03T12:18:18.491Z | 2024-09-06T12:29:05.885Z |
4954572 | 4954572 | 20240811030515_ZWRa4 | UK001Q | 2024-09-03T12:18:16.689Z | 2024-09-06T12:29:03.646Z |
4953288 | 4953288 | 20240811023535_9jOav | UK001Q | 2024-09-03T12:17:31.231Z | 2024-09-06T12:28:22.606Z |
4953016 | 4953016 | 20240811023107_PKw4p | UK001Q | 2024-09-03T12:17:11.977Z | 2024-09-06T12:28:15.929Z |
4948469 | 4948469 | 20240811013406_CCmkG | UK001Q | 2024-09-02T12:15:02.692Z | 2024-09-06T12:27:17.616Z |
4948330 | 4948330 | 20240811013227_uUL9M | UK001Q | 2024-09-02T12:15:00.104Z | 2024-09-06T12:27:14.993Z |
4947743 | 4947743 | 20240811012341_NYkr5 | UK001Q | 2024-09-02T12:14:46.310Z | 2024-09-06T12:27:00.698Z |
4947542 | 4947542 | 20240811012041_LgqTu | UK001Q | 2024-09-02T12:14:36.825Z | 2024-09-06T12:26:54.552Z |
4946872 | 4946872 | 20240811010856_2VX2g | UK001Q | 2024-09-02T12:14:10.301Z | 2024-09-06T12:26:37.196Z |
4946856 | 4946856 | 20240811010834_3m2JW | UK001Q | 2024-09-02T12:14:09.987Z | 2024-09-06T12:26:36.649Z |
4946812 | 4946812 | 20240811010714_Y5aRS | UK001Q | 2024-09-02T12:14:08.749Z | 2024-09-06T12:26:35.746Z |
4946069 | 4946069 | 20240811005614_OZSKh | UK001Q | 2024-09-02T12:13:34.640Z | 2024-09-06T12:26:13.533Z |
4940320 | 4940320 | 20240810230952_Lm5rk | UK001Q | 2024-09-01T12:10:24.605Z | 2024-09-06T12:23:33.941Z |
4928566 | 4928566 | 20240810024344_EJGw8 | UK001Q | 2024-08-31T12:21:27.671Z | 2024-09-02T12:29:12.891Z |
4928276 | 4928276 | 20240810023521_wt24B | UK001Q | 2024-08-31T12:21:17.172Z | 2024-09-02T12:29:05.856Z |
4927658 | 4927658 | 20240810021740_h6YGs | UK001Q | 2024-08-31T12:20:47.365Z | 2024-09-02T12:28:46.434Z |
4915281 | 4915281 | 20240809224523_D72ac | UK001Q | 2024-08-30T12:09:49.328Z | 2024-09-02T12:23:53.745Z |
4915189 | 4915189 | 20240809224125_zYBoh | UK001Q | 2024-08-30T12:09:45.333Z | 2024-09-02T12:23:51.915Z |
4915008 | 4915008 | 20240809223536_rkUnl | UK001Q | 2024-08-30T12:09:38.836Z | 2024-09-02T12:23:48.960Z |
4912233 | 4912233 | 20240809210544_nTJ8T | UK001Q | 2024-08-29T12:08:19.432Z | 2024-09-02T12:22:18.097Z |
4912228 | 4912228 | 20240809210544_43BSa | UK001Q | 2024-08-29T12:08:19.216Z | 2024-09-02T12:22:17.980Z |
4903820 | 4903820 | 20240808031601_1XWi3 | UK001Q | 2024-08-28T12:19:55.946Z | 2024-08-28T12:19:55.946Z |
4903751 | 4903751 | 20240808031309_2sN3B | UK001Q | 2024-08-28T12:19:54.433Z | 2024-08-28T12:19:54.433Z |
4903456 | 4903456 | 20240808025652_mqjBN | UK001Q | 2024-08-28T12:19:39.501Z | 2024-08-28T12:19:39.501Z |
4884129 | 4884129 | 20240807030124_Wvq6n | UK001Q | 2024-08-20T12:15:23.818Z | 2024-08-27T12:16:05.177Z |
4877128 | 4877128 | 20240806235504_S41im | UK001Q | 2024-08-19T12:13:11.266Z | 2024-08-27T12:13:04.449Z |
4876112 | 4876112 | 20240806233232_ZG8fQ | UK001Q | 2024-08-19T12:12:39.590Z | 2024-08-27T12:12:35.595Z |
4875844 | 4875844 | 20240806232625_EUj2q | UK001Q | 2024-08-19T12:12:21.999Z | 2024-08-27T12:12:26.204Z |
4875770 | 4875770 | 20240806232419_uK32M | UK001Q | 2024-08-19T12:12:19.566Z | 2024-08-27T12:12:22.680Z |
4875044 | 4875044 | 20240806230433_2C9ov | UK001Q | 2024-08-19T12:11:59.257Z | 2024-08-27T12:12:02.083Z |
4874356 | 4874356 | 20240806224740_YyHUm | UK001Q | 2024-08-19T12:11:22.037Z | 2024-08-27T12:11:42.833Z |
4873817 | 4873817 | 20240806223354_wrToS | UK001Q | 2024-08-19T12:11:07.521Z | 2024-08-27T12:11:22.952Z |
4873488 | 4873488 | 20240806222308_x7hH3 | UK001Q | 2024-08-19T12:10:48.908Z | 2024-08-27T12:11:12.465Z |
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);