participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,015 rows where station_code = "UK0096" 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 |
---|---|---|---|---|---|
5573260 | 5573260 | 20241121041654_y38K2 | UK0096 | 2024-11-22T14:19:18.754Z | 2024-11-22T14:19:22.478Z |
5573206 | 5573206 | 20241121040826_Ryu6D | UK0096 | 2024-11-22T14:19:15.739Z | 2024-11-22T14:19:22.469Z |
5573128 | 5573128 | 20241121035559_2Vjz2 | UK0096 | 2024-11-22T14:19:11.232Z | 2024-11-22T14:19:22.455Z |
5572840 | 5572840 | 20241121031508_gieeP | UK0096 | 2024-11-22T14:18:52.859Z | 2024-11-22T14:19:22.400Z |
5572836 | 5572836 | 20241121031434_nsHMg | UK0096 | 2024-11-22T14:18:52.736Z | 2024-11-22T14:19:22.399Z |
5572741 | 5572741 | 20241121030409_hjZiI | UK0096 | 2024-11-22T14:18:47.035Z | 2024-11-22T14:19:22.384Z |
5572604 | 5572604 | 20241121024834_HajjP | UK0096 | 2024-11-22T14:18:39.286Z | 2024-11-22T14:19:22.361Z |
5572582 | 5572582 | 20241121024427_D7nLd | UK0096 | 2024-11-22T14:18:38.031Z | 2024-11-22T14:19:22.356Z |
5571304 | 5571304 | 20241120231820_Tcv30 | UK0096 | 2024-11-22T14:16:49.738Z | 2024-11-22T14:19:22.096Z |
5571135 | 5571135 | 20241120223240_xYVpl | UK0096 | 2024-11-22T14:16:28.783Z | 2024-11-22T14:19:22.049Z |
5571067 | 5571067 | 20241120221123_xGYPW | UK0096 | 2024-11-22T14:16:21.081Z | 2024-11-22T14:19:22.034Z |
5571058 | 5571058 | 20241120220624_alzdz | UK0096 | 2024-11-22T14:16:20.338Z | 2024-11-22T14:19:22.031Z |
5570954 | 5570954 | 20241120214342_IiVTg | UK0096 | 2024-11-22T14:16:14.121Z | 2024-11-22T14:19:22.013Z |
5570842 | 5570842 | 20241120211255_t2KtP | UK0096 | 2024-11-22T14:16:08.703Z | 2024-11-22T14:19:21.992Z |
5570839 | 5570839 | 20241120211249_lq280 | UK0096 | 2024-11-22T14:16:08.522Z | 2024-11-22T14:19:21.991Z |
5570818 | 5570818 | 20241120210618_H36qV | UK0096 | 2024-11-22T14:16:06.978Z | 2024-11-22T14:19:21.987Z |
5570530 | 5570530 | 20241120195640_oZys4 | UK0096 | 2024-11-22T14:15:41.056Z | 2024-11-22T14:19:21.932Z |
5570491 | 5570491 | 20241120194803_Ch3zf | UK0096 | 2024-11-22T14:15:36.785Z | 2024-11-22T14:19:21.926Z |
5570451 | 5570451 | 20241120194141_QqCVB | UK0096 | 2024-11-22T14:15:27.390Z | 2024-11-22T14:19:21.919Z |
5570423 | 5570423 | 20241120193528_GS8Cc | UK0096 | 2024-11-22T14:15:23.127Z | 2024-11-22T14:19:21.915Z |
5570365 | 5570365 | 20241120192348_XuPs8 | UK0096 | 2024-11-22T14:15:14.868Z | 2024-11-22T14:19:21.904Z |
5570234 | 5570234 | 20241120190727_ZBeAY | UK0096 | 2024-11-22T14:15:03.283Z | 2024-11-22T14:19:21.885Z |
5566567 | 5566567 | 20241121064408_hqyzk | UK0096 | 2024-11-22T14:03:11.955Z | 2024-11-22T14:03:11.955Z |
5566466 | 5566466 | 20241121061639_X12AV | UK0096 | 2024-11-22T14:02:57.080Z | 2024-11-22T14:02:57.080Z |
5566346 | 5566346 | 20241121060245_naT6W | UK0096 | 2024-11-22T14:02:30.026Z | 2024-11-22T14:02:30.026Z |
5566308 | 5566308 | 20241121055837_2iYHw | UK0096 | 2024-11-22T14:02:24.850Z | 2024-11-22T14:02:24.850Z |
5566013 | 5566013 | 20241121051710_QRhrk | UK0096 | 2024-11-22T14:01:34.177Z | 2024-11-22T14:01:34.177Z |
5565867 | 5565867 | 20241121045704_G2tAW | UK0096 | 2024-11-22T14:01:14.491Z | 2024-11-22T14:01:14.491Z |
5565815 | 5565815 | 20241121045042_m51no | UK0096 | 2024-11-22T14:01:00.781Z | 2024-11-22T14:01:00.781Z |
5565800 | 5565800 | 20241121044843_iD5pr | UK0096 | 2024-11-22T14:00:59.227Z | 2024-11-22T14:00:59.227Z |
5565564 | 5565564 | 20241121042305_32Jao | UK0096 | 2024-11-22T14:00:18.615Z | 2024-11-22T14:00:18.615Z |
5565523 | 5565523 | 20241121041849_uzdts | UK0096 | 2024-11-22T14:00:10.720Z | 2024-11-22T14:00:10.720Z |
5564474 | 5564474 | 20241120025913_nSexN | UK0096 | 2024-11-21T14:17:39.629Z | 2024-11-22T14:21:32.609Z |
5564388 | 5564388 | 20241120025211_H2aAq | UK0096 | 2024-11-21T14:17:31.963Z | 2024-11-22T14:21:31.100Z |
5564363 | 5564363 | 20241120024942_tMJuz | UK0096 | 2024-11-21T14:17:30.730Z | 2024-11-22T14:21:30.864Z |
5564262 | 5564262 | 20241120024303_Dnjsr | UK0096 | 2024-11-21T14:17:22.687Z | 2024-11-22T14:21:29.586Z |
5564098 | 5564098 | 20241120022833_sBY62 | UK0096 | 2024-11-21T14:17:08.830Z | 2024-11-22T14:21:26.907Z |
5563742 | 5563742 | 20241120020036_t0d4U | UK0096 | 2024-11-21T14:16:37.761Z | 2024-11-22T14:21:21.565Z |
5563558 | 5563558 | 20241120014152_5t7Ly | UK0096 | 2024-11-21T14:16:18.956Z | 2024-11-22T14:21:18.461Z |
5563547 | 5563547 | 20241120014006_UH3Xa | UK0096 | 2024-11-21T14:16:16.800Z | 2024-11-22T14:21:17.893Z |
5563451 | 5563451 | 20241120013114_JVMNY | UK0096 | 2024-11-21T14:16:07.113Z | 2024-11-22T14:21:15.791Z |
5563446 | 5563446 | 20241120013102_xXW1g | UK0096 | 2024-11-21T14:16:06.967Z | 2024-11-22T14:21:15.782Z |
5563434 | 5563434 | 20241120012944_m541u | UK0096 | 2024-11-21T14:16:06.396Z | 2024-11-22T14:21:15.557Z |
5563382 | 5563382 | 20241120012346_aBu72 | UK0096 | 2024-11-21T14:16:01.609Z | 2024-11-22T14:21:14.789Z |
5563131 | 5563131 | 20241120005526_CAZr3 | UK0096 | 2024-11-21T14:15:37.681Z | 2024-11-22T14:21:09.902Z |
5563084 | 5563084 | 20241120005003_2mzab | UK0096 | 2024-11-21T14:15:35.203Z | 2024-11-22T14:21:09.346Z |
5563018 | 5563018 | 20241120004349_g2opd | UK0096 | 2024-11-21T14:15:31.977Z | 2024-11-22T14:21:07.837Z |
5563009 | 5563009 | 20241120003949_HiF2c | UK0096 | 2024-11-21T14:15:31.659Z | 2024-11-22T14:21:07.754Z |
5562998 | 5562998 | 20241120003918_6oeFp | UK0096 | 2024-11-21T14:15:31.396Z | 2024-11-22T14:21:07.657Z |
5562931 | 5562931 | 20241120002910_it7me | UK0096 | 2024-11-21T14:15:27.879Z | 2024-11-22T14:21:06.157Z |
5562823 | 5562823 | 20241120001543_mIVwQ | UK0096 | 2024-11-21T14:15:23.867Z | 2024-11-22T14:21:05.126Z |
5562772 | 5562772 | 20241120001057_GHfxz | UK0096 | 2024-11-21T14:15:21.084Z | 2024-11-22T14:21:03.763Z |
5562714 | 5562714 | 20241120000516_7dTHc | UK0096 | 2024-11-21T14:15:17.899Z | 2024-11-22T14:21:02.794Z |
5562642 | 5562642 | 20241120000111_lPp3g | UK0096 | 2024-11-21T14:15:15.094Z | 2024-11-22T14:21:01.644Z |
5562613 | 5562613 | 20241119235512_6Y3a6 | UK0096 | 2024-11-21T14:15:13.642Z | 2024-11-22T14:21:00.907Z |
5561458 | 5561458 | 20241119203819_IeHrb | UK0096 | 2024-11-21T14:13:18.713Z | 2024-11-22T14:20:37.398Z |
5561193 | 5561193 | 20241119185911_INNYS | UK0096 | 2024-11-21T14:12:35.057Z | 2024-11-22T14:20:25.432Z |
5561191 | 5561191 | 20241119185743_ZWWUH | UK0096 | 2024-11-21T14:12:34.833Z | 2024-11-22T14:20:25.247Z |
5561188 | 5561188 | 20241119185420_QZARl | UK0096 | 2024-11-21T14:12:34.576Z | 2024-11-22T14:20:25.125Z |
5561180 | 5561180 | 20241119185340_gYcbC | UK0096 | 2024-11-21T14:12:33.652Z | 2024-11-22T14:20:24.545Z |
5561154 | 5561154 | 20241119184321_QbzeE | UK0096 | 2024-11-21T14:12:30.379Z | 2024-11-22T14:20:23.334Z |
5561130 | 5561130 | 20241119182550_BYhqw | UK0096 | 2024-11-21T14:12:26.753Z | 2024-11-22T14:20:21.760Z |
5561097 | 5561097 | 20241119181041_0bWZB | UK0096 | 2024-11-21T14:12:22.735Z | 2024-11-22T14:20:20.349Z |
5561069 | 5561069 | 20241119174658_ob9km | UK0096 | 2024-11-21T14:12:18.311Z | 2024-11-22T14:20:17.875Z |
5561059 | 5561059 | 20241119174004_rJ8eI | UK0096 | 2024-11-21T14:12:16.953Z | 2024-11-22T14:20:17.472Z |
5558553 | 5558553 | 20241120062814_tB1y9 | UK0096 | 2024-11-21T14:03:37.516Z | 2024-11-22T14:19:21.250Z |
5557495 | 5557495 | 20241120045144_AVxjP | UK0096 | 2024-11-21T14:01:00.971Z | 2024-11-22T14:19:21.079Z |
5557285 | 5557285 | 20241120043343_2dc4O | UK0096 | 2024-11-21T14:00:22.547Z | 2024-11-22T14:19:21.047Z |
5553889 | 5553889 | 20241118044232_BONTC | UK0096 | 2024-11-19T14:11:31.653Z | 2024-11-22T14:22:57.076Z |
5553868 | 5553868 | 20241118043518_fLfDz | UK0096 | 2024-11-19T14:11:30.660Z | 2024-11-22T14:22:56.580Z |
5553860 | 5553860 | 20241118043407_Ffo06 | UK0096 | 2024-11-19T14:11:30.297Z | 2024-11-22T14:22:56.573Z |
5553815 | 5553815 | 20241118042630_1jKFE | UK0096 | 2024-11-19T14:11:28.193Z | 2024-11-22T14:22:56.410Z |
5553770 | 5553770 | 20241118041316_6gcbT | UK0096 | 2024-11-19T14:11:25.533Z | 2024-11-22T14:22:56.084Z |
5553737 | 5553737 | 20241118040534_ynRXr | UK0096 | 2024-11-19T14:11:23.499Z | 2024-11-22T14:22:55.935Z |
5553701 | 5553701 | 20241118035403_GAmQQ | UK0096 | 2024-11-19T14:11:18.101Z | 2024-11-22T14:22:55.431Z |
5553696 | 5553696 | 20241118035358_ATYeW | UK0096 | 2024-11-19T14:11:17.446Z | 2024-11-22T14:22:55.399Z |
5553575 | 5553575 | 20241118032152_LbeaL | UK0096 | 2024-11-19T14:10:56.832Z | 2024-11-22T14:22:54.368Z |
5553425 | 5553425 | 20241118023023_1xp90 | UK0096 | 2024-11-19T14:10:33.331Z | 2024-11-22T14:22:53.145Z |
5553412 | 5553412 | 20241118022837_mv2Of | UK0096 | 2024-11-19T14:10:30.787Z | 2024-11-22T14:22:53.046Z |
5553335 | 5553335 | 20241118020617_ujWsh | UK0096 | 2024-11-19T14:10:19.934Z | 2024-11-22T14:22:52.324Z |
5553316 | 5553316 | 20241118020211_1sep2 | UK0096 | 2024-11-19T14:10:17.430Z | 2024-11-22T14:22:51.971Z |
5553311 | 5553311 | 20241118020147_im39n | UK0096 | 2024-11-19T14:10:16.531Z | 2024-11-22T14:22:51.854Z |
5553296 | 5553296 | 20241118015914_JmZoQ | UK0096 | 2024-11-19T14:10:15.398Z | 2024-11-22T14:22:51.753Z |
5553274 | 5553274 | 20241118015522_0SJFV | UK0096 | 2024-11-19T14:10:14.256Z | 2024-11-22T14:22:51.645Z |
5553196 | 5553196 | 20241118013017_PfBFA | UK0096 | 2024-11-19T14:10:08.899Z | 2024-11-22T14:22:51.012Z |
5553180 | 5553180 | 20241118012144_C6KlY | UK0096 | 2024-11-19T14:10:08.301Z | 2024-11-22T14:22:50.960Z |
5553177 | 5553177 | 20241118012142_es6pB | UK0096 | 2024-11-19T14:10:08.197Z | 2024-11-22T14:22:50.956Z |
5553170 | 5553170 | 20241118011725_Mcdj8 | UK0096 | 2024-11-19T14:10:07.668Z | 2024-11-22T14:22:50.942Z |
5553149 | 5553149 | 20241118010625_rLBMy | UK0096 | 2024-11-19T14:10:06.319Z | 2024-11-22T14:22:50.802Z |
5553145 | 5553145 | 20241118010228_p3wzD | UK0096 | 2024-11-19T14:10:05.959Z | 2024-11-22T14:22:50.762Z |
5553109 | 5553109 | 20241118004439_m8Jjm | UK0096 | 2024-11-19T14:10:03.798Z | 2024-11-22T14:22:50.575Z |
5553097 | 5553097 | 20241118004116_yYjDy | UK0096 | 2024-11-19T14:10:02.979Z | 2024-11-22T14:22:50.453Z |
5553095 | 5553095 | 20241118003955_8mq7C | UK0096 | 2024-11-19T14:10:02.894Z | 2024-11-22T14:22:50.450Z |
5553066 | 5553066 | 20241118003613_OhOSA | UK0096 | 2024-11-19T14:10:01.151Z | 2024-11-22T14:22:50.317Z |
5553048 | 5553048 | 20241118002905_WZfPF | UK0096 | 2024-11-19T14:09:59.205Z | 2024-11-22T14:22:49.997Z |
5552921 | 5552921 | 20241117232834_h5Ls6 | UK0096 | 2024-11-19T14:09:47.601Z | 2024-11-22T14:22:49.189Z |
5549665 | 5549665 | 20241118055503_ut763 | UK0096 | 2024-11-19T14:00:31.886Z | 2024-11-22T14:21:51.053Z |
5549628 | 5549628 | 20241118054447_ZWqLm | UK0096 | 2024-11-19T14:00:27.612Z | 2024-11-22T14:21:50.889Z |
5549625 | 5549625 | 20241118054250_cGmCI | UK0096 | 2024-11-19T14:00:26.914Z | 2024-11-22T14:21:50.808Z |
5549621 | 5549621 | 20241118054148_PVq8b | UK0096 | 2024-11-19T14:00:26.467Z | 2024-11-22T14:21:50.779Z |
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);