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

>10,000 rows count all where station_code = "UK009P" 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
9611764 9611764 20260405032145_CXpOP UK009P 2026-04-06T12:15:55.259Z 2026-04-06T12:16:14.859Z
9611475 9611475 20260405021248_hOSYn UK009P 2026-04-06T12:14:42.699Z 2026-04-06T12:16:14.807Z
9609099 9609099 20260405033346_sQXrr UK009P 2026-04-06T12:00:14.610Z 2026-04-06T12:00:14.610Z
9608556 9608556 20260403233613_Zck4H UK009P 2026-04-05T12:10:48.699Z 2026-04-06T12:20:20.015Z
9608404 9608404 20260403225849_ezHtU UK009P 2026-04-05T12:10:22.106Z 2026-04-06T12:20:11.216Z
9608306 9608306 20260403214323_Etw23 UK009P 2026-04-05T12:09:59.980Z 2026-04-06T12:20:05.317Z
9608245 9608245 20260403211354_03Idb UK009P 2026-04-05T12:09:42.079Z 2026-04-06T12:20:00.293Z
9608223 9608223 20260403205901_83O8v UK009P 2026-04-05T12:09:35.199Z 2026-04-06T12:19:56.449Z
9604814 9604814 20260402005423_xJ3eZ UK009P 2026-04-03T12:11:38.207Z 2026-04-06T12:26:20.460Z
9604787 9604787 20260402003926_xluEo UK009P 2026-04-03T12:11:32.856Z 2026-04-06T12:26:19.132Z
9604772 9604772 20260402003201_veO7o UK009P 2026-04-03T12:11:30.347Z 2026-04-06T12:26:18.239Z
9602964 9602964 20260402042124_5hGY7 UK009P 2026-04-03T12:01:20.889Z 2026-04-06T12:21:22.681Z
9602952 9602952 20260402041437_r1GZX UK009P 2026-04-03T12:01:19.703Z 2026-04-06T12:21:22.283Z
9602897 9602897 20260402035637_qzASv UK009P 2026-04-03T12:01:05.876Z 2026-04-06T12:21:19.637Z
9598573 9598573 20260330012026_gm02P UK009P 2026-03-31T12:10:57.265Z 2026-04-06T12:36:46.669Z
9598564 9598564 20260330012026_nS7SS UK009P 2026-03-31T12:10:56.719Z 2026-04-06T12:36:46.427Z
9598559 9598559 20260330011826_5VlO9 UK009P 2026-03-31T12:10:55.709Z 2026-04-06T12:36:46.078Z
9598547 9598547 20260330010951_KHzWk UK009P 2026-03-31T12:10:53.856Z 2026-04-06T12:36:45.393Z
9598491 9598491 20260330004259_N32Qn UK009P 2026-03-31T12:10:43.633Z 2026-04-06T12:36:35.085Z
9598391 9598391 20260329234642_8MGe3 UK009P 2026-03-31T12:10:31.563Z 2026-04-06T12:36:28.884Z
9598363 9598363 20260329232746_rzg59 UK009P 2026-03-31T12:10:27.775Z 2026-04-06T12:36:27.392Z
9598203 9598203 20260329202237_FE8QJ UK009P 2026-03-31T12:09:58.123Z 2026-04-06T12:36:16.530Z
9595476 9595476 20260330041509_x6h57 UK009P 2026-03-31T12:01:30.883Z 2026-04-06T12:30:05.526Z
9595071 9595071 20260330021434_QH0bE UK009P 2026-03-31T12:00:23.504Z 2026-04-06T12:29:39.190Z
9595021 9595021 20260330014027_m6BRN UK009P 2026-03-31T12:00:12.660Z 2026-04-06T12:29:35.322Z
9594858 9594858 20260329004455_bK3Dr UK009P 2026-03-30T12:10:27.795Z 2026-04-06T12:40:18.451Z
9594757 9594757 20260329002748_22KEM UK009P 2026-03-30T12:10:17.107Z 2026-04-06T12:40:15.204Z
9594529 9594529 20260328225241_jvWGT UK009P 2026-03-30T12:09:46.358Z 2026-04-06T12:39:56.064Z
9594447 9594447 20260328222427_JGlu3 UK009P 2026-03-30T12:09:34.079Z 2026-04-06T12:39:52.425Z
9594434 9594434 20260328222337_KHrC8 UK009P 2026-03-30T12:09:33.380Z 2026-04-06T12:39:52.166Z
9594323 9594323 20260328212525_ajrol UK009P 2026-03-30T12:09:18.105Z 2026-04-06T12:39:47.924Z
9594176 9594176 20260328194224_QeUGE UK009P 2026-03-30T12:08:53.851Z 2026-04-06T12:39:41.031Z
9592444 9592444 20260329020859_o9dFQ UK009P 2026-03-30T12:00:59.282Z 2026-04-06T12:34:10.580Z
9591755 9591755 20260327202059_R8QeJ UK009P 2026-03-29T12:06:41.323Z 2026-04-05T12:35:12.068Z
9591750 9591750 20260327201403_HoXN6 UK009P 2026-03-29T12:06:40.730Z 2026-04-05T12:35:11.722Z
9589867 9589867 20260328041259_hRXlJ UK009P 2026-03-29T12:01:41.468Z 2026-04-06T12:37:36.765Z
9589817 9589817 20260328040906_Q7ble UK009P 2026-03-29T12:01:39.241Z 2026-04-06T12:37:35.644Z
9589593 9589593 20260328034813_bHxNJ UK009P 2026-03-29T12:01:27.239Z 2026-04-06T12:37:28.258Z
9589490 9589490 20260328033503_3BTdl UK009P 2026-03-29T12:01:19.865Z 2026-04-06T12:37:25.580Z
9589245 9589245 20260328030153_IqpXh UK009P 2026-03-29T12:00:59.151Z 2026-04-06T12:37:09.847Z
9589207 9589207 20260328025032_gI2NO UK009P 2026-03-29T12:00:52.446Z 2026-04-06T12:37:07.406Z
9589134 9589134 20260328023159_xczG2 UK009P 2026-03-29T12:00:45.273Z 2026-04-06T12:37:02.716Z
9589088 9589088 20260328022531_m3itC UK009P 2026-03-29T12:00:42.409Z 2026-04-06T12:37:01.382Z
9588778 9588778 20260328011248_QlqSe UK009P 2026-03-29T12:00:14.279Z 2026-04-06T12:36:50.943Z
9585205 9585205 20260325234015_C2FUG UK009P 2026-03-27T12:16:54.275Z 2026-04-03T12:39:51.378Z
9585129 9585129 20260325233255_S5b7r UK009P 2026-03-27T12:16:47.359Z 2026-04-03T12:39:50.215Z
9585112 9585112 20260325233122_7OcGh UK009P 2026-03-27T12:16:45.928Z 2026-04-03T12:39:49.814Z
9585085 9585085 20260325232342_3gVlt UK009P 2026-03-27T12:16:42.538Z 2026-04-03T12:39:49.098Z
9584688 9584688 20260325213621_JmDNn UK009P 2026-03-27T12:15:57.954Z 2026-04-03T12:39:26.512Z
9584619 9584619 20260325211036_O86y1 UK009P 2026-03-27T12:15:50.316Z 2026-04-03T12:39:24.368Z
9584550 9584550 20260325203814_c2XJx UK009P 2026-03-27T12:15:37.467Z 2026-04-03T12:39:19.479Z
9584493 9584493 20260325200801_raHcF UK009P 2026-03-27T12:15:28.174Z 2026-04-03T12:39:16.535Z
9581549 9581549 20260326033021_6ux4t UK009P 2026-03-27T12:03:24.243Z 2026-04-04T12:39:10.481Z
9581361 9581361 20260326025923_L7LT6 UK009P 2026-03-27T12:02:50.589Z 2026-04-04T12:38:54.081Z
9580727 9580727 20260326012243_wMQrC UK009P 2026-03-27T12:01:15.818Z 2026-04-04T12:38:21.681Z
9580677 9580677 20260326011457_wfDbY UK009P 2026-03-27T12:01:08.095Z 2026-04-04T12:38:20.329Z
9580475 9580475 20260326005350_gli32 UK009P 2026-03-27T12:00:33.460Z 2026-04-04T12:38:11.515Z
9580131 9580131 20260325000754_CFF8p UK009P 2026-03-26T12:15:08.531Z 2026-04-02T12:37:43.039Z
9579697 9579697 20260324221834_Tzx92 UK009P 2026-03-26T12:14:13.306Z 2026-04-02T12:37:26.151Z
9579586 9579586 20260324214510_pDSLr UK009P 2026-03-26T12:14:02.365Z 2026-04-02T12:37:16.991Z
9579545 9579545 20260324212127_gUWUs UK009P 2026-03-26T12:13:55.504Z 2026-04-02T12:37:15.626Z
9576634 9576634 20260325024501_oPGOH UK009P 2026-03-26T12:02:50.830Z 2026-04-03T12:36:15.271Z
9575779 9575779 20260325001542_R2SIV UK009P 2026-03-26T12:00:10.810Z 2026-04-03T12:35:21.866Z
9562053 9562053 20260323012613_shCDg UK009P 2026-03-24T12:02:01.646Z 2026-03-31T12:26:00.364Z
9562037 9562037 20260323012039_24AP8 UK009P 2026-03-24T12:01:59.298Z 2026-03-31T12:26:00.016Z
9561736 9561736 20260323003623_lCC8R UK009P 2026-03-24T12:01:07.980Z 2026-03-31T12:25:52.346Z
9561451 9561451 20260321233425_3grRy UK009P 2026-03-23T12:12:19.291Z 2026-03-29T12:21:07.386Z
9560801 9560801 20260321221535_L273u UK009P 2026-03-23T12:12:03.887Z 2026-03-29T12:21:02.940Z
9560695 9560695 20260321220456_CzzfJ UK009P 2026-03-23T12:12:01.384Z 2026-03-29T12:21:02.241Z
9560446 9560446 20260321212519_HJd0t UK009P 2026-03-23T12:11:47.414Z 2026-03-29T12:21:00.298Z
9560388 9560388 20260321210738_7ftQb UK009P 2026-03-23T12:11:44.917Z 2026-03-29T12:20:59.805Z
9560377 9560377 20260321210649_3RL69 UK009P 2026-03-23T12:11:44.699Z 2026-03-29T12:20:59.765Z
9560317 9560317 20260321210143_7mun1 UK009P 2026-03-23T12:11:42.603Z 2026-03-29T12:20:59.258Z
9560096 9560096 20260321203220_AUC3J UK009P 2026-03-23T12:11:37.964Z 2026-03-29T12:20:57.951Z
9560039 9560039 20260321202522_0sNKt UK009P 2026-03-23T12:11:36.480Z 2026-03-29T12:20:57.499Z
9559900 9559900 20260321200812_xls3O UK009P 2026-03-23T12:11:33.433Z 2026-03-29T12:20:56.459Z
9559774 9559774 20260321194430_votiG UK009P 2026-03-23T12:11:29.724Z 2026-03-29T12:20:51.684Z
9555459 9555459 20260322045718_cSClq UK009P 2026-03-23T12:03:26.402Z 2026-03-30T12:28:26.664Z
9555217 9555217 20260322042617_42wSc UK009P 2026-03-23T12:03:15.761Z 2026-03-30T12:28:23.013Z
9554850 9554850 20260322033930_3lIQz UK009P 2026-03-23T12:02:53.373Z 2026-03-30T12:28:10.409Z
9554622 9554622 20260322032107_k3z3X UK009P 2026-03-23T12:02:43.717Z 2026-03-30T12:28:06.586Z
9554384 9554384 20260322030255_V68ZC UK009P 2026-03-23T12:02:28.917Z 2026-03-30T12:28:03.038Z
9554322 9554322 20260322025837_EmDXY UK009P 2026-03-23T12:02:26.634Z 2026-03-30T12:28:02.422Z
9554174 9554174 20260322024547_Nb4jt UK009P 2026-03-23T12:02:18.215Z 2026-03-30T12:27:59.739Z
9553986 9553986 20260322023008_IzhMY UK009P 2026-03-23T12:02:04.925Z 2026-03-30T12:27:56.403Z
9553854 9553854 20260322022107_fXomb UK009P 2026-03-23T12:01:55.440Z 2026-03-30T12:27:53.549Z
9553775 9553775 20260322021301_KfKho UK009P 2026-03-23T12:01:51.339Z 2026-03-30T12:27:52.440Z
9553582 9553582 20260322015554_trEAD UK009P 2026-03-23T12:01:41.184Z 2026-03-30T12:27:49.632Z
9553335 9553335 20260322013144_r1lAU UK009P 2026-03-23T12:01:24.545Z 2026-03-30T12:27:39.556Z
9553298 9553298 20260322012958_oa3PH UK009P 2026-03-23T12:01:23.428Z 2026-03-30T12:27:39.182Z
9553290 9553290 20260322012954_wc23u UK009P 2026-03-23T12:01:23.185Z 2026-03-30T12:27:39.071Z
9553116 9553116 20260322011534_oXd50 UK009P 2026-03-23T12:01:13.992Z 2026-03-30T12:27:35.273Z
9553111 9553111 20260322011453_o6HiA UK009P 2026-03-23T12:01:13.814Z 2026-03-30T12:27:35.195Z
9553017 9553017 20260322010440_AGWP8 UK009P 2026-03-23T12:01:09.476Z 2026-03-30T12:27:33.767Z
9553007 9553007 20260322010440_umfJ3 UK009P 2026-03-23T12:01:09.214Z 2026-03-30T12:27:33.732Z
9552989 9552989 20260322010145_Px1Kd UK009P 2026-03-23T12:01:07.557Z 2026-03-30T12:27:33.403Z
9552651 9552651 20260322002637_K77mJ UK009P 2026-03-23T12:00:40.183Z 2026-03-30T12:27:27.435Z
9552634 9552634 20260322002508_ldDiX UK009P 2026-03-23T12:00:38.494Z 2026-03-30T12:27:27.273Z
9552504 9552504 20260322001511_k6PBJ UK009P 2026-03-23T12:00:29.238Z 2026-03-30T12:27:25.188Z
9552339 9552339 20260321235305_C5x3B UK009P 2026-03-23T12:00:15.739Z 2026-03-30T12:27:22.531Z

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