participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,760 rows where station_code = "UK005J" 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 |
---|---|---|---|---|---|
5503372 | 5503372 | 20241107215914_lt4rL | UK005J | 2024-11-09T14:12:55.834Z | 2024-11-09T14:16:28.233Z |
5502766 | 5502766 | 20241107194258_VaIM0 | UK005J | 2024-11-09T14:12:02.351Z | 2024-11-09T14:16:28.093Z |
5497352 | 5497352 | 20241107032721_l3YBS | UK005J | 2024-11-08T14:13:37.194Z | 2024-11-09T14:18:41.461Z |
5497330 | 5497330 | 20241107032301_mi2qt | UK005J | 2024-11-08T14:13:33.930Z | 2024-11-09T14:18:40.904Z |
5497315 | 5497315 | 20241107032140_QZv37 | UK005J | 2024-11-08T14:13:31.849Z | 2024-11-09T14:18:40.603Z |
5497283 | 5497283 | 20241107031401_hxRNP | UK005J | 2024-11-08T14:13:29.580Z | 2024-11-09T14:18:39.971Z |
5497230 | 5497230 | 20241107030058_sWOyb | UK005J | 2024-11-08T14:13:25.108Z | 2024-11-09T14:18:37.723Z |
5497199 | 5497199 | 20241107025445_E9wsf | UK005J | 2024-11-08T14:13:20.592Z | 2024-11-09T14:18:36.867Z |
5497060 | 5497060 | 20241107023547_ytDlI | UK005J | 2024-11-08T14:13:07.721Z | 2024-11-09T14:18:34.852Z |
5497013 | 5497013 | 20241107022711_HTGQv | UK005J | 2024-11-08T14:13:05.142Z | 2024-11-09T14:18:34.299Z |
5496947 | 5496947 | 20241107021424_2Ra9G | UK005J | 2024-11-08T14:13:00.285Z | 2024-11-09T14:18:33.479Z |
5496810 | 5496810 | 20241107014421_o5mc4 | UK005J | 2024-11-08T14:12:52.975Z | 2024-11-09T14:18:30.686Z |
5496698 | 5496698 | 20241107012017_VUcvj | UK005J | 2024-11-08T14:12:43.634Z | 2024-11-09T14:18:27.722Z |
5496659 | 5496659 | 20241107011058_k0qfz | UK005J | 2024-11-08T14:12:38.295Z | 2024-11-09T14:18:27.123Z |
5496571 | 5496571 | 20241107005502_L33MJ | UK005J | 2024-11-08T14:12:26.586Z | 2024-11-09T14:18:25.413Z |
5496548 | 5496548 | 20241107005112_33Jv4 | UK005J | 2024-11-08T14:12:23.844Z | 2024-11-09T14:18:24.803Z |
5496393 | 5496393 | 20241107001220_12mX5 | UK005J | 2024-11-08T14:12:06.405Z | 2024-11-09T14:18:21.675Z |
5496275 | 5496275 | 20241106234446_kVRcY | UK005J | 2024-11-08T14:11:53.352Z | 2024-11-09T14:18:19.408Z |
5496266 | 5496266 | 20241106234158_701HB | UK005J | 2024-11-08T14:11:52.304Z | 2024-11-09T14:18:19.346Z |
5496260 | 5496260 | 20241106234115_wI8ti | UK005J | 2024-11-08T14:11:51.986Z | 2024-11-09T14:18:19.219Z |
5496242 | 5496242 | 20241106233523_Sg47t | UK005J | 2024-11-08T14:11:50.629Z | 2024-11-09T14:18:19.007Z |
5496225 | 5496225 | 20241106233124_vDiij | UK005J | 2024-11-08T14:11:48.449Z | 2024-11-09T14:18:18.638Z |
5496176 | 5496176 | 20241106231546_oVeD8 | UK005J | 2024-11-08T14:11:43.285Z | 2024-11-09T14:18:17.611Z |
5496158 | 5496158 | 20241106231042_p4xw8 | UK005J | 2024-11-08T14:11:40.216Z | 2024-11-09T14:18:17.142Z |
5496104 | 5496104 | 20241106225512_GuY3a | UK005J | 2024-11-08T14:11:34.560Z | 2024-11-09T14:18:16.244Z |
5495993 | 5495993 | 20241106223312_BWCxc | UK005J | 2024-11-08T14:11:19.716Z | 2024-11-09T14:18:14.125Z |
5495963 | 5495963 | 20241106222318_vPVt2 | UK005J | 2024-11-08T14:11:14.135Z | 2024-11-09T14:18:13.018Z |
5495842 | 5495842 | 20241106214430_uRWGO | UK005J | 2024-11-08T14:10:59.871Z | 2024-11-09T14:18:10.215Z |
5495704 | 5495704 | 20241106210621_o1Z90 | UK005J | 2024-11-08T14:10:39.354Z | 2024-11-09T14:18:05.082Z |
5495612 | 5495612 | 20241106203741_TRKpF | UK005J | 2024-11-08T14:10:28.649Z | 2024-11-09T14:18:01.299Z |
5491775 | 5491775 | 20241106050603_SECqV | UK005J | 2024-11-07T14:16:57.200Z | 2024-11-09T14:20:14.530Z |
5491712 | 5491712 | 20241106043904_TRiZa | UK005J | 2024-11-07T14:16:50.284Z | 2024-11-09T14:20:13.409Z |
5491640 | 5491640 | 20241106041205_KPRD0 | UK005J | 2024-11-07T14:16:35.804Z | 2024-11-09T14:20:12.154Z |
5491633 | 5491633 | 20241106040935_qVbkR | UK005J | 2024-11-07T14:16:34.204Z | 2024-11-09T14:20:12.143Z |
5491454 | 5491454 | 20241106032016_23QEx | UK005J | 2024-11-07T14:16:10.004Z | 2024-11-09T14:20:08.680Z |
5491419 | 5491419 | 20241106031446_6SVSn | UK005J | 2024-11-07T14:16:05.535Z | 2024-11-09T14:20:07.476Z |
5491369 | 5491369 | 20241106030547_i8XIg | UK005J | 2024-11-07T14:15:58.839Z | 2024-11-09T14:20:07.215Z |
5491332 | 5491332 | 20241106025712_3uROS | UK005J | 2024-11-07T14:15:53.297Z | 2024-11-09T14:20:06.838Z |
5491284 | 5491284 | 20241106024840_j7GU1 | UK005J | 2024-11-07T14:15:46.868Z | 2024-11-09T14:20:06.315Z |
5491223 | 5491223 | 20241106022731_KFUO8 | UK005J | 2024-11-07T14:15:33.614Z | 2024-11-09T14:20:05.702Z |
5491210 | 5491210 | 20241106022158_TLw4y | UK005J | 2024-11-07T14:15:31.176Z | 2024-11-09T14:20:05.549Z |
5491177 | 5491177 | 20241106021643_C9cya | UK005J | 2024-11-07T14:15:24.718Z | 2024-11-09T14:20:04.833Z |
5491113 | 5491113 | 20241106020220_yZBGi | UK005J | 2024-11-07T14:15:19.659Z | 2024-11-09T14:20:04.059Z |
5490919 | 5490919 | 20241106011500_0GhD2 | UK005J | 2024-11-07T14:15:05.534Z | 2024-11-09T14:20:01.687Z |
5490723 | 5490723 | 20241106002230_vAN7Y | UK005J | 2024-11-07T14:14:41.792Z | 2024-11-09T14:19:58.900Z |
5490624 | 5490624 | 20241105234103_a14gM | UK005J | 2024-11-07T14:14:19.177Z | 2024-11-09T14:19:57.404Z |
5490552 | 5490552 | 20241105232428_fE8un | UK005J | 2024-11-07T14:14:11.774Z | 2024-11-09T14:19:56.904Z |
5490527 | 5490527 | 20241105231627_OltLx | UK005J | 2024-11-07T14:14:09.502Z | 2024-11-09T14:19:56.681Z |
5490497 | 5490497 | 20241105230855_Rqdk7 | UK005J | 2024-11-07T14:14:06.268Z | 2024-11-09T14:19:56.235Z |
5490493 | 5490493 | 20241105230601_yTIc0 | UK005J | 2024-11-07T14:14:05.903Z | 2024-11-09T14:19:56.185Z |
5490491 | 5490491 | 20241105230509_29WMk | UK005J | 2024-11-07T14:14:05.634Z | 2024-11-09T14:19:56.152Z |
5490440 | 5490440 | 20241105224809_7DJ4n | UK005J | 2024-11-07T14:14:01.774Z | 2024-11-09T14:19:55.509Z |
5490406 | 5490406 | 20241105223647_2Zpxu | UK005J | 2024-11-07T14:13:58.904Z | 2024-11-09T14:19:54.909Z |
5490334 | 5490334 | 20241105221519_VtVSo | UK005J | 2024-11-07T14:13:53.530Z | 2024-11-09T14:19:53.933Z |
5490193 | 5490193 | 20241105213820_NxUzZ | UK005J | 2024-11-07T14:13:32.803Z | 2024-11-09T14:19:52.009Z |
5490189 | 5490189 | 20241105213331_T8DYi | UK005J | 2024-11-07T14:13:31.807Z | 2024-11-09T14:19:51.840Z |
5490169 | 5490169 | 20241105213003_j2fZP | UK005J | 2024-11-07T14:13:25.970Z | 2024-11-09T14:19:51.708Z |
5490133 | 5490133 | 20241105211624_793pw | UK005J | 2024-11-07T14:13:18.224Z | 2024-11-09T14:19:51.272Z |
5489982 | 5489982 | 20241105203821_51bX6 | UK005J | 2024-11-07T14:12:59.414Z | 2024-11-09T14:19:49.670Z |
5485653 | 5485653 | 20241103045343_bZgOk | UK005J | 2024-11-06T14:23:36.479Z | 2024-11-09T14:23:04.475Z |
5485651 | 5485651 | 20241103033128_IKr9K | UK005J | 2024-11-06T14:23:29.011Z | 2024-11-09T14:23:02.677Z |
5485649 | 5485649 | 20241103031336_UKt2q | UK005J | 2024-11-06T14:23:27.054Z | 2024-11-09T14:23:02.252Z |
5485647 | 5485647 | 20241102235908_1qBFW | UK005J | 2024-11-06T14:23:13.047Z | 2024-11-09T14:22:57.732Z |
5485645 | 5485645 | 20241102224041_3ELU5 | UK005J | 2024-11-06T14:23:04.826Z | 2024-11-09T14:22:55.710Z |
5485639 | 5485639 | 20241102211219_JVZKH | UK005J | 2024-11-06T14:22:57.986Z | 2024-11-09T14:22:54.438Z |
5470090 | 5470090 | 20241103052825_g8bDZ | UK005J | 2024-11-04T14:17:47.411Z | 2024-11-09T14:23:05.368Z |
5469972 | 5469972 | 20241103045839_ZnZE2 | UK005J | 2024-11-04T14:17:28.281Z | 2024-11-09T14:23:04.495Z |
5469937 | 5469937 | 20241103044852_miuYb | UK005J | 2024-11-04T14:17:23.690Z | 2024-11-09T14:23:04.364Z |
5469432 | 5469432 | 20241103032550_fAUkh | UK005J | 2024-11-04T14:16:27.540Z | 2024-11-09T14:23:02.569Z |
5469414 | 5469414 | 20241103032405_rkJGW | UK005J | 2024-11-04T14:16:26.007Z | 2024-11-09T14:23:02.476Z |
5469205 | 5469205 | 20241103024800_EHeJt | UK005J | 2024-11-04T14:15:54.501Z | 2024-11-09T14:23:01.282Z |
5469128 | 5469128 | 20241103023947_LcL2b | UK005J | 2024-11-04T14:15:41.902Z | 2024-11-09T14:23:01.036Z |
5469089 | 5469089 | 20241103023430_xsiYi | UK005J | 2024-11-04T14:15:35.554Z | 2024-11-09T14:23:00.947Z |
5469086 | 5469086 | 20241103023352_OcnTU | UK005J | 2024-11-04T14:15:35.352Z | 2024-11-09T14:23:00.896Z |
5468905 | 5468905 | 20241103020711_6C70U | UK005J | 2024-11-04T14:15:12.821Z | 2024-11-09T14:23:00.286Z |
5468243 | 5468243 | 20241102235632_IoEKM | UK005J | 2024-11-04T14:13:49.101Z | 2024-11-09T14:22:57.617Z |
5468152 | 5468152 | 20241102234207_i2qHb | UK005J | 2024-11-04T14:13:26.256Z | 2024-11-09T14:22:57.315Z |
5468119 | 5468119 | 20241102233419_WMOOI | UK005J | 2024-11-04T14:13:18.689Z | 2024-11-09T14:22:57.150Z |
5468101 | 5468101 | 20241102232842_0a3pi | UK005J | 2024-11-04T14:13:16.738Z | 2024-11-09T14:22:57.066Z |
5467736 | 5467736 | 20241102222657_IIwD0 | UK005J | 2024-11-04T14:12:25.904Z | 2024-11-09T14:22:55.505Z |
5467678 | 5467678 | 20241102221453_757vA | UK005J | 2024-11-04T14:12:20.353Z | 2024-11-09T14:22:55.376Z |
5467249 | 5467249 | 20241102202920_aWAJ5 | UK005J | 2024-11-04T14:11:10.126Z | 2024-11-09T14:22:53.784Z |
5442826 | 5442826 | 20241030023833_c3TFE | UK005J | 2024-11-01T12:20:09.943Z | 2024-11-07T14:26:48.504Z |
5442508 | 5442508 | 20241030014204_U9033 | UK005J | 2024-11-01T12:19:55.875Z | 2024-11-07T14:26:46.840Z |
5442408 | 5442408 | 20241030012628_V6JAh | UK005J | 2024-11-01T12:19:46.835Z | 2024-11-07T14:26:46.541Z |
5439540 | 5439540 | 20241030200511_gtoF7 | UK005J | 2024-11-01T12:13:57.615Z | 2024-11-08T14:23:03.886Z |
5439518 | 5439518 | 20241030200217_o6m1Z | UK005J | 2024-11-01T12:13:55.934Z | 2024-11-08T14:23:03.820Z |
5432993 | 5432993 | 20241029053856_Rws28 | UK005J | 2024-10-31T12:21:42.235Z | 2024-11-06T14:27:29.493Z |
5432979 | 5432979 | 20241029053458_ykpJi | UK005J | 2024-10-31T12:21:41.791Z | 2024-11-06T14:27:29.459Z |
5432802 | 5432802 | 20241029044141_SAFjr | UK005J | 2024-10-31T12:21:35.649Z | 2024-11-06T14:27:28.756Z |
5432662 | 5432662 | 20241029041231_MpDbH | UK005J | 2024-10-31T12:21:30.398Z | 2024-11-06T14:27:28.319Z |
5410836 | 5410836 | 20241027054001_PWQYL | UK005J | 2024-10-29T12:18:05.993Z | 2024-11-04T14:29:05.644Z |
5410454 | 5410454 | 20241027051356_vo527 | UK005J | 2024-10-29T12:17:56.165Z | 2024-11-04T14:29:04.613Z |
5410402 | 5410402 | 20241027051156_D7LQ2 | UK005J | 2024-10-29T12:17:55.350Z | 2024-11-04T14:29:04.547Z |
5409775 | 5409775 | 20241027043543_tSNjQ | UK005J | 2024-10-29T12:17:40.797Z | 2024-11-04T14:29:02.635Z |
5409384 | 5409384 | 20241027041335_UDF30 | UK005J | 2024-10-29T12:17:19.320Z | 2024-11-04T14:29:01.632Z |
5409146 | 5409146 | 20241027040259_e3JiH | UK005J | 2024-10-29T12:17:09.103Z | 2024-11-04T14:29:01.223Z |
5409101 | 5409101 | 20241027040005_UweLM | UK005J | 2024-10-29T12:17:05.730Z | 2024-11-04T14:29:01.047Z |
5409057 | 5409057 | 20241027035757_r2J9q | UK005J | 2024-10-29T12:17:04.267Z | 2024-11-04T14:29:01.022Z |
5408940 | 5408940 | 20241027035044_9QNYT | UK005J | 2024-10-29T12:16:57.794Z | 2024-11-04T14:29:00.848Z |
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);