participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,189 rows where station_code = "UK004H" 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 |
---|---|---|---|---|---|
5571023 | 5571023 | 20241120215856_gqScJ | UK004H | 2024-11-22T14:16:19.050Z | 2024-11-22T14:19:22.025Z |
5569766 | 5569766 | 20241120171935_o2iEP | UK004H | 2024-11-22T14:14:05.656Z | 2024-11-22T14:19:21.800Z |
5565320 | 5565320 | 20241120041931_BKxVw | UK004H | 2024-11-21T14:18:46.548Z | 2024-11-22T14:21:45.997Z |
5565041 | 5565041 | 20241120034535_3lqSv | UK004H | 2024-11-21T14:18:23.436Z | 2024-11-22T14:21:40.520Z |
5564587 | 5564587 | 20241120031131_tfBi2 | UK004H | 2024-11-21T14:17:51.799Z | 2024-11-22T14:21:33.783Z |
5563329 | 5563329 | 20241120011703_vBkMX | UK004H | 2024-11-21T14:15:53.950Z | 2024-11-22T14:21:13.100Z |
5562973 | 5562973 | 20241120003504_xl1TV | UK004H | 2024-11-21T14:15:30.507Z | 2024-11-22T14:21:07.424Z |
5562656 | 5562656 | 20241120000233_i1QyL | UK004H | 2024-11-21T14:15:15.717Z | 2024-11-22T14:21:01.890Z |
5562576 | 5562576 | 20241119235306_Nak4W | UK004H | 2024-11-21T14:15:10.815Z | 2024-11-22T14:21:00.730Z |
5558405 | 5558405 | 20241120060220_onvKF | UK004H | 2024-11-21T14:03:12.766Z | 2024-11-22T14:19:21.225Z |
5558172 | 5558172 | 20241120054136_vIE3M | UK004H | 2024-11-21T14:02:38.981Z | 2024-11-22T14:19:21.187Z |
5529655 | 5529655 | 20241112005045_13g4Q | UK004H | 2024-11-13T14:13:04.735Z | 2024-11-20T14:25:47.185Z |
5529336 | 5529336 | 20241112000411_g3mWa | UK004H | 2024-11-13T14:12:23.393Z | 2024-11-20T14:25:42.972Z |
5529322 | 5529322 | 20241112000059_TDgS9 | UK004H | 2024-11-13T14:12:22.004Z | 2024-11-20T14:25:42.804Z |
5529298 | 5529298 | 20241111235836_WJUII | UK004H | 2024-11-13T14:12:20.735Z | 2024-11-20T14:25:42.639Z |
5528131 | 5528131 | 20241111194203_K2Wil | UK004H | 2024-11-13T14:09:59.045Z | 2024-11-20T14:25:25.489Z |
5528112 | 5528112 | 20241111194045_ZhM2K | UK004H | 2024-11-13T14:09:55.284Z | 2024-11-20T14:25:25.287Z |
5527891 | 5527891 | 20241111185440_2nKg7 | UK004H | 2024-11-13T14:09:30.913Z | 2024-11-20T14:25:22.752Z |
5439708 | 5439708 | 20241030202109_Nr1Qd | UK004H | 2024-11-01T12:14:12.934Z | 2024-11-08T14:23:04.964Z |
5433009 | 5433009 | 20241029054305_sW24H | UK004H | 2024-10-31T12:21:42.783Z | 2024-11-06T14:27:29.601Z |
5418626 | 5418626 | 20241027212528_DPz9L | UK004H | 2024-10-30T12:15:54.397Z | 2024-11-05T14:27:10.843Z |
5410751 | 5410751 | 20241027053413_lEolC | UK004H | 2024-10-29T12:18:04.374Z | 2024-11-04T14:29:05.381Z |
5406007 | 5406007 | 20241027011202_lpyJm | UK004H | 2024-10-29T12:13:47.561Z | 2024-11-04T14:28:54.843Z |
5405958 | 5405958 | 20241027011023_tutN1 | UK004H | 2024-10-29T12:13:39.422Z | 2024-11-04T14:28:54.768Z |
5405599 | 5405599 | 20241027004754_a9jpq | UK004H | 2024-10-29T12:13:04.347Z | 2024-11-04T14:28:53.698Z |
5378116 | 5378116 | 20241024052729_nWSLp | UK004H | 2024-10-26T12:22:54.558Z | 2024-11-01T12:27:03.290Z |
5377957 | 5377957 | 20241024051937_918K6 | UK004H | 2024-10-26T12:22:50.896Z | 2024-11-01T12:27:03.200Z |
5377924 | 5377924 | 20241024051758_VhjYU | UK004H | 2024-10-26T12:22:49.812Z | 2024-11-01T12:27:03.165Z |
5377854 | 5377854 | 20241024051450_2f0RI | UK004H | 2024-10-26T12:22:48.535Z | 2024-11-01T12:27:03.090Z |
5343118 | 5343118 | 20241022031004_o1jRG | UK004H | 2024-10-23T12:17:35.163Z | 2024-10-30T12:26:49.412Z |
5340784 | 5340784 | 20241022004724_1rcyO | UK004H | 2024-10-23T12:14:54.223Z | 2024-10-30T12:26:46.305Z |
5334250 | 5334250 | 20241021021300_B6rVG | UK004H | 2024-10-22T12:16:30.759Z | 2024-10-29T12:26:34.993Z |
5333592 | 5333592 | 20241021005808_yCjnB | UK004H | 2024-10-22T12:15:37.089Z | 2024-10-29T12:26:34.432Z |
5333183 | 5333183 | 20241020235553_oeCjZ | UK004H | 2024-10-22T12:14:52.151Z | 2024-10-29T12:26:34.168Z |
5323139 | 5323139 | 20241018213109_1sVqs | UK004H | 2024-10-20T12:05:12.220Z | 2024-10-27T12:28:49.588Z |
5323106 | 5323106 | 20241018203631_feRHK | UK004H | 2024-10-20T12:05:02.028Z | 2024-10-27T12:28:49.505Z |
5321710 | 5321710 | 20241017030103_324IG | UK004H | 2024-10-19T12:10:58.954Z | 2024-10-25T12:24:35.103Z |
5321704 | 5321704 | 20241017025244_GVqi2 | UK004H | 2024-10-19T12:10:56.550Z | 2024-10-25T12:24:34.821Z |
5321698 | 5321698 | 20241018020813_oCh7d | UK004H | 2024-10-19T12:08:08.016Z | 2024-10-26T12:27:54.947Z |
5321696 | 5321696 | 20241018020259_cEQ5P | UK004H | 2024-10-19T12:08:07.712Z | 2024-10-26T12:27:54.903Z |
5321691 | 5321691 | 20241018015513_gFT09 | UK004H | 2024-10-19T12:08:07.405Z | 2024-10-26T12:27:54.701Z |
5290781 | 5290781 | 20241011185523_AN3VN | UK004H | 2024-10-13T12:13:19.461Z | 2024-10-20T12:24:20.206Z |
5285560 | 5285560 | 20241011040446_ZtrN9 | UK004H | 2024-10-12T12:18:16.064Z | 2024-10-19T12:28:03.884Z |
5284389 | 5284389 | 20241011024042_SeYGm | UK004H | 2024-10-12T12:17:19.643Z | 2024-10-19T12:27:55.635Z |
5282979 | 5282979 | 20241011002407_fH39O | UK004H | 2024-10-12T12:16:16.525Z | 2024-10-19T12:27:48.095Z |
5282004 | 5282004 | 20241010200457_5FB35 | UK004H | 2024-10-12T12:15:07.146Z | 2024-10-19T12:27:39.642Z |
5281748 | 5281748 | 20241010192631_dCAzR | UK004H | 2024-10-12T12:14:39.784Z | 2024-10-19T12:27:36.335Z |
5248641 | 5248641 | 20241007050919_VvzVt | UK004H | 2024-10-08T12:02:59.048Z | 2024-10-16T12:21:00.527Z |
5248633 | 5248633 | 20241007050914_voV2Q | UK004H | 2024-10-08T12:02:55.230Z | 2024-10-16T12:21:00.496Z |
5236018 | 5236018 | 20241005001521_XBD2o | UK004H | 2024-10-06T12:17:07.182Z | 2024-10-13T12:26:24.639Z |
5227409 | 5227409 | 20241004012248_4Dnv9 | UK004H | 2024-10-05T12:21:29.739Z | 2024-10-12T12:25:12.746Z |
5192581 | 5192581 | 20240928224939_t39mU | UK004H | 2024-09-30T12:18:47.909Z | 2024-10-06T12:28:25.947Z |
5191736 | 5191736 | 20240928204303_9qahM | UK004H | 2024-09-30T12:18:03.356Z | 2024-10-06T12:28:23.835Z |
5191684 | 5191684 | 20240928203407_eWEy2 | UK004H | 2024-09-30T12:18:00.434Z | 2024-10-06T12:28:23.397Z |
5186177 | 5186177 | 20240929033346_7oiVc | UK004H | 2024-09-30T12:06:15.859Z | 2024-10-07T12:21:19.923Z |
5185906 | 5185906 | 20240929030737_tI5es | UK004H | 2024-09-30T12:05:28.631Z | 2024-10-07T12:21:19.263Z |
5185331 | 5185331 | 20240929021626_Pp6Ha | UK004H | 2024-09-30T12:04:04.002Z | 2024-10-07T12:21:17.588Z |
5184455 | 5184455 | 20240929005633_bdKoO | UK004H | 2024-09-30T12:01:40.964Z | 2024-10-07T12:21:15.129Z |
5178705 | 5178705 | 20240928031353_BOfYX | UK004H | 2024-09-29T12:06:47.741Z | 2024-10-06T12:28:00.536Z |
5177896 | 5177896 | 20240928021907_AY0qp | UK004H | 2024-09-29T12:05:16.832Z | 2024-10-06T12:27:56.584Z |
5177447 | 5177447 | 20240928014131_H1271 | UK004H | 2024-09-29T12:04:18.776Z | 2024-10-06T12:27:55.083Z |
5177109 | 5177109 | 20240928011829_AVgkz | UK004H | 2024-09-29T12:03:41.868Z | 2024-10-06T12:27:54.214Z |
5141849 | 5141849 | 20240920214604_wmifd | UK004H | 2024-09-22T12:00:53.320Z | 2024-09-29T12:21:58.596Z |
5138490 | 5138490 | 20240919195512_2Ts3o | UK004H | 2024-09-21T12:00:21.941Z | 2024-09-28T12:23:07.751Z |
5135895 | 5135895 | 20240918201603_YCtJ0 | UK004H | 2024-09-20T12:00:44.431Z | 2024-09-27T12:19:42.658Z |
5129241 | 5129241 | 20240917033929_mjEu9 | UK004H | 2024-09-19T12:11:24.081Z | 2024-09-25T12:22:29.653Z |
5128465 | 5128465 | 20240917014722_EZJyI | UK004H | 2024-09-19T12:10:37.007Z | 2024-09-25T12:22:25.223Z |
5127897 | 5127897 | 20240917000143_9GapR | UK004H | 2024-09-19T12:09:46.165Z | 2024-09-25T12:22:20.872Z |
5127609 | 5127609 | 20240916223556_JAi7W | UK004H | 2024-09-19T12:09:26.054Z | 2024-09-25T12:22:16.843Z |
5121384 | 5121384 | 20240914035911_Tv6J3 | UK004H | 2024-09-18T12:10:54.723Z | 2024-09-22T12:18:00.559Z |
5121172 | 5121172 | 20240914035440_zfJJC | UK004H | 2024-09-18T12:10:52.106Z | 2024-09-22T12:17:59.832Z |
5120857 | 5120857 | 20240914033748_e0jyq | UK004H | 2024-09-18T12:10:47.980Z | 2024-09-22T12:17:58.276Z |
5120010 | 5120010 | 20240914025625_lO87G | UK004H | 2024-09-18T12:10:31.070Z | 2024-09-22T12:17:56.082Z |
5117439 | 5117439 | 20240915043339_hFYBo | UK004H | 2024-09-18T12:07:41.651Z | 2024-09-23T12:16:24.974Z |
5116034 | 5116034 | 20240915030422_BjdsF | UK004H | 2024-09-18T12:06:35.055Z | 2024-09-23T12:16:20.226Z |
5114187 | 5114187 | 20240915013027_ED8xF | UK004H | 2024-09-18T12:05:05.873Z | 2024-09-23T12:16:12.510Z |
5112525 | 5112525 | 20240914232550_H2UbD | UK004H | 2024-09-18T12:03:12.197Z | 2024-09-23T12:16:04.196Z |
5111911 | 5111911 | 20240914213755_kAAwm | UK004H | 2024-09-18T12:02:30.569Z | 2024-09-23T12:16:01.212Z |
5107999 | 5107999 | 20240913041856_A4Uqs | UK004H | 2024-09-17T12:13:27.533Z | 2024-09-21T12:16:36.912Z |
5107657 | 5107657 | 20240913040748_x4tvX | UK004H | 2024-09-17T12:13:20.790Z | 2024-09-21T12:16:35.988Z |
5106818 | 5106818 | 20240913033542_dZVWo | UK004H | 2024-09-17T12:13:02.125Z | 2024-09-21T12:16:34.293Z |
5106762 | 5106762 | 20240913033355_jgXwb | UK004H | 2024-09-17T12:13:00.753Z | 2024-09-21T12:16:34.224Z |
5106090 | 5106090 | 20240913031041_Kn2zk | UK004H | 2024-09-17T12:12:41.991Z | 2024-09-21T12:16:31.751Z |
5103663 | 5103663 | 20240913013551_Kikf3 | UK004H | 2024-09-17T12:11:07.705Z | 2024-09-21T12:16:25.808Z |
5103136 | 5103136 | 20240914020249_tVOu9 | UK004H | 2024-09-17T12:07:53.719Z | 2024-09-22T12:17:54.525Z |
5099811 | 5099811 | 20240913220632_jQ0bR | UK004H | 2024-09-17T12:03:36.186Z | 2024-09-22T12:17:48.352Z |
5099496 | 5099496 | 20240913212354_QaXZP | UK004H | 2024-09-17T12:03:03.648Z | 2024-09-22T12:17:47.750Z |
5099351 | 5099351 | 20240913210539_NZJ4w | UK004H | 2024-09-17T12:02:48.810Z | 2024-09-22T12:17:47.331Z |
5098779 | 5098779 | 20240913192754_AdEDe | UK004H | 2024-09-17T12:01:35.086Z | 2024-09-22T12:17:44.147Z |
5097137 | 5097137 | 20240913003318_ISyzp | UK004H | 2024-09-16T12:17:05.919Z | 2024-09-21T12:16:19.345Z |
5094837 | 5094837 | 20240912042556_x1sh4 | UK004H | 2024-09-16T12:14:59.343Z | 2024-09-20T12:21:56.005Z |
5094610 | 5094610 | 20240912041229_dzmcA | UK004H | 2024-09-16T12:14:52.549Z | 2024-09-20T12:21:55.614Z |
5094380 | 5094380 | 20240912035914_LegIv | UK004H | 2024-09-16T12:14:43.114Z | 2024-09-20T12:21:55.240Z |
5094321 | 5094321 | 20240912035726_MvYSU | UK004H | 2024-09-16T12:14:41.442Z | 2024-09-20T12:21:55.198Z |
5094257 | 5094257 | 20240912035433_lV9rG | UK004H | 2024-09-16T12:14:40.103Z | 2024-09-20T12:21:55.106Z |
5094182 | 5094182 | 20240912035217_oANe9 | UK004H | 2024-09-16T12:14:38.164Z | 2024-09-20T12:21:55.025Z |
5093371 | 5093371 | 20240912031937_Gkdyr | UK004H | 2024-09-16T12:14:16.120Z | 2024-09-20T12:21:53.383Z |
5093216 | 5093216 | 20240912031506_uvmvL | UK004H | 2024-09-16T12:14:13.426Z | 2024-09-20T12:21:53.028Z |
5093099 | 5093099 | 20240912031124_CDBfh | UK004H | 2024-09-16T12:14:11.684Z | 2024-09-20T12:21:52.807Z |
5091644 | 5091644 | 20240912021648_rICRw | UK004H | 2024-09-16T12:13:15.633Z | 2024-09-20T12:21:48.892Z |
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);