participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,869 rows where station_code = "UK0090" 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 |
---|---|---|---|---|---|
5409610 | 5409610 | 20241027042808_Qpgc7 | UK0090 | 2024-10-29T12:17:32.939Z | 2024-11-04T14:29:02.007Z |
5408969 | 5408969 | 20241027035141_O3X66 | UK0090 | 2024-10-29T12:16:58.445Z | 2024-11-04T14:29:00.879Z |
5408302 | 5408302 | 20241027032207_Qopv8 | UK0090 | 2024-10-29T12:16:21.841Z | 2024-11-04T14:28:59.069Z |
5408279 | 5408279 | 20241027032105_aDNOt | UK0090 | 2024-10-29T12:16:20.916Z | 2024-11-04T14:28:59.046Z |
5407380 | 5407380 | 20241027023423_05cST | UK0090 | 2024-10-29T12:15:23.073Z | 2024-11-04T14:28:57.462Z |
5407321 | 5407321 | 20241027023134_2Kd9I | UK0090 | 2024-10-29T12:15:20.576Z | 2024-11-04T14:28:57.336Z |
5406266 | 5406266 | 20241027012414_P3opI | UK0090 | 2024-10-29T12:13:59.984Z | 2024-11-04T14:28:55.274Z |
5400099 | 5400099 | 20241026053942_9JUW5 | UK0090 | 2024-10-28T12:20:22.912Z | 2024-11-03T14:27:41.301Z |
5399986 | 5399986 | 20241026051859_o7xBp | UK0090 | 2024-10-28T12:20:18.080Z | 2024-11-03T14:27:40.945Z |
5399799 | 5399799 | 20241026050403_3BBeh | UK0090 | 2024-10-28T12:20:11.433Z | 2024-11-03T14:27:40.530Z |
5399790 | 5399790 | 20241026050252_s3bXi | UK0090 | 2024-10-28T12:20:11.121Z | 2024-11-03T14:27:40.512Z |
5399675 | 5399675 | 20241026044706_BjUw1 | UK0090 | 2024-10-28T12:20:05.641Z | 2024-11-03T14:27:40.221Z |
5399673 | 5399673 | 20241026044705_5Z03f | UK0090 | 2024-10-28T12:20:05.637Z | 2024-11-03T14:27:40.216Z |
5398220 | 5398220 | 20241026023545_0ejDj | UK0090 | 2024-10-28T12:19:06.610Z | 2024-11-03T14:27:35.703Z |
5397901 | 5397901 | 20241026020619_C4SMr | UK0090 | 2024-10-28T12:18:49.860Z | 2024-11-03T14:27:34.458Z |
5397848 | 5397848 | 20241026020215_MFn0G | UK0090 | 2024-10-28T12:18:48.156Z | 2024-11-03T14:27:34.321Z |
5397528 | 5397528 | 20241026013752_5bShE | UK0090 | 2024-10-28T12:18:26.336Z | 2024-11-03T14:27:33.346Z |
5397474 | 5397474 | 20241026013248_pQQM4 | UK0090 | 2024-10-28T12:18:24.430Z | 2024-11-03T14:27:33.141Z |
5397451 | 5397451 | 20241026013125_od88K | UK0090 | 2024-10-28T12:18:23.018Z | 2024-11-03T14:27:33.026Z |
5397379 | 5397379 | 20241026012420_u8aPb | UK0090 | 2024-10-28T12:18:18.726Z | 2024-11-03T14:27:32.758Z |
5377207 | 5377207 | 20241024043857_YY4St | UK0090 | 2024-10-26T12:22:31.079Z | 2024-11-01T12:27:02.327Z |
5374434 | 5374434 | 20241024022649_6CLTw | UK0090 | 2024-10-26T12:20:48.459Z | 2024-11-01T12:26:59.366Z |
5374345 | 5374345 | 20241024022310_jJ1Fx | UK0090 | 2024-10-26T12:20:45.600Z | 2024-11-01T12:26:58.853Z |
5374187 | 5374187 | 20241024021501_JAZSH | UK0090 | 2024-10-26T12:20:38.822Z | 2024-11-01T12:26:58.751Z |
5374087 | 5374087 | 20241024020854_Nx0r1 | UK0090 | 2024-10-26T12:20:36.697Z | 2024-11-01T12:26:58.692Z |
5373996 | 5373996 | 20241024020448_jEQ7x | UK0090 | 2024-10-26T12:20:33.971Z | 2024-11-01T12:26:58.620Z |
5373800 | 5373800 | 20241024015416_jtjjv | UK0090 | 2024-10-26T12:20:26.143Z | 2024-11-01T12:26:58.497Z |
5373584 | 5373584 | 20241024014525_MxnH2 | UK0090 | 2024-10-26T12:20:17.678Z | 2024-11-01T12:26:58.332Z |
5373376 | 5373376 | 20241024013455_qI20o | UK0090 | 2024-10-26T12:20:09.045Z | 2024-11-01T12:26:58.236Z |
5373041 | 5373041 | 20241024012050_fd35q | UK0090 | 2024-10-26T12:19:55.115Z | 2024-11-01T12:26:58.102Z |
5372126 | 5372126 | 20241024003346_V7ll4 | UK0090 | 2024-10-26T12:19:10.457Z | 2024-11-01T12:26:57.154Z |
5371920 | 5371920 | 20241024002326_vhYNi | UK0090 | 2024-10-26T12:18:58.116Z | 2024-11-01T12:26:57.000Z |
5366037 | 5366037 | 20241024000215_5XyOC | UK0090 | 2024-10-25T12:18:14.957Z | 2024-11-01T12:26:56.550Z |
5365767 | 5365767 | 20241023234759_gUr3m | UK0090 | 2024-10-25T12:18:07.394Z | 2024-11-01T12:26:56.400Z |
5365071 | 5365071 | 20241023231209_4HC1j | UK0090 | 2024-10-25T12:17:44.952Z | 2024-11-01T12:26:55.848Z |
5363635 | 5363635 | 20241023212918_83DBZ | UK0090 | 2024-10-25T12:16:30.666Z | 2024-11-01T12:26:53.473Z |
5355797 | 5355797 | 20241023041709_g6Kug | UK0090 | 2024-10-24T12:21:36.987Z | 2024-10-31T12:30:08.861Z |
5355706 | 5355706 | 20241023040258_fpg5f | UK0090 | 2024-10-24T12:21:32.999Z | 2024-10-31T12:30:08.543Z |
5355521 | 5355521 | 20241023034747_Efikw | UK0090 | 2024-10-24T12:21:25.063Z | 2024-10-31T12:30:08.036Z |
5354849 | 5354849 | 20241023024929_N2AZf | UK0090 | 2024-10-24T12:20:53.983Z | 2024-10-31T12:30:06.372Z |
5354755 | 5354755 | 20241023024356_N91Ri | UK0090 | 2024-10-24T12:20:48.689Z | 2024-10-31T12:30:06.295Z |
5354636 | 5354636 | 20241023023733_hulq9 | UK0090 | 2024-10-24T12:20:45.153Z | 2024-10-31T12:30:06.200Z |
5354574 | 5354574 | 20241023023330_BKta0 | UK0090 | 2024-10-24T12:20:41.284Z | 2024-10-31T12:30:06.015Z |
5354266 | 5354266 | 20241023021551_MPwK4 | UK0090 | 2024-10-24T12:20:25.220Z | 2024-10-31T12:30:05.562Z |
5354199 | 5354199 | 20241023021015_M032Y | UK0090 | 2024-10-24T12:20:22.050Z | 2024-10-31T12:30:05.503Z |
5354023 | 5354023 | 20241023020012_MP5nt | UK0090 | 2024-10-24T12:20:09.421Z | 2024-10-31T12:30:05.274Z |
5353918 | 5353918 | 20241023015439_okmwY | UK0090 | 2024-10-24T12:20:04.000Z | 2024-10-31T12:30:05.172Z |
5353700 | 5353700 | 20241023014130_rKDDG | UK0090 | 2024-10-24T12:19:53.693Z | 2024-10-31T12:30:04.672Z |
5353635 | 5353635 | 20241023013635_lrfbm | UK0090 | 2024-10-24T12:19:49.866Z | 2024-10-31T12:30:04.433Z |
5353513 | 5353513 | 20241023012915_iQeIi | UK0090 | 2024-10-24T12:19:45.169Z | 2024-10-31T12:30:04.316Z |
5353478 | 5353478 | 20241023012731_zkWg1 | UK0090 | 2024-10-24T12:19:43.968Z | 2024-10-31T12:30:04.289Z |
5353422 | 5353422 | 20241023012522_753ZA | UK0090 | 2024-10-24T12:19:42.461Z | 2024-10-31T12:30:04.240Z |
5352956 | 5352956 | 20241023005801_32Eg7 | UK0090 | 2024-10-24T12:19:27.732Z | 2024-10-31T12:30:03.577Z |
5352785 | 5352785 | 20241023004954_5bo6B | UK0090 | 2024-10-24T12:19:11.945Z | 2024-10-31T12:30:03.288Z |
5352638 | 5352638 | 20241023004215_xQqDG | UK0090 | 2024-10-24T12:19:02.154Z | 2024-10-31T12:30:03.009Z |
5352516 | 5352516 | 20241023003708_nejWy | UK0090 | 2024-10-24T12:18:54.102Z | 2024-10-31T12:30:02.849Z |
5352216 | 5352216 | 20241023001829_f4xcd | UK0090 | 2024-10-24T12:18:32.180Z | 2024-10-31T12:30:02.302Z |
5352041 | 5352041 | 20241023000730_G3nfE | UK0090 | 2024-10-24T12:18:16.169Z | 2024-10-31T12:30:01.681Z |
5351887 | 5351887 | 20241022235725_KBkTj | UK0090 | 2024-10-24T12:18:07.469Z | 2024-10-31T12:30:01.179Z |
5351517 | 5351517 | 20241022233500_A3AS2 | UK0090 | 2024-10-24T12:17:37.687Z | 2024-10-31T12:30:00.489Z |
5351288 | 5351288 | 20241022231325_YEZlO | UK0090 | 2024-10-24T12:17:24.163Z | 2024-10-31T12:29:59.747Z |
5351050 | 5351050 | 20241022225116_GrALp | UK0090 | 2024-10-24T12:17:06.667Z | 2024-10-31T12:29:59.308Z |
5350895 | 5350895 | 20241022223852_aXm2X | UK0090 | 2024-10-24T12:16:45.678Z | 2024-10-31T12:29:58.994Z |
5349802 | 5349802 | 20241022203624_2e3oC | UK0090 | 2024-10-24T12:14:39.366Z | 2024-10-31T12:29:56.544Z |
5349565 | 5349565 | 20241022201243_kzxkg | UK0090 | 2024-10-24T12:13:58.609Z | 2024-10-31T12:29:55.823Z |
5348862 | 5348862 | 20241022190424_5H7Yh | UK0090 | 2024-10-24T12:12:26.723Z | 2024-10-31T12:29:53.868Z |
5345201 | 5345201 | 20241022052427_FU2OR | UK0090 | 2024-10-23T12:19:10.418Z | 2024-10-30T12:26:52.292Z |
5344588 | 5344588 | 20241022043355_6Bwt9 | UK0090 | 2024-10-23T12:18:42.640Z | 2024-10-30T12:26:51.391Z |
5344541 | 5344541 | 20241022043034_e1htL | UK0090 | 2024-10-23T12:18:40.963Z | 2024-10-30T12:26:51.353Z |
5344118 | 5344118 | 20241022040624_IrHFs | UK0090 | 2024-10-23T12:18:24.413Z | 2024-10-30T12:26:50.946Z |
5344035 | 5344035 | 20241022040237_IgbTU | UK0090 | 2024-10-23T12:18:19.872Z | 2024-10-30T12:26:50.895Z |
5343970 | 5343970 | 20241022035826_cUiWL | UK0090 | 2024-10-23T12:18:16.553Z | 2024-10-30T12:26:50.827Z |
5342601 | 5342601 | 20241022023553_znDlc | UK0090 | 2024-10-23T12:17:07.291Z | 2024-10-30T12:26:48.708Z |
5342183 | 5342183 | 20241022021300_lcXDm | UK0090 | 2024-10-23T12:16:38.738Z | 2024-10-30T12:26:48.131Z |
5341632 | 5341632 | 20241022014459_vdwmy | UK0090 | 2024-10-23T12:16:03.106Z | 2024-10-30T12:26:47.244Z |
5341362 | 5341362 | 20241022012905_eFP71 | UK0090 | 2024-10-23T12:15:41.334Z | 2024-10-30T12:26:46.964Z |
5340490 | 5340490 | 20241022001945_dOwmW | UK0090 | 2024-10-23T12:14:35.568Z | 2024-10-30T12:26:45.929Z |
5340372 | 5340372 | 20241022000844_U1aBq | UK0090 | 2024-10-23T12:14:30.077Z | 2024-10-30T12:26:45.700Z |
5339338 | 5339338 | 20241021222347_wGV9q | UK0090 | 2024-10-23T12:13:00.764Z | 2024-10-30T12:26:44.044Z |
5339298 | 5339298 | 20241021222031_v8bwO | UK0090 | 2024-10-23T12:12:58.249Z | 2024-10-30T12:26:44.008Z |
5338632 | 5338632 | 20241021201330_lOtwf | UK0090 | 2024-10-23T12:11:29.786Z | 2024-10-30T12:26:42.596Z |
5338274 | 5338274 | 20241021190546_TAaar | UK0090 | 2024-10-23T12:10:37.090Z | 2024-10-30T12:26:42.098Z |
5338114 | 5338114 | 20241021183936_QzKPZ | UK0090 | 2024-10-23T12:10:15.682Z | 2024-10-30T12:26:41.730Z |
5332901 | 5332901 | 20241020230230_uq5gT | UK0090 | 2024-10-22T12:14:26.992Z | 2024-10-29T12:26:33.946Z |
5302836 | 5302836 | 20241013015024_Zfdq0 | UK0090 | 2024-10-14T12:16:50.502Z | 2024-10-21T12:24:13.487Z |
5302419 | 5302419 | 20241013010047_b0VSv | UK0090 | 2024-10-14T12:16:13.235Z | 2024-10-21T12:24:07.973Z |
5302280 | 5302280 | 20241013004731_OKvMx | UK0090 | 2024-10-14T12:16:05.267Z | 2024-10-21T12:24:06.249Z |
5302268 | 5302268 | 20241013004554_ZM4LR | UK0090 | 2024-10-14T12:16:04.783Z | 2024-10-21T12:24:05.999Z |
5302142 | 5302142 | 20241013003510_AyFMz | UK0090 | 2024-10-14T12:15:55.510Z | 2024-10-21T12:24:04.750Z |
5302092 | 5302092 | 20241013002916_KRp36 | UK0090 | 2024-10-14T12:15:52.307Z | 2024-10-21T12:24:04.358Z |
5302070 | 5302070 | 20241013002805_T4Yo3 | UK0090 | 2024-10-14T12:15:50.736Z | 2024-10-21T12:24:04.285Z |
5302053 | 5302053 | 20241013002543_x8686 | UK0090 | 2024-10-14T12:15:50.310Z | 2024-10-21T12:24:04.157Z |
5301902 | 5301902 | 20241013001511_W2NEk | UK0090 | 2024-10-14T12:15:42.927Z | 2024-10-21T12:24:02.898Z |
5301841 | 5301841 | 20241013001012_9eze4 | UK0090 | 2024-10-14T12:15:40.465Z | 2024-10-21T12:24:02.487Z |
5301778 | 5301778 | 20241013000448_XZOsz | UK0090 | 2024-10-14T12:15:38.623Z | 2024-10-21T12:24:01.877Z |
5301731 | 5301731 | 20241012235857_AEMIp | UK0090 | 2024-10-14T12:15:36.329Z | 2024-10-21T12:24:00.606Z |
5301701 | 5301701 | 20241012235608_32t8l | UK0090 | 2024-10-14T12:15:35.161Z | 2024-10-21T12:24:00.076Z |
5301683 | 5301683 | 20241012235418_smXbs | UK0090 | 2024-10-14T12:15:34.596Z | 2024-10-21T12:23:59.950Z |
5301563 | 5301563 | 20241012234505_NDiL5 | UK0090 | 2024-10-14T12:15:31.354Z | 2024-10-21T12:23:59.265Z |
5301384 | 5301384 | 20241012231633_0atdS | UK0090 | 2024-10-14T12:15:22.711Z | 2024-10-21T12:23:57.913Z |
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);