home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

Data license: CC BY 4.0 license · Data source: Global Meteor Network

2,756 rows where station_code = "UK00BL" sorted by created_at descending

✎ View and edit SQL

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
6614918 6614918 20250430033009_UFCjo UK00BL 2025-05-01T12:19:35.882Z 2025-05-08T12:35:17.045Z
6614614 6614614 20250430025417_3L9eB UK00BL 2025-05-01T12:19:09.425Z 2025-05-08T12:35:15.897Z
6614346 6614346 20250430023519_Z8m5W UK00BL 2025-05-01T12:18:56.437Z 2025-05-08T12:35:14.535Z
6614306 6614306 20250430023320_LTf76 UK00BL 2025-05-01T12:18:54.538Z 2025-05-08T12:35:14.214Z
6613894 6613894 20250430020741_fDZB0 UK00BL 2025-05-01T12:18:14.187Z 2025-05-08T12:35:12.355Z
6613712 6613712 20250430015543_i9P0q UK00BL 2025-05-01T12:18:05.158Z 2025-05-08T12:35:11.342Z
6613255 6613255 20250430011923_i2Qnc UK00BL 2025-05-01T12:17:15.782Z 2025-05-08T12:35:08.950Z
6613149 6613149 20250430011222_qdBDg UK00BL 2025-05-01T12:17:09.882Z 2025-05-08T12:35:08.315Z
6612780 6612780 20250430005055_H9Y1j UK00BL 2025-05-01T12:16:34.253Z 2025-05-08T12:35:06.401Z
6612491 6612491 20250430003541_MAJLL UK00BL 2025-05-01T12:16:00.380Z 2025-05-08T12:35:05.392Z
6612208 6612208 20250430001431_PaoFc UK00BL 2025-05-01T12:15:42.769Z 2025-05-08T12:35:03.990Z
6611999 6611999 20250429235956_Nig2u UK00BL 2025-05-01T12:15:21.574Z 2025-05-08T12:35:03.094Z
6611970 6611970 20250429235912_nbUq8 UK00BL 2025-05-01T12:15:18.221Z 2025-05-08T12:35:02.963Z
6611735 6611735 20250429233524_2eXdZ UK00BL 2025-05-01T12:14:50.869Z 2025-05-08T12:35:01.930Z
6611309 6611309 20250429230016_eCK6C UK00BL 2025-05-01T12:14:14.638Z 2025-05-08T12:34:58.864Z
6605502 6605502 20250429025339_B7ab7 UK00BL 2025-04-30T12:21:45.061Z 2025-05-07T12:35:09.902Z
6604897 6604897 20250429021003_TP3kn UK00BL 2025-04-30T12:20:55.150Z 2025-05-07T12:35:07.012Z
6604808 6604808 20250429020516_aQZo3 UK00BL 2025-04-30T12:20:50.932Z 2025-05-07T12:35:06.572Z
6604783 6604783 20250429020312_B10YT UK00BL 2025-04-30T12:20:49.512Z 2025-05-07T12:35:06.527Z
6604474 6604474 20250429014514_qH36k UK00BL 2025-04-30T12:20:09.278Z 2025-05-07T12:35:05.100Z
6604275 6604275 20250429013125_AwfTD UK00BL 2025-04-30T12:19:58.718Z 2025-05-07T12:35:04.204Z
6603888 6603888 20250429010710_JMWhm UK00BL 2025-04-30T12:19:11.496Z 2025-05-07T12:35:01.092Z
6603626 6603626 20250429005149_IMls3 UK00BL 2025-04-30T12:18:56.407Z 2025-05-07T12:34:59.807Z
6603472 6603472 20250429004319_P97o6 UK00BL 2025-04-30T12:18:42.397Z 2025-05-07T12:34:58.795Z
6603312 6603312 20250429003129_YYmeb UK00BL 2025-04-30T12:18:19.698Z 2025-05-07T12:34:58.185Z
6602926 6602926 20250429000105_MKrUY UK00BL 2025-04-30T12:17:46.123Z 2025-05-07T12:34:56.132Z
6602785 6602785 20250428235114_p2BLn UK00BL 2025-04-30T12:17:24.667Z 2025-05-07T12:34:55.519Z
6602748 6602748 20250428234706_wRSma UK00BL 2025-04-30T12:17:20.533Z 2025-05-07T12:34:55.323Z
6602508 6602508 20250428232323_TWV6b UK00BL 2025-04-30T12:17:00.142Z 2025-05-07T12:34:54.172Z
6601779 6601779 20250428221126_FVZ1L UK00BL 2025-04-30T12:15:41.280Z 2025-05-07T12:34:48.067Z
6601604 6601604 20250428215940_HNzeK UK00BL 2025-04-30T12:15:30.258Z 2025-05-07T12:34:47.382Z
6601599 6601599 20250428215940_3A8qJ UK00BL 2025-04-30T12:15:30.137Z 2025-05-07T12:34:47.381Z
6601231 6601231 20250428212821_gnY9p UK00BL 2025-04-30T12:14:49.025Z 2025-05-07T12:34:45.856Z
6600961 6600961 20250428210226_RUJ8u UK00BL 2025-04-30T12:14:20.550Z 2025-05-07T12:34:43.694Z
6596360 6596360 20250428032732_2wVPm UK00BL 2025-04-29T12:22:28.585Z 2025-05-06T12:36:54.991Z
6596294 6596294 20250428031642_MGnKy UK00BL 2025-04-29T12:22:26.420Z 2025-05-06T12:36:54.753Z
6596037 6596037 20250428025316_kJHZy UK00BL 2025-04-29T12:22:18.857Z 2025-05-06T12:36:53.599Z
6595583 6595583 20250428021552_9jF3k UK00BL 2025-04-29T12:21:36.368Z 2025-05-06T12:36:50.853Z
6595337 6595337 20250428015640_qIyFM UK00BL 2025-04-29T12:21:26.151Z 2025-05-06T12:36:49.131Z
6595223 6595223 20250428014936_T2aDa UK00BL 2025-04-29T12:21:22.069Z 2025-05-06T12:36:48.413Z
6595136 6595136 20250428014308_GvpoZ UK00BL 2025-04-29T12:21:18.004Z 2025-05-06T12:36:47.742Z
6595070 6595070 20250428014058_Zzoj3 UK00BL 2025-04-29T12:21:07.956Z 2025-05-06T12:36:47.471Z
6594693 6594693 20250428011219_E1yxp UK00BL 2025-04-29T12:20:34.492Z 2025-05-06T12:36:45.130Z
6594396 6594396 20250428005535_H3fJo UK00BL 2025-04-29T12:20:14.651Z 2025-05-06T12:36:44.189Z
6594279 6594279 20250428004716_9aroE UK00BL 2025-04-29T12:19:58.113Z 2025-05-06T12:36:43.473Z
6594024 6594024 20250428002836_fJSd9 UK00BL 2025-04-29T12:19:44.239Z 2025-05-06T12:36:42.147Z
6593898 6593898 20250428002025_0IV0I UK00BL 2025-04-29T12:19:22.801Z 2025-05-06T12:36:41.505Z
6593374 6593374 20250427232637_6WxkH UK00BL 2025-04-29T12:18:51.807Z 2025-05-06T12:36:37.747Z
6593030 6593030 20250427230305_YPIkN UK00BL 2025-04-29T12:18:23.447Z 2025-05-06T12:36:35.707Z
6592964 6592964 20250427225535_FSOwl UK00BL 2025-04-29T12:18:19.888Z 2025-05-06T12:36:35.395Z
6592937 6592937 20250427225330_R1nDK UK00BL 2025-04-29T12:18:18.393Z 2025-05-06T12:36:35.251Z
6592363 6592363 20250427214611_R72C6 UK00BL 2025-04-29T12:17:20.251Z 2025-05-06T12:36:31.021Z
6592165 6592165 20250427212754_gp1Rq UK00BL 2025-04-29T12:17:04.452Z 2025-05-06T12:36:29.409Z
6592135 6592135 20250427212343_DySNl UK00BL 2025-04-29T12:16:54.964Z 2025-05-06T12:36:29.205Z
6586257 6586257 20250427032350_9nMWD UK00BL 2025-04-28T12:23:33.737Z 2025-05-05T12:31:32.255Z
6586198 6586198 20250427031300_dDvQT UK00BL 2025-04-28T12:23:30.047Z 2025-05-05T12:31:31.954Z
6586103 6586103 20250427025427_whwtF UK00BL 2025-04-28T12:23:08.663Z 2025-05-05T12:31:31.585Z
6586083 6586083 20250427025408_JAn9I UK00BL 2025-04-28T12:23:08.025Z 2025-05-05T12:31:31.515Z
6585869 6585869 20250427022327_Z6xwz UK00BL 2025-04-28T12:22:52.707Z 2025-05-05T12:31:30.742Z
6585825 6585825 20250427021802_28WBr UK00BL 2025-04-28T12:22:42.667Z 2025-05-05T12:31:30.661Z
6585717 6585717 20250427020952_3OfDU UK00BL 2025-04-28T12:22:35.253Z 2025-05-05T12:31:30.377Z
6585520 6585520 20250427015542_GcX4m UK00BL 2025-04-28T12:22:17.027Z 2025-05-05T12:31:29.504Z
6585236 6585236 20250427012321_L99lB UK00BL 2025-04-28T12:21:44.232Z 2025-05-05T12:31:28.556Z
6584449 6584449 20250426235729_YISiO UK00BL 2025-04-28T12:20:06.576Z 2025-05-05T12:31:25.807Z
6584322 6584322 20250426233805_xJhq2 UK00BL 2025-04-28T12:19:55.339Z 2025-05-05T12:31:25.414Z
6584165 6584165 20250426230255_8S0kJ UK00BL 2025-04-28T12:19:24.245Z 2025-05-05T12:31:24.922Z
6584004 6584004 20250426223658_Ng7Lr UK00BL 2025-04-28T12:19:11.752Z 2025-05-05T12:31:24.307Z
6577882 6577882 20250425204838_4a6T2 UK00BL 2025-04-27T12:20:11.485Z 2025-05-04T12:36:38.731Z
6569796 6569796 20250425020237_266ZN UK00BL 2025-04-26T12:23:25.297Z 2025-05-03T12:32:37.019Z
6569507 6569507 20250425010858_g1myH UK00BL 2025-04-26T12:23:01.726Z 2025-05-03T12:32:36.267Z
6569305 6569305 20250425003238_ewCHf UK00BL 2025-04-26T12:22:40.997Z 2025-05-03T12:32:35.359Z
6569200 6569200 20250425001321_5hrO5 UK00BL 2025-04-26T12:22:33.280Z 2025-05-03T12:32:34.693Z
6569167 6569167 20250425000447_WLrJT UK00BL 2025-04-26T12:22:26.028Z 2025-05-03T12:32:34.404Z
6568538 6568538 20250424213614_VBTvN UK00BL 2025-04-26T12:21:22.352Z 2025-05-03T12:32:31.790Z
6568420 6568420 20250424212221_MLN3J UK00BL 2025-04-26T12:21:02.379Z 2025-05-03T12:32:31.338Z
6568403 6568403 20250424212113_5Ar9L UK00BL 2025-04-26T12:21:01.862Z 2025-05-03T12:32:31.300Z
6546079 6546079 20250422031400_AaojY UK00BL 2025-04-23T12:21:35.442Z 2025-04-30T12:41:37.776Z
6545912 6545912 20250422030602_6yE5Y UK00BL 2025-04-23T12:21:31.172Z 2025-04-30T12:41:37.130Z
6545644 6545644 20250422025440_4xpQx UK00BL 2025-04-23T12:21:26.426Z 2025-04-30T12:41:36.410Z
6545631 6545631 20250422025413_3GtLk UK00BL 2025-04-23T12:21:26.372Z 2025-04-30T12:41:36.403Z
6545376 6545376 20250422023819_43bgD UK00BL 2025-04-23T12:21:21.202Z 2025-04-30T12:41:35.097Z
6545368 6545368 20250422023808_sO2yR UK00BL 2025-04-23T12:21:21.168Z 2025-04-30T12:41:35.094Z
6545137 6545137 20250422022700_lWf36 UK00BL 2025-04-23T12:21:07.913Z 2025-04-30T12:41:34.388Z
6544926 6544926 20250422021838_5VZ8h UK00BL 2025-04-23T12:20:58.133Z 2025-04-30T12:41:33.875Z
6544499 6544499 20250422014835_x0EwZ UK00BL 2025-04-23T12:20:30.186Z 2025-04-30T12:41:32.266Z
6544029 6544029 20250422011537_PkoW6 UK00BL 2025-04-23T12:20:00.318Z 2025-04-30T12:41:30.429Z
6544012 6544012 20250422011422_cznrb UK00BL 2025-04-23T12:19:59.646Z 2025-04-30T12:41:30.278Z
6543823 6543823 20250422010242_oeKVx UK00BL 2025-04-23T12:19:34.532Z 2025-04-30T12:41:29.606Z
6543554 6543554 20250422003400_LT2Zi UK00BL 2025-04-23T12:19:21.758Z 2025-04-30T12:41:28.189Z
6543246 6543246 20250421235412_s3jj5 UK00BL 2025-04-23T12:18:59.872Z 2025-04-30T12:41:25.685Z
6543136 6543136 20250421233754_JkJf9 UK00BL 2025-04-23T12:18:46.166Z 2025-04-30T12:41:24.337Z
6543070 6543070 20250421232747_uUoHQ UK00BL 2025-04-23T12:18:35.239Z 2025-04-30T12:41:23.979Z
6542993 6542993 20250421232121_Dt7So UK00BL 2025-04-23T12:18:30.013Z 2025-04-30T12:41:23.513Z
6542909 6542909 20250421231221_0S2rA UK00BL 2025-04-23T12:18:26.239Z 2025-04-30T12:41:22.762Z
6542448 6542448 20250421214344_ktpYR UK00BL 2025-04-23T12:17:41.467Z 2025-04-30T12:41:19.544Z
6542427 6542427 20250421214251_DAJ8L UK00BL 2025-04-23T12:17:40.115Z 2025-04-30T12:41:19.423Z
6542211 6542211 20250421205417_gljfM UK00BL 2025-04-23T12:17:06.270Z 2025-04-30T12:41:17.237Z
6520131 6520131 20250417021500_5s26p UK00BL 2025-04-18T12:10:12.880Z 2025-04-25T12:33:42.913Z
6520036 6520036 20250417015556_lFnmA UK00BL 2025-04-18T12:09:52.488Z 2025-04-25T12:33:41.777Z
6520014 6520014 20250417015234_n3Lue UK00BL 2025-04-18T12:09:48.325Z 2025-04-25T12:33:41.712Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network