participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,641 rows where station_code = "UK00BH" 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 |
---|---|---|---|---|---|
5129734 | 5129734 | 20240917042446_4c0yQ | UK00BH | 2024-09-19T12:12:02.431Z | 2024-09-19T12:12:02.431Z |
5129387 | 5129387 | 20240917035455_GRAvj | UK00BH | 2024-09-19T12:11:34.191Z | 2024-09-19T12:11:34.191Z |
5129251 | 5129251 | 20240917033929_mjEu9 | UK00BH | 2024-09-19T12:11:24.081Z | 2024-09-19T12:11:24.081Z |
5129195 | 5129195 | 20240917033545_hH0PQ | UK00BH | 2024-09-19T12:11:22.818Z | 2024-09-19T12:11:22.818Z |
5128793 | 5128793 | 20240917023914_nzNSY | UK00BH | 2024-09-19T12:11:02.027Z | 2024-09-19T12:11:02.027Z |
5128611 | 5128611 | 20240917020927_nF6vd | UK00BH | 2024-09-19T12:10:47.579Z | 2024-09-19T12:10:47.579Z |
5128468 | 5128468 | 20240917014722_EZJyI | UK00BH | 2024-09-19T12:10:37.007Z | 2024-09-19T12:10:37.007Z |
5128394 | 5128394 | 20240917013344_8bUeG | UK00BH | 2024-09-19T12:10:30.305Z | 2024-09-19T12:10:30.305Z |
5128240 | 5128240 | 20240917010822_61oNf | UK00BH | 2024-09-19T12:10:21.192Z | 2024-09-19T12:10:21.192Z |
5128071 | 5128071 | 20240917003218_Yjok5 | UK00BH | 2024-09-19T12:10:00.073Z | 2024-09-19T12:10:00.073Z |
5128056 | 5128056 | 20240917002958_DCV0a | UK00BH | 2024-09-19T12:09:56.963Z | 2024-09-19T12:09:56.963Z |
5128021 | 5128021 | 20240917002016_VD3L1 | UK00BH | 2024-09-19T12:09:54.376Z | 2024-09-19T12:09:54.376Z |
5127997 | 5127997 | 20240917001852_jdaSA | UK00BH | 2024-09-19T12:09:53.374Z | 2024-09-19T12:09:53.374Z |
5127965 | 5127965 | 20240917001034_DHbPk | UK00BH | 2024-09-19T12:09:48.768Z | 2024-09-19T12:09:48.768Z |
5127938 | 5127938 | 20240917000518_ymau4 | UK00BH | 2024-09-19T12:09:47.057Z | 2024-09-19T12:09:47.057Z |
5127898 | 5127898 | 20240917000143_9GapR | UK00BH | 2024-09-19T12:09:46.165Z | 2024-09-19T12:09:46.165Z |
5127645 | 5127645 | 20240916224221_GhjEt | UK00BH | 2024-09-19T12:09:28.190Z | 2024-09-19T12:09:28.190Z |
5127617 | 5127617 | 20240916223556_JAi7W | UK00BH | 2024-09-19T12:09:26.054Z | 2024-09-19T12:09:26.054Z |
5127479 | 5127479 | 20240916221051_U3b5a | UK00BH | 2024-09-19T12:09:14.468Z | 2024-09-19T12:09:14.468Z |
5127472 | 5127472 | 20240916220327_5JFVg | UK00BH | 2024-09-19T12:09:12.991Z | 2024-09-19T12:09:12.991Z |
5127471 | 5127471 | 20240916215942_ajU55 | UK00BH | 2024-09-19T12:09:12.270Z | 2024-09-19T12:09:12.270Z |
5127402 | 5127402 | 20240916214417_ZEOKa | UK00BH | 2024-09-19T12:09:02.980Z | 2024-09-19T12:09:02.980Z |
5127211 | 5127211 | 20240916205455_3OK9Z | UK00BH | 2024-09-19T12:08:32.234Z | 2024-09-19T12:08:32.234Z |
5127156 | 5127156 | 20240916203420_7rUnL | UK00BH | 2024-09-19T12:08:19.545Z | 2024-09-19T12:08:19.545Z |
5127111 | 5127111 | 20240916202354_hctKj | UK00BH | 2024-09-19T12:08:12.563Z | 2024-09-19T12:08:12.563Z |
5126927 | 5126927 | 20240916195352_LkSm4 | UK00BH | 2024-09-19T12:07:41.508Z | 2024-09-19T12:07:41.508Z |
5126870 | 5126870 | 20240916194132_mW4qH | UK00BH | 2024-09-19T12:07:28.727Z | 2024-09-19T12:07:28.727Z |
5125854 | 5125854 | 20240918041140_n0Kz9 | UK00BH | 2024-09-19T12:04:18.279Z | 2024-09-19T12:06:42.096Z |
5125801 | 5125801 | 20240918035722_Sn20q | UK00BH | 2024-09-19T12:04:07.921Z | 2024-09-19T12:06:42.087Z |
5125595 | 5125595 | 20240918030454_PzTLA | UK00BH | 2024-09-19T12:03:36.207Z | 2024-09-19T12:06:42.055Z |
5125176 | 5125176 | 20240918005257_yIO3T | UK00BH | 2024-09-19T12:02:27.078Z | 2024-09-19T12:06:41.987Z |
5125088 | 5125088 | 20240918000711_h8IDR | UK00BH | 2024-09-19T12:02:14.496Z | 2024-09-19T12:06:41.975Z |
5125059 | 5125059 | 20240917235120_xb0rB | UK00BH | 2024-09-19T12:02:04.407Z | 2024-09-19T12:06:41.969Z |
5124410 | 5124410 | 20240917195617_v7dEp | UK00BH | 2024-09-19T12:00:45.811Z | 2024-09-19T12:06:41.889Z |
5121484 | 5121484 | 20240914040446_Ed2AU | UK00BH | 2024-09-18T12:10:57.122Z | 2024-09-19T12:20:01.957Z |
5121367 | 5121367 | 20240914035905_QiNcV | UK00BH | 2024-09-18T12:10:54.685Z | 2024-09-19T12:20:01.699Z |
5121257 | 5121257 | 20240914035641_jtQxq | UK00BH | 2024-09-18T12:10:53.299Z | 2024-09-19T12:20:01.533Z |
5121123 | 5121123 | 20240914035228_sJvYo | UK00BH | 2024-09-18T12:10:51.280Z | 2024-09-19T12:20:01.367Z |
5120944 | 5120944 | 20240914034205_Gq0aN | UK00BH | 2024-09-18T12:10:48.814Z | 2024-09-19T12:20:01.076Z |
5120795 | 5120795 | 20240914033528_eFpzL | UK00BH | 2024-09-18T12:10:46.694Z | 2024-09-19T12:20:00.858Z |
5120784 | 5120784 | 20240914033522_Iae8b | UK00BH | 2024-09-18T12:10:46.657Z | 2024-09-19T12:20:00.856Z |
5120737 | 5120737 | 20240914033304_2dWFf | UK00BH | 2024-09-18T12:10:46.215Z | 2024-09-19T12:20:00.801Z |
5120668 | 5120668 | 20240914033102_bvUGA | UK00BH | 2024-09-18T12:10:44.285Z | 2024-09-19T12:20:00.676Z |
5120552 | 5120552 | 20240914032754_uE9bi | UK00BH | 2024-09-18T12:10:42.964Z | 2024-09-19T12:20:00.564Z |
5120387 | 5120387 | 20240914031907_3J4lm | UK00BH | 2024-09-18T12:10:39.079Z | 2024-09-19T12:20:00.086Z |
5119717 | 5119717 | 20240914024413_3Swqf | UK00BH | 2024-09-18T12:10:24.383Z | 2024-09-19T12:19:58.781Z |
5119696 | 5119696 | 20240914024409_grNiF | UK00BH | 2024-09-18T12:10:24.068Z | 2024-09-19T12:19:58.737Z |
5119565 | 5119565 | 20240914023920_ytJ2I | UK00BH | 2024-09-18T12:10:22.337Z | 2024-09-19T12:19:58.537Z |
5119547 | 5119547 | 20240914023837_UfZw2 | UK00BH | 2024-09-18T12:10:22.187Z | 2024-09-19T12:19:58.485Z |
5119531 | 5119531 | 20240914023818_PpSda | UK00BH | 2024-09-18T12:10:22.095Z | 2024-09-19T12:19:58.467Z |
5119473 | 5119473 | 20240914023600_2u6WP | UK00BH | 2024-09-18T12:10:21.526Z | 2024-09-19T12:19:58.286Z |
5119383 | 5119383 | 20240914022955_aPR5h | UK00BH | 2024-09-18T12:10:20.652Z | 2024-09-19T12:19:58.100Z |
5119253 | 5119253 | 20240914021832_IPZrP | UK00BH | 2024-09-18T12:10:18.774Z | 2024-09-19T12:19:57.474Z |
5117450 | 5117450 | 20240915043339_hFYBo | UK00BH | 2024-09-18T12:07:41.651Z | 2024-09-19T12:19:15.101Z |
5117303 | 5117303 | 20240915041638_6NqyD | UK00BH | 2024-09-18T12:07:37.327Z | 2024-09-19T12:19:14.155Z |
5116768 | 5116768 | 20240915034018_8sSmw | UK00BH | 2024-09-18T12:07:20.178Z | 2024-09-19T12:19:12.313Z |
5116588 | 5116588 | 20240915033225_MK2tZ | UK00BH | 2024-09-18T12:07:10.683Z | 2024-09-19T12:19:11.568Z |
5116522 | 5116522 | 20240915033030_5Zu31 | UK00BH | 2024-09-18T12:07:08.342Z | 2024-09-19T12:19:11.432Z |
5116428 | 5116428 | 20240915032539_9leAG | UK00BH | 2024-09-18T12:07:01.982Z | 2024-09-19T12:19:11.103Z |
5116171 | 5116171 | 20240915031254_FwXDE | UK00BH | 2024-09-18T12:06:45.632Z | 2024-09-19T12:19:09.098Z |
5116049 | 5116049 | 20240915030422_BjdsF | UK00BH | 2024-09-18T12:06:35.056Z | 2024-09-19T12:19:08.235Z |
5115914 | 5115914 | 20240915025912_eze3N | UK00BH | 2024-09-18T12:06:31.499Z | 2024-09-19T12:19:07.807Z |
5115748 | 5115748 | 20240915025118_ZVC3C | UK00BH | 2024-09-18T12:06:22.631Z | 2024-09-19T12:19:06.714Z |
5115677 | 5115677 | 20240915024901_VW6yq | UK00BH | 2024-09-18T12:06:21.014Z | 2024-09-19T12:19:06.373Z |
5114843 | 5114843 | 20240915020037_79AML | UK00BH | 2024-09-18T12:05:36.393Z | 2024-09-19T12:19:00.134Z |
5114754 | 5114754 | 20240915015725_ZneBD | UK00BH | 2024-09-18T12:05:33.097Z | 2024-09-19T12:18:59.796Z |
5114636 | 5114636 | 20240915015225_PAl02 | UK00BH | 2024-09-18T12:05:25.859Z | 2024-09-19T12:18:59.082Z |
5114500 | 5114500 | 20240915014441_aDP0R | UK00BH | 2024-09-18T12:05:19.775Z | 2024-09-19T12:18:58.559Z |
5114390 | 5114390 | 20240915014044_iD3CJ | UK00BH | 2024-09-18T12:05:14.128Z | 2024-09-19T12:18:57.925Z |
5114193 | 5114193 | 20240915013027_ED8xF | UK00BH | 2024-09-18T12:05:05.873Z | 2024-09-19T12:18:56.665Z |
5113940 | 5113940 | 20240915012025_uhUMW | UK00BH | 2024-09-18T12:04:55.863Z | 2024-09-19T12:18:54.474Z |
5113913 | 5113913 | 20240915011813_4rPkM | UK00BH | 2024-09-18T12:04:55.121Z | 2024-09-19T12:18:54.250Z |
5113859 | 5113859 | 20240915011547_TCzq1 | UK00BH | 2024-09-18T12:04:53.119Z | 2024-09-19T12:18:53.403Z |
5113686 | 5113686 | 20240915010509_grEkf | UK00BH | 2024-09-18T12:04:39.659Z | 2024-09-19T12:18:51.253Z |
5113604 | 5113604 | 20240915010038_yynXa | UK00BH | 2024-09-18T12:04:34.570Z | 2024-09-19T12:18:50.528Z |
5113558 | 5113558 | 20240915005842_zCgmm | UK00BH | 2024-09-18T12:04:30.204Z | 2024-09-19T12:18:50.377Z |
5113449 | 5113449 | 20240915004949_mcy3v | UK00BH | 2024-09-18T12:04:17.704Z | 2024-09-19T12:18:49.142Z |
5113221 | 5113221 | 20240915003210_PtWdE | UK00BH | 2024-09-18T12:04:03.183Z | 2024-09-19T12:18:48.003Z |
5113040 | 5113040 | 20240915001640_zqpDA | UK00BH | 2024-09-18T12:03:52.447Z | 2024-09-19T12:18:46.674Z |
5112736 | 5112736 | 20240914234642_5yMMA | UK00BH | 2024-09-18T12:03:25.778Z | 2024-09-19T12:18:43.749Z |
5112659 | 5112659 | 20240914233857_oFHQB | UK00BH | 2024-09-18T12:03:19.364Z | 2024-09-19T12:18:42.650Z |
5112597 | 5112597 | 20240914233034_ABu4f | UK00BH | 2024-09-18T12:03:15.509Z | 2024-09-19T12:18:41.527Z |
5112478 | 5112478 | 20240914231854_40L2a | UK00BH | 2024-09-18T12:03:09.635Z | 2024-09-19T12:18:41.112Z |
5112442 | 5112442 | 20240914231447_tdCWJ | UK00BH | 2024-09-18T12:03:06.394Z | 2024-09-19T12:18:41.023Z |
5112428 | 5112428 | 20240914230944_ybmw3 | UK00BH | 2024-09-18T12:03:03.963Z | 2024-09-19T12:18:40.947Z |
5112265 | 5112265 | 20240914224747_14gv3 | UK00BH | 2024-09-18T12:02:57.165Z | 2024-09-19T12:18:40.240Z |
5112147 | 5112147 | 20240914222537_yN6EK | UK00BH | 2024-09-18T12:02:49.873Z | 2024-09-19T12:18:38.649Z |
5112102 | 5112102 | 20240914221423_sct88 | UK00BH | 2024-09-18T12:02:47.713Z | 2024-09-19T12:18:38.285Z |
5112034 | 5112034 | 20240914220133_n9GpU | UK00BH | 2024-09-18T12:02:42.739Z | 2024-09-19T12:18:36.650Z |
5111995 | 5111995 | 20240914215035_R3HCY | UK00BH | 2024-09-18T12:02:36.119Z | 2024-09-19T12:18:36.262Z |
5111951 | 5111951 | 20240914214554_0Ehjz | UK00BH | 2024-09-18T12:02:31.944Z | 2024-09-19T12:18:35.473Z |
5111836 | 5111836 | 20240914212020_ys9E5 | UK00BH | 2024-09-18T12:02:19.078Z | 2024-09-19T12:18:34.222Z |
5111804 | 5111804 | 20240914211716_PHIJa | UK00BH | 2024-09-18T12:02:18.042Z | 2024-09-19T12:18:34.062Z |
5111704 | 5111704 | 20240914210049_wBjPi | UK00BH | 2024-09-18T12:02:11.198Z | 2024-09-19T12:18:33.329Z |
5111588 | 5111588 | 20240914205051_F6LRZ | UK00BH | 2024-09-18T12:02:04.393Z | 2024-09-19T12:18:31.498Z |
5111305 | 5111305 | 20240914202048_RBYeT | UK00BH | 2024-09-18T12:01:48.338Z | 2024-09-19T12:18:28.847Z |
5111132 | 5111132 | 20240914200340_bGQCV | UK00BH | 2024-09-18T12:01:38.051Z | 2024-09-19T12:18:26.908Z |
5111058 | 5111058 | 20240914194621_Ywshl | UK00BH | 2024-09-18T12:01:23.341Z | 2024-09-19T12:18:25.576Z |
5111011 | 5111011 | 20240914193941_xDZd2 | UK00BH | 2024-09-18T12:01:19.168Z | 2024-09-19T12:18:25.275Z |
5110946 | 5110946 | 20240914193007_bLy1e | UK00BH | 2024-09-18T12:01:13.383Z | 2024-09-19T12:18:24.881Z |
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);