participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,161 rows where station_code = "UK007Z" 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 |
---|---|---|---|---|---|
5505319 | 5505319 | 20241108043521_FKxnT | UK007Z | 2024-11-09T14:16:09.336Z | 2024-11-09T14:16:28.754Z |
5503180 | 5503180 | 20241107205635_UM2B7 | UK007Z | 2024-11-09T14:12:31.443Z | 2024-11-09T14:16:28.185Z |
5502849 | 5502849 | 20241107195532_bsEpP | UK007Z | 2024-11-09T14:12:07.097Z | 2024-11-09T14:16:28.111Z |
5502816 | 5502816 | 20241107194929_52P3a | UK007Z | 2024-11-09T14:12:04.810Z | 2024-11-09T14:16:28.103Z |
5502611 | 5502611 | 20241107191625_v5pQ4 | UK007Z | 2024-11-09T14:11:50.947Z | 2024-11-09T14:16:28.064Z |
5502269 | 5502269 | 20241107175400_O6Qwb | UK007Z | 2024-11-09T14:11:07.265Z | 2024-11-09T14:16:27.994Z |
5497770 | 5497770 | 20241107050331_es6Rs | UK007Z | 2024-11-08T14:14:19.686Z | 2024-11-09T14:18:51.676Z |
5497749 | 5497749 | 20241107045843_n3pWc | UK007Z | 2024-11-08T14:14:18.098Z | 2024-11-09T14:18:51.455Z |
5497664 | 5497664 | 20241107042142_pGWnR | UK007Z | 2024-11-08T14:14:09.361Z | 2024-11-09T14:18:49.780Z |
5497603 | 5497603 | 20241107041035_8jW2x | UK007Z | 2024-11-08T14:14:02.341Z | 2024-11-09T14:18:47.349Z |
5497587 | 5497587 | 20241107040619_TVtHe | UK007Z | 2024-11-08T14:14:00.555Z | 2024-11-09T14:18:46.594Z |
5497444 | 5497444 | 20241107034216_OIpoG | UK007Z | 2024-11-08T14:13:47.075Z | 2024-11-09T14:18:43.212Z |
5497368 | 5497368 | 20241107032851_YLWTl | UK007Z | 2024-11-08T14:13:38.968Z | 2024-11-09T14:18:41.706Z |
5497323 | 5497323 | 20241107032235_xiVgA | UK007Z | 2024-11-08T14:13:32.888Z | 2024-11-09T14:18:40.687Z |
5497316 | 5497316 | 20241107032142_bmmQb | UK007Z | 2024-11-08T14:13:31.932Z | 2024-11-09T14:18:40.619Z |
5497206 | 5497206 | 20241107025524_aNet6 | UK007Z | 2024-11-08T14:13:21.556Z | 2024-11-09T14:18:37.140Z |
5497195 | 5497195 | 20241107025417_3qBbe | UK007Z | 2024-11-08T14:13:20.027Z | 2024-11-09T14:18:36.781Z |
5496934 | 5496934 | 20241107021154_rzJdi | UK007Z | 2024-11-08T14:12:59.703Z | 2024-11-09T14:18:33.309Z |
5496801 | 5496801 | 20241107014210_2V174 | UK007Z | 2024-11-08T14:12:52.212Z | 2024-11-09T14:18:30.430Z |
5496762 | 5496762 | 20241107013330_jcRtq | UK007Z | 2024-11-08T14:12:50.275Z | 2024-11-09T14:18:29.679Z |
5496680 | 5496680 | 20241107011524_xHm2f | UK007Z | 2024-11-08T14:12:41.054Z | 2024-11-09T14:18:27.526Z |
5496640 | 5496640 | 20241107010718_ubn2V | UK007Z | 2024-11-08T14:12:35.758Z | 2024-11-09T14:18:26.863Z |
5496594 | 5496594 | 20241107005941_bvZi1 | UK007Z | 2024-11-08T14:12:29.967Z | 2024-11-09T14:18:26.274Z |
5496573 | 5496573 | 20241107005505_TtHTC | UK007Z | 2024-11-08T14:12:27.200Z | 2024-11-09T14:18:25.704Z |
5496495 | 5496495 | 20241107003652_iDhxK | UK007Z | 2024-11-08T14:12:16.276Z | 2024-11-09T14:18:23.330Z |
5496489 | 5496489 | 20241107003505_mNLSv | UK007Z | 2024-11-08T14:12:15.665Z | 2024-11-09T14:18:23.225Z |
5496460 | 5496460 | 20241107003040_OddLo | UK007Z | 2024-11-08T14:12:11.689Z | 2024-11-09T14:18:22.748Z |
5496383 | 5496383 | 20241107000843_tLaIU | UK007Z | 2024-11-08T14:12:05.582Z | 2024-11-09T14:18:21.432Z |
5496272 | 5496272 | 20241106234445_xGRg0 | UK007Z | 2024-11-08T14:11:53.050Z | 2024-11-09T14:18:19.374Z |
5496186 | 5496186 | 20241106231733_4u8Ge | UK007Z | 2024-11-08T14:11:44.563Z | 2024-11-09T14:18:17.796Z |
5496032 | 5496032 | 20241106224252_eOmbP | UK007Z | 2024-11-08T14:11:24.911Z | 2024-11-09T14:18:14.777Z |
5495607 | 5495607 | 20241106203130_a5MMF | UK007Z | 2024-11-08T14:10:27.952Z | 2024-11-09T14:18:00.677Z |
5495605 | 5495605 | 20241106203055_B2DE9 | UK007Z | 2024-11-08T14:10:27.771Z | 2024-11-09T14:18:00.451Z |
5495580 | 5495580 | 20241106202451_DmhEH | UK007Z | 2024-11-08T14:10:25.687Z | 2024-11-09T14:17:59.684Z |
5491727 | 5491727 | 20241106044528_OxfJi | UK007Z | 2024-11-07T14:16:52.347Z | 2024-11-09T14:20:13.929Z |
5491681 | 5491681 | 20241106042711_Vsmtf | UK007Z | 2024-11-07T14:16:44.614Z | 2024-11-09T14:20:12.803Z |
5491572 | 5491572 | 20241106035429_9kNUC | UK007Z | 2024-11-07T14:16:25.040Z | 2024-11-09T14:20:11.079Z |
5491568 | 5491568 | 20241106035212_GgYLF | UK007Z | 2024-11-07T14:16:23.950Z | 2024-11-09T14:20:11.054Z |
5491353 | 5491353 | 20241106030309_qzsJv | UK007Z | 2024-11-07T14:15:56.434Z | 2024-11-09T14:20:07.052Z |
5491257 | 5491257 | 20241106023759_qRUiz | UK007Z | 2024-11-07T14:15:42.811Z | 2024-11-09T14:20:06.119Z |
5491205 | 5491205 | 20241106022152_sKoDR | UK007Z | 2024-11-07T14:15:30.697Z | 2024-11-09T14:20:05.536Z |
5491166 | 5491166 | 20241106021518_Ka1My | UK007Z | 2024-11-07T14:15:24.140Z | 2024-11-09T14:20:04.694Z |
5490989 | 5490989 | 20241106013216_80MVF | UK007Z | 2024-11-07T14:15:10.376Z | 2024-11-09T14:20:02.660Z |
5490954 | 5490954 | 20241106012222_kT7Z5 | UK007Z | 2024-11-07T14:15:07.773Z | 2024-11-09T14:20:02.306Z |
5490894 | 5490894 | 20241106010652_wO8Ee | UK007Z | 2024-11-07T14:15:03.404Z | 2024-11-09T14:20:01.077Z |
5490837 | 5490837 | 20241106005110_rBTSn | UK007Z | 2024-11-07T14:14:58.374Z | 2024-11-09T14:19:59.977Z |
5490730 | 5490730 | 20241106002442_kP5l5 | UK007Z | 2024-11-07T14:14:43.745Z | 2024-11-09T14:19:58.964Z |
5490647 | 5490647 | 20241105235312_p9P5r | UK007Z | 2024-11-07T14:14:23.473Z | 2024-11-09T14:19:57.621Z |
5490526 | 5490526 | 20241105231622_4P4Oz | UK007Z | 2024-11-07T14:14:09.395Z | 2024-11-09T14:19:56.651Z |
5490520 | 5490520 | 20241105231517_blADU | UK007Z | 2024-11-07T14:14:08.762Z | 2024-11-09T14:19:56.477Z |
5490490 | 5490490 | 20241105230113_i8cVx | UK007Z | 2024-11-07T14:14:05.532Z | 2024-11-09T14:19:56.151Z |
5490488 | 5490488 | 20241105230047_98aHk | UK007Z | 2024-11-07T14:14:05.451Z | 2024-11-09T14:19:56.143Z |
5490337 | 5490337 | 20241105221524_5HqDE | UK007Z | 2024-11-07T14:13:53.819Z | 2024-11-09T14:19:53.961Z |
5490262 | 5490262 | 20241105215025_fkCrf | UK007Z | 2024-11-07T14:13:46.945Z | 2024-11-09T14:19:53.256Z |
5490226 | 5490226 | 20241105214442_vRHKI | UK007Z | 2024-11-07T14:13:37.729Z | 2024-11-09T14:19:52.964Z |
5490166 | 5490166 | 20241105212750_hrVpd | UK007Z | 2024-11-07T14:13:24.148Z | 2024-11-09T14:19:51.637Z |
5490155 | 5490155 | 20241105212507_86b2V | UK007Z | 2024-11-07T14:13:21.978Z | 2024-11-09T14:19:51.503Z |
5490034 | 5490034 | 20241105204653_GI31A | UK007Z | 2024-11-07T14:13:05.453Z | 2024-11-09T14:19:50.164Z |
5490019 | 5490019 | 20241105204253_4Ec3d | UK007Z | 2024-11-07T14:13:03.070Z | 2024-11-09T14:19:50.022Z |
5477645 | 5477645 | 20241104021644_ubJCK | UK007Z | 2024-11-05T14:17:12.239Z | 2024-11-09T14:22:20.317Z |
5474787 | 5474787 | 20241103181701_X2MYW | UK007Z | 2024-11-05T14:12:00.524Z | 2024-11-09T14:21:52.401Z |
5470153 | 5470153 | 20241103061128_dEXkE | UK007Z | 2024-11-04T14:17:51.797Z | 2024-11-09T14:23:05.723Z |
5470128 | 5470128 | 20241103055232_NS8Ln | UK007Z | 2024-11-04T14:17:49.893Z | 2024-11-09T14:23:05.570Z |
5470125 | 5470125 | 20241103054419_NnbJZ | UK007Z | 2024-11-04T14:17:49.689Z | 2024-11-09T14:23:05.516Z |
5470121 | 5470121 | 20241103053955_ooQAd | UK007Z | 2024-11-04T14:17:49.366Z | 2024-11-09T14:23:05.483Z |
5469664 | 5469664 | 20241103035808_W2KFP | UK007Z | 2024-11-04T14:16:45.128Z | 2024-11-09T14:23:03.435Z |
5469645 | 5469645 | 20241103035524_X5dAC | UK007Z | 2024-11-04T14:16:43.115Z | 2024-11-09T14:23:03.325Z |
5469434 | 5469434 | 20241103032637_ORivV | UK007Z | 2024-11-04T14:16:27.751Z | 2024-11-09T14:23:02.586Z |
5469422 | 5469422 | 20241103032448_Vcowe | UK007Z | 2024-11-04T14:16:26.699Z | 2024-11-09T14:23:02.519Z |
5469259 | 5469259 | 20241103025656_3VMiG | UK007Z | 2024-11-04T14:16:07.333Z | 2024-11-09T14:23:01.802Z |
5469208 | 5469208 | 20241103024959_9bX8p | UK007Z | 2024-11-04T14:15:54.787Z | 2024-11-09T14:23:01.290Z |
5468877 | 5468877 | 20241103020417_X2b4Q | UK007Z | 2024-11-04T14:15:10.980Z | 2024-11-09T14:23:00.086Z |
5468458 | 5468458 | 20241103004030_ZQdUz | UK007Z | 2024-11-04T14:14:09.022Z | 2024-11-09T14:22:58.452Z |
5468417 | 5468417 | 20241103003158_k7gRY | UK007Z | 2024-11-04T14:14:04.992Z | 2024-11-09T14:22:58.319Z |
5468411 | 5468411 | 20241103002914_Q52Cp | UK007Z | 2024-11-04T14:14:04.450Z | 2024-11-09T14:22:58.288Z |
5468404 | 5468404 | 20241103002858_aFWj7 | UK007Z | 2024-11-04T14:14:04.056Z | 2024-11-09T14:22:58.248Z |
5468220 | 5468220 | 20241102235150_BKkyf | UK007Z | 2024-11-04T14:13:46.684Z | 2024-11-09T14:22:57.503Z |
5468216 | 5468216 | 20241102235112_aydUz | UK007Z | 2024-11-04T14:13:46.257Z | 2024-11-09T14:22:57.488Z |
5467644 | 5467644 | 20241102220941_0uLar | UK007Z | 2024-11-04T14:12:17.086Z | 2024-11-09T14:22:55.230Z |
5443415 | 5443415 | 20241030060040_XJ29F | UK007Z | 2024-11-01T12:20:30.018Z | 2024-11-07T14:26:51.337Z |
5443185 | 5443185 | 20241030035529_fAJ88 | UK007Z | 2024-11-01T12:20:21.225Z | 2024-11-07T14:26:49.995Z |
5443158 | 5443158 | 20241030034539_bo876 | UK007Z | 2024-11-01T12:20:19.771Z | 2024-11-07T14:26:49.794Z |
5442937 | 5442937 | 20241030025846_kIVm3 | UK007Z | 2024-11-01T12:20:13.320Z | 2024-11-07T14:26:48.989Z |
5433047 | 5433047 | 20241029055804_xmmkH | UK007Z | 2024-10-31T12:21:44.208Z | 2024-11-06T14:27:29.763Z |
5433041 | 5433041 | 20241029055315_umkBY | UK007Z | 2024-10-31T12:21:44.047Z | 2024-11-06T14:27:29.731Z |
5433037 | 5433037 | 20241029055150_f2hAt | UK007Z | 2024-10-31T12:21:43.952Z | 2024-11-06T14:27:29.720Z |
5433033 | 5433033 | 20241029054954_HLWzk | UK007Z | 2024-10-31T12:21:43.821Z | 2024-11-06T14:27:29.709Z |
5433015 | 5433015 | 20241029054313_YhsV9 | UK007Z | 2024-10-31T12:21:42.874Z | 2024-11-06T14:27:29.605Z |
5433002 | 5433002 | 20241029054154_BKGtY | UK007Z | 2024-10-31T12:21:42.667Z | 2024-11-06T14:27:29.549Z |
5433000 | 5433000 | 20241029054134_ZLKbr | UK007Z | 2024-10-31T12:21:42.615Z | 2024-11-06T14:27:29.546Z |
5432986 | 5432986 | 20241029053622_422WL | UK007Z | 2024-10-31T12:21:41.998Z | 2024-11-06T14:27:29.467Z |
5432819 | 5432819 | 20241029044807_RCZNN | UK007Z | 2024-10-31T12:21:36.080Z | 2024-11-06T14:27:28.812Z |
5432779 | 5432779 | 20241029043612_I2da7 | UK007Z | 2024-10-31T12:21:34.698Z | 2024-11-06T14:27:28.694Z |
5432745 | 5432745 | 20241029043158_AhWZr | UK007Z | 2024-10-31T12:21:33.505Z | 2024-11-06T14:27:28.608Z |
5432686 | 5432686 | 20241029041748_2xfWW | UK007Z | 2024-10-31T12:21:31.300Z | 2024-11-06T14:27:28.447Z |
5432678 | 5432678 | 20241029041339_09SUm | UK007Z | 2024-10-31T12:21:31.056Z | 2024-11-06T14:27:28.393Z |
5432642 | 5432642 | 20241029040714_JIzhm | UK007Z | 2024-10-31T12:21:29.752Z | 2024-11-06T14:27:28.270Z |
5432607 | 5432607 | 20241029040139_y3Npe | UK007Z | 2024-10-31T12:21:28.491Z | 2024-11-06T14:27:28.218Z |
5410957 | 5410957 | 20241027055637_Iui32 | UK007Z | 2024-10-29T12:18:13.903Z | 2024-11-04T14:29:06.436Z |
5410814 | 5410814 | 20241027053826_w1Glx | UK007Z | 2024-10-29T12:18:05.508Z | 2024-11-04T14:29:05.566Z |
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);