participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,825 rows where station_code = "UK002H" 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 |
---|---|---|---|---|---|
4734321 | 4734321 | 20240729014449_ky9Il | UK002H | 2024-08-01T12:04:23.068Z | 2024-08-06T12:14:49.813Z |
4733751 | 4733751 | 20240729013155_VlIt8 | UK002H | 2024-08-01T12:04:04.711Z | 2024-08-06T12:14:48.380Z |
4733521 | 4733521 | 20240729012550_zszV6 | UK002H | 2024-08-01T12:03:52.119Z | 2024-08-06T12:14:47.014Z |
4732399 | 4732399 | 20240729005624_ZnMvc | UK002H | 2024-08-01T12:03:03.063Z | 2024-08-06T12:14:44.006Z |
4732298 | 4732298 | 20240729005447_BiKOx | UK002H | 2024-08-01T12:03:00.406Z | 2024-08-06T12:14:43.733Z |
4732229 | 4732229 | 20240729005420_UaU9k | UK002H | 2024-08-01T12:02:56.355Z | 2024-08-06T12:14:43.630Z |
4731749 | 4731749 | 20240729004201_6pDbX | UK002H | 2024-08-01T12:02:32.815Z | 2024-08-06T12:14:41.804Z |
4729323 | 4729323 | 20240728224649_sr45K | UK002H | 2024-07-31T12:13:47.814Z | 2024-08-05T12:20:31.397Z |
4729256 | 4729256 | 20240728224508_Ti3s1 | UK002H | 2024-07-31T12:13:46.600Z | 2024-08-05T12:20:31.252Z |
4728872 | 4728872 | 20240728223319_4xzdF | UK002H | 2024-07-31T12:13:36.413Z | 2024-08-05T12:20:30.560Z |
4728762 | 4728762 | 20240728222836_PCsC6 | UK002H | 2024-07-31T12:13:33.938Z | 2024-08-05T12:20:30.406Z |
4721095 | 4721095 | 20240728234634_cUkQp | UK002H | 2024-07-31T12:02:05.641Z | 2024-08-06T12:14:34.463Z |
4721018 | 4721018 | 20240728234414_hOVh9 | UK002H | 2024-07-31T12:01:58.353Z | 2024-08-06T12:14:34.323Z |
4718254 | 4718254 | 20240728022725_L5sA1 | UK002H | 2024-07-30T12:09:21.349Z | 2024-08-05T12:19:54.917Z |
4718145 | 4718145 | 20240728022336_Uklgn | UK002H | 2024-07-30T12:09:15.782Z | 2024-08-05T12:19:54.457Z |
4717563 | 4717563 | 20240728020507_vc0h4 | UK002H | 2024-07-30T12:08:37.186Z | 2024-08-05T12:19:52.888Z |
4717207 | 4717207 | 20240728015506_I2lnm | UK002H | 2024-07-30T12:08:21.773Z | 2024-08-05T12:19:51.427Z |
4716774 | 4716774 | 20240728014800_3GdEm | UK002H | 2024-07-30T12:08:09.035Z | 2024-08-05T12:19:50.544Z |
4716477 | 4716477 | 20240728013946_mxthY | UK002H | 2024-07-30T12:07:43.367Z | 2024-08-05T12:19:48.645Z |
4716011 | 4716011 | 20240728012525_aTOEW | UK002H | 2024-07-30T12:06:58.002Z | 2024-08-05T12:19:46.574Z |
4715970 | 4715970 | 20240728012419_v3cqJ | UK002H | 2024-07-30T12:06:56.346Z | 2024-08-05T12:19:46.366Z |
4220069 | 4220069 | 20240420030752_Qk5Lp | UK002H | 2024-04-21T12:02:45.584Z | 2024-04-28T12:21:26.109Z |
4220002 | 4220002 | 20240420030239_cQEHV | UK002H | 2024-04-21T12:02:41.127Z | 2024-04-28T12:21:24.054Z |
4219895 | 4219895 | 20240420025535_WF1o9 | UK002H | 2024-04-21T12:02:33.632Z | 2024-04-28T12:21:23.345Z |
4130413 | 4130413 | 20240331043712_zCSeS | UK002H | 2024-04-01T12:08:08.169Z | 2024-04-08T12:18:52.296Z |
4130253 | 4130253 | 20240331040004_scrzl | UK002H | 2024-04-01T12:07:59.387Z | 2024-04-08T12:18:50.760Z |
4129960 | 4129960 | 20240331031801_72ibY | UK002H | 2024-04-01T12:07:30.062Z | 2024-04-08T12:18:46.272Z |
4129846 | 4129846 | 20240331030602_29T8T | UK002H | 2024-04-01T12:07:25.219Z | 2024-04-08T12:18:45.706Z |
4129784 | 4129784 | 20240331025941_9J6Ew | UK002H | 2024-04-01T12:07:22.241Z | 2024-04-08T12:18:44.999Z |
4128990 | 4128990 | 20240331011230_azYav | UK002H | 2024-04-01T12:06:23.557Z | 2024-04-08T12:18:40.370Z |
4128937 | 4128937 | 20240331010808_6oMpp | UK002H | 2024-04-01T12:06:19.522Z | 2024-04-08T12:18:40.079Z |
4128359 | 4128359 | 20240330232043_g1y79 | UK002H | 2024-04-01T12:05:27.032Z | 2024-04-08T12:18:35.345Z |
4127952 | 4127952 | 20240330205047_1z1v8 | UK002H | 2024-04-01T12:04:49.175Z | 2024-04-08T12:18:31.158Z |
4127935 | 4127935 | 20240330205034_QASpS | UK002H | 2024-04-01T12:04:48.186Z | 2024-04-08T12:18:31.098Z |
4078404 | 4078404 | 20240316050019_roPke | UK002H | 2024-03-17T12:09:31.250Z | 2024-03-24T12:20:57.490Z |
4078374 | 4078374 | 20240316050006_I7gBA | UK002H | 2024-03-17T12:09:30.853Z | 2024-03-24T12:20:57.453Z |
4078248 | 4078248 | 20240316045211_5IhlW | UK002H | 2024-03-17T12:09:24.664Z | 2024-03-24T12:20:56.876Z |
4077902 | 4077902 | 20240316035502_p7vJ9 | UK002H | 2024-03-17T12:09:07.056Z | 2024-03-24T12:20:53.972Z |
4027317 | 4027317 | 20240304052217_JtfBH | UK002H | 2024-03-05T14:09:14.836Z | 2024-03-12T12:15:35.691Z |
4027179 | 4027179 | 20240304050613_32tcz | UK002H | 2024-03-05T14:09:00.657Z | 2024-03-12T12:15:35.129Z |
4027127 | 4027127 | 20240304050239_DbKkL | UK002H | 2024-03-05T14:08:57.820Z | 2024-03-12T12:15:35.029Z |
4026979 | 4026979 | 20240304045112_iR91p | UK002H | 2024-03-05T14:08:46.653Z | 2024-03-12T12:15:34.231Z |
4026812 | 4026812 | 20240304043511_ELB56 | UK002H | 2024-03-05T14:08:38.303Z | 2024-03-12T12:15:33.960Z |
4026494 | 4026494 | 20240304040634_4NSQX | UK002H | 2024-03-05T14:08:25.060Z | 2024-03-12T12:15:32.527Z |
4026453 | 4026453 | 20240304040537_M3ivY | UK002H | 2024-03-05T14:08:23.380Z | 2024-03-12T12:15:32.316Z |
4025410 | 4025410 | 20240304022359_KYWPL | UK002H | 2024-03-05T14:07:05.976Z | 2024-03-12T12:15:27.051Z |
4025231 | 4025231 | 20240304021241_y5IJB | UK002H | 2024-03-05T14:06:50.081Z | 2024-03-12T12:15:26.358Z |
4025203 | 4025203 | 20240304020831_BFlkl | UK002H | 2024-03-05T14:06:44.394Z | 2024-03-12T12:15:26.038Z |
4025007 | 4025007 | 20240304015013_tH3YJ | UK002H | 2024-03-05T14:06:25.810Z | 2024-03-12T12:15:24.991Z |
4024156 | 4024156 | 20240304001558_wKxXd | UK002H | 2024-03-05T14:05:17.341Z | 2024-03-12T12:15:21.587Z |
4023753 | 4023753 | 20240303233219_K3Vxc | UK002H | 2024-03-05T14:04:40.312Z | 2024-03-12T12:15:19.838Z |
4023409 | 4023409 | 20240303225813_3YqOe | UK002H | 2024-03-05T14:04:08.492Z | 2024-03-12T12:15:18.050Z |
4023340 | 4023340 | 20240303224527_ANAXH | UK002H | 2024-03-05T14:04:03.446Z | 2024-03-12T12:15:17.449Z |
4023278 | 4023278 | 20240303223548_2vXXY | UK002H | 2024-03-05T14:04:00.356Z | 2024-03-12T12:15:17.336Z |
4022722 | 4022722 | 20240303202222_yw5pX | UK002H | 2024-03-05T14:02:53.437Z | 2024-03-12T12:15:14.881Z |
4022709 | 4022709 | 20240303201353_r2eTj | UK002H | 2024-03-05T14:02:51.687Z | 2024-03-12T12:15:14.758Z |
4022655 | 4022655 | 20240303194826_Lao9x | UK002H | 2024-03-05T14:02:42.490Z | 2024-03-12T12:15:14.302Z |
4022624 | 4022624 | 20240303194051_IanPi | UK002H | 2024-03-05T14:02:39.726Z | 2024-03-12T12:15:14.214Z |
3954484 | 3954484 | 20240212055331_AD2Fd | UK002H | 2024-02-13T14:09:00.013Z | 2024-02-20T14:26:07.099Z |
3954139 | 3954139 | 20240212050457_eAidi | UK002H | 2024-02-13T14:08:41.863Z | 2024-02-20T14:26:04.984Z |
3951299 | 3951299 | 20240211205320_HDIW0 | UK002H | 2024-02-13T14:04:34.128Z | 2024-02-20T14:25:36.374Z |
3915755 | 3915755 | 20240203184839_lK3eO | UK002H | 2024-02-05T14:00:27.614Z | 2024-02-12T14:22:54.635Z |
3901224 | 3901224 | 20240130230644_Vu84U | UK002H | 2024-02-01T14:02:48.843Z | 2024-02-08T14:20:09.531Z |
3901136 | 3901136 | 20240130223438_2xDM2 | UK002H | 2024-02-01T14:02:37.592Z | 2024-02-08T14:20:08.851Z |
3900443 | 3900443 | 20240130183905_NzA43 | UK002H | 2024-02-01T14:00:30.820Z | 2024-02-08T14:19:59.177Z |
3857566 | 3857566 | 20240118065043_q89co | UK002H | 2024-01-21T14:11:33.991Z | 2024-01-26T14:21:40.588Z |
3857538 | 3857538 | 20240118064850_Tif4r | UK002H | 2024-01-21T14:11:32.889Z | 2024-01-26T14:21:40.489Z |
3857498 | 3857498 | 20240118064345_oLlBi | UK002H | 2024-01-21T14:11:29.028Z | 2024-01-26T14:21:40.110Z |
3857377 | 3857377 | 20240118063759_5K43i | UK002H | 2024-01-21T14:11:16.641Z | 2024-01-26T14:21:38.681Z |
3856673 | 3856673 | 20240118055345_olqOF | UK002H | 2024-01-21T14:09:46.149Z | 2024-01-26T14:21:27.120Z |
3856592 | 3856592 | 20240118054812_gjguX | UK002H | 2024-01-21T14:09:30.497Z | 2024-01-26T14:21:25.696Z |
3856111 | 3856111 | 20240118052045_YCqpW | UK002H | 2024-01-21T14:08:18.593Z | 2024-01-26T14:21:21.007Z |
3855748 | 3855748 | 20240118050403_4IBH1 | UK002H | 2024-01-21T14:07:06.990Z | 2024-01-26T14:21:17.643Z |
3855663 | 3855663 | 20240118050205_icU8E | UK002H | 2024-01-21T14:06:59.506Z | 2024-01-26T14:21:17.374Z |
3855523 | 3855523 | 20240118045618_Hg0Ey | UK002H | 2024-01-21T14:06:31.172Z | 2024-01-26T14:21:16.394Z |
3855402 | 3855402 | 20240118045129_uP2UN | UK002H | 2024-01-21T14:06:11.815Z | 2024-01-26T14:21:15.620Z |
3854849 | 3854849 | 20240118041547_SLrkq | UK002H | 2024-01-21T14:04:25.711Z | 2024-01-26T14:21:10.979Z |
3854446 | 3854446 | 20240117224931_0Q40z | UK002H | 2024-01-20T14:14:52.381Z | 2024-01-21T14:21:49.941Z |
3854318 | 3854318 | 20240117223308_2iNmG | UK002H | 2024-01-20T14:14:50.044Z | 2024-01-21T14:21:47.278Z |
3849128 | 3849128 | 20240118035314_N39jd | UK002H | 2024-01-20T14:05:41.835Z | 2024-01-26T14:21:07.856Z |
3848852 | 3848852 | 20240118034057_OPw4N | UK002H | 2024-01-20T14:05:28.959Z | 2024-01-26T14:21:06.161Z |
3848569 | 3848569 | 20240118031927_VShE8 | UK002H | 2024-01-20T14:04:58.789Z | 2024-01-26T14:21:03.548Z |
3848268 | 3848268 | 20240118030229_OEvwa | UK002H | 2024-01-20T14:04:37.455Z | 2024-01-26T14:21:00.757Z |
3847869 | 3847869 | 20240118024217_GbJVO | UK002H | 2024-01-20T14:04:07.088Z | 2024-01-26T14:20:57.767Z |
3847682 | 3847682 | 20240118022420_SQ5aD | UK002H | 2024-01-20T14:03:44.864Z | 2024-01-26T14:20:56.037Z |
3847520 | 3847520 | 20240118021320_IYyA2 | UK002H | 2024-01-20T14:03:21.593Z | 2024-01-26T14:20:54.238Z |
3847468 | 3847468 | 20240118021223_Df5BL | UK002H | 2024-01-20T14:03:20.330Z | 2024-01-26T14:20:53.929Z |
3847175 | 3847175 | 20240118013758_S2W2o | UK002H | 2024-01-20T14:02:45.007Z | 2024-01-26T14:20:47.132Z |
3847088 | 3847088 | 20240118013532_qID2Y | UK002H | 2024-01-20T14:02:41.329Z | 2024-01-26T14:20:46.308Z |
3846747 | 3846747 | 20240118011311_ilbDs | UK002H | 2024-01-20T14:02:15.412Z | 2024-01-26T14:20:39.747Z |
3845978 | 3845978 | 20240118000109_iQyUo | UK002H | 2024-01-20T14:00:48.134Z | 2024-01-26T14:20:26.194Z |
3845818 | 3845818 | 20240117234503_qEf7D | UK002H | 2024-01-20T14:00:34.647Z | 2024-01-26T14:20:23.145Z |
3831991 | 3831991 | 20240115055825_FvexE | UK002H | 2024-01-18T14:04:12.697Z | 2024-01-24T14:18:27.627Z |
3831860 | 3831860 | 20240115034131_vtUwN | UK002H | 2024-01-18T14:02:51.280Z | 2024-01-24T14:18:16.829Z |
3826875 | 3826875 | 20240115070043_23zeX | UK002H | 2024-01-17T14:06:35.300Z | 2024-01-24T14:18:32.563Z |
3826258 | 3826258 | 20240115061231_aoMqu | UK002H | 2024-01-17T14:05:55.391Z | 2024-01-24T14:18:28.542Z |
3826217 | 3826217 | 20240115060948_lRrvP | UK002H | 2024-01-17T14:05:52.103Z | 2024-01-24T14:18:28.396Z |
3826183 | 3826183 | 20240115060613_ebYZM | UK002H | 2024-01-17T14:05:49.668Z | 2024-01-24T14:18:28.146Z |
3826149 | 3826149 | 20240115060510_3eE82 | UK002H | 2024-01-17T14:05:49.056Z | 2024-01-24T14:18:28.141Z |
3826089 | 3826089 | 20240115060315_HYeax | UK002H | 2024-01-17T14:05:46.817Z | 2024-01-24T14:18:27.912Z |
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);