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

9,055 rows where station_code = "UK0049" 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
8682503 8682503 20251203054046_y4B8l UK0049 2025-12-04T14:17:19.217Z 2025-12-05T14:22:40.808Z
8682146 8682146 20251203045452_ufmYX UK0049 2025-12-04T14:16:30.386Z 2025-12-05T14:22:15.880Z
8680723 8680723 20251203010958_Zs4TH UK0049 2025-12-04T14:12:48.520Z 2025-12-05T14:20:58.200Z
8680709 8680709 20251203010652_tgUSg UK0049 2025-12-04T14:12:46.285Z 2025-12-05T14:20:53.970Z
8680644 8680644 20251203005259_LewKO UK0049 2025-12-04T14:12:31.836Z 2025-12-05T14:20:50.691Z
8680618 8680618 20251203004712_83DN5 UK0049 2025-12-04T14:12:28.772Z 2025-12-05T14:20:49.368Z
8680543 8680543 20251203002658_vtzpj UK0049 2025-12-04T14:12:18.509Z 2025-12-05T14:20:43.659Z
8680344 8680344 20251202233055_QHRxX UK0049 2025-12-04T14:11:49.161Z 2025-12-05T14:20:34.927Z
8677042 8677042 20251202064220_Unh26 UK0049 2025-12-03T14:26:13.271Z 2025-12-05T14:29:19.128Z
8676617 8676617 20251202060852_GTz42 UK0049 2025-12-03T14:25:22.448Z 2025-12-05T14:29:09.133Z
8676535 8676535 20251202060101_SXPEA UK0049 2025-12-03T14:25:17.423Z 2025-12-05T14:29:01.123Z
8676505 8676505 20251202055733_HDZJ3 UK0049 2025-12-03T14:25:15.535Z 2025-12-05T14:28:57.698Z
8676326 8676326 20251202054713_jIsPp UK0049 2025-12-03T14:25:06.643Z 2025-12-05T14:28:54.549Z
8676261 8676261 20251202054246_u2aGA UK0049 2025-12-03T14:24:52.128Z 2025-12-05T14:28:51.124Z
8676142 8676142 20251202053846_pR7uL UK0049 2025-12-03T14:24:46.848Z 2025-12-05T14:28:49.568Z
8675752 8675752 20251202051218_T3PpH UK0049 2025-12-03T14:24:13.909Z 2025-12-05T14:28:40.119Z
8675726 8675726 20251202051118_hY5gn UK0049 2025-12-03T14:24:12.603Z 2025-12-05T14:28:39.622Z
8675646 8675646 20251202050332_znz02 UK0049 2025-12-03T14:23:57.787Z 2025-12-05T14:28:37.138Z
8675567 8675567 20251202045706_TVoSY UK0049 2025-12-03T14:23:51.990Z 2025-12-05T14:28:35.645Z
8675460 8675460 20251202044357_Kx77Z UK0049 2025-12-03T14:23:45.214Z 2025-12-05T14:28:32.752Z
8675354 8675354 20251202043132_w7ZIK UK0049 2025-12-03T14:23:33.657Z 2025-12-05T14:28:20.907Z
8675143 8675143 20251202040541_3YLgJ UK0049 2025-12-03T14:23:07.437Z 2025-12-05T14:28:12.832Z
8675075 8675075 20251202040004_1kj3S UK0049 2025-12-03T14:23:01.157Z 2025-12-05T14:28:10.715Z
8674675 8674675 20251202030653_G3pzT UK0049 2025-12-03T14:22:12.245Z 2025-12-05T14:27:59.537Z
8674611 8674611 20251202025849_l3X15 UK0049 2025-12-03T14:22:08.293Z 2025-12-05T14:27:57.899Z
8674514 8674514 20251202023914_YYKBN UK0049 2025-12-03T14:21:43.689Z 2025-12-05T14:27:50.571Z
8674471 8674471 20251202023152_1fI2d UK0049 2025-12-03T14:21:40.973Z 2025-12-05T14:27:42.663Z
8674459 8674459 20251202022852_8uqgC UK0049 2025-12-03T14:21:40.483Z 2025-12-05T14:27:42.354Z
8674236 8674236 20251202015312_pHR02 UK0049 2025-12-03T14:21:16.915Z 2025-12-05T14:27:33.632Z
8674200 8674200 20251202014536_XYICU UK0049 2025-12-03T14:21:09.124Z 2025-12-05T14:27:32.124Z
8673938 8673938 20251202004437_3UJAk UK0049 2025-12-03T14:20:25.094Z 2025-12-05T14:27:23.538Z
8673913 8673913 20251202002659_KF3Kx UK0049 2025-12-03T14:20:20.810Z 2025-12-05T14:27:22.871Z
8673888 8673888 20251202001741_IJkXS UK0049 2025-12-03T14:20:15.288Z 2025-12-05T14:27:21.666Z
8658086 8658086 20251130063643_VAtuD UK0049 2025-12-01T14:34:54.056Z 2025-12-05T14:46:02.039Z
8657308 8657308 20251130053829_nOJs2 UK0049 2025-12-01T14:34:04.096Z 2025-12-05T14:45:28.098Z
8657192 8657192 20251130053332_Eb2AW UK0049 2025-12-01T14:34:00.336Z 2025-12-05T14:45:26.665Z
8657162 8657162 20251130053213_jVUGf UK0049 2025-12-01T14:33:57.214Z 2025-12-05T14:45:26.175Z
8656921 8656921 20251130051818_GEpgT UK0049 2025-12-01T14:33:49.194Z 2025-12-05T14:45:23.290Z
8656889 8656889 20251130051533_Nlcsd UK0049 2025-12-01T14:33:48.357Z 2025-12-05T14:45:23.015Z
8656856 8656856 20251130051453_AeqmQ UK0049 2025-12-01T14:33:47.123Z 2025-12-05T14:45:22.544Z
8655688 8655688 20251130041152_4eH3J UK0049 2025-12-01T14:27:21.460Z 2025-12-05T14:44:37.128Z
8655431 8655431 20251130040215_I95H7 UK0049 2025-12-01T14:26:53.856Z 2025-12-05T14:44:33.611Z
8654648 8654648 20251130032444_VbTDs UK0049 2025-12-01T14:25:40.688Z 2025-12-05T14:44:19.882Z
8654239 8654239 20251130030510_ZUwV9 UK0049 2025-12-01T14:25:00.832Z 2025-12-05T14:43:51.647Z
8654032 8654032 20251130025353_9u0BD UK0049 2025-12-01T14:24:45.925Z 2025-12-05T14:43:45.453Z
8653261 8653261 20251130020509_pZe2h UK0049 2025-12-01T14:23:08.189Z 2025-12-05T14:43:06.850Z
8653131 8653131 20251130015926_rTlnS UK0049 2025-12-01T14:22:52.043Z 2025-12-05T14:43:04.385Z
8652939 8652939 20251130014610_D3wQI UK0049 2025-12-01T14:22:33.903Z 2025-12-05T14:42:58.018Z
8652898 8652898 20251130014428_Mv12R UK0049 2025-12-01T14:22:29.521Z 2025-12-05T14:42:57.057Z
8652713 8652713 20251130012839_FiUaZ UK0049 2025-12-01T14:22:01.729Z 2025-12-05T14:42:50.783Z
8652684 8652684 20251130012713_7hhQX UK0049 2025-12-01T14:21:58.801Z 2025-12-05T14:42:50.137Z
8652600 8652600 20251130012250_ulDaA UK0049 2025-12-01T14:21:51.162Z 2025-12-05T14:42:48.561Z
8652212 8652212 20251130005520_2a072 UK0049 2025-12-01T14:20:55.747Z 2025-12-05T14:42:38.200Z
8652063 8652063 20251130004421_ZnlL2 UK0049 2025-12-01T14:20:39.214Z 2025-12-05T14:42:15.329Z
8651845 8651845 20251130002509_FHH3E UK0049 2025-12-01T14:20:07.660Z 2025-12-05T14:42:07.757Z
8651668 8651668 20251130000929_cdbxU UK0049 2025-12-01T14:19:40.010Z 2025-12-05T14:42:03.159Z
8651418 8651418 20251129234055_sT2Vq UK0049 2025-12-01T14:19:01.763Z 2025-12-05T14:41:57.576Z
8637763 8637763 20251128063208_836Ow UK0049 2025-11-29T14:27:48.666Z 2025-12-05T15:00:25.785Z
8637650 8637650 20251128060634_RIkq1 UK0049 2025-11-29T14:27:40.124Z 2025-12-05T15:00:12.020Z
8637611 8637611 20251128055952_3q2Ed UK0049 2025-11-29T14:27:37.702Z 2025-12-05T15:00:10.428Z
8637584 8637584 20251128055558_H61gU UK0049 2025-11-29T14:27:36.175Z 2025-12-05T15:00:05.820Z
8637491 8637491 20251128054550_k3w2B UK0049 2025-11-29T14:27:30.674Z 2025-12-05T14:59:56.587Z
8637415 8637415 20251128053825_Jfr1M UK0049 2025-11-29T14:27:13.516Z 2025-12-05T14:59:51.303Z
8637399 8637399 20251128053721_32SiV UK0049 2025-11-29T14:27:12.464Z 2025-12-05T14:59:50.883Z
8637280 8637280 20251128052524_wBc37 UK0049 2025-11-29T14:27:03.043Z 2025-12-05T14:59:39.850Z
8637100 8637100 20251128050116_RCwjW UK0049 2025-11-29T14:26:50.700Z 2025-12-05T14:59:37.185Z
8636306 8636306 20251128033521_93GrG UK0049 2025-11-29T14:25:21.953Z 2025-12-05T14:59:22.597Z
8634418 8634418 20251128004836_Hdbnf UK0049 2025-11-29T14:21:20.815Z 2025-12-05T14:58:20.488Z
8633786 8633786 20251127235453_VwQft UK0049 2025-11-29T14:20:23.661Z 2025-12-05T14:57:58.772Z
8632393 8632393 20251127210202_ShCg2 UK0049 2025-11-29T14:17:25.637Z 2025-12-05T14:56:20.582Z
8616260 8616260 20251126054842_jrFk6 UK0049 2025-11-27T14:31:00.219Z 2025-12-04T15:11:37.344Z
8616172 8616172 20251126054407_UjJFF UK0049 2025-11-27T14:30:40.776Z 2025-12-04T15:11:36.527Z
8616103 8616103 20251126053915_evORd UK0049 2025-11-27T14:30:31.055Z 2025-12-04T15:11:35.753Z
8615687 8615687 20251126051305_9eqfH UK0049 2025-11-27T14:30:05.446Z 2025-12-04T15:11:31.279Z
8615672 8615672 20251126051245_cv8ct UK0049 2025-11-27T14:30:04.593Z 2025-12-04T15:11:31.151Z
8615642 8615642 20251126051211_veiAP UK0049 2025-11-27T14:30:04.017Z 2025-12-04T15:11:31.112Z
8615618 8615618 20251126051137_5Fjfk UK0049 2025-11-27T14:30:02.920Z 2025-12-04T15:11:30.859Z
8615533 8615533 20251126050859_rn3Iz UK0049 2025-11-27T14:29:40.288Z 2025-12-04T15:11:30.122Z
8615406 8615406 20251126050146_qjh82 UK0049 2025-11-27T14:29:30.665Z 2025-12-04T15:11:28.411Z
8615327 8615327 20251126045704_d4qFL UK0049 2025-11-27T14:29:27.807Z 2025-12-04T15:11:27.944Z
8614783 8614783 20251126042721_0fn3j UK0049 2025-11-27T14:28:33.005Z 2025-12-04T15:11:08.300Z
8614576 8614576 20251126041816_7fcMS UK0049 2025-11-27T14:28:03.187Z 2025-12-04T15:10:51.740Z
8614430 8614430 20251126040850_IkmD2 UK0049 2025-11-27T14:27:52.263Z 2025-12-04T15:10:40.799Z
8614194 8614194 20251126035611_XIlik UK0049 2025-11-27T14:27:38.283Z 2025-12-04T15:10:29.330Z
8614169 8614169 20251126035542_8cqcD UK0049 2025-11-27T14:27:26.759Z 2025-12-04T15:10:27.324Z
8613010 8613010 20251126025852_y8gla UK0049 2025-11-27T14:25:10.138Z 2025-12-04T15:09:36.456Z
8612956 8612956 20251126025740_93pjF UK0049 2025-11-27T14:25:02.889Z 2025-12-04T15:09:36.120Z
8612902 8612902 20251126025507_dvq4L UK0049 2025-11-27T14:24:59.117Z 2025-12-04T15:09:35.726Z
8612829 8612829 20251126025006_TPfc7 UK0049 2025-11-27T14:24:53.764Z 2025-12-04T15:09:34.726Z
8612637 8612637 20251126024036_Low24 UK0049 2025-11-27T14:24:25.530Z 2025-12-04T15:09:32.343Z
8612611 8612611 20251126023941_t32Vt UK0049 2025-11-27T14:24:24.519Z 2025-12-04T15:09:32.200Z
8612567 8612567 20251126023804_nmVKI UK0049 2025-11-27T14:24:22.620Z 2025-12-04T15:09:32.070Z
8612212 8612212 20251126022157_SkEVY UK0049 2025-11-27T14:23:37.340Z 2025-12-04T15:09:28.277Z
8612125 8612125 20251126021923_4Ig3x UK0049 2025-11-27T14:23:32.592Z 2025-12-04T15:09:27.867Z
8611089 8611089 20251126012020_xjRE1 UK0049 2025-11-27T14:21:10.612Z 2025-12-04T15:08:50.488Z
8610922 8610922 20251126011413_zreiV UK0049 2025-11-27T14:20:57.856Z 2025-12-04T15:08:45.239Z
8610898 8610898 20251126011353_LJygi UK0049 2025-11-27T14:20:56.855Z 2025-12-04T15:08:45.098Z
8610401 8610401 20251126004202_Dwzsy UK0049 2025-11-27T14:20:04.025Z 2025-12-04T15:08:05.054Z
8610220 8610220 20251126003100_8YP8D UK0049 2025-11-27T14:19:37.894Z 2025-12-04T15:08:03.434Z
8610072 8610072 20251126002031_08a2E UK0049 2025-11-27T14:19:25.383Z 2025-12-04T15:08:01.898Z

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