participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,673 rows where station_code = "UK003T" 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 |
---|---|---|---|---|---|
5134056 | 5134056 | 20240916043715_3EjSy | UK003T | 2024-09-19T12:17:17.396Z | 2024-09-19T12:17:17.396Z |
5134008 | 5134008 | 20240916043003_jzPoh | UK003T | 2024-09-19T12:17:15.895Z | 2024-09-19T12:17:15.895Z |
5133981 | 5133981 | 20240916042509_s0S2D | UK003T | 2024-09-19T12:17:15.446Z | 2024-09-19T12:17:15.446Z |
5133828 | 5133828 | 20240916040834_EWxyd | UK003T | 2024-09-19T12:17:10.044Z | 2024-09-19T12:17:10.044Z |
5133768 | 5133768 | 20240916040434_vD9Tv | UK003T | 2024-09-19T12:17:07.426Z | 2024-09-19T12:17:07.426Z |
5133688 | 5133688 | 20240916035051_298Kt | UK003T | 2024-09-19T12:17:05.257Z | 2024-09-19T12:17:05.257Z |
5133653 | 5133653 | 20240916035000_ySRCK | UK003T | 2024-09-19T12:17:04.958Z | 2024-09-19T12:17:04.958Z |
5133629 | 5133629 | 20240916034910_mp5PQ | UK003T | 2024-09-19T12:17:04.332Z | 2024-09-19T12:17:04.332Z |
5133611 | 5133611 | 20240916034744_63kze | UK003T | 2024-09-19T12:17:03.806Z | 2024-09-19T12:17:03.806Z |
5133558 | 5133558 | 20240916034027_d7GAl | UK003T | 2024-09-19T12:17:01.758Z | 2024-09-19T12:17:01.758Z |
5133484 | 5133484 | 20240916033229_MfMLr | UK003T | 2024-09-19T12:16:59.300Z | 2024-09-19T12:16:59.300Z |
5133447 | 5133447 | 20240916033110_5jGcn | UK003T | 2024-09-19T12:16:56.814Z | 2024-09-19T12:16:56.814Z |
5133422 | 5133422 | 20240916032951_wW9CU | UK003T | 2024-09-19T12:16:56.299Z | 2024-09-19T12:16:56.299Z |
5133405 | 5133405 | 20240916032800_zKDzl | UK003T | 2024-09-19T12:16:56.197Z | 2024-09-19T12:16:56.197Z |
5133380 | 5133380 | 20240916032749_bSoYG | UK003T | 2024-09-19T12:16:55.901Z | 2024-09-19T12:16:55.901Z |
5133324 | 5133324 | 20240916032335_geFny | UK003T | 2024-09-19T12:16:54.445Z | 2024-09-19T12:16:54.445Z |
5133183 | 5133183 | 20240916030511_MHH2X | UK003T | 2024-09-19T12:16:46.730Z | 2024-09-19T12:16:46.730Z |
5133157 | 5133157 | 20240916030303_7KrY0 | UK003T | 2024-09-19T12:16:45.953Z | 2024-09-19T12:16:45.953Z |
5133099 | 5133099 | 20240916025621_vpekO | UK003T | 2024-09-19T12:16:44.228Z | 2024-09-19T12:16:44.228Z |
5132901 | 5132901 | 20240916022710_WFR7H | UK003T | 2024-09-19T12:16:35.660Z | 2024-09-19T12:16:35.660Z |
5132886 | 5132886 | 20240916022606_DNFFW | UK003T | 2024-09-19T12:16:35.324Z | 2024-09-19T12:16:35.324Z |
5132853 | 5132853 | 20240916022137_rH5c2 | UK003T | 2024-09-19T12:16:34.481Z | 2024-09-19T12:16:34.481Z |
5132667 | 5132667 | 20240916015145_9afZI | UK003T | 2024-09-19T12:16:25.856Z | 2024-09-19T12:16:25.856Z |
5132625 | 5132625 | 20240916014701_Xhiys | UK003T | 2024-09-19T12:16:23.353Z | 2024-09-19T12:16:23.353Z |
5132542 | 5132542 | 20240916012624_l27ZM | UK003T | 2024-09-19T12:16:17.830Z | 2024-09-19T12:16:17.830Z |
5132518 | 5132518 | 20240916012417_VjU0M | UK003T | 2024-09-19T12:16:16.748Z | 2024-09-19T12:16:16.748Z |
5132372 | 5132372 | 20240916005348_GnncH | UK003T | 2024-09-19T12:16:09.802Z | 2024-09-19T12:16:09.802Z |
5132366 | 5132366 | 20240916005201_5RaLE | UK003T | 2024-09-19T12:16:09.672Z | 2024-09-19T12:16:09.672Z |
5132260 | 5132260 | 20240916001321_0n1p8 | UK003T | 2024-09-19T12:16:02.199Z | 2024-09-19T12:16:02.199Z |
5132215 | 5132215 | 20240916000305_wezP8 | UK003T | 2024-09-19T12:15:59.074Z | 2024-09-19T12:15:59.074Z |
5132149 | 5132149 | 20240915234306_mepEv | UK003T | 2024-09-19T12:15:53.279Z | 2024-09-19T12:15:53.279Z |
5131949 | 5131949 | 20240915222340_a3ikz | UK003T | 2024-09-19T12:15:37.375Z | 2024-09-19T12:15:37.375Z |
5131875 | 5131875 | 20240915220029_xDUD3 | UK003T | 2024-09-19T12:15:32.238Z | 2024-09-19T12:15:32.238Z |
5131519 | 5131519 | 20240915200850_koie8 | UK003T | 2024-09-19T12:15:07.407Z | 2024-09-19T12:15:07.407Z |
5131493 | 5131493 | 20240915200503_K55lN | UK003T | 2024-09-19T12:15:06.388Z | 2024-09-19T12:15:06.388Z |
5129804 | 5129804 | 20240917043553_4Zu1t | UK003T | 2024-09-19T12:12:06.230Z | 2024-09-19T12:12:06.230Z |
5129615 | 5129615 | 20240917041350_8Ytfi | UK003T | 2024-09-19T12:11:54.024Z | 2024-09-19T12:11:54.024Z |
5129573 | 5129573 | 20240917041036_NcG33 | UK003T | 2024-09-19T12:11:49.616Z | 2024-09-19T12:11:49.616Z |
5129460 | 5129460 | 20240917035905_c8PfO | UK003T | 2024-09-19T12:11:40.597Z | 2024-09-19T12:11:40.597Z |
5129415 | 5129415 | 20240917035510_MI92n | UK003T | 2024-09-19T12:11:34.874Z | 2024-09-19T12:11:34.874Z |
5129303 | 5129303 | 20240917034654_gA6cd | UK003T | 2024-09-19T12:11:26.439Z | 2024-09-19T12:11:26.439Z |
5129261 | 5129261 | 20240917034125_OsjUI | UK003T | 2024-09-19T12:11:24.486Z | 2024-09-19T12:11:24.486Z |
5129199 | 5129199 | 20240917033625_JsPFf | UK003T | 2024-09-19T12:11:23.051Z | 2024-09-19T12:11:23.051Z |
5129176 | 5129176 | 20240917033229_xPsAK | UK003T | 2024-09-19T12:11:20.422Z | 2024-09-19T12:11:20.422Z |
5129148 | 5129148 | 20240917033004_wa4gT | UK003T | 2024-09-19T12:11:17.525Z | 2024-09-19T12:11:17.525Z |
5129051 | 5129051 | 20240917031209_wrefG | UK003T | 2024-09-19T12:11:12.878Z | 2024-09-19T12:11:12.878Z |
5129044 | 5129044 | 20240917031136_L1khT | UK003T | 2024-09-19T12:11:12.675Z | 2024-09-19T12:11:12.675Z |
5128946 | 5128946 | 20240917030146_KRAl1 | UK003T | 2024-09-19T12:11:09.333Z | 2024-09-19T12:11:09.333Z |
5128924 | 5128924 | 20240917025528_KxLzw | UK003T | 2024-09-19T12:11:07.819Z | 2024-09-19T12:11:07.819Z |
5128891 | 5128891 | 20240917025210_taz74 | UK003T | 2024-09-19T12:11:05.780Z | 2024-09-19T12:11:05.780Z |
5128832 | 5128832 | 20240917024548_NLBNf | UK003T | 2024-09-19T12:11:03.360Z | 2024-09-19T12:11:03.360Z |
5128668 | 5128668 | 20240917022337_4JaNX | UK003T | 2024-09-19T12:10:55.289Z | 2024-09-19T12:10:55.289Z |
5128497 | 5128497 | 20240917015222_IBDPu | UK003T | 2024-09-19T12:10:39.312Z | 2024-09-19T12:10:39.312Z |
5128286 | 5128286 | 20240917012139_RtkFS | UK003T | 2024-09-19T12:10:25.282Z | 2024-09-19T12:10:25.282Z |
5128282 | 5128282 | 20240917012138_w2DDR | UK003T | 2024-09-19T12:10:24.995Z | 2024-09-19T12:10:24.995Z |
5127779 | 5127779 | 20240916232731_VaeRR | UK003T | 2024-09-19T12:09:37.933Z | 2024-09-19T12:09:37.933Z |
5127746 | 5127746 | 20240916231742_DoQH3 | UK003T | 2024-09-19T12:09:35.762Z | 2024-09-19T12:09:35.762Z |
5127511 | 5127511 | 20240916221318_Q9u33 | UK003T | 2024-09-19T12:09:16.226Z | 2024-09-19T12:09:16.226Z |
5127481 | 5127481 | 20240916221109_8S1uG | UK003T | 2024-09-19T12:09:14.987Z | 2024-09-19T12:09:14.987Z |
5126989 | 5126989 | 20240916200351_LJ4N3 | UK003T | 2024-09-19T12:07:50.490Z | 2024-09-19T12:07:50.490Z |
5124821 | 5124821 | 20240917221045_2PT9s | UK003T | 2024-09-19T12:01:38.289Z | 2024-09-19T12:06:41.939Z |
5124740 | 5124740 | 20240917215711_Pr9ND | UK003T | 2024-09-19T12:01:30.814Z | 2024-09-19T12:06:41.930Z |
5117190 | 5117190 | 20240915041110_Jqtig | UK003T | 2024-09-18T12:07:35.020Z | 2024-09-19T12:19:13.767Z |
5117129 | 5117129 | 20240915040406_W3JjZ | UK003T | 2024-09-18T12:07:33.253Z | 2024-09-19T12:19:13.451Z |
5116531 | 5116531 | 20240915033116_Lx8aQ | UK003T | 2024-09-18T12:07:09.025Z | 2024-09-19T12:19:11.487Z |
5116213 | 5116213 | 20240915031627_Ym6j5 | UK003T | 2024-09-18T12:06:49.288Z | 2024-09-19T12:19:09.905Z |
5116153 | 5116153 | 20240915031223_s9K6J | UK003T | 2024-09-18T12:06:44.370Z | 2024-09-19T12:19:09.025Z |
5116142 | 5116142 | 20240915031156_ahNCo | UK003T | 2024-09-18T12:06:43.795Z | 2024-09-19T12:19:08.957Z |
5116105 | 5116105 | 20240915030859_mJL9F | UK003T | 2024-09-18T12:06:40.271Z | 2024-09-19T12:19:08.730Z |
5116088 | 5116088 | 20240915030739_HcUId | UK003T | 2024-09-18T12:06:38.699Z | 2024-09-19T12:19:08.625Z |
5116068 | 5116068 | 20240915030714_e97Xy | UK003T | 2024-09-18T12:06:36.742Z | 2024-09-19T12:19:08.385Z |
5115813 | 5115813 | 20240915025415_7Df7e | UK003T | 2024-09-18T12:06:25.068Z | 2024-09-19T12:19:07.389Z |
5115750 | 5115750 | 20240915025136_KNTj4 | UK003T | 2024-09-18T12:06:22.765Z | 2024-09-19T12:19:06.744Z |
5115527 | 5115527 | 20240915024416_4zErU | UK003T | 2024-09-18T12:06:17.176Z | 2024-09-19T12:19:05.189Z |
5115497 | 5115497 | 20240915024213_rWJl7 | UK003T | 2024-09-18T12:06:16.289Z | 2024-09-19T12:19:05.073Z |
5115369 | 5115369 | 20240915023515_zDfX8 | UK003T | 2024-09-18T12:06:11.905Z | 2024-09-19T12:19:04.067Z |
5115288 | 5115288 | 20240915023113_oy2q4 | UK003T | 2024-09-18T12:06:10.087Z | 2024-09-19T12:19:03.776Z |
5115217 | 5115217 | 20240915022746_zQh1s | UK003T | 2024-09-18T12:06:06.992Z | 2024-09-19T12:19:03.115Z |
5115202 | 5115202 | 20240915022647_i0Vt5 | UK003T | 2024-09-18T12:06:06.203Z | 2024-09-19T12:19:03.000Z |
5115141 | 5115141 | 20240915022156_JYzH9 | UK003T | 2024-09-18T12:06:03.175Z | 2024-09-19T12:19:02.552Z |
5115095 | 5115095 | 20240915022002_IkHk4 | UK003T | 2024-09-18T12:05:58.907Z | 2024-09-19T12:19:01.591Z |
5114918 | 5114918 | 20240915020738_X45uT | UK003T | 2024-09-18T12:05:42.432Z | 2024-09-19T12:19:00.562Z |
5114416 | 5114416 | 20240915014110_JrNif | UK003T | 2024-09-18T12:05:14.418Z | 2024-09-19T12:18:57.943Z |
5114071 | 5114071 | 20240915012450_R1z3y | UK003T | 2024-09-18T12:05:00.661Z | 2024-09-19T12:18:55.699Z |
5113889 | 5113889 | 20240915011750_GE31n | UK003T | 2024-09-18T12:04:54.749Z | 2024-09-19T12:18:54.042Z |
5113872 | 5113872 | 20240915011647_jieeG | UK003T | 2024-09-18T12:04:53.951Z | 2024-09-19T12:18:53.951Z |
5113591 | 5113591 | 20240915010038_yynXa | UK003T | 2024-09-18T12:04:34.530Z | 2024-09-19T12:18:50.527Z |
5031854 | 5031854 | 20240906233231_KJL0L | UK003T | 2024-09-12T12:05:56.948Z | 2024-09-15T12:21:24.442Z |
5031708 | 5031708 | 20240906230440_m3oDt | UK003T | 2024-09-12T12:05:30.069Z | 2024-09-15T12:21:23.920Z |
5031701 | 5031701 | 20240906230201_8zWaF | UK003T | 2024-09-12T12:05:26.570Z | 2024-09-15T12:21:23.898Z |
5031397 | 5031397 | 20240906214020_M49si | UK003T | 2024-09-12T12:04:41.628Z | 2024-09-15T12:21:22.204Z |
5019388 | 5019388 | 20240904224213_1LX13 | UK003T | 2024-09-10T12:12:41.693Z | 2024-09-13T12:19:51.682Z |
5019369 | 5019369 | 20240904223926_TLJQX | UK003T | 2024-09-10T12:12:40.646Z | 2024-09-13T12:19:51.513Z |
5019218 | 5019218 | 20240904221100_bmSD9 | UK003T | 2024-09-10T12:12:23.884Z | 2024-09-13T12:19:51.017Z |
5018760 | 5018760 | 20240904200838_MJ3uf | UK003T | 2024-09-10T12:11:30.854Z | 2024-09-13T12:19:48.833Z |
5008589 | 5008589 | 20240903235936_BV24B | UK003T | 2024-09-09T12:06:54.511Z | 2024-09-12T12:19:18.249Z |
5008546 | 5008546 | 20240903235309_he92j | UK003T | 2024-09-09T12:06:52.546Z | 2024-09-12T12:19:18.041Z |
5008541 | 5008541 | 20240903235247_xPno1 | UK003T | 2024-09-09T12:06:52.252Z | 2024-09-12T12:19:18.036Z |
5008439 | 5008439 | 20240903234421_iMtqP | UK003T | 2024-09-09T12:06:44.625Z | 2024-09-12T12:19:17.630Z |
5008405 | 5008405 | 20240903234033_2voIW | UK003T | 2024-09-09T12:06:42.757Z | 2024-09-12T12:19:17.477Z |
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);