participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
669 rows where station_code = "UK00CH" 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 |
---|---|---|---|---|---|
5462168 | 5462168 | 20241101231513_0QhGQ | UK00CH | 2024-11-03T14:17:01.278Z | 2024-11-09T14:23:32.943Z |
5462134 | 5462134 | 20241101230807_dbdvC | UK00CH | 2024-11-03T14:16:58.865Z | 2024-11-09T14:23:32.581Z |
5410630 | 5410630 | 20241027052423_dD6oi | UK00CH | 2024-10-29T12:17:59.829Z | 2024-11-04T14:29:05.126Z |
5410618 | 5410618 | 20241027052324_C8RfW | UK00CH | 2024-10-29T12:17:59.573Z | 2024-11-04T14:29:05.099Z |
5410533 | 5410533 | 20241027051642_RUiax | UK00CH | 2024-10-29T12:17:57.618Z | 2024-11-04T14:29:04.734Z |
5410501 | 5410501 | 20241027051544_zFtsH | UK00CH | 2024-10-29T12:17:56.983Z | 2024-11-04T14:29:04.651Z |
5410206 | 5410206 | 20241027045939_2YCSm | UK00CH | 2024-10-29T12:17:50.640Z | 2024-11-04T14:29:04.040Z |
5410053 | 5410053 | 20241027044921_a0NsN | UK00CH | 2024-10-29T12:17:46.601Z | 2024-11-04T14:29:03.633Z |
5409479 | 5409479 | 20241027042008_j3uvR | UK00CH | 2024-10-29T12:17:25.662Z | 2024-11-04T14:29:01.853Z |
5408612 | 5408612 | 20241027033204_cQPv8 | UK00CH | 2024-10-29T12:16:39.109Z | 2024-11-04T14:28:59.674Z |
5408549 | 5408549 | 20241027033015_S6h1q | UK00CH | 2024-10-29T12:16:35.713Z | 2024-11-04T14:28:59.614Z |
5408442 | 5408442 | 20241027032712_IWPFD | UK00CH | 2024-10-29T12:16:29.522Z | 2024-11-04T14:28:59.407Z |
5408304 | 5408304 | 20241027032207_Qopv8 | UK00CH | 2024-10-29T12:16:21.841Z | 2024-11-04T14:28:59.069Z |
5408281 | 5408281 | 20241027032105_aDNOt | UK00CH | 2024-10-29T12:16:20.916Z | 2024-11-04T14:28:59.046Z |
5408267 | 5408267 | 20241027032005_7ZZ5U | UK00CH | 2024-10-29T12:16:20.248Z | 2024-11-04T14:28:59.040Z |
5407680 | 5407680 | 20241027024651_HAmtv | UK00CH | 2024-10-29T12:15:33.997Z | 2024-11-04T14:28:58.026Z |
5406525 | 5406525 | 20241027014237_CZ3Fi | UK00CH | 2024-10-29T12:14:17.407Z | 2024-11-04T14:28:55.822Z |
5404572 | 5404572 | 20241026233857_e3y63 | UK00CH | 2024-10-29T12:11:43.817Z | 2024-11-04T14:28:51.341Z |
5402311 | 5402311 | 20241026191456_5R3ez | UK00CH | 2024-10-29T12:06:58.376Z | 2024-11-04T14:28:43.688Z |
5401976 | 5401976 | 20241026181457_aC9Wg | UK00CH | 2024-10-29T12:05:57.221Z | 2024-11-04T14:28:41.177Z |
5401965 | 5401965 | 20241026181218_X4ZK6 | UK00CH | 2024-10-29T12:05:55.390Z | 2024-11-04T14:28:41.133Z |
5401963 | 5401963 | 20241026181210_XZPqg | UK00CH | 2024-10-29T12:05:54.992Z | 2024-11-04T14:28:41.121Z |
5399327 | 5399327 | 20241026041019_VVEFi | UK00CH | 2024-10-28T12:19:54.718Z | 2024-11-03T14:27:39.448Z |
5398940 | 5398940 | 20241026033936_W3sJg | UK00CH | 2024-10-28T12:19:40.644Z | 2024-11-03T14:27:38.663Z |
5398728 | 5398728 | 20241026032150_7NVzB | UK00CH | 2024-10-28T12:19:29.672Z | 2024-11-03T14:27:37.899Z |
5396536 | 5396536 | 20241026000955_0KhG3 | UK00CH | 2024-10-28T12:17:48.938Z | 2024-11-03T14:27:30.157Z |
5395873 | 5395873 | 20241025231656_HM7e3 | UK00CH | 2024-10-28T12:17:02.129Z | 2024-11-03T14:27:27.445Z |
5395596 | 5395596 | 20241025225743_SQKAS | UK00CH | 2024-10-28T12:16:30.636Z | 2024-11-03T14:27:26.084Z |
5395341 | 5395341 | 20241025223350_fUqTD | UK00CH | 2024-10-28T12:16:09.981Z | 2024-11-03T14:27:25.154Z |
5395285 | 5395285 | 20241025222924_jrEqm | UK00CH | 2024-10-28T12:16:04.448Z | 2024-11-03T14:27:24.575Z |
5384951 | 5384951 | 20241024212057_UR2Q4 | UK00CH | 2024-10-27T12:18:02.604Z | 2024-11-02T12:28:28.778Z |
5384847 | 5384847 | 20241024210324_0pQ2Q | UK00CH | 2024-10-27T12:17:49.466Z | 2024-11-02T12:28:28.456Z |
5383436 | 5383436 | 20241024182103_raDWA | UK00CH | 2024-10-27T12:15:27.478Z | 2024-11-02T12:28:25.308Z |
5377311 | 5377311 | 20241024044311_yabLv | UK00CH | 2024-10-26T12:22:33.629Z | 2024-11-01T12:27:02.357Z |
5376344 | 5376344 | 20241024035152_wesRX | UK00CH | 2024-10-26T12:21:58.170Z | 2024-11-01T12:27:01.505Z |
5374437 | 5374437 | 20241024022649_6CLTw | UK00CH | 2024-10-26T12:20:48.459Z | 2024-11-01T12:26:59.366Z |
5374346 | 5374346 | 20241024022310_jJ1Fx | UK00CH | 2024-10-26T12:20:45.600Z | 2024-11-01T12:26:58.853Z |
5371921 | 5371921 | 20241024002326_vhYNi | UK00CH | 2024-10-26T12:18:58.142Z | 2024-11-01T12:26:57.000Z |
5366330 | 5366330 | 20241024001619_G22Wg | UK00CH | 2024-10-25T12:18:23.419Z | 2024-11-01T12:26:56.872Z |
5366249 | 5366249 | 20241024001039_Skxjt | UK00CH | 2024-10-25T12:18:19.877Z | 2024-11-01T12:26:56.819Z |
5366241 | 5366241 | 20241024001003_5c7Rn | UK00CH | 2024-10-25T12:18:19.784Z | 2024-11-01T12:26:56.815Z |
5366040 | 5366040 | 20241024000215_5XyOC | UK00CH | 2024-10-25T12:18:14.957Z | 2024-11-01T12:26:56.550Z |
5365144 | 5365144 | 20241023231628_o67Ak | UK00CH | 2024-10-25T12:17:47.442Z | 2024-11-01T12:26:55.891Z |
5365074 | 5365074 | 20241023231209_4HC1j | UK00CH | 2024-10-25T12:17:44.952Z | 2024-11-01T12:26:55.848Z |
5364571 | 5364571 | 20241023223829_Q3TOu | UK00CH | 2024-10-25T12:17:25.075Z | 2024-11-01T12:26:55.221Z |
5364407 | 5364407 | 20241023222624_1OVvW | UK00CH | 2024-10-25T12:17:19.771Z | 2024-11-01T12:26:55.042Z |
5364312 | 5364312 | 20241023222008_HWaSf | UK00CH | 2024-10-25T12:17:16.239Z | 2024-11-01T12:26:54.665Z |
5363638 | 5363638 | 20241023212918_83DBZ | UK00CH | 2024-10-25T12:16:30.666Z | 2024-11-01T12:26:53.474Z |
5363624 | 5363624 | 20241023212822_0pzHN | UK00CH | 2024-10-25T12:16:28.680Z | 2024-11-01T12:26:53.470Z |
5363530 | 5363530 | 20241023211640_z6uzg | UK00CH | 2024-10-25T12:16:20.305Z | 2024-11-01T12:26:53.349Z |
5363269 | 5363269 | 20241023204044_aP4ZA | UK00CH | 2024-10-25T12:15:49.121Z | 2024-11-01T12:26:53.011Z |
5362692 | 5362692 | 20241023195432_3O64H | UK00CH | 2024-10-25T12:15:01.904Z | 2024-11-01T12:26:52.269Z |
5362579 | 5362579 | 20241023194401_7Su2p | UK00CH | 2024-10-25T12:14:46.198Z | 2024-11-01T12:26:52.051Z |
5362241 | 5362241 | 20241023192041_sxBEu | UK00CH | 2024-10-25T12:14:03.480Z | 2024-11-01T12:26:51.138Z |
5362145 | 5362145 | 20241023191132_WW2cI | UK00CH | 2024-10-25T12:13:56.267Z | 2024-11-01T12:26:51.041Z |
5356291 | 5356291 | 20241023053100_PsK4t | UK00CH | 2024-10-24T12:21:56.997Z | 2024-10-31T12:30:11.240Z |
5356283 | 5356283 | 20241023052916_399lk | UK00CH | 2024-10-24T12:21:56.965Z | 2024-10-31T12:30:11.214Z |
5356239 | 5356239 | 20241023052346_LchvF | UK00CH | 2024-10-24T12:21:56.562Z | 2024-10-31T12:30:11.158Z |
5356205 | 5356205 | 20241023051608_J9FoR | UK00CH | 2024-10-24T12:21:55.653Z | 2024-10-31T12:30:10.859Z |
5356185 | 5356185 | 20241023051233_RG0XD | UK00CH | 2024-10-24T12:21:55.036Z | 2024-10-31T12:30:10.772Z |
5356172 | 5356172 | 20241023051148_25S1P | UK00CH | 2024-10-24T12:21:54.913Z | 2024-10-31T12:30:10.740Z |
5355983 | 5355983 | 20241023044643_7xbMl | UK00CH | 2024-10-24T12:21:45.662Z | 2024-10-31T12:30:09.446Z |
5355947 | 5355947 | 20241023044339_7NBr5 | UK00CH | 2024-10-24T12:21:44.080Z | 2024-10-31T12:30:09.350Z |
5355925 | 5355925 | 20241023043709_8CcMs | UK00CH | 2024-10-24T12:21:42.331Z | 2024-10-31T12:30:09.207Z |
5355893 | 5355893 | 20241023043319_74AsB | UK00CH | 2024-10-24T12:21:41.257Z | 2024-10-31T12:30:09.150Z |
5353481 | 5353481 | 20241023012731_zkWg1 | UK00CH | 2024-10-24T12:19:43.968Z | 2024-10-31T12:30:04.289Z |
5353423 | 5353423 | 20241023012522_753ZA | UK00CH | 2024-10-24T12:19:42.461Z | 2024-10-31T12:30:04.240Z |
5352958 | 5352958 | 20241023005801_32Eg7 | UK00CH | 2024-10-24T12:19:27.732Z | 2024-10-31T12:30:03.577Z |
5352695 | 5352695 | 20241023004424_E0x3o | UK00CH | 2024-10-24T12:19:05.550Z | 2024-10-31T12:30:03.149Z |
5352687 | 5352687 | 20241023004356_79B1F | UK00CH | 2024-10-24T12:19:05.232Z | 2024-10-31T12:30:03.144Z |
5352639 | 5352639 | 20241023004215_xQqDG | UK00CH | 2024-10-24T12:19:02.154Z | 2024-10-31T12:30:03.009Z |
5352556 | 5352556 | 20241023003838_4FTes | UK00CH | 2024-10-24T12:18:56.915Z | 2024-10-31T12:30:02.883Z |
5352191 | 5352191 | 20241023001644_CLdav | UK00CH | 2024-10-24T12:18:29.419Z | 2024-10-31T12:30:02.281Z |
5352060 | 5352060 | 20241023000804_UsE2d | UK00CH | 2024-10-24T12:18:17.904Z | 2024-10-31T12:30:01.725Z |
5351889 | 5351889 | 20241022235725_KBkTj | UK00CH | 2024-10-24T12:18:07.469Z | 2024-10-31T12:30:01.179Z |
5351518 | 5351518 | 20241022233500_A3AS2 | UK00CH | 2024-10-24T12:17:37.688Z | 2024-10-31T12:30:00.489Z |
5351476 | 5351476 | 20241022233128_IIhgF | UK00CH | 2024-10-24T12:17:34.036Z | 2024-10-31T12:30:00.436Z |
5351289 | 5351289 | 20241022231325_YEZlO | UK00CH | 2024-10-24T12:17:24.163Z | 2024-10-31T12:29:59.747Z |
5350898 | 5350898 | 20241022223852_aXm2X | UK00CH | 2024-10-24T12:16:45.678Z | 2024-10-31T12:29:58.995Z |
5350847 | 5350847 | 20241022223309_DGhEa | UK00CH | 2024-10-24T12:16:41.551Z | 2024-10-31T12:29:58.848Z |
5350407 | 5350407 | 20241022214305_tRICp | UK00CH | 2024-10-24T12:15:42.259Z | 2024-10-31T12:29:58.130Z |
5350145 | 5350145 | 20241022211610_kIL1X | UK00CH | 2024-10-24T12:15:24.280Z | 2024-10-31T12:29:57.374Z |
5350040 | 5350040 | 20241022210424_iqvo2 | UK00CH | 2024-10-24T12:15:08.499Z | 2024-10-31T12:29:57.215Z |
5349806 | 5349806 | 20241022203624_2e3oC | UK00CH | 2024-10-24T12:14:39.366Z | 2024-10-31T12:29:56.544Z |
5349734 | 5349734 | 20241022203049_BBkkZ | UK00CH | 2024-10-24T12:14:33.713Z | 2024-10-31T12:29:56.197Z |
5349568 | 5349568 | 20241022201243_kzxkg | UK00CH | 2024-10-24T12:13:58.610Z | 2024-10-31T12:29:55.823Z |
5348773 | 5348773 | 20241022185753_vQUl9 | UK00CH | 2024-10-24T12:12:18.236Z | 2024-10-31T12:29:53.768Z |
5348402 | 5348402 | 20241022181438_oi2vj | UK00CH | 2024-10-24T12:11:20.941Z | 2024-10-31T12:29:52.375Z |
5345285 | 5345285 | 20241022053216_61O9M | UK00CH | 2024-10-23T12:19:13.011Z | 2024-10-30T12:26:52.393Z |
5345276 | 5345276 | 20241022053136_60wsu | UK00CH | 2024-10-23T12:19:12.789Z | 2024-10-30T12:26:52.379Z |
5345202 | 5345202 | 20241022052427_FU2OR | UK00CH | 2024-10-23T12:19:10.418Z | 2024-10-30T12:26:52.292Z |
5345194 | 5345194 | 20241022052218_12oa1 | UK00CH | 2024-10-23T12:19:09.803Z | 2024-10-30T12:26:52.285Z |
5344150 | 5344150 | 20241022040840_9eKjZ | UK00CH | 2024-10-23T12:18:26.227Z | 2024-10-30T12:26:50.966Z |
5342603 | 5342603 | 20241022023553_znDlc | UK00CH | 2024-10-23T12:17:07.291Z | 2024-10-30T12:26:48.708Z |
5340377 | 5340377 | 20241022000844_U1aBq | UK00CH | 2024-10-23T12:14:30.077Z | 2024-10-30T12:26:45.700Z |
5338283 | 5338283 | 20241021190618_CFCRO | UK00CH | 2024-10-23T12:10:37.798Z | 2024-10-30T12:26:42.107Z |
5338127 | 5338127 | 20241021184314_WNPQr | UK00CH | 2024-10-23T12:10:19.682Z | 2024-10-30T12:26:41.744Z |
5338041 | 5338041 | 20241021182435_NvvBz | UK00CH | 2024-10-23T12:09:56.989Z | 2024-10-30T12:26:41.301Z |
5332904 | 5332904 | 20241020230230_uq5gT | UK00CH | 2024-10-22T12:14:27.024Z | 2024-10-29T12:26:33.946Z |
5332772 | 5332772 | 20241020222316_jvLpC | UK00CH | 2024-10-22T12:14:18.960Z | 2024-10-29T12:26:33.817Z |
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);