participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,193 rows where station_code = "UK00AM" 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 |
---|---|---|---|---|---|
5134059 | 5134059 | 20240916043715_3EjSy | UK00AM | 2024-09-19T12:17:17.396Z | 2024-09-19T12:17:17.396Z |
5134013 | 5134013 | 20240916043003_jzPoh | UK00AM | 2024-09-19T12:17:15.895Z | 2024-09-19T12:17:15.895Z |
5133990 | 5133990 | 20240916042709_7a9jH | UK00AM | 2024-09-19T12:17:15.450Z | 2024-09-19T12:17:15.450Z |
5133835 | 5133835 | 20240916040834_EWxyd | UK00AM | 2024-09-19T12:17:10.044Z | 2024-09-19T12:17:10.044Z |
5133815 | 5133815 | 20240916040726_LvkS6 | UK00AM | 2024-09-19T12:17:08.348Z | 2024-09-19T12:17:08.348Z |
5133763 | 5133763 | 20240916040327_IbtOL | UK00AM | 2024-09-19T12:17:07.293Z | 2024-09-19T12:17:07.293Z |
5133692 | 5133692 | 20240916035051_298Kt | UK00AM | 2024-09-19T12:17:05.257Z | 2024-09-19T12:17:05.257Z |
5133667 | 5133667 | 20240916035000_ySRCK | UK00AM | 2024-09-19T12:17:04.958Z | 2024-09-19T12:17:04.958Z |
5133641 | 5133641 | 20240916034914_CZQGb | UK00AM | 2024-09-19T12:17:04.554Z | 2024-09-19T12:17:04.554Z |
5133633 | 5133633 | 20240916034910_mp5PQ | UK00AM | 2024-09-19T12:17:04.332Z | 2024-09-19T12:17:04.332Z |
5133617 | 5133617 | 20240916034744_63kze | UK00AM | 2024-09-19T12:17:03.806Z | 2024-09-19T12:17:03.806Z |
5133569 | 5133569 | 20240916034141_sVk8p | UK00AM | 2024-09-19T12:17:02.131Z | 2024-09-19T12:17:02.131Z |
5133561 | 5133561 | 20240916034027_d7GAl | UK00AM | 2024-09-19T12:17:01.758Z | 2024-09-19T12:17:01.758Z |
5133472 | 5133472 | 20240916033130_5v03X | UK00AM | 2024-09-19T12:16:57.404Z | 2024-09-19T12:16:57.404Z |
5133451 | 5133451 | 20240916033110_5jGcn | UK00AM | 2024-09-19T12:16:56.814Z | 2024-09-19T12:16:56.814Z |
5133437 | 5133437 | 20240916032951_wW9CU | UK00AM | 2024-09-19T12:16:56.299Z | 2024-09-19T12:16:56.299Z |
5133413 | 5133413 | 20240916032800_zKDzl | UK00AM | 2024-09-19T12:16:56.197Z | 2024-09-19T12:16:56.197Z |
5133400 | 5133400 | 20240916032749_bSoYG | UK00AM | 2024-09-19T12:16:55.901Z | 2024-09-19T12:16:55.901Z |
5133338 | 5133338 | 20240916032335_geFny | UK00AM | 2024-09-19T12:16:54.445Z | 2024-09-19T12:16:54.445Z |
5132904 | 5132904 | 20240916022710_WFR7H | UK00AM | 2024-09-19T12:16:35.660Z | 2024-09-19T12:16:35.660Z |
5132890 | 5132890 | 20240916022606_DNFFW | UK00AM | 2024-09-19T12:16:35.324Z | 2024-09-19T12:16:35.324Z |
5132865 | 5132865 | 20240916022338_51p7l | UK00AM | 2024-09-19T12:16:34.830Z | 2024-09-19T12:16:34.830Z |
5132674 | 5132674 | 20240916015145_9afZI | UK00AM | 2024-09-19T12:16:25.856Z | 2024-09-19T12:16:25.856Z |
5132640 | 5132640 | 20240916014919_jECKZ | UK00AM | 2024-09-19T12:16:24.111Z | 2024-09-19T12:16:24.111Z |
5132573 | 5132573 | 20240916013307_N3s7Z | UK00AM | 2024-09-19T12:16:19.371Z | 2024-09-19T12:16:19.371Z |
5132545 | 5132545 | 20240916012624_l27ZM | UK00AM | 2024-09-19T12:16:17.830Z | 2024-09-19T12:16:17.830Z |
5132539 | 5132539 | 20240916012618_St0Z6 | UK00AM | 2024-09-19T12:16:17.653Z | 2024-09-19T12:16:17.653Z |
5132527 | 5132527 | 20240916012417_VjU0M | UK00AM | 2024-09-19T12:16:16.748Z | 2024-09-19T12:16:16.748Z |
5132505 | 5132505 | 20240916012011_UgT2Z | UK00AM | 2024-09-19T12:16:15.844Z | 2024-09-19T12:16:15.844Z |
5132487 | 5132487 | 20240916011537_8Z6Pz | UK00AM | 2024-09-19T12:16:14.669Z | 2024-09-19T12:16:14.669Z |
5132476 | 5132476 | 20240916011528_gDqpw | UK00AM | 2024-09-19T12:16:14.092Z | 2024-09-19T12:16:14.092Z |
5132455 | 5132455 | 20240916011124_Apx3N | UK00AM | 2024-09-19T12:16:13.626Z | 2024-09-19T12:16:13.626Z |
5132452 | 5132452 | 20240916011101_99Y5G | UK00AM | 2024-09-19T12:16:13.528Z | 2024-09-19T12:16:13.528Z |
5132387 | 5132387 | 20240916005612_ukF6O | UK00AM | 2024-09-19T12:16:10.143Z | 2024-09-19T12:16:10.143Z |
5132369 | 5132369 | 20240916005201_5RaLE | UK00AM | 2024-09-19T12:16:09.672Z | 2024-09-19T12:16:09.672Z |
5132364 | 5132364 | 20240916005201_G2aMl | UK00AM | 2024-09-19T12:16:09.444Z | 2024-09-19T12:16:09.444Z |
5132333 | 5132333 | 20240916003406_NOwYh | UK00AM | 2024-09-19T12:16:07.446Z | 2024-09-19T12:16:07.446Z |
5132314 | 5132314 | 20240916003156_lj24Q | UK00AM | 2024-09-19T12:16:05.110Z | 2024-09-19T12:16:05.110Z |
5132238 | 5132238 | 20240916000934_ad0L4 | UK00AM | 2024-09-19T12:16:00.008Z | 2024-09-19T12:16:00.008Z |
5132225 | 5132225 | 20240916000728_thWp5 | UK00AM | 2024-09-19T12:15:59.618Z | 2024-09-19T12:15:59.618Z |
5132219 | 5132219 | 20240916000305_wezP8 | UK00AM | 2024-09-19T12:15:59.074Z | 2024-09-19T12:15:59.074Z |
5132205 | 5132205 | 20240915235944_fAYNJ | UK00AM | 2024-09-19T12:15:58.337Z | 2024-09-19T12:15:58.337Z |
5132042 | 5132042 | 20240915225218_b8X6y | UK00AM | 2024-09-19T12:15:44.768Z | 2024-09-19T12:15:44.768Z |
5131959 | 5131959 | 20240915222340_a3ikz | UK00AM | 2024-09-19T12:15:37.375Z | 2024-09-19T12:15:37.375Z |
5131922 | 5131922 | 20240915221409_y63vZ | UK00AM | 2024-09-19T12:15:34.076Z | 2024-09-19T12:15:34.076Z |
5131911 | 5131911 | 20240915221137_gLIa3 | UK00AM | 2024-09-19T12:15:33.754Z | 2024-09-19T12:15:33.754Z |
5131885 | 5131885 | 20240915220029_xDUD3 | UK00AM | 2024-09-19T12:15:32.238Z | 2024-09-19T12:15:32.238Z |
5129619 | 5129619 | 20240917041350_8Ytfi | UK00AM | 2024-09-19T12:11:54.024Z | 2024-09-19T12:11:54.024Z |
5129611 | 5129611 | 20240917041328_zkJ2z | UK00AM | 2024-09-19T12:11:53.455Z | 2024-09-19T12:11:53.455Z |
5129333 | 5129333 | 20240917034940_Z32Lr | UK00AM | 2024-09-19T12:11:29.344Z | 2024-09-19T12:11:29.344Z |
5129309 | 5129309 | 20240917034654_gA6cd | UK00AM | 2024-09-19T12:11:26.439Z | 2024-09-19T12:11:26.439Z |
5129150 | 5129150 | 20240917033004_wa4gT | UK00AM | 2024-09-19T12:11:17.525Z | 2024-09-19T12:11:17.525Z |
5129048 | 5129048 | 20240917031136_L1khT | UK00AM | 2024-09-19T12:11:12.675Z | 2024-09-19T12:11:12.675Z |
5128953 | 5128953 | 20240917030146_KRAl1 | UK00AM | 2024-09-19T12:11:09.333Z | 2024-09-19T12:11:09.333Z |
5128680 | 5128680 | 20240917022337_4JaNX | UK00AM | 2024-09-19T12:10:55.289Z | 2024-09-19T12:10:55.289Z |
5128464 | 5128464 | 20240917014556_EpX3t | UK00AM | 2024-09-19T12:10:36.539Z | 2024-09-19T12:10:36.539Z |
5128087 | 5128087 | 20240917003411_AqYOW | UK00AM | 2024-09-19T12:10:02.396Z | 2024-09-19T12:10:02.396Z |
5128036 | 5128036 | 20240917002452_Mtvn2 | UK00AM | 2024-09-19T12:09:55.547Z | 2024-09-19T12:09:55.547Z |
5128019 | 5128019 | 20240917002016_VD3L1 | UK00AM | 2024-09-19T12:09:54.376Z | 2024-09-19T12:09:54.376Z |
5127375 | 5127375 | 20240916213800_XYuxG | UK00AM | 2024-09-19T12:09:00.372Z | 2024-09-19T12:09:00.372Z |
5127341 | 5127341 | 20240916213349_JBE61 | UK00AM | 2024-09-19T12:08:55.257Z | 2024-09-19T12:08:55.257Z |
5127026 | 5127026 | 20240916201329_ymCXW | UK00AM | 2024-09-19T12:07:54.562Z | 2024-09-19T12:07:54.562Z |
5126998 | 5126998 | 20240916200351_LJ4N3 | UK00AM | 2024-09-19T12:07:50.490Z | 2024-09-19T12:07:50.490Z |
5124531 | 5124531 | 20240917205551_GBozT | UK00AM | 2024-09-19T12:01:05.529Z | 2024-09-19T12:06:41.907Z |
5122050 | 5122050 | 20240914042919_kBCVX | UK00AM | 2024-09-18T12:11:05.171Z | 2024-09-19T12:20:02.713Z |
5121820 | 5121820 | 20240914041445_8V42i | UK00AM | 2024-09-18T12:11:01.619Z | 2024-09-19T12:20:02.386Z |
5121529 | 5121529 | 20240914040751_ERo2K | UK00AM | 2024-09-18T12:10:57.976Z | 2024-09-19T12:20:02.083Z |
5121522 | 5121522 | 20240914040750_ae4sy | UK00AM | 2024-09-18T12:10:57.908Z | 2024-09-19T12:20:02.082Z |
5120878 | 5120878 | 20240914034010_S7Zzk | UK00AM | 2024-09-18T12:10:48.365Z | 2024-09-19T12:20:00.994Z |
5120528 | 5120528 | 20240914032631_UikgF | UK00AM | 2024-09-18T12:10:42.874Z | 2024-09-19T12:20:00.561Z |
5120403 | 5120403 | 20240914031928_Z7jJ3 | UK00AM | 2024-09-18T12:10:39.180Z | 2024-09-19T12:20:00.089Z |
5120348 | 5120348 | 20240914031645_ly1cL | UK00AM | 2024-09-18T12:10:37.882Z | 2024-09-19T12:19:59.957Z |
5119890 | 5119890 | 20240914025141_uCbHb | UK00AM | 2024-09-18T12:10:28.432Z | 2024-09-19T12:19:59.053Z |
5117387 | 5117387 | 20240915042327_NDted | UK00AM | 2024-09-18T12:07:39.496Z | 2024-09-19T12:19:14.649Z |
5117285 | 5117285 | 20240915041627_a3TeT | UK00AM | 2024-09-18T12:07:37.092Z | 2024-09-19T12:19:14.144Z |
5117193 | 5117193 | 20240915041110_Jqtig | UK00AM | 2024-09-18T12:07:35.020Z | 2024-09-19T12:19:13.767Z |
5116773 | 5116773 | 20240915034120_vq4jI | UK00AM | 2024-09-18T12:07:20.556Z | 2024-09-19T12:19:12.340Z |
5116326 | 5116326 | 20240915032139_auUX1 | UK00AM | 2024-09-18T12:06:57.244Z | 2024-09-19T12:19:10.364Z |
5116156 | 5116156 | 20240915031223_s9K6J | UK00AM | 2024-09-18T12:06:44.370Z | 2024-09-19T12:19:09.025Z |
5116109 | 5116109 | 20240915030859_mJL9F | UK00AM | 2024-09-18T12:06:40.271Z | 2024-09-19T12:19:08.730Z |
5115499 | 5115499 | 20240915024213_rWJl7 | UK00AM | 2024-09-18T12:06:16.290Z | 2024-09-19T12:19:05.073Z |
5115373 | 5115373 | 20240915023515_zDfX8 | UK00AM | 2024-09-18T12:06:11.906Z | 2024-09-19T12:19:04.067Z |
5115293 | 5115293 | 20240915023113_oy2q4 | UK00AM | 2024-09-18T12:06:10.087Z | 2024-09-19T12:19:03.776Z |
5115220 | 5115220 | 20240915022746_zQh1s | UK00AM | 2024-09-18T12:06:06.993Z | 2024-09-19T12:19:03.115Z |
5115205 | 5115205 | 20240915022647_i0Vt5 | UK00AM | 2024-09-18T12:06:06.203Z | 2024-09-19T12:19:03.000Z |
5115200 | 5115200 | 20240915022642_3UIH3 | UK00AM | 2024-09-18T12:06:06.026Z | 2024-09-19T12:19:02.965Z |
5114924 | 5114924 | 20240915020738_X45uT | UK00AM | 2024-09-18T12:05:42.432Z | 2024-09-19T12:19:00.562Z |
5114423 | 5114423 | 20240915014110_JrNif | UK00AM | 2024-09-18T12:05:14.433Z | 2024-09-19T12:18:57.943Z |
5114330 | 5114330 | 20240915013642_J2rXY | UK00AM | 2024-09-18T12:05:10.763Z | 2024-09-19T12:18:57.541Z |
5114074 | 5114074 | 20240915012450_R1z3y | UK00AM | 2024-09-18T12:05:00.662Z | 2024-09-19T12:18:55.699Z |
5113896 | 5113896 | 20240915011750_GE31n | UK00AM | 2024-09-18T12:04:54.749Z | 2024-09-19T12:18:54.042Z |
5113874 | 5113874 | 20240915011647_jieeG | UK00AM | 2024-09-18T12:04:53.951Z | 2024-09-19T12:18:53.951Z |
5113602 | 5113602 | 20240915010038_yynXa | UK00AM | 2024-09-18T12:04:34.570Z | 2024-09-19T12:18:50.528Z |
5113534 | 5113534 | 20240915005619_DAKxN | UK00AM | 2024-09-18T12:04:26.685Z | 2024-09-19T12:18:50.056Z |
5113129 | 5113129 | 20240915002347_Y6L38 | UK00AM | 2024-09-18T12:03:57.706Z | 2024-09-19T12:18:47.176Z |
5113043 | 5113043 | 20240915001649_t9UHd | UK00AM | 2024-09-18T12:03:52.782Z | 2024-09-19T12:18:46.683Z |
5112875 | 5112875 | 20240915000328_gXDS2 | UK00AM | 2024-09-18T12:03:44.791Z | 2024-09-19T12:18:45.487Z |
5112872 | 5112872 | 20240915000243_Te3L2 | UK00AM | 2024-09-18T12:03:44.548Z | 2024-09-19T12:18:45.463Z |
5112750 | 5112750 | 20240914234820_iCJNL | UK00AM | 2024-09-18T12:03:27.224Z | 2024-09-19T12:18:44.245Z |
5112686 | 5112686 | 20240914234145_AWkK2 | UK00AM | 2024-09-18T12:03:21.787Z | 2024-09-19T12:18:43.005Z |
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);