participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
392 rows where station_code = "UK000B" 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 |
---|---|---|---|---|---|
5133565 | 5133565 | 20240916034127_1SyHF | UK000B | 2024-09-19T12:17:01.994Z | 2024-09-19T12:17:01.994Z |
5132709 | 5132709 | 20240916020058_r38fV | UK000B | 2024-09-19T12:16:29.051Z | 2024-09-19T12:16:29.051Z |
5132398 | 5132398 | 20240916010127_5yF2n | UK000B | 2024-09-19T12:16:10.979Z | 2024-09-19T12:16:10.979Z |
5132274 | 5132274 | 20240916001615_TdV7H | UK000B | 2024-09-19T12:16:02.860Z | 2024-09-19T12:16:02.860Z |
5131972 | 5131972 | 20240915222635_1LSCq | UK000B | 2024-09-19T12:15:39.164Z | 2024-09-19T12:15:39.164Z |
5131636 | 5131636 | 20240915203900_KiMRx | UK000B | 2024-09-19T12:15:12.554Z | 2024-09-19T12:15:12.554Z |
5131449 | 5131449 | 20240915195639_iNvFO | UK000B | 2024-09-19T12:15:04.287Z | 2024-09-19T12:15:04.287Z |
5129417 | 5129417 | 20240917035526_hH3pZ | UK000B | 2024-09-19T12:11:35.425Z | 2024-09-19T12:11:35.425Z |
5129367 | 5129367 | 20240917035446_buuW3 | UK000B | 2024-09-19T12:11:33.792Z | 2024-09-19T12:11:33.792Z |
5128921 | 5128921 | 20240917025428_WBORR | UK000B | 2024-09-19T12:11:07.496Z | 2024-09-19T12:11:07.496Z |
5128810 | 5128810 | 20240917024351_kv0kn | UK000B | 2024-09-19T12:11:02.928Z | 2024-09-19T12:11:02.928Z |
5128631 | 5128631 | 20240917021406_2X4bG | UK000B | 2024-09-19T12:10:49.362Z | 2024-09-19T12:10:49.362Z |
5111996 | 5111996 | 20240914215058_NdqT0 | UK000B | 2024-09-18T12:02:36.429Z | 2024-09-19T12:18:36.290Z |
5107858 | 5107858 | 20240913041241_AfvpN | UK000B | 2024-09-17T12:13:24.976Z | 2024-09-19T12:20:47.611Z |
5106338 | 5106338 | 20240913032010_bN9o4 | UK000B | 2024-09-17T12:12:50.691Z | 2024-09-19T12:20:45.962Z |
5105975 | 5105975 | 20240913030454_c947D | UK000B | 2024-09-17T12:12:34.701Z | 2024-09-19T12:20:45.092Z |
5105137 | 5105137 | 20240913023158_4teot | UK000B | 2024-09-17T12:11:57.573Z | 2024-09-19T12:20:43.745Z |
5097174 | 5097174 | 20240913003500_xppio | UK000B | 2024-09-16T12:17:07.206Z | 2024-09-19T12:20:37.811Z |
5093521 | 5093521 | 20240912032438_T8TH2 | UK000B | 2024-09-16T12:14:19.377Z | 2024-09-19T12:21:15.391Z |
5089984 | 5089984 | 20240912010539_bdaqx | UK000B | 2024-09-16T12:11:53.414Z | 2024-09-19T12:21:10.895Z |
5088500 | 5088500 | 20240913001330_duW02 | UK000B | 2024-09-16T12:08:06.449Z | 2024-09-19T12:20:36.968Z |
5080467 | 5080467 | 20240911040108_Opapd | UK000B | 2024-09-15T12:17:04.453Z | 2024-09-19T12:21:43.297Z |
5079964 | 5079964 | 20240911032236_E0xow | UK000B | 2024-09-15T12:16:42.888Z | 2024-09-19T12:21:42.914Z |
5079612 | 5079612 | 20240911030614_MYF3x | UK000B | 2024-09-15T12:16:29.854Z | 2024-09-19T12:21:42.497Z |
5079056 | 5079056 | 20240911023019_HNvXb | UK000B | 2024-09-15T12:16:03.372Z | 2024-09-19T12:21:41.047Z |
5078653 | 5078653 | 20240911020925_Mr70x | UK000B | 2024-09-15T12:15:48.181Z | 2024-09-19T12:21:40.651Z |
5078520 | 5078520 | 20240911020248_terIh | UK000B | 2024-09-15T12:15:42.132Z | 2024-09-19T12:21:40.480Z |
5077171 | 5077171 | 20240911002937_aR5h8 | UK000B | 2024-09-15T12:14:27.027Z | 2024-09-19T12:21:38.311Z |
5072918 | 5072918 | 20240911204756_cEKiE | UK000B | 2024-09-15T12:06:17.803Z | 2024-09-19T12:21:04.913Z |
5069285 | 5069285 | 20240910212742_jMYKs | UK000B | 2024-09-14T12:19:53.154Z | 2024-09-19T12:21:34.424Z |
5069274 | 5069274 | 20240910212519_XIKeR | UK000B | 2024-09-14T12:19:52.030Z | 2024-09-19T12:21:34.407Z |
4998574 | 4998574 | 20240903031939_V39yZ | UK000B | 2024-09-08T12:07:53.437Z | 2024-09-11T12:21:13.656Z |
4991818 | 4991818 | 20240901032143_2E0rY | UK000B | 2024-09-07T12:12:30.953Z | 2024-09-09T12:27:23.002Z |
4991767 | 4991767 | 20240901031013_Wb4TS | UK000B | 2024-09-07T12:12:28.488Z | 2024-09-09T12:27:19.030Z |
4991529 | 4991529 | 20240901024340_khIBx | UK000B | 2024-09-07T12:12:08.246Z | 2024-09-09T12:27:11.869Z |
4991205 | 4991205 | 20240901020813_fudVo | UK000B | 2024-09-07T12:11:43.484Z | 2024-09-09T12:27:02.465Z |
4991140 | 4991140 | 20240901020150_vSGtW | UK000B | 2024-09-07T12:11:36.413Z | 2024-09-09T12:27:00.964Z |
4991035 | 4991035 | 20240901015118_fE2nr | UK000B | 2024-09-07T12:11:31.086Z | 2024-09-09T12:26:58.576Z |
4989930 | 4989930 | 20240831230144_gFyHk | UK000B | 2024-09-07T12:09:49.468Z | 2024-09-09T12:26:06.412Z |
4976517 | 4976517 | 20240811233114_VcW2X | UK000B | 2024-09-06T12:11:35.167Z | 2024-09-06T12:11:35.167Z |
4969501 | 4969501 | 20240811221227_FAgHu | UK000B | 2024-09-05T12:08:46.799Z | 2024-09-06T12:07:53.251Z |
4952557 | 4952557 | 20240811022415_j1uGD | UK000B | 2024-09-03T12:17:01.505Z | 2024-09-06T12:28:04.993Z |
4948682 | 4948682 | 20240811013828_DASpI | UK000B | 2024-09-02T12:15:10.775Z | 2024-09-06T12:27:23.476Z |
4946650 | 4946650 | 20240811010404_F2bgf | UK000B | 2024-09-02T12:14:02.498Z | 2024-09-06T12:26:29.265Z |
4942693 | 4942693 | 20240810235543_qeyq2 | UK000B | 2024-09-02T12:11:28.922Z | 2024-09-06T12:24:27.800Z |
4938930 | 4938930 | 20240810223240_rf63k | UK000B | 2024-09-01T12:09:31.683Z | 2024-09-06T12:23:08.092Z |
4938631 | 4938631 | 20240810222438_LKpaP | UK000B | 2024-09-01T12:09:13.160Z | 2024-09-06T12:22:58.481Z |
4938537 | 4938537 | 20240810222148_ar3Xe | UK000B | 2024-09-01T12:09:10.136Z | 2024-09-06T12:22:56.184Z |
4928181 | 4928181 | 20240810023137_09t6m | UK000B | 2024-08-31T12:21:13.214Z | 2024-09-02T12:29:02.925Z |
4919527 | 4919527 | 20240810001325_ARaRc | UK000B | 2024-08-30T12:12:47.548Z | 2024-09-02T12:25:53.255Z |
4918825 | 4918825 | 20240809235929_DFwTj | UK000B | 2024-08-30T12:12:16.638Z | 2024-09-02T12:25:37.318Z |
4878776 | 4878776 | 20240807003603_jOsIE | UK000B | 2024-08-19T12:14:21.517Z | 2024-08-27T12:13:48.945Z |
4878413 | 4878413 | 20240807002739_shhAn | UK000B | 2024-08-19T12:14:11.853Z | 2024-08-27T12:13:41.842Z |
4875106 | 4875106 | 20240806230601_IrA05 | UK000B | 2024-08-19T12:12:01.018Z | 2024-08-27T12:12:07.875Z |
4875040 | 4875040 | 20240806230428_mFadT | UK000B | 2024-08-19T12:11:58.963Z | 2024-08-27T12:12:01.752Z |
4873957 | 4873957 | 20240806223840_Gp3td | UK000B | 2024-08-19T12:11:12.085Z | 2024-08-27T12:11:28.168Z |
4873897 | 4873897 | 20240806223643_Y1gpy | UK000B | 2024-08-19T12:11:10.258Z | 2024-08-27T12:11:26.136Z |
4857513 | 4857513 | 20240806023252_OrIJ2 | UK000B | 2024-08-17T12:22:37.322Z | 2024-08-19T12:28:15.648Z |
4826150 | 4826150 | 20240804021904_wecH6 | UK000B | 2024-08-14T12:20:46.489Z | 2024-08-15T12:26:09.748Z |
4826040 | 4826040 | 20240804020602_yc4mj | UK000B | 2024-08-14T12:20:39.606Z | 2024-08-15T12:26:07.621Z |
4825025 | 4825025 | 20240804003748_AIkPC | UK000B | 2024-08-14T12:19:51.454Z | 2024-08-15T12:25:42.347Z |
4824615 | 4824615 | 20240804000507_AT7nV | UK000B | 2024-08-14T12:19:18.546Z | 2024-08-15T12:25:31.928Z |
4824262 | 4824262 | 20240803234127_ZNSbp | UK000B | 2024-08-14T12:18:56.982Z | 2024-08-15T12:25:21.104Z |
4823834 | 4823834 | 20240803231823_3aKpg | UK000B | 2024-08-14T12:18:37.651Z | 2024-08-15T12:25:13.446Z |
4823314 | 4823314 | 20240803223743_3RWAi | UK000B | 2024-08-14T12:18:07.317Z | 2024-08-15T12:24:54.112Z |
4778371 | 4778371 | 20240731224748_dGrzc | UK000B | 2024-08-07T12:13:42.955Z | 2024-08-10T12:21:04.723Z |
4759312 | 4759312 | 20240730224637_dDDHo | UK000B | 2024-08-05T12:15:19.255Z | 2024-08-08T12:23:59.753Z |
4714703 | 4714703 | 20240728004434_0i1Ma | UK000B | 2024-07-30T12:05:23.073Z | 2024-08-05T12:19:41.083Z |
4372926 | 4372926 | 20240521000336_vAPvH | UK000B | 2024-05-27T12:05:35.455Z | 2024-05-29T12:13:30.486Z |
4361079 | 4361079 | 20240517010605_RudOt | UK000B | 2024-05-25T12:03:19.923Z | 2024-05-25T12:09:10.568Z |
4257066 | 4257066 | 20240429024750_4DiyB | UK000B | 2024-05-01T12:13:07.995Z | 2024-05-07T12:18:55.359Z |
4257011 | 4257011 | 20240429023817_f6PUe | UK000B | 2024-05-01T12:13:04.333Z | 2024-05-07T12:18:54.658Z |
4256874 | 4256874 | 20240429021406_yvTqW | UK000B | 2024-05-01T12:12:56.091Z | 2024-05-07T12:18:53.376Z |
4256836 | 4256836 | 20240429020644_GJ8iB | UK000B | 2024-05-01T12:12:53.691Z | 2024-05-07T12:18:53.087Z |
4256612 | 4256612 | 20240429013747_5m2Tf | UK000B | 2024-05-01T12:12:42.041Z | 2024-05-07T12:18:50.578Z |
4186076 | 4186076 | 20240414030552_gUbpe | UK000B | 2024-04-15T12:05:55.994Z | 2024-04-22T12:22:25.820Z |
4185749 | 4185749 | 20240414015937_Wd2dj | UK000B | 2024-04-15T12:05:07.695Z | 2024-04-22T12:22:21.520Z |
4185683 | 4185683 | 20240414014735_kqYMg | UK000B | 2024-04-15T12:04:51.222Z | 2024-04-22T12:22:20.809Z |
4185564 | 4185564 | 20240414012910_WmrzD | UK000B | 2024-04-15T12:04:39.753Z | 2024-04-22T12:22:19.824Z |
4185548 | 4185548 | 20240414012709_1O2vZ | UK000B | 2024-04-15T12:04:37.762Z | 2024-04-22T12:22:19.677Z |
4185203 | 4185203 | 20240414002413_ByOPp | UK000B | 2024-04-15T12:03:49.780Z | 2024-04-22T12:22:15.892Z |
4179488 | 4179488 | 20240412221924_8tBI7 | UK000B | 2024-04-14T12:01:49.555Z | 2024-04-21T12:21:29.321Z |
4179452 | 4179452 | 20240412215307_R7sRH | UK000B | 2024-04-14T12:01:40.100Z | 2024-04-21T12:21:28.216Z |
4171702 | 4171702 | 20240410025323_liYMP | UK000B | 2024-04-12T12:08:04.791Z | 2024-04-18T12:21:19.585Z |
4171586 | 4171586 | 20240410024055_IB2cZ | UK000B | 2024-04-12T12:07:53.840Z | 2024-04-18T12:21:18.580Z |
4170672 | 4170672 | 20240411004058_yoN7K | UK000B | 2024-04-12T12:03:24.634Z | 2024-04-19T12:13:19.080Z |
4170476 | 4170476 | 20240410222358_eCtvo | UK000B | 2024-04-12T12:02:40.194Z | 2024-04-19T12:13:18.174Z |
4169463 | 4169463 | 20240410012102_rAFQh | UK000B | 2024-04-11T12:14:44.436Z | 2024-04-18T12:21:14.915Z |
4166674 | 4166674 | 20240410000327_D9ODG | UK000B | 2024-04-11T12:05:54.837Z | 2024-04-18T12:21:11.002Z |
4166284 | 4166284 | 20240409231127_E1Ai4 | UK000B | 2024-04-11T12:05:18.660Z | 2024-04-18T12:21:08.961Z |
4165893 | 4165893 | 20240409214613_sa2N7 | UK000B | 2024-04-11T12:04:32.704Z | 2024-04-18T12:21:04.980Z |
4157732 | 4157732 | 20240408032145_jiIsB | UK000B | 2024-04-09T12:05:39.600Z | 2024-04-16T12:20:19.538Z |
4157590 | 4157590 | 20240408021558_6nkZ3 | UK000B | 2024-04-09T12:05:11.017Z | 2024-04-16T12:20:17.935Z |
4157530 | 4157530 | 20240408013850_4lPwE | UK000B | 2024-04-09T12:05:02.171Z | 2024-04-16T12:20:17.143Z |
4157153 | 4157153 | 20240407221210_XJEek | UK000B | 2024-04-09T12:03:48.183Z | 2024-04-16T12:20:13.491Z |
4154540 | 4154540 | 20240407021629_9qYx7 | UK000B | 2024-04-08T12:06:46.675Z | 2024-04-15T12:19:16.140Z |
4154005 | 4154005 | 20240407000837_31Msk | UK000B | 2024-04-08T12:05:41.234Z | 2024-04-15T12:19:13.352Z |
4146647 | 4146647 | 20240404221246_yloec | UK000B | 2024-04-06T12:03:58.790Z | 2024-04-13T12:21:19.548Z |
4119434 | 4119434 | 20240328014649_FYkbD | UK000B | 2024-03-30T12:12:01.785Z | 2024-04-05T12:18:42.333Z |
4119332 | 4119332 | 20240327232836_Q3Dln | UK000B | 2024-03-30T12:11:50.188Z | 2024-04-05T12:18:41.615Z |
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);