participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
450 rows where station_code = "UK003K" 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 |
---|---|---|---|---|---|
5432940 | 5432940 | 20241029052043_dbTmn | UK003K | 2024-10-31T12:21:40.616Z | 2024-11-06T14:27:29.357Z |
5204166 | 5204166 | 20240930190611_6WIit | UK003K | 2024-10-02T12:11:16.324Z | 2024-10-09T12:29:13.263Z |
5129785 | 5129785 | 20240917042819_qmEeV | UK003K | 2024-09-19T12:12:04.409Z | 2024-09-25T12:22:32.860Z |
5072259 | 5072259 | 20240911195223_qzkKY | UK003K | 2024-09-15T12:05:03.073Z | 2024-09-20T12:21:26.168Z |
4782724 | 4782724 | 20240801212527_c9XbO | UK003K | 2024-08-10T12:12:37.747Z | 2024-08-11T12:13:51.983Z |
4004783 | 4004783 | 20240226225450_RUKV4 | UK003K | 2024-02-28T14:02:59.122Z | 2024-03-06T14:19:39.657Z |
4004679 | 4004679 | 20240226221734_Hb6Tq | UK003K | 2024-02-28T14:02:50.982Z | 2024-03-06T14:19:38.657Z |
4004551 | 4004551 | 20240226214042_ijZwh | UK003K | 2024-02-28T14:02:45.342Z | 2024-03-06T14:19:37.765Z |
3957708 | 3957708 | 20240212204522_pDaxL | UK003K | 2024-02-14T14:06:07.506Z | 2024-02-21T14:20:25.528Z |
3861530 | 3861530 | 20240118233228_4kasa | UK003K | 2024-01-22T14:00:35.092Z | 2024-01-27T14:18:39.114Z |
3800457 | 3800457 | 20240110222437_sjyNp | UK003K | 2024-01-13T14:16:25.553Z | 2024-01-19T14:28:05.051Z |
3604723 | 3604723 | 20231213224025_EMSYm | UK003K | 2024-01-06T00:05:21.693Z | 2024-01-06T00:05:21.693Z |
3510358 | 3510358 | 20231204013741_ky3KI | UK003K | 2024-01-06T00:04:57.381Z | 2024-01-06T00:04:57.381Z |
3499725 | 3499725 | 20231202012857_StR29 | UK003K | 2024-01-06T00:04:53.652Z | 2024-01-06T00:04:53.652Z |
3499709 | 3499709 | 20231202012357_WE922 | UK003K | 2024-01-06T00:04:53.649Z | 2024-01-06T00:04:53.649Z |
3499673 | 3499673 | 20231202011544_5Ul3W | UK003K | 2024-01-06T00:04:53.645Z | 2024-01-06T00:04:53.645Z |
3499608 | 3499608 | 20231202010036_wVtGx | UK003K | 2024-01-06T00:04:53.637Z | 2024-01-06T00:04:53.637Z |
3369053 | 3369053 | 20231111021807_505XZ | UK003K | 2024-01-06T00:04:15.237Z | 2024-01-06T00:04:15.237Z |
3368521 | 3368521 | 20231111015345_OX7a3 | UK003K | 2024-01-06T00:04:15.194Z | 2024-01-06T00:04:15.194Z |
3314023 | 3314023 | 20231105051605_beKLV | UK003K | 2024-01-06T00:03:52.505Z | 2024-01-06T00:03:52.505Z |
3171863 | 3171863 | 20231015052321_jMx5m | UK003K | 2024-01-06T00:02:48.950Z | 2024-01-06T00:02:48.950Z |
3169736 | 3169736 | 20231015040934_Q9f0b | UK003K | 2024-01-06T00:02:48.696Z | 2024-01-06T00:02:48.696Z |
3169635 | 3169635 | 20231015040642_XNKSx | UK003K | 2024-01-06T00:02:48.690Z | 2024-01-06T00:02:48.690Z |
3159237 | 3159237 | 20231014191513_apNG1 | UK003K | 2024-01-06T00:02:46.297Z | 2024-01-06T00:02:46.297Z |
2735349 | 2735349 | 20230809233317_S5sFo | UK003K | 2024-01-06T00:00:27.562Z | 2024-01-06T00:00:27.562Z |
2732572 | 2732572 | 20230809211755_3BZZ2 | UK003K | 2024-01-06T00:00:27.092Z | 2024-01-06T00:00:27.092Z |
2700539 | 2700539 | 20230806001301_A02QV | UK003K | 2024-01-06T00:00:15.677Z | 2024-01-06T00:00:15.677Z |
2700511 | 2700511 | 20230806000910_IQo3M | UK003K | 2024-01-06T00:00:15.675Z | 2024-01-06T00:00:15.675Z |
2600587 | 2600587 | 20230711223254_03Vbz | UK003K | 2024-01-05T23:59:27.029Z | 2024-01-05T23:59:27.029Z |
2384700 | 2384700 | 20230415040233_jQfHw | UK003K | 2024-01-05T23:56:54.383Z | 2024-01-05T23:56:54.383Z |
2345829 | 2345829 | 20230324195542_k5iHQ | UK003K | 2024-01-05T23:56:22.503Z | 2024-01-05T23:56:22.503Z |
2335182 | 2335182 | 20230318200012_KrYVx | UK003K | 2024-01-05T23:56:13.207Z | 2024-01-05T23:56:13.207Z |
2308601 | 2308601 | 20230228000841_xUKoX | UK003K | 2024-01-05T23:55:44.520Z | 2024-01-05T23:55:44.520Z |
2304754 | 2304754 | 20230226234733_1nDEg | UK003K | 2024-01-05T23:55:42.985Z | 2024-01-05T23:55:42.985Z |
2271139 | 2271139 | 20230211234709_L2Pmu | UK003K | 2024-01-05T23:55:15.642Z | 2024-01-05T23:55:15.642Z |
2267386 | 2267386 | 20230209204430_j2VD3 | UK003K | 2024-01-05T23:55:10.283Z | 2024-01-05T23:55:10.283Z |
2263228 | 2263228 | 20230207215926_ZtMA2 | UK003K | 2024-01-05T23:55:05.254Z | 2024-01-05T23:55:05.254Z |
2233678 | 2233678 | 20230125215739_y33vJ | UK003K | 2024-01-05T23:54:43.474Z | 2024-01-05T23:54:43.474Z |
2233653 | 2233653 | 20230125215511_Ovyln | UK003K | 2024-01-05T23:54:43.470Z | 2024-01-05T23:54:43.470Z |
2227563 | 2227563 | 20230124002632_EKXq9 | UK003K | 2024-01-05T23:54:38.507Z | 2024-01-05T23:54:38.507Z |
2225280 | 2225280 | 20230123000048_2GZPA | UK003K | 2024-01-05T23:54:36.140Z | 2024-01-05T23:54:36.140Z |
2217157 | 2217157 | 20230121013638_iIJdN | UK003K | 2024-01-05T23:54:30.949Z | 2024-01-05T23:54:30.949Z |
2216511 | 2216511 | 20230120230730_n2yyQ | UK003K | 2024-01-05T23:54:30.815Z | 2024-01-05T23:54:30.815Z |
2216325 | 2216325 | 20230120222533_dkN2K | UK003K | 2024-01-05T23:54:30.778Z | 2024-01-05T23:54:30.778Z |
2211412 | 2211412 | 20230120001800_Kr9AO | UK003K | 2024-01-05T23:54:27.914Z | 2024-01-05T23:54:27.914Z |
2203156 | 2203156 | 20230118014927_Bq7ei | UK003K | 2024-01-05T23:54:21.905Z | 2024-01-05T23:54:21.905Z |
2202294 | 2202294 | 20230117215423_xbp3S | UK003K | 2024-01-05T23:54:21.827Z | 2024-01-05T23:54:21.827Z |
2178197 | 2178197 | 20230102174916_YHKQs | UK003K | 2024-01-05T23:54:01.967Z | 2024-01-05T23:54:01.967Z |
2114442 | 2114442 | 20221216033736_JwtMp | UK003K | 2024-01-05T23:53:33.036Z | 2024-01-05T23:53:33.036Z |
2113628 | 2113628 | 20221216023158_QWOKd | UK003K | 2024-01-05T23:53:32.972Z | 2024-01-05T23:53:32.972Z |
2112462 | 2112462 | 20221216003139_L5KUl | UK003K | 2024-01-05T23:53:32.878Z | 2024-01-05T23:53:32.878Z |
2110875 | 2110875 | 20221215215609_cJeEn | UK003K | 2024-01-05T23:53:32.765Z | 2024-01-05T23:53:32.765Z |
2110879 | 2110879 | 20221215215626_MEkTH | UK003K | 2024-01-05T23:53:32.765Z | 2024-01-05T23:53:32.765Z |
2110641 | 2110641 | 20221215212513_kfI1O | UK003K | 2024-01-05T23:53:32.747Z | 2024-01-05T23:53:32.747Z |
2110167 | 2110167 | 20221215201336_Pcnwj | UK003K | 2024-01-05T23:53:32.705Z | 2024-01-05T23:53:32.705Z |
2109491 | 2109491 | 20221215180344_S68BV | UK003K | 2024-01-05T23:53:32.642Z | 2024-01-05T23:53:32.642Z |
2036975 | 2036975 | 20221212015256_FbD0b | UK003K | 2024-01-05T23:53:17.396Z | 2024-01-05T23:53:17.396Z |
2036967 | 2036967 | 20221212015005_zuxjx | UK003K | 2024-01-05T23:53:17.395Z | 2024-01-05T23:53:17.395Z |
2036800 | 2036800 | 20221212002645_PbwEx | UK003K | 2024-01-05T23:53:17.373Z | 2024-01-05T23:53:17.373Z |
2036730 | 2036730 | 20221212000511_P2KkB | UK003K | 2024-01-05T23:53:17.364Z | 2024-01-05T23:53:17.364Z |
2036629 | 2036629 | 20221211230443_NQX7a | UK003K | 2024-01-05T23:53:17.351Z | 2024-01-05T23:53:17.351Z |
2032512 | 2032512 | 20221210232856_Jx9sG | UK003K | 2024-01-05T23:53:15.628Z | 2024-01-05T23:53:15.628Z |
2032380 | 2032380 | 20221210214456_3gcA0 | UK003K | 2024-01-05T23:53:15.612Z | 2024-01-05T23:53:15.612Z |
2032348 | 2032348 | 20221210213330_CPgpy | UK003K | 2024-01-05T23:53:15.609Z | 2024-01-05T23:53:15.609Z |
2032079 | 2032079 | 20221210192632_7elbN | UK003K | 2024-01-05T23:53:15.582Z | 2024-01-05T23:53:15.582Z |
2031979 | 2031979 | 20221210185541_D5arT | UK003K | 2024-01-05T23:53:15.571Z | 2024-01-05T23:53:15.571Z |
2031898 | 2031898 | 20221210183035_jdHZx | UK003K | 2024-01-05T23:53:15.563Z | 2024-01-05T23:53:15.563Z |
2027623 | 2027623 | 20221209213225_kfgKu | UK003K | 2024-01-05T23:53:13.947Z | 2024-01-05T23:53:13.947Z |
2027365 | 2027365 | 20221209185629_rUQhW | UK003K | 2024-01-05T23:53:13.926Z | 2024-01-05T23:53:13.926Z |
2026554 | 2026554 | 20221209061409_fCCl6 | UK003K | 2024-01-05T23:53:12.626Z | 2024-01-05T23:53:12.626Z |
2026556 | 2026556 | 20221209061514_EIKC0 | UK003K | 2024-01-05T23:53:12.626Z | 2024-01-05T23:53:12.626Z |
2018177 | 2018177 | 20221204032020_Ep2N5 | UK003K | 2024-01-05T23:53:05.821Z | 2024-01-05T23:53:05.821Z |
2016311 | 2016311 | 20221202234253_VOLzK | UK003K | 2024-01-05T23:53:04.384Z | 2024-01-05T23:53:04.384Z |
2015243 | 2015243 | 20221202053432_9HvH0 | UK003K | 2024-01-05T23:53:02.938Z | 2024-01-05T23:53:02.938Z |
2015197 | 2015197 | 20221202044531_TqoQM | UK003K | 2024-01-05T23:53:02.930Z | 2024-01-05T23:53:02.930Z |
2014870 | 2014870 | 20221201231623_Y3QpQ | UK003K | 2024-01-05T23:53:02.878Z | 2024-01-05T23:53:02.878Z |
2002025 | 2002025 | 20221129015022_kQD5H | UK003K | 2024-01-05T23:52:55.721Z | 2024-01-05T23:52:55.721Z |
2001750 | 2001750 | 20221129002721_29MGk | UK003K | 2024-01-05T23:52:55.646Z | 2024-01-05T23:52:55.646Z |
2001618 | 2001618 | 20221128234441_TEr88 | UK003K | 2024-01-05T23:52:55.597Z | 2024-01-05T23:52:55.597Z |
1950201 | 1950201 | 20221119061913_D41xa | UK003K | 2024-01-05T23:52:30.384Z | 2024-01-05T23:52:30.384Z |
1950197 | 1950197 | 20221119061831_Jv4Hs | UK003K | 2024-01-05T23:52:30.383Z | 2024-01-05T23:52:30.383Z |
1949419 | 1949419 | 20221119035030_FaJJL | UK003K | 2024-01-05T23:52:30.279Z | 2024-01-05T23:52:30.279Z |
1949408 | 1949408 | 20221119034835_Ym39n | UK003K | 2024-01-05T23:52:30.277Z | 2024-01-05T23:52:30.277Z |
1949057 | 1949057 | 20221119024618_F1fD3 | UK003K | 2024-01-05T23:52:30.229Z | 2024-01-05T23:52:30.229Z |
1948987 | 1948987 | 20221119022843_Hn4SG | UK003K | 2024-01-05T23:52:30.218Z | 2024-01-05T23:52:30.218Z |
1778332 | 1778332 | 20221017210328_Ue5o2 | UK003K | 2024-01-05T23:51:11.046Z | 2024-01-05T23:51:11.046Z |
1777944 | 1777944 | 20221017194100_1Zvvg | UK003K | 2024-01-05T23:51:11.000Z | 2024-01-05T23:51:11.000Z |
1777892 | 1777892 | 20221017192114_IbGlF | UK003K | 2024-01-05T23:51:10.994Z | 2024-01-05T23:51:10.994Z |
1774053 | 1774053 | 20221016040153_ofW2J | UK003K | 2024-01-05T23:51:07.261Z | 2024-01-05T23:51:07.261Z |
1769738 | 1769738 | 20221015041359_fFH0m | UK003K | 2024-01-05T23:51:05.275Z | 2024-01-05T23:51:05.275Z |
1756121 | 1756121 | 20221009040920_NOU75 | UK003K | 2024-01-05T23:50:55.344Z | 2024-01-05T23:50:55.344Z |
1722888 | 1722888 | 20221001043559_sO4j3 | UK003K | 2024-01-05T23:50:39.239Z | 2024-01-05T23:50:39.239Z |
1713796 | 1713796 | 20220929221452_agqKW | UK003K | 2024-01-05T23:50:37.137Z | 2024-01-05T23:50:37.137Z |
1713774 | 1713774 | 20220929221151_1ysjv | UK003K | 2024-01-05T23:50:37.135Z | 2024-01-05T23:50:37.135Z |
1710135 | 1710135 | 20220929011249_3DI80 | UK003K | 2024-01-05T23:50:35.243Z | 2024-01-05T23:50:35.243Z |
1709966 | 1709966 | 20220929003243_lUw4Y | UK003K | 2024-01-05T23:50:35.222Z | 2024-01-05T23:50:35.222Z |
1695169 | 1695169 | 20220925043030_za1FH | UK003K | 2024-01-05T23:50:27.235Z | 2024-01-05T23:50:27.235Z |
1694411 | 1694411 | 20220925032414_WpCUI | UK003K | 2024-01-05T23:50:27.181Z | 2024-01-05T23:50:27.181Z |
1692883 | 1692883 | 20220925001235_MbEjf | UK003K | 2024-01-05T23:50:27.052Z | 2024-01-05T23:50:27.052Z |
1692408 | 1692408 | 20220924225447_d3ppD | UK003K | 2024-01-05T23:50:27.012Z | 2024-01-05T23:50:27.012Z |
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);