participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,214 rows where station_code = "UK0098" 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 |
---|---|---|---|---|---|
5524722 | 5524722 | 20241111051943_Xybkr | UK0098 | 2024-11-12T14:17:57.947Z | 2024-11-12T14:18:08.749Z |
5524685 | 5524685 | 20241111051014_pU8Kg | UK0098 | 2024-11-12T14:17:54.947Z | 2024-11-12T14:18:08.736Z |
5524611 | 5524611 | 20241111044557_gKkPg | UK0098 | 2024-11-12T14:17:46.005Z | 2024-11-12T14:18:08.703Z |
5524601 | 5524601 | 20241111044446_6rMFC | UK0098 | 2024-11-12T14:17:44.955Z | 2024-11-12T14:18:08.700Z |
5524547 | 5524547 | 20241111043052_yHaSh | UK0098 | 2024-11-12T14:17:39.375Z | 2024-11-12T14:18:08.675Z |
5524471 | 5524471 | 20241111041812_Prqwa | UK0098 | 2024-11-12T14:17:23.936Z | 2024-11-12T14:18:08.635Z |
5524447 | 5524447 | 20241111041445_zgHpl | UK0098 | 2024-11-12T14:17:22.221Z | 2024-11-12T14:18:08.627Z |
5524405 | 5524405 | 20241111040910_2XwjQ | UK0098 | 2024-11-12T14:17:15.978Z | 2024-11-12T14:18:08.606Z |
5524369 | 5524369 | 20241111040211_YI6x8 | UK0098 | 2024-11-12T14:17:10.365Z | 2024-11-12T14:18:08.586Z |
5524343 | 5524343 | 20241111035837_JIi9v | UK0098 | 2024-11-12T14:17:04.730Z | 2024-11-12T14:18:08.571Z |
5524314 | 5524314 | 20241111035256_jJLX3 | UK0098 | 2024-11-12T14:16:59.975Z | 2024-11-12T14:18:08.557Z |
5524265 | 5524265 | 20241111034207_iV5pT | UK0098 | 2024-11-12T14:16:52.760Z | 2024-11-12T14:18:08.533Z |
5524242 | 5524242 | 20241111033800_wH1B8 | UK0098 | 2024-11-12T14:16:50.203Z | 2024-11-12T14:18:08.526Z |
5524232 | 5524232 | 20241111033739_CZLPv | UK0098 | 2024-11-12T14:16:49.691Z | 2024-11-12T14:18:08.523Z |
5524178 | 5524178 | 20241111032205_JE5lN | UK0098 | 2024-11-12T14:16:41.029Z | 2024-11-12T14:18:08.497Z |
5524129 | 5524129 | 20241111031744_yAl8X | UK0098 | 2024-11-12T14:16:34.906Z | 2024-11-12T14:18:08.480Z |
5524125 | 5524125 | 20241111031710_X3Wml | UK0098 | 2024-11-12T14:16:34.597Z | 2024-11-12T14:18:08.479Z |
5524063 | 5524063 | 20241111030711_hgW6M | UK0098 | 2024-11-12T14:16:30.440Z | 2024-11-12T14:18:08.453Z |
5524043 | 5524043 | 20241111030625_4boNY | UK0098 | 2024-11-12T14:16:29.430Z | 2024-11-12T14:18:08.446Z |
5524002 | 5524002 | 20241111030109_zKSRD | UK0098 | 2024-11-12T14:16:25.542Z | 2024-11-12T14:18:08.428Z |
5523958 | 5523958 | 20241111025407_4R3t7 | UK0098 | 2024-11-12T14:16:22.266Z | 2024-11-12T14:18:08.411Z |
5523788 | 5523788 | 20241111022313_pWOLK | UK0098 | 2024-11-12T14:16:13.137Z | 2024-11-12T14:18:08.343Z |
5523661 | 5523661 | 20241111020147_nQHV0 | UK0098 | 2024-11-12T14:16:06.405Z | 2024-11-12T14:18:08.292Z |
5523657 | 5523657 | 20241111020117_qI2ab | UK0098 | 2024-11-12T14:16:06.227Z | 2024-11-12T14:18:08.291Z |
5523586 | 5523586 | 20241111014944_gxQtI | UK0098 | 2024-11-12T14:16:02.000Z | 2024-11-12T14:18:08.260Z |
5523508 | 5523508 | 20241111013817_mNrlK | UK0098 | 2024-11-12T14:15:50.280Z | 2024-11-12T14:18:08.227Z |
5523501 | 5523501 | 20241111013718_JJpxI | UK0098 | 2024-11-12T14:15:49.315Z | 2024-11-12T14:18:08.224Z |
5523433 | 5523433 | 20241111012225_9k7uR | UK0098 | 2024-11-12T14:15:36.564Z | 2024-11-12T14:18:08.193Z |
5523426 | 5523426 | 20241111012153_RWq4S | UK0098 | 2024-11-12T14:15:35.910Z | 2024-11-12T14:18:08.191Z |
5523192 | 5523192 | 20241111002835_8g3FJ | UK0098 | 2024-11-12T14:14:57.850Z | 2024-11-12T14:18:08.077Z |
5523158 | 5523158 | 20241111001735_hW33P | UK0098 | 2024-11-12T14:14:51.807Z | 2024-11-12T14:18:08.057Z |
5523118 | 5523118 | 20241111000629_bLoJ6 | UK0098 | 2024-11-12T14:14:46.493Z | 2024-11-12T14:18:08.038Z |
5523032 | 5523032 | 20241110234128_ArHtE | UK0098 | 2024-11-12T14:14:40.257Z | 2024-11-12T14:18:08.003Z |
5522997 | 5522997 | 20241110233012_ZMj8i | UK0098 | 2024-11-12T14:14:36.963Z | 2024-11-12T14:18:07.990Z |
5443041 | 5443041 | 20241030032224_0nbPx | UK0098 | 2024-11-01T12:20:16.326Z | 2024-11-07T14:26:49.291Z |
5442955 | 5442955 | 20241030030234_eHI08 | UK0098 | 2024-11-01T12:20:13.990Z | 2024-11-07T14:26:49.018Z |
5442943 | 5442943 | 20241030030017_sf7gM | UK0098 | 2024-11-01T12:20:13.435Z | 2024-11-07T14:26:48.995Z |
5442572 | 5442572 | 20241030015428_Xhofa | UK0098 | 2024-11-01T12:20:02.100Z | 2024-11-07T14:26:47.034Z |
5441776 | 5441776 | 20241029232911_HBR3L | UK0098 | 2024-11-01T12:19:01.514Z | 2024-11-07T14:26:43.227Z |
5441679 | 5441679 | 20241029231032_o2pwy | UK0098 | 2024-11-01T12:18:52.830Z | 2024-11-07T14:26:42.929Z |
5441580 | 5441580 | 20241029223915_Zaw2x | UK0098 | 2024-11-01T12:18:46.420Z | 2024-11-07T14:26:42.690Z |
5441515 | 5441515 | 20241029222823_kOgnn | UK0098 | 2024-11-01T12:18:42.200Z | 2024-11-07T14:26:42.543Z |
5441411 | 5441411 | 20241029220747_HrmT6 | UK0098 | 2024-11-01T12:18:32.831Z | 2024-11-07T14:26:42.013Z |
5441385 | 5441385 | 20241029215808_7ebEv | UK0098 | 2024-11-01T12:18:30.881Z | 2024-11-07T14:26:41.973Z |
5441369 | 5441369 | 20241029215406_P7DMX | UK0098 | 2024-11-01T12:18:30.141Z | 2024-11-07T14:26:41.926Z |
5441323 | 5441323 | 20241029214241_BjRJd | UK0098 | 2024-11-01T12:18:26.274Z | 2024-11-07T14:26:41.695Z |
5441264 | 5441264 | 20241029212256_Vo0R7 | UK0098 | 2024-11-01T12:18:21.969Z | 2024-11-07T14:26:41.416Z |
5441240 | 5441240 | 20241029211820_bMcvI | UK0098 | 2024-11-01T12:18:20.753Z | 2024-11-07T14:26:41.357Z |
5410737 | 5410737 | 20241027053323_lW3XN | UK0098 | 2024-10-29T12:18:03.825Z | 2024-11-04T14:29:05.370Z |
5410382 | 5410382 | 20241027051049_qXa2Z | UK0098 | 2024-10-29T12:17:54.954Z | 2024-11-04T14:29:04.490Z |
5410307 | 5410307 | 20241027050559_zwPaY | UK0098 | 2024-10-29T12:17:52.717Z | 2024-11-04T14:29:04.322Z |
5410283 | 5410283 | 20241027050522_HY2wU | UK0098 | 2024-10-29T12:17:52.317Z | 2024-11-04T14:29:04.281Z |
5410244 | 5410244 | 20241027050234_4umfj | UK0098 | 2024-10-29T12:17:51.307Z | 2024-11-04T14:29:04.239Z |
5409983 | 5409983 | 20241027044656_y5CLp | UK0098 | 2024-10-29T12:17:45.296Z | 2024-11-04T14:29:03.171Z |
5409931 | 5409931 | 20241027044239_eUWQD | UK0098 | 2024-10-29T12:17:44.176Z | 2024-11-04T14:29:02.941Z |
5409806 | 5409806 | 20241027043623_HzM20 | UK0098 | 2024-10-29T12:17:41.211Z | 2024-11-04T14:29:02.668Z |
5409757 | 5409757 | 20241027043416_YLCoo | UK0098 | 2024-10-29T12:17:40.250Z | 2024-11-04T14:29:02.617Z |
5409670 | 5409670 | 20241027042959_eyu1f | UK0098 | 2024-10-29T12:17:36.363Z | 2024-11-04T14:29:02.061Z |
5409653 | 5409653 | 20241027042926_KPwfA | UK0098 | 2024-10-29T12:17:36.160Z | 2024-11-04T14:29:02.054Z |
5409579 | 5409579 | 20241027042713_LUPXj | UK0098 | 2024-10-29T12:17:31.751Z | 2024-11-04T14:29:01.964Z |
5409561 | 5409561 | 20241027042427_Knc8I | UK0098 | 2024-10-29T12:17:30.271Z | 2024-11-04T14:29:01.954Z |
5409546 | 5409546 | 20241027042424_7NOBT | UK0098 | 2024-10-29T12:17:29.934Z | 2024-11-04T14:29:01.948Z |
5409507 | 5409507 | 20241027042230_ZaRyf | UK0098 | 2024-10-29T12:17:27.029Z | 2024-11-04T14:29:01.919Z |
5409502 | 5409502 | 20241027042223_B3g32 | UK0098 | 2024-10-29T12:17:26.938Z | 2024-11-04T14:29:01.916Z |
5409409 | 5409409 | 20241027041648_tdCRo | UK0098 | 2024-10-29T12:17:22.141Z | 2024-11-04T14:29:01.651Z |
5409286 | 5409286 | 20241027040919_Btn7I | UK0098 | 2024-10-29T12:17:14.814Z | 2024-11-04T14:29:01.490Z |
5409066 | 5409066 | 20241027035806_e0jiW | UK0098 | 2024-10-29T12:17:04.412Z | 2024-11-04T14:29:01.026Z |
5409049 | 5409049 | 20241027035731_Wv2qJ | UK0098 | 2024-10-29T12:17:03.496Z | 2024-11-04T14:29:00.998Z |
5409023 | 5409023 | 20241027035545_CacHo | UK0098 | 2024-10-29T12:17:01.736Z | 2024-11-04T14:29:00.940Z |
5409016 | 5409016 | 20241027035431_D2JLe | UK0098 | 2024-10-29T12:17:01.422Z | 2024-11-04T14:29:00.936Z |
5408958 | 5408958 | 20241027035107_0eFoe | UK0098 | 2024-10-29T12:16:58.101Z | 2024-11-04T14:29:00.868Z |
5408840 | 5408840 | 20241027034524_MdEft | UK0098 | 2024-10-29T12:16:54.655Z | 2024-11-04T14:29:00.616Z |
5408474 | 5408474 | 20241027032805_oUwqC | UK0098 | 2024-10-29T12:16:32.322Z | 2024-11-04T14:28:59.554Z |
5408405 | 5408405 | 20241027032534_834Qh | UK0098 | 2024-10-29T12:16:26.787Z | 2024-11-04T14:28:59.321Z |
5408329 | 5408329 | 20241027032217_473fM | UK0098 | 2024-10-29T12:16:23.244Z | 2024-11-04T14:28:59.179Z |
5408280 | 5408280 | 20241027032105_aDNOt | UK0098 | 2024-10-29T12:16:20.916Z | 2024-11-04T14:28:59.046Z |
5408042 | 5408042 | 20241027030420_ok4pg | UK0098 | 2024-10-29T12:16:01.879Z | 2024-11-04T14:28:58.740Z |
5408016 | 5408016 | 20241027030215_8dZrM | UK0098 | 2024-10-29T12:15:59.680Z | 2024-11-04T14:28:58.691Z |
5407925 | 5407925 | 20241027025823_t2lcI | UK0098 | 2024-10-29T12:15:53.598Z | 2024-11-04T14:28:58.412Z |
5407917 | 5407917 | 20241027025819_JBq2F | UK0098 | 2024-10-29T12:15:52.334Z | 2024-11-04T14:28:58.350Z |
5407814 | 5407814 | 20241027025321_OXV63 | UK0098 | 2024-10-29T12:15:44.351Z | 2024-11-04T14:28:58.170Z |
5407782 | 5407782 | 20241027025223_dKO1G | UK0098 | 2024-10-29T12:15:41.517Z | 2024-11-04T14:28:58.143Z |
5407773 | 5407773 | 20241027025204_lUWIS | UK0098 | 2024-10-29T12:15:40.168Z | 2024-11-04T14:28:58.140Z |
5407591 | 5407591 | 20241027024338_B4c2o | UK0098 | 2024-10-29T12:15:30.902Z | 2024-11-04T14:28:57.906Z |
5407557 | 5407557 | 20241027024201_XOabj | UK0098 | 2024-10-29T12:15:29.111Z | 2024-11-04T14:28:57.867Z |
5407490 | 5407490 | 20241027023847_h52k1 | UK0098 | 2024-10-29T12:15:26.761Z | 2024-11-04T14:28:57.768Z |
5407229 | 5407229 | 20241027022720_ekEnm | UK0098 | 2024-10-29T12:15:17.885Z | 2024-11-04T14:28:57.254Z |
5407140 | 5407140 | 20241027022333_pjlH1 | UK0098 | 2024-10-29T12:15:14.540Z | 2024-11-04T14:28:57.011Z |
5406340 | 5406340 | 20241027012911_aubvE | UK0098 | 2024-10-29T12:14:02.854Z | 2024-11-04T14:28:55.477Z |
5403630 | 5403630 | 20241026221838_IxpdU | UK0098 | 2024-10-29T12:10:03.126Z | 2024-11-04T14:28:49.363Z |
5403436 | 5403436 | 20241026215616_gM3Z8 | UK0098 | 2024-10-29T12:09:30.127Z | 2024-11-04T14:28:48.821Z |
5403277 | 5403277 | 20241026213540_6RNrh | UK0098 | 2024-10-29T12:09:18.338Z | 2024-11-04T14:28:48.259Z |
5403176 | 5403176 | 20241026212537_u5XAq | UK0098 | 2024-10-29T12:09:10.195Z | 2024-11-04T14:28:47.923Z |
5403135 | 5403135 | 20241026212212_20852 | UK0098 | 2024-10-29T12:09:03.615Z | 2024-11-04T14:28:47.797Z |
5402749 | 5402749 | 20241026201918_PXVF6 | UK0098 | 2024-10-29T12:08:04.947Z | 2024-11-04T14:28:46.433Z |
5402704 | 5402704 | 20241026201529_DEP2K | UK0098 | 2024-10-29T12:07:58.721Z | 2024-11-04T14:28:46.257Z |
5402388 | 5402388 | 20241026192525_OezW0 | UK0098 | 2024-10-29T12:07:07.723Z | 2024-11-04T14:28:44.172Z |
5402277 | 5402277 | 20241026190926_Fh2Md | UK0098 | 2024-10-29T12:06:52.216Z | 2024-11-04T14:28:43.594Z |
5402035 | 5402035 | 20241026183028_SDFAZ | UK0098 | 2024-10-29T12:06:07.381Z | 2024-11-04T14:28:41.749Z |
5402008 | 5402008 | 20241026182338_ydLlA | UK0098 | 2024-10-29T12:06:03.366Z | 2024-11-04T14:28:41.538Z |
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);