participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,821 rows where station_code = "UK00C7" 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 |
---|---|---|---|---|---|
5524497 | 5524497 | 20241111042141_mfZxO | UK00C7 | 2024-11-12T14:17:26.944Z | 2024-11-12T14:18:08.645Z |
5522809 | 5522809 | 20241110214840_H2kpi | UK00C7 | 2024-11-12T14:14:20.127Z | 2024-11-12T14:18:07.905Z |
5522613 | 5522613 | 20241110204408_K6orn | UK00C7 | 2024-11-12T14:13:46.928Z | 2024-11-12T14:18:07.825Z |
5522495 | 5522495 | 20241110201230_Wv4mo | UK00C7 | 2024-11-12T14:13:23.683Z | 2024-11-12T14:18:07.771Z |
5422976 | 5422976 | 20241027010945_kKqFD | UK00C7 | 2024-10-30T12:22:34.342Z | 2024-11-04T14:28:54.649Z |
5418654 | 5418654 | 20241027212852_RtTLT | UK00C7 | 2024-10-30T12:15:57.514Z | 2024-11-05T14:27:10.899Z |
5418458 | 5418458 | 20241027205050_PTTRx | UK00C7 | 2024-10-30T12:15:42.593Z | 2024-11-05T14:27:10.071Z |
5418375 | 5418375 | 20241027203338_0kZ33 | UK00C7 | 2024-10-30T12:15:36.623Z | 2024-11-05T14:27:09.929Z |
5418316 | 5418316 | 20241027202158_k4DnE | UK00C7 | 2024-10-30T12:15:24.869Z | 2024-11-05T14:27:09.618Z |
5418173 | 5418173 | 20241027200445_wisrL | UK00C7 | 2024-10-30T12:15:02.656Z | 2024-11-05T14:27:09.414Z |
5418138 | 5418138 | 20241027195810_mEubV | UK00C7 | 2024-10-30T12:14:58.852Z | 2024-11-05T14:27:09.260Z |
5417770 | 5417770 | 20241027191218_36ro4 | UK00C7 | 2024-10-30T12:14:26.874Z | 2024-11-05T14:27:08.205Z |
5417737 | 5417737 | 20241027190638_dJXFk | UK00C7 | 2024-10-30T12:14:22.249Z | 2024-11-05T14:27:08.137Z |
5417703 | 5417703 | 20241027190248_kZO4h | UK00C7 | 2024-10-30T12:14:17.444Z | 2024-11-05T14:27:08.111Z |
5417597 | 5417597 | 20241027185016_b34gl | UK00C7 | 2024-10-30T12:13:57.564Z | 2024-11-05T14:27:07.699Z |
5410782 | 5410782 | 20241027053555_b8hq1 | UK00C7 | 2024-10-29T12:18:04.877Z | 2024-11-04T14:29:05.466Z |
5410693 | 5410693 | 20241027052902_7v9sz | UK00C7 | 2024-10-29T12:18:02.714Z | 2024-11-04T14:29:05.234Z |
5410666 | 5410666 | 20241027052555_zl4gO | UK00C7 | 2024-10-29T12:18:02.211Z | 2024-11-04T14:29:05.203Z |
5410626 | 5410626 | 20241027052412_PftkL | UK00C7 | 2024-10-29T12:17:59.794Z | 2024-11-04T14:29:05.125Z |
5410519 | 5410519 | 20241027051622_VhkyR | UK00C7 | 2024-10-29T12:17:57.451Z | 2024-11-04T14:29:04.714Z |
5410486 | 5410486 | 20241027051501_nfgiN | UK00C7 | 2024-10-29T12:17:56.886Z | 2024-11-04T14:29:04.643Z |
5410467 | 5410467 | 20241027051425_j4kW6 | UK00C7 | 2024-10-29T12:17:56.381Z | 2024-11-04T14:29:04.630Z |
5410152 | 5410152 | 20241027045550_gD33j | UK00C7 | 2024-10-29T12:17:48.973Z | 2024-11-04T14:29:03.900Z |
5410091 | 5410091 | 20241027045222_hiTz5 | UK00C7 | 2024-10-29T12:17:47.532Z | 2024-11-04T14:29:03.680Z |
5410041 | 5410041 | 20241027044859_4foLg | UK00C7 | 2024-10-29T12:17:46.396Z | 2024-11-04T14:29:03.626Z |
5410014 | 5410014 | 20241027044738_IdH2R | UK00C7 | 2024-10-29T12:17:45.746Z | 2024-11-04T14:29:03.260Z |
5410006 | 5410006 | 20241027044738_3x2KZ | UK00C7 | 2024-10-29T12:17:45.707Z | 2024-11-04T14:29:03.258Z |
5409886 | 5409886 | 20241027043935_RBUSX | UK00C7 | 2024-10-29T12:17:43.298Z | 2024-11-04T14:29:02.847Z |
5409786 | 5409786 | 20241027043601_1aKFi | UK00C7 | 2024-10-29T12:17:40.839Z | 2024-11-04T14:29:02.638Z |
5409729 | 5409729 | 20241027043228_0ugNh | UK00C7 | 2024-10-29T12:17:39.447Z | 2024-11-04T14:29:02.186Z |
5409711 | 5409711 | 20241027043146_Q8LtN | UK00C7 | 2024-10-29T12:17:38.331Z | 2024-11-04T14:29:02.168Z |
5409350 | 5409350 | 20241027041203_ktV9o | UK00C7 | 2024-10-29T12:17:17.074Z | 2024-11-04T14:29:01.595Z |
5408727 | 5408727 | 20241027033940_xJKLx | UK00C7 | 2024-10-29T12:16:47.406Z | 2024-11-04T14:29:00.370Z |
5408470 | 5408470 | 20241027032803_dSYt1 | UK00C7 | 2024-10-29T12:16:31.843Z | 2024-11-04T14:28:59.543Z |
5408186 | 5408186 | 20241027031414_pK9kX | UK00C7 | 2024-10-29T12:16:14.791Z | 2024-11-04T14:28:58.952Z |
5408168 | 5408168 | 20241027031221_B0CNF | UK00C7 | 2024-10-29T12:16:13.206Z | 2024-11-04T14:28:58.941Z |
5408068 | 5408068 | 20241027030530_deLch | UK00C7 | 2024-10-29T12:16:03.711Z | 2024-11-04T14:28:58.749Z |
5407906 | 5407906 | 20241027025725_5xOQM | UK00C7 | 2024-10-29T12:15:51.315Z | 2024-11-04T14:28:58.318Z |
5407877 | 5407877 | 20241027025620_UOH2t | UK00C7 | 2024-10-29T12:15:50.445Z | 2024-11-04T14:28:58.287Z |
5407601 | 5407601 | 20241027024356_BIlnj | UK00C7 | 2024-10-29T12:15:31.001Z | 2024-11-04T14:28:57.909Z |
5407525 | 5407525 | 20241027024034_INvSO | UK00C7 | 2024-10-29T12:15:28.162Z | 2024-11-04T14:28:57.840Z |
5407499 | 5407499 | 20241027023857_AVsuJ | UK00C7 | 2024-10-29T12:15:27.149Z | 2024-11-04T14:28:57.781Z |
5407455 | 5407455 | 20241027023727_l2Skb | UK00C7 | 2024-10-29T12:15:25.451Z | 2024-11-04T14:28:57.587Z |
5407317 | 5407317 | 20241027023118_LoAz3 | UK00C7 | 2024-10-29T12:15:20.529Z | 2024-11-04T14:28:57.335Z |
5407077 | 5407077 | 20241027022032_PZfMH | UK00C7 | 2024-10-29T12:15:11.331Z | 2024-11-04T14:28:56.837Z |
5407015 | 5407015 | 20241027021639_ar5mh | UK00C7 | 2024-10-29T12:15:08.709Z | 2024-11-04T14:28:56.775Z |
5406971 | 5406971 | 20241027021426_L90xQ | UK00C7 | 2024-10-29T12:15:03.381Z | 2024-11-04T14:28:56.736Z |
5406764 | 5406764 | 20241027015842_R53Zk | UK00C7 | 2024-10-29T12:14:39.731Z | 2024-11-04T14:28:56.361Z |
5406378 | 5406378 | 20241027013305_MsnM8 | UK00C7 | 2024-10-29T12:14:05.127Z | 2024-11-04T14:28:55.620Z |
5406233 | 5406233 | 20241027012253_zpjxk | UK00C7 | 2024-10-29T12:13:58.236Z | 2024-11-04T14:28:55.230Z |
5406018 | 5406018 | 20241027011214_RRwA9 | UK00C7 | 2024-10-29T12:13:48.051Z | 2024-11-04T14:28:54.885Z |
5406004 | 5406004 | 20241027011200_6Ip7s | UK00C7 | 2024-10-29T12:13:47.293Z | 2024-11-04T14:28:54.832Z |
5405950 | 5405950 | 20241027010959_x3nGo | UK00C7 | 2024-10-29T12:13:37.832Z | 2024-11-04T14:28:54.663Z |
5405803 | 5405803 | 20241027005914_a6Sr1 | UK00C7 | 2024-10-29T12:13:18.486Z | 2024-11-04T14:28:54.323Z |
5405538 | 5405538 | 20241027004216_bx2W0 | UK00C7 | 2024-10-29T12:13:00.792Z | 2024-11-04T14:28:53.594Z |
5405425 | 5405425 | 20241027003309_mIghY | UK00C7 | 2024-10-29T12:12:55.159Z | 2024-11-04T14:28:53.464Z |
5405405 | 5405405 | 20241027003221_yw2nF | UK00C7 | 2024-10-29T12:12:54.626Z | 2024-11-04T14:28:53.448Z |
5405268 | 5405268 | 20241027002606_Peah2 | UK00C7 | 2024-10-29T12:12:46.806Z | 2024-11-04T14:28:53.208Z |
5405086 | 5405086 | 20241027001237_FwTiD | UK00C7 | 2024-10-29T12:12:24.161Z | 2024-11-04T14:28:52.662Z |
5405007 | 5405007 | 20241027000807_TpXml | UK00C7 | 2024-10-29T12:12:15.722Z | 2024-11-04T14:28:52.534Z |
5404594 | 5404594 | 20241026233956_AI8fa | UK00C7 | 2024-10-29T12:11:45.066Z | 2024-11-04T14:28:51.366Z |
5404395 | 5404395 | 20241026232245_d3wlO | UK00C7 | 2024-10-29T12:11:18.023Z | 2024-11-04T14:28:50.846Z |
5404219 | 5404219 | 20241026230945_88JPM | UK00C7 | 2024-10-29T12:11:01.102Z | 2024-11-04T14:28:50.460Z |
5404055 | 5404055 | 20241026225453_4WnQH | UK00C7 | 2024-10-29T12:10:51.013Z | 2024-11-04T14:28:50.276Z |
5403913 | 5403913 | 20241026224510_atRJZ | UK00C7 | 2024-10-29T12:10:26.921Z | 2024-11-04T14:28:50.002Z |
5399434 | 5399434 | 20241026041813_zY361 | UK00C7 | 2024-10-28T12:19:59.442Z | 2024-11-03T14:27:39.705Z |
5398652 | 5398652 | 20241026031459_Sb0av | UK00C7 | 2024-10-28T12:19:25.389Z | 2024-11-03T14:27:37.450Z |
5398603 | 5398603 | 20241026031056_TBVTM | UK00C7 | 2024-10-28T12:19:23.605Z | 2024-11-03T14:27:36.915Z |
5398493 | 5398493 | 20241026030316_TItz2 | UK00C7 | 2024-10-28T12:19:19.996Z | 2024-11-03T14:27:36.614Z |
5398411 | 5398411 | 20241026025520_kJg0U | UK00C7 | 2024-10-28T12:19:14.113Z | 2024-11-03T14:27:36.329Z |
5398353 | 5398353 | 20241026024814_qFMvB | UK00C7 | 2024-10-28T12:19:11.743Z | 2024-11-03T14:27:35.936Z |
5398105 | 5398105 | 20241026022707_35KPn | UK00C7 | 2024-10-28T12:19:01.008Z | 2024-11-03T14:27:35.417Z |
5398101 | 5398101 | 20241026022704_Bn2mt | UK00C7 | 2024-10-28T12:19:00.926Z | 2024-11-03T14:27:35.416Z |
5398069 | 5398069 | 20241026022155_PWO61 | UK00C7 | 2024-10-28T12:18:59.455Z | 2024-11-03T14:27:35.262Z |
5397148 | 5397148 | 20241026010528_7ELys | UK00C7 | 2024-10-28T12:18:09.299Z | 2024-11-03T14:27:32.098Z |
5397002 | 5397002 | 20241026005521_nAGdv | UK00C7 | 2024-10-28T12:18:01.871Z | 2024-11-03T14:27:31.662Z |
5396808 | 5396808 | 20241026003550_bX4hR | UK00C7 | 2024-10-28T12:17:56.167Z | 2024-11-03T14:27:30.951Z |
5396635 | 5396635 | 20241026001809_6mK22 | UK00C7 | 2024-10-28T12:17:51.730Z | 2024-11-03T14:27:30.517Z |
5396567 | 5396567 | 20241026001255_Kh7YX | UK00C7 | 2024-10-28T12:17:49.945Z | 2024-11-03T14:27:30.275Z |
5396411 | 5396411 | 20241026000202_3mnE3 | UK00C7 | 2024-10-28T12:17:39.793Z | 2024-11-03T14:27:29.757Z |
5396409 | 5396409 | 20241026000202_jkMCJ | UK00C7 | 2024-10-28T12:17:39.412Z | 2024-11-03T14:27:29.737Z |
5396313 | 5396313 | 20241025235531_2KgCm | UK00C7 | 2024-10-28T12:17:33.368Z | 2024-11-03T14:27:29.332Z |
5396126 | 5396126 | 20241025234132_irMl3 | UK00C7 | 2024-10-28T12:17:19.273Z | 2024-11-03T14:27:28.601Z |
5396092 | 5396092 | 20241025234003_T0EKk | UK00C7 | 2024-10-28T12:17:18.188Z | 2024-11-03T14:27:28.519Z |
5396042 | 5396042 | 20241025233449_7CL2D | UK00C7 | 2024-10-28T12:17:15.214Z | 2024-11-03T14:27:28.204Z |
5395990 | 5395990 | 20241025232730_a29Gv | UK00C7 | 2024-10-28T12:17:09.384Z | 2024-11-03T14:27:27.937Z |
5395859 | 5395859 | 20241025231533_Qs3ZE | UK00C7 | 2024-10-28T12:17:00.891Z | 2024-11-03T14:27:27.418Z |
5395785 | 5395785 | 20241025231016_db4D6 | UK00C7 | 2024-10-28T12:16:50.894Z | 2024-11-03T14:27:26.690Z |
5395766 | 5395766 | 20241025230931_Aoyd5 | UK00C7 | 2024-10-28T12:16:47.962Z | 2024-11-03T14:27:26.660Z |
5395632 | 5395632 | 20241025230014_j0iQn | UK00C7 | 2024-10-28T12:16:34.346Z | 2024-11-03T14:27:26.299Z |
5395603 | 5395603 | 20241025225906_EO143 | UK00C7 | 2024-10-28T12:16:32.089Z | 2024-11-03T14:27:26.199Z |
5395556 | 5395556 | 20241025225301_0r3CD | UK00C7 | 2024-10-28T12:16:27.142Z | 2024-11-03T14:27:25.843Z |
5395548 | 5395548 | 20241025225146_Nt08F | UK00C7 | 2024-10-28T12:16:25.555Z | 2024-11-03T14:27:25.702Z |
5395540 | 5395540 | 20241025225043_UKgxR | UK00C7 | 2024-10-28T12:16:24.891Z | 2024-11-03T14:27:25.700Z |
5395516 | 5395516 | 20241025224750_vqiLr | UK00C7 | 2024-10-28T12:16:22.381Z | 2024-11-03T14:27:25.661Z |
5393940 | 5393940 | 20241025191705_tnPz5 | UK00C7 | 2024-10-28T12:13:54.141Z | 2024-11-03T14:27:19.114Z |
5393895 | 5393895 | 20241025190616_bOfS5 | UK00C7 | 2024-10-28T12:13:48.598Z | 2024-11-03T14:27:18.802Z |
5377936 | 5377936 | 20241024051804_X22yk | UK00C7 | 2024-10-26T12:22:50.197Z | 2024-11-01T12:27:03.166Z |
5377919 | 5377919 | 20241024051741_G1cVQ | UK00C7 | 2024-10-26T12:22:49.793Z | 2024-11-01T12:27:03.163Z |
5377821 | 5377821 | 20241024051240_G6IaF | UK00C7 | 2024-10-26T12:22:47.731Z | 2024-11-01T12:27:03.078Z |
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);