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

885 rows where station_code = "UK00BD" 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
8690349 8690349 20251204231309_WGtN6 UK00BD 2025-12-06T14:14:04.382Z 2025-12-06T14:18:00.864Z
8690332 8690332 20251204230814_BW7OM UK00BD 2025-12-06T14:14:02.954Z 2025-12-06T14:18:00.862Z
8690290 8690290 20251204223618_xou8r UK00BD 2025-12-06T14:13:57.566Z 2025-12-06T14:18:00.855Z
8683091 8683091 20251203062616_3I3KG UK00BD 2025-12-04T14:18:34.318Z 2025-12-06T14:29:41.487Z
8682988 8682988 20251203061840_2n14J UK00BD 2025-12-04T14:18:26.216Z 2025-12-06T14:29:38.479Z
8682677 8682677 20251203055818_xlyvB UK00BD 2025-12-04T14:17:53.757Z 2025-12-06T14:29:22.677Z
8680409 8680409 20251202235333_Q7cip UK00BD 2025-12-04T14:11:56.267Z 2025-12-06T14:27:10.941Z
8680149 8680149 20251202215408_2ep4w UK00BD 2025-12-04T14:11:11.706Z 2025-12-06T14:26:52.157Z
8676496 8676496 20251202055527_gyFsG UK00BD 2025-12-03T14:25:14.529Z 2025-12-06T14:35:22.356Z
8675420 8675420 20251202043700_OmoV5 UK00BD 2025-12-03T14:23:41.700Z 2025-12-06T14:34:52.008Z
8657578 8657578 20251130055308_K8OsG UK00BD 2025-12-01T14:34:33.566Z 2025-12-06T14:50:12.261Z
8654576 8654576 20251130032031_09TIJ UK00BD 2025-12-01T14:25:35.074Z 2025-12-06T14:48:44.126Z
8654009 8654009 20251130025159_qoEtY UK00BD 2025-12-01T14:24:44.380Z 2025-12-06T14:48:35.956Z
8653980 8653980 20251130025000_gAhit UK00BD 2025-12-01T14:24:34.009Z 2025-12-06T14:48:35.319Z
8651607 8651607 20251129235948_n0n2x UK00BD 2025-12-01T14:19:26.950Z 2025-12-06T14:46:49.325Z
8651133 8651133 20251129224625_Ln573 UK00BD 2025-12-01T14:18:04.316Z 2025-12-06T14:46:40.509Z
8650570 8650570 20251129204119_ZnC7J UK00BD 2025-12-01T14:16:28.933Z 2025-12-06T14:46:12.738Z
8602628 8602628 20251125051006_6rtkK UK00BD 2025-11-26T14:26:11.816Z 2025-12-02T15:09:31.819Z
8602258 8602258 20251125044514_Entip UK00BD 2025-11-26T14:25:28.528Z 2025-12-02T15:09:30.145Z
8602087 8602087 20251125043624_QRjsp UK00BD 2025-11-26T14:25:20.488Z 2025-12-02T15:09:29.421Z
8597189 8597189 20251124231008_1STyx UK00BD 2025-11-26T14:16:18.975Z 2025-12-02T15:07:23.911Z
8597024 8597024 20251124224358_YXwKj UK00BD 2025-11-26T14:15:53.519Z 2025-12-02T15:07:22.371Z
8587975 8587975 20251123230522_N25Fz UK00BD 2025-11-25T14:16:30.612Z 2025-12-02T15:11:23.290Z
8587482 8587482 20251123220955_nzvko UK00BD 2025-11-25T14:15:23.656Z 2025-12-02T15:11:16.353Z
8586272 8586272 20251123191031_sGY1m UK00BD 2025-11-25T14:12:24.116Z 2025-12-02T15:10:45.485Z
8556564 8556564 20251121020117_jvJa3 UK00BD 2025-11-22T14:39:36.924Z 2025-11-29T14:54:32.528Z
8553641 8553641 20251120055317_S5HOW UK00BD 2025-11-22T14:34:06.643Z 2025-11-28T14:58:30.817Z
8553566 8553566 20251120054724_RJqIZ UK00BD 2025-11-22T14:34:04.129Z 2025-11-28T14:58:25.712Z
8551908 8551908 20251120032316_Nuq0V UK00BD 2025-11-22T14:31:32.682Z 2025-11-28T14:57:17.878Z
8551781 8551781 20251120031213_0tmTY UK00BD 2025-11-22T14:31:09.392Z 2025-11-28T14:57:13.049Z
8551736 8551736 20251120030910_4ecDM UK00BD 2025-11-22T14:31:07.613Z 2025-11-28T14:57:12.260Z
8549376 8549376 20251120222126_jUZ8J UK00BD 2025-11-22T14:18:51.290Z 2025-11-29T14:54:24.609Z
8549148 8549148 20251120215733_DmneK UK00BD 2025-11-22T14:18:23.493Z 2025-11-29T14:54:24.088Z
8549079 8549079 20251120214927_inCOY UK00BD 2025-11-22T14:18:20.006Z 2025-11-29T14:54:23.940Z
8548995 8548995 20251120214123_L2U50 UK00BD 2025-11-22T14:18:03.548Z 2025-11-29T14:54:23.812Z
8541227 8541227 20251120020759_S62ph UK00BD 2025-11-21T14:37:10.290Z 2025-11-28T14:56:40.478Z
8541004 8541004 20251120014820_qNMvl UK00BD 2025-11-21T14:37:04.883Z 2025-11-28T14:56:30.383Z
8540142 8540142 20251120004008_2api7 UK00BD 2025-11-21T14:35:52.752Z 2025-11-28T14:56:05.204Z
8538752 8538752 20251119221655_af8Hn UK00BD 2025-11-21T14:34:33.516Z 2025-11-28T14:55:37.424Z
8538168 8538168 20251119203312_mLsna UK00BD 2025-11-21T14:33:24.001Z 2025-11-28T14:55:17.781Z
8537978 8537978 20251119195513_xbIZg UK00BD 2025-11-21T14:33:16.787Z 2025-11-28T14:55:02.991Z
8529011 8529011 20251119053358_zPYXI UK00BD 2025-11-20T14:44:36.914Z 2025-11-27T15:13:17.341Z
8528996 8528996 20251119053242_oBOgo UK00BD 2025-11-20T14:44:35.223Z 2025-11-20T14:44:35.223Z
8528673 8528673 20251119044819_3B08h UK00BD 2025-11-20T14:43:37.242Z 2025-11-27T15:13:10.015Z
8528632 8528632 20251119044110_Z2yX1 UK00BD 2025-11-20T14:43:28.166Z 2025-11-20T14:43:28.166Z
8528589 8528589 20251119043715_73vYP UK00BD 2025-11-20T14:43:20.297Z 2025-11-27T15:13:07.721Z
8528564 8528564 20251119043440_PQEzt UK00BD 2025-11-20T14:43:17.787Z 2025-11-27T15:13:07.267Z
8528546 8528546 20251119043312_W4etY UK00BD 2025-11-20T14:43:16.470Z 2025-11-27T15:13:07.007Z
8528405 8528405 20251119041224_Y52d0 UK00BD 2025-11-20T14:42:48.622Z 2025-11-27T15:13:03.183Z
8528254 8528254 20251119035051_u6Xjh UK00BD 2025-11-20T14:42:20.068Z 2025-11-27T15:12:56.331Z
8527451 8527451 20251119020315_0nicm UK00BD 2025-11-20T14:41:45.783Z 2025-11-27T15:12:15.835Z
8525841 8525841 20251118192531_d0qpf UK00BD 2025-11-20T14:37:57.350Z 2025-11-27T15:11:33.275Z
8525781 8525781 20251118185847_A5RJm UK00BD 2025-11-20T14:37:41.776Z 2025-11-27T15:11:31.762Z
8525617 8525617 20251118180754_a37BE UK00BD 2025-11-20T14:37:11.070Z 2025-11-27T15:11:28.896Z
8513739 8513739 20251118005915_5ki2j UK00BD 2025-11-19T14:36:27.825Z 2025-11-26T15:07:50.710Z
8513605 8513605 20251118004624_8QCd8 UK00BD 2025-11-19T14:36:23.243Z 2025-11-26T15:07:50.015Z
8513401 8513401 20251118002345_jWJk9 UK00BD 2025-11-19T14:36:16.448Z 2025-11-26T15:07:49.045Z
8512089 8512089 20251117212151_xXRWf UK00BD 2025-11-19T14:34:30.133Z 2025-11-26T15:07:41.430Z
8511878 8511878 20251117204112_QLfUF UK00BD 2025-11-19T14:34:22.812Z 2025-11-26T15:07:39.604Z
8511406 8511406 20251117190410_CGDUh UK00BD 2025-11-19T14:33:14.952Z 2025-11-26T15:07:26.744Z
8511222 8511222 20251117182831_2pN6h UK00BD 2025-11-19T14:32:45.583Z 2025-11-26T15:07:10.709Z
8497696 8497696 20251117054253_234z4 UK00BD 2025-11-18T14:29:26.584Z 2025-11-25T15:10:52.283Z
8496064 8496064 20251117042116_RDASq UK00BD 2025-11-18T14:27:02.992Z 2025-11-25T15:10:06.307Z
8494246 8494246 20251117023502_fk82J UK00BD 2025-11-18T14:23:59.328Z 2025-11-25T15:09:31.712Z
8492699 8492699 20251117004718_8FYMU UK00BD 2025-11-18T14:20:23.947Z 2025-11-25T15:08:55.971Z
8423998 8423998 20251110234313_jf84L UK00BD 2025-11-12T14:19:16.578Z 2025-11-19T15:16:05.402Z
8423229 8423229 20251110230237_MArou UK00BD 2025-11-12T14:18:10.196Z 2025-11-19T15:15:49.035Z
8423147 8423147 20251110225729_fcFQO UK00BD 2025-11-12T14:17:51.615Z 2025-11-19T15:15:47.195Z
8415652 8415652 20251110061154_OlUKh UK00BD 2025-11-11T14:24:07.148Z 2025-11-18T15:21:31.864Z
8404964 8404964 20251109024419_AtAG3 UK00BD 2025-11-10T14:13:13.884Z 2025-11-17T14:58:53.932Z
8403225 8403225 20251108224532_VSbLA UK00BD 2025-11-10T14:08:45.364Z 2025-11-17T14:58:33.410Z
8403137 8403137 20251108222850_PtJK4 UK00BD 2025-11-10T14:08:21.361Z 2025-11-17T14:58:32.094Z
8402906 8402906 20251108214755_AYLwT UK00BD 2025-11-10T14:07:59.253Z 2025-11-17T14:58:29.273Z
8356089 8356089 20251101222605_NoIl5 UK00BD 2025-11-03T14:39:00.254Z 2025-11-10T15:05:47.432Z
8351158 8351158 20251101222604_MrDzQ UK00BD 2025-11-03T14:12:53.402Z 2025-11-10T15:05:47.390Z
8345056 8345056 20251101054200_npKlb UK00BD 2025-11-02T14:42:22.596Z 2025-11-09T15:03:55.608Z
8336496 8336496 20251031044647_Lv92f UK00BD 2025-11-02T14:29:35.585Z 2025-11-08T15:15:58.340Z
8335485 8335485 20251031032301_yAcLl UK00BD 2025-11-02T14:27:24.898Z 2025-11-08T15:14:51.274Z
8335058 8335058 20251031024816_3CgEd UK00BD 2025-11-02T14:26:30.257Z 2025-11-08T15:14:23.906Z
8334474 8334474 20251031015635_hZttQ UK00BD 2025-11-02T14:25:16.851Z 2025-11-08T15:13:37.528Z
8334351 8334351 20251031014549_dBrCz UK00BD 2025-11-02T14:25:07.908Z 2025-11-08T15:13:24.640Z
8320356 8320356 20251030025343_3JT0w UK00BD 2025-11-01T12:26:07.576Z 2025-11-07T15:14:22.294Z
8313097 8313097 20251029235228_oVG62 UK00BD 2025-10-31T12:37:29.254Z 2025-11-07T15:12:27.709Z
8312012 8312012 20251029224341_YYyDx UK00BD 2025-10-31T12:36:34.497Z 2025-11-07T15:11:38.431Z
8310956 8310956 20251029210953_9clus UK00BD 2025-10-31T12:35:22.587Z 2025-11-07T15:11:23.383Z
8273719 8273719 20251027043915_SaTq0 UK00BD 2025-10-29T12:24:28.895Z 2025-11-04T15:45:02.064Z
8273693 8273693 20251027043813_huWD6 UK00BD 2025-10-29T12:24:27.637Z 2025-11-04T15:45:01.816Z
8262935 8262935 20251026043404_eBr3u UK00BD 2025-10-28T12:35:55.956Z 2025-11-03T15:16:51.315Z
8262508 8262508 20251026042307_1GW4f UK00BD 2025-10-28T12:35:45.862Z 2025-11-03T15:16:49.283Z
8258326 8258326 20251026021757_YRp1Z UK00BD 2025-10-28T12:31:38.279Z 2025-11-03T15:16:22.211Z
8258090 8258090 20251026021033_QzOPA UK00BD 2025-10-28T12:31:10.385Z 2025-11-03T15:16:19.855Z
8257798 8257798 20251026020255_eezfD UK00BD 2025-10-28T12:30:59.192Z 2025-11-03T15:16:19.293Z
8257379 8257379 20251026015249_9YcC9 UK00BD 2025-10-28T12:30:26.098Z 2025-11-03T15:16:18.663Z
8257324 8257324 20251026015127_aSa5f UK00BD 2025-10-28T12:30:22.232Z 2025-11-03T15:16:18.578Z
8256602 8256602 20251026013348_1S3zf UK00BD 2025-10-28T12:29:54.689Z 2025-11-03T15:16:16.209Z
8256120 8256120 20251026011934_qMBBd UK00BD 2025-10-28T12:29:20.087Z 2025-11-03T15:16:13.519Z
8254393 8254393 20251027035936_0mWvc UK00BD 2025-10-28T12:19:52.272Z 2025-11-04T15:44:26.100Z
8254102 8254102 20251027034424_qQkX1 UK00BD 2025-10-28T12:19:20.037Z 2025-11-04T15:44:19.226Z
8253900 8253900 20251027033209_KdWcB UK00BD 2025-10-28T12:18:53.036Z 2025-11-04T15:44:15.018Z
8253796 8253796 20251027032537_QrLKx UK00BD 2025-10-28T12:18:44.005Z 2025-11-04T15:44:12.757Z

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