participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,666 rows where station_code = "UK006Y" 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 |
---|---|---|---|---|---|
4001354 | 4001354 | 20240224045211_kuxSI | UK006Y | 2024-02-25T14:03:05.707Z | 2024-03-03T14:17:37.581Z |
4000480 | 4000480 | 20240220045238_uE3CO | UK006Y | 2024-02-24T14:14:59.801Z | 2024-02-28T14:14:33.920Z |
3912581 | 3912581 | 20240203052926_cHxhN | UK006Y | 2024-02-04T14:04:48.471Z | 2024-02-11T14:23:14.677Z |
3822353 | 3822353 | 20240114015939_AR8EU | UK006Y | 2024-01-16T14:15:19.824Z | 2024-01-23T14:24:44.180Z |
3822230 | 3822230 | 20240114001411_iEzy4 | UK006Y | 2024-01-16T14:14:30.803Z | 2024-01-22T14:23:20.138Z |
3821640 | 3821640 | 20240113202437_Rhc3W | UK006Y | 2024-01-16T14:13:23.841Z | 2024-01-22T14:23:13.266Z |
3821529 | 3821529 | 20240113201141_STITD | UK006Y | 2024-01-16T14:13:17.087Z | 2024-01-22T14:23:12.400Z |
3820795 | 3820795 | 20240113183236_FV8LX | UK006Y | 2024-01-16T14:12:06.766Z | 2024-01-22T14:23:05.984Z |
3820737 | 3820737 | 20240113182428_hSwu2 | UK006Y | 2024-01-16T14:12:02.153Z | 2024-01-22T14:23:05.250Z |
3814467 | 3814467 | 20240113043141_HRdHd | UK006Y | 2024-01-15T14:14:04.223Z | 2024-01-22T14:21:50.462Z |
3814438 | 3814438 | 20240113042257_WbiYY | UK006Y | 2024-01-15T14:14:02.182Z | 2024-01-22T14:21:49.862Z |
3807778 | 3807778 | 20240113025837_TTY62 | UK006Y | 2024-01-15T14:01:07.237Z | 2024-01-22T14:21:42.834Z |
3807636 | 3807636 | 20240113014207_YTqk6 | UK006Y | 2024-01-15T14:00:25.167Z | 2024-01-22T14:21:39.518Z |
3716792 | 3716792 | 20231226062637_jPBuq | UK006Y | 2024-01-06T00:05:59.702Z | 2024-01-06T00:05:59.702Z |
3716504 | 3716504 | 20231226051336_o78C5 | UK006Y | 2024-01-06T00:05:59.670Z | 2024-01-06T00:05:59.670Z |
3696575 | 3696575 | 20231220055152_4xdZO | UK006Y | 2024-01-06T00:05:46.123Z | 2024-01-06T00:05:46.123Z |
3696362 | 3696362 | 20231220051703_D68P7 | UK006Y | 2024-01-06T00:05:46.009Z | 2024-01-06T00:05:46.009Z |
3696300 | 3696300 | 20231220050939_41sfa | UK006Y | 2024-01-06T00:05:45.987Z | 2024-01-06T00:05:45.987Z |
3696249 | 3696249 | 20231220050351_62CGS | UK006Y | 2024-01-06T00:05:45.974Z | 2024-01-06T00:05:45.974Z |
3696190 | 3696190 | 20231220045947_u8EsT | UK006Y | 2024-01-06T00:05:45.965Z | 2024-01-06T00:05:45.965Z |
3696135 | 3696135 | 20231220045240_oK8Fq | UK006Y | 2024-01-06T00:05:45.952Z | 2024-01-06T00:05:45.952Z |
3696057 | 3696057 | 20231220044313_NXc83 | UK006Y | 2024-01-06T00:05:45.938Z | 2024-01-06T00:05:45.938Z |
3695962 | 3695962 | 20231220043710_Rlh2v | UK006Y | 2024-01-06T00:05:45.922Z | 2024-01-06T00:05:45.922Z |
3695835 | 3695835 | 20231220042503_sP0x8 | UK006Y | 2024-01-06T00:05:45.895Z | 2024-01-06T00:05:45.895Z |
3695629 | 3695629 | 20231220035843_04ybX | UK006Y | 2024-01-06T00:05:45.837Z | 2024-01-06T00:05:45.837Z |
3695391 | 3695391 | 20231220034100_Z27Gt | UK006Y | 2024-01-06T00:05:45.746Z | 2024-01-06T00:05:45.746Z |
3695187 | 3695187 | 20231220031426_GWYbV | UK006Y | 2024-01-06T00:05:45.645Z | 2024-01-06T00:05:45.645Z |
3695185 | 3695185 | 20231220031417_sC8dQ | UK006Y | 2024-01-06T00:05:45.644Z | 2024-01-06T00:05:45.644Z |
3694714 | 3694714 | 20231220023806_Q24wz | UK006Y | 2024-01-06T00:05:45.411Z | 2024-01-06T00:05:45.411Z |
3694593 | 3694593 | 20231220022651_rL0mr | UK006Y | 2024-01-06T00:05:45.334Z | 2024-01-06T00:05:45.334Z |
3692635 | 3692635 | 20231220001822_WFFBo | UK006Y | 2024-01-06T00:05:44.639Z | 2024-01-06T00:05:44.639Z |
3692436 | 3692436 | 20231219235131_OTfot | UK006Y | 2024-01-06T00:05:44.560Z | 2024-01-06T00:05:44.560Z |
3688867 | 3688867 | 20231219063909_tVf6B | UK006Y | 2024-01-06T00:05:41.225Z | 2024-01-06T00:05:41.225Z |
3688843 | 3688843 | 20231219062826_mCz8t | UK006Y | 2024-01-06T00:05:41.220Z | 2024-01-06T00:05:41.220Z |
3561583 | 3561583 | 20231210054813_2nrU9 | UK006Y | 2024-01-06T00:05:10.630Z | 2024-01-06T00:05:10.630Z |
3525549 | 3525549 | 20231206062117_kkq1w | UK006Y | 2024-01-06T00:05:01.477Z | 2024-01-06T00:05:01.477Z |
3525133 | 3525133 | 20231206054545_J7x1s | UK006Y | 2024-01-06T00:05:01.440Z | 2024-01-06T00:05:01.440Z |
3525052 | 3525052 | 20231206054203_Wfrme | UK006Y | 2024-01-06T00:05:01.434Z | 2024-01-06T00:05:01.434Z |
3524584 | 3524584 | 20231206050943_Xzq6G | UK006Y | 2024-01-06T00:05:01.391Z | 2024-01-06T00:05:01.391Z |
3524548 | 3524548 | 20231206050816_qnmFK | UK006Y | 2024-01-06T00:05:01.388Z | 2024-01-06T00:05:01.388Z |
3524503 | 3524503 | 20231206050546_gwrNv | UK006Y | 2024-01-06T00:05:01.384Z | 2024-01-06T00:05:01.384Z |
3523287 | 3523287 | 20231206034337_aK0ZL | UK006Y | 2024-01-06T00:05:01.286Z | 2024-01-06T00:05:01.286Z |
3523146 | 3523146 | 20231206033600_nBr5x | UK006Y | 2024-01-06T00:05:01.275Z | 2024-01-06T00:05:01.275Z |
3522723 | 3522723 | 20231206030701_LhwX3 | UK006Y | 2024-01-06T00:05:01.247Z | 2024-01-06T00:05:01.247Z |
3521984 | 3521984 | 20231206021129_CFjyL | UK006Y | 2024-01-06T00:05:01.187Z | 2024-01-06T00:05:01.187Z |
3521932 | 3521932 | 20231206020745_2sAio | UK006Y | 2024-01-06T00:05:01.183Z | 2024-01-06T00:05:01.183Z |
3521877 | 3521877 | 20231206020548_JIpIk | UK006Y | 2024-01-06T00:05:01.179Z | 2024-01-06T00:05:01.179Z |
3521447 | 3521447 | 20231206013701_PZi9k | UK006Y | 2024-01-06T00:05:01.143Z | 2024-01-06T00:05:01.143Z |
3499296 | 3499296 | 20231201233401_331Zv | UK006Y | 2024-01-06T00:04:53.597Z | 2024-01-06T00:04:53.597Z |
3499176 | 3499176 | 20231201225750_UH1Oq | UK006Y | 2024-01-06T00:04:53.582Z | 2024-01-06T00:04:53.582Z |
3499179 | 3499179 | 20231201225833_xht63 | UK006Y | 2024-01-06T00:04:53.582Z | 2024-01-06T00:04:53.582Z |
3499079 | 3499079 | 20231201221434_pV2lf | UK006Y | 2024-01-06T00:04:53.569Z | 2024-01-06T00:04:53.569Z |
3497872 | 3497872 | 20231201182130_mCD22 | UK006Y | 2024-01-06T00:04:52.244Z | 2024-01-06T00:04:52.244Z |
3487111 | 3487111 | 20231129063836_wRmka | UK006Y | 2024-01-06T00:04:48.774Z | 2024-01-06T00:04:48.774Z |
3486934 | 3486934 | 20231129054535_63Wne | UK006Y | 2024-01-06T00:04:48.758Z | 2024-01-06T00:04:48.758Z |
3486852 | 3486852 | 20231129051929_FN7iB | UK006Y | 2024-01-06T00:04:48.751Z | 2024-01-06T00:04:48.751Z |
3486792 | 3486792 | 20231129050114_8qKs5 | UK006Y | 2024-01-06T00:04:48.746Z | 2024-01-06T00:04:48.746Z |
3486776 | 3486776 | 20231129045822_eXxE3 | UK006Y | 2024-01-06T00:04:48.745Z | 2024-01-06T00:04:48.745Z |
3486752 | 3486752 | 20231129044323_OuIo7 | UK006Y | 2024-01-06T00:04:48.743Z | 2024-01-06T00:04:48.743Z |
3486705 | 3486705 | 20231129043246_379km | UK006Y | 2024-01-06T00:04:48.740Z | 2024-01-06T00:04:48.740Z |
3486632 | 3486632 | 20231129040854_CI6Fo | UK006Y | 2024-01-06T00:04:48.732Z | 2024-01-06T00:04:48.732Z |
3486607 | 3486607 | 20231129040008_CQNod | UK006Y | 2024-01-06T00:04:48.729Z | 2024-01-06T00:04:48.729Z |
3485134 | 3485134 | 20231128180415_fx5B1 | UK006Y | 2024-01-06T00:04:47.399Z | 2024-01-06T00:04:47.399Z |
3481388 | 3481388 | 20231125183345_WoaY3 | UK006Y | 2024-01-06T00:04:43.466Z | 2024-01-06T00:04:43.466Z |
3447877 | 3447877 | 20231121010744_6TRLR | UK006Y | 2024-01-06T00:04:35.230Z | 2024-01-06T00:04:35.230Z |
3379985 | 3379985 | 20231113020719_Ois0D | UK006Y | 2024-01-06T00:04:17.613Z | 2024-01-06T00:04:17.613Z |
3379864 | 3379864 | 20231113010823_hLmzt | UK006Y | 2024-01-06T00:04:17.592Z | 2024-01-06T00:04:17.592Z |
3379829 | 3379829 | 20231113004559_km24y | UK006Y | 2024-01-06T00:04:17.586Z | 2024-01-06T00:04:17.586Z |
3379790 | 3379790 | 20231113001735_Y2H7p | UK006Y | 2024-01-06T00:04:17.580Z | 2024-01-06T00:04:17.580Z |
3373477 | 3373477 | 20231111060132_3g1Ko | UK006Y | 2024-01-06T00:04:15.559Z | 2024-01-06T00:04:15.559Z |
3373364 | 3373364 | 20231111055123_HXd8G | UK006Y | 2024-01-06T00:04:15.549Z | 2024-01-06T00:04:15.549Z |
3373344 | 3373344 | 20231111054935_Rblrt | UK006Y | 2024-01-06T00:04:15.547Z | 2024-01-06T00:04:15.547Z |
3372928 | 3372928 | 20231111053338_PkD3v | UK006Y | 2024-01-06T00:04:15.515Z | 2024-01-06T00:04:15.515Z |
3372674 | 3372674 | 20231111052119_UmeGG | UK006Y | 2024-01-06T00:04:15.498Z | 2024-01-06T00:04:15.498Z |
3372557 | 3372557 | 20231111051632_ON5Vn | UK006Y | 2024-01-06T00:04:15.490Z | 2024-01-06T00:04:15.490Z |
3372529 | 3372529 | 20231111051552_we5OE | UK006Y | 2024-01-06T00:04:15.488Z | 2024-01-06T00:04:15.488Z |
3372505 | 3372505 | 20231111051355_nSiIU | UK006Y | 2024-01-06T00:04:15.487Z | 2024-01-06T00:04:15.487Z |
3372380 | 3372380 | 20231111050500_82JhV | UK006Y | 2024-01-06T00:04:15.478Z | 2024-01-06T00:04:15.478Z |
3372243 | 3372243 | 20231111045822_KrCbg | UK006Y | 2024-01-06T00:04:15.467Z | 2024-01-06T00:04:15.467Z |
3371894 | 3371894 | 20231111044332_8vJrj | UK006Y | 2024-01-06T00:04:15.444Z | 2024-01-06T00:04:15.444Z |
3371741 | 3371741 | 20231111043535_ccOZE | UK006Y | 2024-01-06T00:04:15.432Z | 2024-01-06T00:04:15.432Z |
3371695 | 3371695 | 20231111043509_tqnbB | UK006Y | 2024-01-06T00:04:15.429Z | 2024-01-06T00:04:15.429Z |
3371569 | 3371569 | 20231111042826_WQi4G | UK006Y | 2024-01-06T00:04:15.421Z | 2024-01-06T00:04:15.421Z |
3371503 | 3371503 | 20231111042735_wxydI | UK006Y | 2024-01-06T00:04:15.418Z | 2024-01-06T00:04:15.418Z |
3371447 | 3371447 | 20231111042612_akJRc | UK006Y | 2024-01-06T00:04:15.414Z | 2024-01-06T00:04:15.414Z |
3371181 | 3371181 | 20231111040850_ysFWO | UK006Y | 2024-01-06T00:04:15.395Z | 2024-01-06T00:04:15.395Z |
3370957 | 3370957 | 20231111040031_7VcBa | UK006Y | 2024-01-06T00:04:15.379Z | 2024-01-06T00:04:15.379Z |
3370912 | 3370912 | 20231111035638_VFwcV | UK006Y | 2024-01-06T00:04:15.375Z | 2024-01-06T00:04:15.375Z |
3370826 | 3370826 | 20231111035230_y6tIx | UK006Y | 2024-01-06T00:04:15.370Z | 2024-01-06T00:04:15.370Z |
3370766 | 3370766 | 20231111035136_WR9xK | UK006Y | 2024-01-06T00:04:15.366Z | 2024-01-06T00:04:15.366Z |
3370424 | 3370424 | 20231111033705_cfIVY | UK006Y | 2024-01-06T00:04:15.342Z | 2024-01-06T00:04:15.342Z |
3370402 | 3370402 | 20231111033606_ENayJ | UK006Y | 2024-01-06T00:04:15.340Z | 2024-01-06T00:04:15.340Z |
3370335 | 3370335 | 20231111033034_RCFf9 | UK006Y | 2024-01-06T00:04:15.334Z | 2024-01-06T00:04:15.334Z |
3370213 | 3370213 | 20231111032536_b5J3C | UK006Y | 2024-01-06T00:04:15.325Z | 2024-01-06T00:04:15.325Z |
3369979 | 3369979 | 20231111030921_fB88n | UK006Y | 2024-01-06T00:04:15.307Z | 2024-01-06T00:04:15.307Z |
3369849 | 3369849 | 20231111030414_D2uEu | UK006Y | 2024-01-06T00:04:15.298Z | 2024-01-06T00:04:15.298Z |
3364975 | 3364975 | 20231110212046_ijtbO | UK006Y | 2024-01-06T00:04:13.585Z | 2024-01-06T00:04:13.585Z |
3363611 | 3363611 | 20231110191841_p3tm4 | UK006Y | 2024-01-06T00:04:13.466Z | 2024-01-06T00:04:13.466Z |
3358021 | 3358021 | 20231110060138_818PD | UK006Y | 2024-01-06T00:04:12.837Z | 2024-01-06T00:04:12.837Z |
3357985 | 3357985 | 20231110055651_h9YVX | UK006Y | 2024-01-06T00:04:12.833Z | 2024-01-06T00:04:12.833Z |
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);