participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,945 rows where station_code = "UK003Y" 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 |
---|---|---|---|---|---|
5497886 | 5497886 | 20241107054949_66jT6 | UK003Y | 2024-11-08T14:14:29.027Z | 2024-11-09T14:18:53.231Z |
5497877 | 5497877 | 20241107054039_Oc9A1 | UK003Y | 2024-11-08T14:14:28.639Z | 2024-11-09T14:18:53.040Z |
5497835 | 5497835 | 20241107052923_yC719 | UK003Y | 2024-11-08T14:14:25.712Z | 2024-11-09T14:18:52.588Z |
5497823 | 5497823 | 20241107052331_hGOyG | UK003Y | 2024-11-08T14:14:25.217Z | 2024-11-09T14:18:52.464Z |
5400167 | 5400167 | 20241026054809_zM12p | UK003Y | 2024-10-28T12:20:25.275Z | 2024-11-03T14:27:41.451Z |
5399541 | 5399541 | 20241026043330_T2J2E | UK003Y | 2024-10-28T12:20:01.760Z | 2024-11-03T14:27:39.943Z |
5399218 | 5399218 | 20241026040219_cdA3y | UK003Y | 2024-10-28T12:19:51.594Z | 2024-11-03T14:27:39.253Z |
5399181 | 5399181 | 20241026035937_oYHlK | UK003Y | 2024-10-28T12:19:50.765Z | 2024-11-03T14:27:39.194Z |
5385320 | 5385320 | 20241024222452_FZqAg | UK003Y | 2024-10-27T12:18:44.490Z | 2024-11-02T12:28:29.545Z |
5385297 | 5385297 | 20241024222020_xbFCQ | UK003Y | 2024-10-27T12:18:42.754Z | 2024-11-02T12:28:29.535Z |
5384658 | 5384658 | 20241024203347_PTgnd | UK003Y | 2024-10-27T12:17:24.487Z | 2024-11-02T12:28:27.576Z |
5383791 | 5383791 | 20241024190039_aFpvY | UK003Y | 2024-10-27T12:16:09.938Z | 2024-11-02T12:28:26.343Z |
5383571 | 5383571 | 20241024183428_PrrJU | UK003Y | 2024-10-27T12:15:47.572Z | 2024-11-02T12:28:25.767Z |
5383434 | 5383434 | 20241024182103_raDWA | UK003Y | 2024-10-27T12:15:27.421Z | 2024-11-02T12:28:25.308Z |
5378160 | 5378160 | 20241024053337_p3pi0 | UK003Y | 2024-10-26T12:22:56.662Z | 2024-11-01T12:27:03.333Z |
5378011 | 5378011 | 20241024052354_1d37O | UK003Y | 2024-10-26T12:22:52.879Z | 2024-11-01T12:27:03.225Z |
5377998 | 5377998 | 20241024052245_J5e9b | UK003Y | 2024-10-26T12:22:52.499Z | 2024-11-01T12:27:03.220Z |
5377945 | 5377945 | 20241024051818_jgq2t | UK003Y | 2024-10-26T12:22:50.579Z | 2024-11-01T12:27:03.184Z |
5377902 | 5377902 | 20241024051709_aQMcx | UK003Y | 2024-10-26T12:22:49.418Z | 2024-11-01T12:27:03.158Z |
5377642 | 5377642 | 20241024050148_gwgbN | UK003Y | 2024-10-26T12:22:43.046Z | 2024-11-01T12:27:02.691Z |
5376682 | 5376682 | 20241024040833_Ga2b6 | UK003Y | 2024-10-26T12:22:10.289Z | 2024-11-01T12:27:01.741Z |
5376538 | 5376538 | 20241024035934_8yneZ | UK003Y | 2024-10-26T12:22:04.831Z | 2024-11-01T12:27:01.591Z |
5376531 | 5376531 | 20241024035912_Z9JHc | UK003Y | 2024-10-26T12:22:04.646Z | 2024-11-01T12:27:01.591Z |
5376410 | 5376410 | 20241024035405_QmZsR | UK003Y | 2024-10-26T12:22:01.823Z | 2024-11-01T12:27:01.530Z |
5376376 | 5376376 | 20241024035255_X8zth | UK003Y | 2024-10-26T12:21:59.567Z | 2024-11-01T12:27:01.516Z |
5376349 | 5376349 | 20241024035203_gf5Nu | UK003Y | 2024-10-26T12:21:58.574Z | 2024-11-01T12:27:01.507Z |
5376310 | 5376310 | 20241024035045_QbOXP | UK003Y | 2024-10-26T12:21:56.083Z | 2024-11-01T12:27:01.490Z |
5376303 | 5376303 | 20241024035030_pLWSq | UK003Y | 2024-10-26T12:21:56.015Z | 2024-11-01T12:27:01.488Z |
5376242 | 5376242 | 20241024034718_EVCcs | UK003Y | 2024-10-26T12:21:54.627Z | 2024-11-01T12:27:01.471Z |
5376170 | 5376170 | 20241024034449_RVzJc | UK003Y | 2024-10-26T12:21:52.690Z | 2024-11-01T12:27:01.417Z |
5376041 | 5376041 | 20241024033904_9DYTP | UK003Y | 2024-10-26T12:21:48.096Z | 2024-11-01T12:27:01.343Z |
5366326 | 5366326 | 20241024001619_G22Wg | UK003Y | 2024-10-25T12:18:23.419Z | 2024-11-01T12:26:56.872Z |
5366034 | 5366034 | 20241024000215_5XyOC | UK003Y | 2024-10-25T12:18:14.957Z | 2024-11-01T12:26:56.550Z |
5365961 | 5365961 | 20241023235922_ywIRb | UK003Y | 2024-10-25T12:18:12.447Z | 2024-11-01T12:26:56.506Z |
5365764 | 5365764 | 20241023234759_gUr3m | UK003Y | 2024-10-25T12:18:07.394Z | 2024-11-01T12:26:56.400Z |
5365150 | 5365150 | 20241023231704_xp8Dq | UK003Y | 2024-10-25T12:17:47.940Z | 2024-11-01T12:26:55.898Z |
5364732 | 5364732 | 20241023225030_6WyLk | UK003Y | 2024-10-25T12:17:31.767Z | 2024-11-01T12:26:55.602Z |
5362259 | 5362259 | 20241023192106_VMH67 | UK003Y | 2024-10-25T12:14:06.185Z | 2024-11-01T12:26:51.149Z |
5348941 | 5348941 | 20241022191119_uZrpv | UK003Y | 2024-10-24T12:12:37.271Z | 2024-10-31T12:29:54.183Z |
5345373 | 5345373 | 20241022054118_NwSUR | UK003Y | 2024-10-23T12:19:16.395Z | 2024-10-30T12:26:52.568Z |
5345331 | 5345331 | 20241022053722_n1YIZ | UK003Y | 2024-10-23T12:19:14.681Z | 2024-10-30T12:26:52.453Z |
5345327 | 5345327 | 20241022053708_XrMK0 | UK003Y | 2024-10-23T12:19:14.598Z | 2024-10-30T12:26:52.451Z |
5345280 | 5345280 | 20241022053216_61O9M | UK003Y | 2024-10-23T12:19:13.011Z | 2024-10-30T12:26:52.392Z |
5345271 | 5345271 | 20241022053136_60wsu | UK003Y | 2024-10-23T12:19:12.789Z | 2024-10-30T12:26:52.379Z |
5345195 | 5345195 | 20241022052334_Jar2h | UK003Y | 2024-10-23T12:19:09.850Z | 2024-10-30T12:26:52.289Z |
5345178 | 5345178 | 20241022052100_MyeOG | UK003Y | 2024-10-23T12:19:09.487Z | 2024-10-30T12:26:52.280Z |
5344941 | 5344941 | 20241022050016_mPjwl | UK003Y | 2024-10-23T12:18:58.008Z | 2024-10-30T12:26:52.001Z |
5344815 | 5344815 | 20241022044828_frwXv | UK003Y | 2024-10-23T12:18:52.076Z | 2024-10-30T12:26:51.780Z |
5344587 | 5344587 | 20241022043355_6Bwt9 | UK003Y | 2024-10-23T12:18:42.640Z | 2024-10-30T12:26:51.391Z |
5344554 | 5344554 | 20241022043216_22g72 | UK003Y | 2024-10-23T12:18:41.887Z | 2024-10-30T12:26:51.366Z |
5344546 | 5344546 | 20241022043135_jfPft | UK003Y | 2024-10-23T12:18:41.145Z | 2024-10-30T12:26:51.358Z |
5344539 | 5344539 | 20241022043034_e1htL | UK003Y | 2024-10-23T12:18:40.963Z | 2024-10-30T12:26:51.353Z |
5344410 | 5344410 | 20241022041948_K2BQJ | UK003Y | 2024-10-23T12:18:35.885Z | 2024-10-30T12:26:51.223Z |
5344371 | 5344371 | 20241022041735_Q5HIa | UK003Y | 2024-10-23T12:18:33.885Z | 2024-10-30T12:26:51.204Z |
5344225 | 5344225 | 20241022041117_1p6js | UK003Y | 2024-10-23T12:18:28.968Z | 2024-10-30T12:26:51.065Z |
5344212 | 5344212 | 20241022041028_Mt5xo | UK003Y | 2024-10-23T12:18:28.187Z | 2024-10-30T12:26:51.017Z |
5344146 | 5344146 | 20241022040840_9eKjZ | UK003Y | 2024-10-23T12:18:26.227Z | 2024-10-30T12:26:50.966Z |
5344119 | 5344119 | 20241022040631_zu2n7 | UK003Y | 2024-10-23T12:18:24.754Z | 2024-10-30T12:26:50.949Z |
5344117 | 5344117 | 20241022040624_IrHFs | UK003Y | 2024-10-23T12:18:24.413Z | 2024-10-30T12:26:50.946Z |
5344033 | 5344033 | 20241022040237_IgbTU | UK003Y | 2024-10-23T12:18:19.872Z | 2024-10-30T12:26:50.895Z |
5344016 | 5344016 | 20241022040153_Rw53j | UK003Y | 2024-10-23T12:18:19.205Z | 2024-10-30T12:26:50.884Z |
5343967 | 5343967 | 20241022035826_cUiWL | UK003Y | 2024-10-23T12:18:16.552Z | 2024-10-30T12:26:50.827Z |
5343819 | 5343819 | 20241022034731_KjGLr | UK003Y | 2024-10-23T12:18:09.064Z | 2024-10-30T12:26:50.629Z |
5343688 | 5343688 | 20241022034005_i22XR | UK003Y | 2024-10-23T12:18:00.743Z | 2024-10-30T12:26:50.440Z |
5343501 | 5343501 | 20241022033235_clztx | UK003Y | 2024-10-23T12:17:48.465Z | 2024-10-30T12:26:50.109Z |
5343380 | 5343380 | 20241022032625_gMWqR | UK003Y | 2024-10-23T12:17:45.322Z | 2024-10-30T12:26:49.991Z |
5326555 | 5326555 | 20241019185844_biizt | UK003Y | 2024-10-21T12:09:53.968Z | 2024-10-28T12:26:42.042Z |
5326501 | 5326501 | 20241019184313_tIk0s | UK003Y | 2024-10-21T12:09:37.456Z | 2024-10-28T12:26:41.873Z |
5326492 | 5326492 | 20241019184236_HzILy | UK003Y | 2024-10-21T12:09:36.345Z | 2024-10-28T12:26:41.767Z |
5326423 | 5326423 | 20241019182539_BvCrh | UK003Y | 2024-10-21T12:09:24.842Z | 2024-10-28T12:26:41.649Z |
5321662 | 5321662 | 20241018053552_yGBC2 | UK003Y | 2024-10-19T12:08:00.370Z | 2024-10-26T12:27:57.102Z |
5321574 | 5321574 | 20241018051555_VTYQB | UK003Y | 2024-10-19T12:07:49.813Z | 2024-10-26T12:27:57.019Z |
5320102 | 5320102 | 20241017234135_V00ka | UK003Y | 2024-10-19T12:04:36.717Z | 2024-10-26T12:27:54.022Z |
5320096 | 5320096 | 20241017234104_T2Zl2 | UK003Y | 2024-10-19T12:04:36.369Z | 2024-10-26T12:27:54.021Z |
5320077 | 5320077 | 20241017232856_nBOxc | UK003Y | 2024-10-19T12:04:34.104Z | 2024-10-26T12:27:54.005Z |
5319912 | 5319912 | 20241017220514_06uro | UK003Y | 2024-10-19T12:04:06.328Z | 2024-10-26T12:27:53.572Z |
5319836 | 5319836 | 20241017211934_gIvrQ | UK003Y | 2024-10-19T12:03:57.360Z | 2024-10-26T12:27:53.197Z |
5313255 | 5313255 | 20241014042341_p9HoW | UK003Y | 2024-10-16T12:13:59.787Z | 2024-10-22T12:24:44.876Z |
5313247 | 5313247 | 20241014041930_Z3dE6 | UK003Y | 2024-10-16T12:13:59.114Z | 2024-10-22T12:24:44.750Z |
5313231 | 5313231 | 20241014041107_ViUgS | UK003Y | 2024-10-16T12:13:57.901Z | 2024-10-22T12:24:44.661Z |
5313225 | 5313225 | 20241014040840_DNscN | UK003Y | 2024-10-16T12:13:57.169Z | 2024-10-22T12:24:44.545Z |
5313158 | 5313158 | 20241014033524_POlF6 | UK003Y | 2024-10-16T12:13:48.440Z | 2024-10-22T12:24:42.006Z |
5313154 | 5313154 | 20241014033024_Ti2O2 | UK003Y | 2024-10-16T12:13:47.211Z | 2024-10-22T12:24:41.877Z |
5313132 | 5313132 | 20241014032032_3BVE3 | UK003Y | 2024-10-16T12:13:44.575Z | 2024-10-22T12:24:41.583Z |
5313106 | 5313106 | 20241014030131_fuS2n | UK003Y | 2024-10-16T12:13:42.012Z | 2024-10-22T12:24:40.989Z |
5310901 | 5310901 | 20241014213251_GIicr | UK003Y | 2024-10-16T12:07:59.409Z | 2024-10-23T12:24:39.924Z |
5310859 | 5310859 | 20241014210318_5OugE | UK003Y | 2024-10-16T12:07:55.146Z | 2024-10-23T12:24:39.433Z |
5310689 | 5310689 | 20241014194727_6vLcX | UK003Y | 2024-10-16T12:07:26.690Z | 2024-10-23T12:24:36.822Z |
5307864 | 5307864 | 20241014051456_UON6v | UK003Y | 2024-10-16T12:02:27.172Z | 2024-10-23T12:24:09.044Z |
5306888 | 5306888 | 20241014044541_3Vz7K | UK003Y | 2024-10-15T12:08:41.396Z | 2024-10-22T12:24:45.845Z |
5306864 | 5306864 | 20241014043431_o5Ik6 | UK003Y | 2024-10-15T12:08:37.856Z | 2024-10-22T12:24:45.264Z |
5306838 | 5306838 | 20241014041939_dN1uY | UK003Y | 2024-10-15T12:08:30.880Z | 2024-10-22T12:24:44.781Z |
5306820 | 5306820 | 20241014041014_nljGf | UK003Y | 2024-10-15T12:08:27.370Z | 2024-10-22T12:24:44.614Z |
5306726 | 5306726 | 20241014034342_1Q2kh | UK003Y | 2024-10-15T12:08:17.462Z | 2024-10-22T12:24:42.537Z |
5306706 | 5306706 | 20241014034029_eeNx9 | UK003Y | 2024-10-15T12:08:15.298Z | 2024-10-22T12:24:42.263Z |
5306669 | 5306669 | 20241014032824_v5k9Q | UK003Y | 2024-10-15T12:08:10.977Z | 2024-10-22T12:24:41.835Z |
5306613 | 5306613 | 20241014031007_Gk7Jx | UK003Y | 2024-10-15T12:08:05.348Z | 2024-10-22T12:24:41.469Z |
5306526 | 5306526 | 20241014024456_TgnPM | UK003Y | 2024-10-15T12:07:45.581Z | 2024-10-22T12:24:40.420Z |
5306498 | 5306498 | 20241014023904_jbUAA | UK003Y | 2024-10-15T12:07:38.276Z | 2024-10-22T12:24:40.188Z |
5306494 | 5306494 | 20241014023726_90Lyv | UK003Y | 2024-10-15T12:07:36.636Z | 2024-10-22T12:24:40.159Z |
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);