participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,509 rows where station_code = "UK0032" 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 |
---|---|---|---|---|---|
5442503 | 5442503 | 20241030014139_Pyv0T | UK0032 | 2024-11-01T12:19:55.520Z | 2024-11-07T14:26:46.829Z |
5442219 | 5442219 | 20241030005608_K2w9k | UK0032 | 2024-11-01T12:19:34.275Z | 2024-11-07T14:26:45.643Z |
5442085 | 5442085 | 20241030003508_lH933 | UK0032 | 2024-11-01T12:19:24.637Z | 2024-11-07T14:26:44.974Z |
5442014 | 5442014 | 20241030001813_DFi3T | UK0032 | 2024-11-01T12:19:19.455Z | 2024-11-07T14:26:44.688Z |
5441907 | 5441907 | 20241030000203_Mk8n1 | UK0032 | 2024-11-01T12:19:12.099Z | 2024-11-07T14:26:44.332Z |
5441850 | 5441850 | 20241029235241_3H8V0 | UK0032 | 2024-11-01T12:19:06.562Z | 2024-11-07T14:26:43.816Z |
5441842 | 5441842 | 20241029234951_H8MNb | UK0032 | 2024-11-01T12:19:05.850Z | 2024-11-07T14:26:43.754Z |
5441775 | 5441775 | 20241029232911_HBR3L | UK0032 | 2024-11-01T12:19:01.514Z | 2024-11-07T14:26:43.227Z |
5441755 | 5441755 | 20241029232520_cME6e | UK0032 | 2024-11-01T12:18:59.839Z | 2024-11-07T14:26:43.162Z |
5441712 | 5441712 | 20241029231637_gNQ6G | UK0032 | 2024-11-01T12:18:55.228Z | 2024-11-07T14:26:43.082Z |
5441590 | 5441590 | 20241029224338_DVNNS | UK0032 | 2024-11-01T12:18:46.753Z | 2024-11-07T14:26:42.701Z |
5441579 | 5441579 | 20241029223915_Zaw2x | UK0032 | 2024-11-01T12:18:46.420Z | 2024-11-07T14:26:42.690Z |
5441313 | 5441313 | 20241029214000_BMcJ1 | UK0032 | 2024-11-01T12:18:26.049Z | 2024-11-07T14:26:41.677Z |
5441151 | 5441151 | 20241029205857_BxmHS | UK0032 | 2024-11-01T12:18:11.585Z | 2024-11-07T14:26:41.006Z |
5433495 | 5433495 | 20241029200823_6kUqA | UK0032 | 2024-10-31T12:22:18.534Z | 2024-11-07T14:26:39.946Z |
5433400 | 5433400 | 20241029194104_5AiTr | UK0032 | 2024-10-31T12:22:12.924Z | 2024-11-07T14:26:39.033Z |
5433330 | 5433330 | 20241029191023_WIzPl | UK0032 | 2024-10-31T12:22:08.241Z | 2024-11-07T14:26:38.296Z |
5433196 | 5433196 | 20241029180921_C0T1F | UK0032 | 2024-10-31T12:21:56.658Z | 2024-11-07T14:26:36.480Z |
5410680 | 5410680 | 20241027052755_rMIxt | UK0032 | 2024-10-29T12:18:02.339Z | 2024-11-04T14:29:05.213Z |
5410380 | 5410380 | 20241027051049_qXa2Z | UK0032 | 2024-10-29T12:17:54.954Z | 2024-11-04T14:29:04.490Z |
5410297 | 5410297 | 20241027050526_99QyE | UK0032 | 2024-10-29T12:17:52.648Z | 2024-11-04T14:29:04.317Z |
5409927 | 5409927 | 20241027044239_eUWQD | UK0032 | 2024-10-29T12:17:44.176Z | 2024-11-04T14:29:02.941Z |
5409650 | 5409650 | 20241027042926_KPwfA | UK0032 | 2024-10-29T12:17:36.160Z | 2024-11-04T14:29:02.054Z |
5409606 | 5409606 | 20241027042808_Qpgc7 | UK0032 | 2024-10-29T12:17:32.939Z | 2024-11-04T14:29:02.007Z |
5407811 | 5407811 | 20241027025321_OXV63 | UK0032 | 2024-10-29T12:15:44.351Z | 2024-11-04T14:28:58.170Z |
5407771 | 5407771 | 20241027025204_lUWIS | UK0032 | 2024-10-29T12:15:40.168Z | 2024-11-04T14:28:58.140Z |
5407612 | 5407612 | 20241027024416_ENltf | UK0032 | 2024-10-29T12:15:31.327Z | 2024-11-04T14:28:57.934Z |
5407221 | 5407221 | 20241027022651_ZQTGX | UK0032 | 2024-10-29T12:15:17.565Z | 2024-11-04T14:28:57.246Z |
5407139 | 5407139 | 20241027022333_pjlH1 | UK0032 | 2024-10-29T12:15:14.540Z | 2024-11-04T14:28:57.011Z |
5407113 | 5407113 | 20241027022243_dpLhe | UK0032 | 2024-10-29T12:15:12.731Z | 2024-11-04T14:28:56.850Z |
5406929 | 5406929 | 20241027021029_8YxqV | UK0032 | 2024-10-29T12:15:01.386Z | 2024-11-04T14:28:56.707Z |
5406641 | 5406641 | 20241027015144_gwnWn | UK0032 | 2024-10-29T12:14:28.269Z | 2024-11-04T14:28:55.971Z |
5406549 | 5406549 | 20241027014341_5fkUg | UK0032 | 2024-10-29T12:14:19.751Z | 2024-11-04T14:28:55.858Z |
5406337 | 5406337 | 20241027012911_aubvE | UK0032 | 2024-10-29T12:14:02.852Z | 2024-11-04T14:28:55.477Z |
5406310 | 5406310 | 20241027012658_HEDF2 | UK0032 | 2024-10-29T12:14:01.794Z | 2024-11-04T14:28:55.425Z |
5406242 | 5406242 | 20241027012331_BbnsN | UK0032 | 2024-10-29T12:13:59.057Z | 2024-11-04T14:28:55.249Z |
5406234 | 5406234 | 20241027012253_CU4r7 | UK0032 | 2024-10-29T12:13:58.424Z | 2024-11-04T14:28:55.242Z |
5405750 | 5405750 | 20241027005529_U2li3 | UK0032 | 2024-10-29T12:13:12.506Z | 2024-11-04T14:28:54.137Z |
5405608 | 5405608 | 20241027004849_9hCG4 | UK0032 | 2024-10-29T12:13:04.574Z | 2024-11-04T14:28:53.710Z |
5405508 | 5405508 | 20241027003956_3XpyO | UK0032 | 2024-10-29T12:12:59.591Z | 2024-11-04T14:28:53.580Z |
5405464 | 5405464 | 20241027003741_xfioa | UK0032 | 2024-10-29T12:12:57.470Z | 2024-11-04T14:28:53.528Z |
5405337 | 5405337 | 20241027002907_1x3el | UK0032 | 2024-10-29T12:12:50.148Z | 2024-11-04T14:28:53.294Z |
5404726 | 5404726 | 20241026234925_gxOAe | UK0032 | 2024-10-29T12:11:55.131Z | 2024-11-04T14:28:51.872Z |
5404269 | 5404269 | 20241026231312_2dMb8 | UK0032 | 2024-10-29T12:11:04.002Z | 2024-11-04T14:28:50.571Z |
5403745 | 5403745 | 20241026222751_Myfx3 | UK0032 | 2024-10-29T12:10:11.408Z | 2024-11-04T14:28:49.541Z |
5403232 | 5403232 | 20241026213115_8ypVe | UK0032 | 2024-10-29T12:09:14.918Z | 2024-11-04T14:28:47.992Z |
5403172 | 5403172 | 20241026212537_u5XAq | UK0032 | 2024-10-29T12:09:10.195Z | 2024-11-04T14:28:47.923Z |
5403040 | 5403040 | 20241026210855_8qLR2 | UK0032 | 2024-10-29T12:08:48.264Z | 2024-11-04T14:28:47.607Z |
5402780 | 5402780 | 20241026202414_l3re5 | UK0032 | 2024-10-29T12:08:07.947Z | 2024-11-04T14:28:46.520Z |
5402701 | 5402701 | 20241026201529_DEP2K | UK0032 | 2024-10-29T12:07:58.721Z | 2024-11-04T14:28:46.257Z |
5402657 | 5402657 | 20241026201132_k0xJF | UK0032 | 2024-10-29T12:07:54.900Z | 2024-11-04T14:28:45.893Z |
5401958 | 5401958 | 20241026181210_XZPqg | UK0032 | 2024-10-29T12:05:54.955Z | 2024-11-04T14:28:41.121Z |
5399940 | 5399940 | 20241026051438_31Uik | UK0032 | 2024-10-28T12:20:17.253Z | 2024-11-03T14:27:40.883Z |
5399821 | 5399821 | 20241026050517_HM2FP | UK0032 | 2024-10-28T12:20:12.318Z | 2024-11-03T14:27:40.576Z |
5399366 | 5399366 | 20241026041359_otTl4 | UK0032 | 2024-10-28T12:19:56.418Z | 2024-11-03T14:27:39.550Z |
5399164 | 5399164 | 20241026035758_sfM3v | UK0032 | 2024-10-28T12:19:50.312Z | 2024-11-03T14:27:39.167Z |
5398950 | 5398950 | 20241026034045_2nBij | UK0032 | 2024-10-28T12:19:41.165Z | 2024-11-03T14:27:38.700Z |
5398911 | 5398911 | 20241026033718_i44QH | UK0032 | 2024-10-28T12:19:40.093Z | 2024-11-03T14:27:38.598Z |
5398901 | 5398901 | 20241026033659_pKDuf | UK0032 | 2024-10-28T12:19:39.733Z | 2024-11-03T14:27:38.385Z |
5398843 | 5398843 | 20241026033324_gEwM0 | UK0032 | 2024-10-28T12:19:37.116Z | 2024-11-03T14:27:38.295Z |
5398541 | 5398541 | 20241026030600_My2El | UK0032 | 2024-10-28T12:19:21.085Z | 2024-11-03T14:27:36.769Z |
5398423 | 5398423 | 20241026025549_Erkmh | UK0032 | 2024-10-28T12:19:16.641Z | 2024-11-03T14:27:36.358Z |
5398358 | 5398358 | 20241026024929_d3RhO | UK0032 | 2024-10-28T12:19:12.439Z | 2024-11-03T14:27:36.061Z |
5398255 | 5398255 | 20241026023822_ydMre | UK0032 | 2024-10-28T12:19:07.919Z | 2024-11-03T14:27:35.733Z |
5398094 | 5398094 | 20241026022621_kjh1m | UK0032 | 2024-10-28T12:19:00.769Z | 2024-11-03T14:27:35.377Z |
5398058 | 5398058 | 20241026022147_4ba2X | UK0032 | 2024-10-28T12:18:59.333Z | 2024-11-03T14:27:35.247Z |
5397577 | 5397577 | 20241026014114_FHRGo | UK0032 | 2024-10-28T12:18:28.606Z | 2024-11-03T14:27:33.428Z |
5395390 | 5395390 | 20241025223936_PELed | UK0032 | 2024-10-28T12:16:11.998Z | 2024-11-03T14:27:25.423Z |
5395259 | 5395259 | 20241025222837_GmSUL | UK0032 | 2024-10-28T12:16:03.789Z | 2024-11-03T14:27:24.461Z |
5385759 | 5385759 | 20241024232619_2Ds34 | UK0032 | 2024-10-27T12:19:21.683Z | 2024-11-02T12:28:30.154Z |
5385658 | 5385658 | 20241024231423_MJEi7 | UK0032 | 2024-10-27T12:19:14.834Z | 2024-11-02T12:28:30.021Z |
5385539 | 5385539 | 20241024225900_CTB0r | UK0032 | 2024-10-27T12:19:04.842Z | 2024-11-02T12:28:29.901Z |
5385360 | 5385360 | 20241024223009_gsRqx | UK0032 | 2024-10-27T12:18:47.762Z | 2024-11-02T12:28:29.669Z |
5384911 | 5384911 | 20241024211518_Va9SZ | UK0032 | 2024-10-27T12:17:58.219Z | 2024-11-02T12:28:28.590Z |
5384697 | 5384697 | 20241024204036_u582U | UK0032 | 2024-10-27T12:17:32.115Z | 2024-11-02T12:28:27.654Z |
5384558 | 5384558 | 20241024202130_qaUi4 | UK0032 | 2024-10-27T12:17:11.181Z | 2024-11-02T12:28:27.321Z |
5384365 | 5384365 | 20241024200000_PUGe7 | UK0032 | 2024-10-27T12:16:59.064Z | 2024-11-02T12:28:26.999Z |
5383443 | 5383443 | 20241024182122_ayR0A | UK0032 | 2024-10-27T12:15:27.984Z | 2024-11-02T12:28:25.311Z |
5383388 | 5383388 | 20241024181717_Ad8DM | UK0032 | 2024-10-27T12:15:23.001Z | 2024-11-02T12:28:25.102Z |
5378107 | 5378107 | 20241024052717_qfc38 | UK0032 | 2024-10-26T12:22:54.523Z | 2024-11-01T12:27:03.289Z |
5378078 | 5378078 | 20241024052606_xa2xB | UK0032 | 2024-10-26T12:22:54.219Z | 2024-11-01T12:27:03.275Z |
5377354 | 5377354 | 20241024044607_1pwHx | UK0032 | 2024-10-26T12:22:34.819Z | 2024-11-01T12:27:02.387Z |
5376936 | 5376936 | 20241024042458_KkISC | UK0032 | 2024-10-26T12:22:17.640Z | 2024-11-01T12:27:01.924Z |
5376777 | 5376777 | 20241024041535_2X88i | UK0032 | 2024-10-26T12:22:13.089Z | 2024-11-01T12:27:01.850Z |
5376384 | 5376384 | 20241024035306_WJG2e | UK0032 | 2024-10-26T12:22:00.212Z | 2024-11-01T12:27:01.520Z |
5376101 | 5376101 | 20241024034157_QAFA5 | UK0032 | 2024-10-26T12:21:50.525Z | 2024-11-01T12:27:01.390Z |
5376081 | 5376081 | 20241024034034_awEbb | UK0032 | 2024-10-26T12:21:50.023Z | 2024-11-01T12:27:01.384Z |
5375819 | 5375819 | 20241024033205_Du9An | UK0032 | 2024-10-26T12:21:41.193Z | 2024-11-01T12:27:01.213Z |
5375813 | 5375813 | 20241024033153_E9mXE | UK0032 | 2024-10-26T12:21:40.768Z | 2024-11-01T12:27:01.210Z |
5375540 | 5375540 | 20241024031937_7wDJY | UK0032 | 2024-10-26T12:21:31.052Z | 2024-11-01T12:27:00.771Z |
5375294 | 5375294 | 20241024030538_9FgdS | UK0032 | 2024-10-26T12:21:18.800Z | 2024-11-01T12:27:00.475Z |
5374628 | 5374628 | 20241024023712_ANSMv | UK0032 | 2024-10-26T12:20:55.198Z | 2024-11-01T12:26:59.522Z |
5374595 | 5374595 | 20241024023614_qnlPc | UK0032 | 2024-10-26T12:20:54.384Z | 2024-11-01T12:26:59.515Z |
5374441 | 5374441 | 20241024022745_T2wq1 | UK0032 | 2024-10-26T12:20:48.929Z | 2024-11-01T12:26:59.368Z |
5374287 | 5374287 | 20241024022030_DyxCL | UK0032 | 2024-10-26T12:20:43.900Z | 2024-11-01T12:26:58.827Z |
5374126 | 5374126 | 20241024021155_kMemI | UK0032 | 2024-10-26T12:20:37.598Z | 2024-11-01T12:26:58.707Z |
5373992 | 5373992 | 20241024020448_jEQ7x | UK0032 | 2024-10-26T12:20:33.971Z | 2024-11-01T12:26:58.620Z |
5373796 | 5373796 | 20241024015416_jtjjv | UK0032 | 2024-10-26T12:20:26.143Z | 2024-11-01T12:26:58.497Z |
5373371 | 5373371 | 20241024013455_qI20o | UK0032 | 2024-10-26T12:20:09.044Z | 2024-11-01T12:26:58.236Z |
5373091 | 5373091 | 20241024012325_PAj8G | UK0032 | 2024-10-26T12:19:56.812Z | 2024-11-01T12:26:58.129Z |
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);