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

4,116 rows where station_code = "UK008J" 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
9273513 9273513 20260128064756_x23gd UK008J 2026-01-29T14:30:02.475Z 2026-01-29T14:30:25.827Z
9260553 9260553 20260125052200_9kGUJ UK008J 2026-01-26T14:22:11.174Z 2026-01-29T14:44:26.864Z
9260544 9260544 20260125051725_DG0QJ UK008J 2026-01-26T14:22:09.397Z 2026-01-29T14:44:21.603Z
9260479 9260479 20260125044431_EnQgq UK008J 2026-01-26T14:21:56.708Z 2026-01-29T14:44:17.428Z
9260423 9260423 20260125041920_wA4zS UK008J 2026-01-26T14:21:46.009Z 2026-01-29T14:44:11.836Z
9260344 9260344 20260125035134_rPu3J UK008J 2026-01-26T14:21:20.959Z 2026-01-29T14:44:06.971Z
9260254 9260254 20260125031517_sL5i3 UK008J 2026-01-26T14:20:56.939Z 2026-01-29T14:44:02.284Z
9252106 9252106 20260123010358_R6Aa3 UK008J 2026-01-24T14:14:22.115Z 2026-01-29T14:52:33.616Z
9252095 9252095 20260123010032_aBzqa UK008J 2026-01-24T14:14:21.009Z 2026-01-29T14:52:32.876Z
9251915 9251915 20260122235937_KjQWt UK008J 2026-01-24T14:13:43.377Z 2026-01-29T14:52:17.067Z
9251821 9251821 20260122231717_CAGTo UK008J 2026-01-24T14:13:20.078Z 2026-01-29T14:52:11.839Z
9251325 9251325 20260122194210_X1Z5x UK008J 2026-01-24T14:11:17.721Z 2026-01-29T14:51:28.930Z
9248745 9248745 20260122015912_eAGxj UK008J 2026-01-23T14:13:37.074Z 2026-01-29T14:57:44.392Z
9241778 9241778 20260120222730_nQFTv UK008J 2026-01-22T14:14:29.029Z 2026-01-29T15:03:01.943Z
9237760 9237760 20260120060059_Jw1oo UK008J 2026-01-21T14:27:35.738Z 2026-01-28T15:01:39.773Z
9237722 9237722 20260120055545_Whd68 UK008J 2026-01-21T14:27:29.937Z 2026-01-28T15:01:37.834Z
9237050 9237050 20260120043127_1XkoE UK008J 2026-01-21T14:25:01.908Z 2026-01-28T15:00:55.668Z
9237026 9237026 20260120042817_IZnyx UK008J 2026-01-21T14:24:58.833Z 2026-01-28T15:00:54.491Z
9236412 9236412 20260120031213_Dtulr UK008J 2026-01-21T14:22:45.781Z 2026-01-28T14:59:59.059Z
9236379 9236379 20260120030838_3DYVz UK008J 2026-01-21T14:22:32.008Z 2026-01-28T14:59:57.622Z
9236045 9236045 20260120023005_pp0P9 UK008J 2026-01-21T14:21:18.897Z 2026-01-28T14:59:42.361Z
9235765 9235765 20260120015707_db5ki UK008J 2026-01-21T14:20:10.793Z 2026-01-28T14:59:19.605Z
9235681 9235681 20260120014547_J63gs UK008J 2026-01-21T14:19:53.989Z 2026-01-28T14:59:15.741Z
9235642 9235642 20260120014146_ekq2q UK008J 2026-01-21T14:19:47.223Z 2026-01-28T14:59:14.015Z
9235423 9235423 20260120011101_rQM0q UK008J 2026-01-21T14:18:51.295Z 2026-01-28T14:58:54.338Z
9235377 9235377 20260120010420_ZydOu UK008J 2026-01-21T14:18:44.596Z 2026-01-28T14:58:51.961Z
9223239 9223239 20260117235337_922ZU UK008J 2026-01-19T14:18:20.886Z 2026-01-26T15:01:59.255Z
9222856 9222856 20260117210603_IMVZ5 UK008J 2026-01-19T14:16:35.463Z 2026-01-26T15:01:23.538Z
9222828 9222828 20260117210018_0P2WB UK008J 2026-01-19T14:16:26.236Z 2026-01-26T15:01:22.555Z
9222551 9222551 20260117195532_lISmn UK008J 2026-01-19T14:15:15.078Z 2026-01-26T15:01:13.323Z
9222229 9222229 20260117184453_XUQd4 UK008J 2026-01-19T14:13:52.253Z 2026-01-26T15:00:44.602Z
9222057 9222057 20260117175457_o3RJn UK008J 2026-01-19T14:13:01.916Z 2026-01-26T15:00:36.415Z
9218958 9218958 20260117064519_8odQS UK008J 2026-01-18T14:14:24.035Z 2026-01-25T14:58:56.668Z
9218906 9218906 20260117062742_nlrFm UK008J 2026-01-18T14:14:09.552Z 2026-01-25T14:58:55.166Z
9218884 9218884 20260117061856_0shnA UK008J 2026-01-18T14:14:05.092Z 2026-01-25T14:58:54.571Z
9218880 9218880 20260117061752_IL8ik UK008J 2026-01-18T14:14:03.911Z 2026-01-25T14:58:54.481Z
9218842 9218842 20260117060536_ZcY2S UK008J 2026-01-18T14:13:55.057Z 2026-01-25T14:58:52.978Z
9218721 9218721 20260117052828_rigju UK008J 2026-01-18T14:13:24.798Z 2026-01-25T14:58:36.627Z
9217954 9217954 20260116205916_S8ZXu UK008J 2026-01-18T14:09:44.027Z 2026-01-25T14:57:53.108Z
9217945 9217945 20260116205316_zsdcb UK008J 2026-01-18T14:09:41.962Z 2026-01-25T14:57:52.795Z
9217885 9217885 20260116202015_ADj5Z UK008J 2026-01-18T14:09:28.649Z 2026-01-25T14:57:50.922Z
9213587 9213587 20260116040514_2TZcG UK008J 2026-01-17T14:17:40.527Z 2026-01-24T15:12:23.399Z
9207485 9207485 20260115014926_W0t3D UK008J 2026-01-16T14:08:57.475Z 2026-01-22T15:03:23.023Z
9204538 9204538 20260114065805_SddDr UK008J 2026-01-15T14:27:32.350Z 2026-01-22T15:10:34.296Z
9204517 9204517 20260114065459_uTXpV UK008J 2026-01-15T14:27:29.202Z 2026-01-22T15:10:30.613Z
9204472 9204472 20260114064730_J28JA UK008J 2026-01-15T14:27:25.473Z 2026-01-22T15:10:29.417Z
9203922 9203922 20260114055531_MT3cY UK008J 2026-01-15T14:25:52.992Z 2026-01-22T15:10:15.720Z
9202298 9202298 20260114032711_ICfP4 UK008J 2026-01-15T14:21:01.716Z 2026-01-22T15:09:16.128Z
9202272 9202272 20260114032506_gZd5J UK008J 2026-01-15T14:20:49.983Z 2026-01-22T15:09:15.390Z
9202229 9202229 20260114032429_hg2mX UK008J 2026-01-15T14:20:43.577Z 2026-01-22T15:09:15.078Z
9202133 9202133 20260114032010_z39Qj UK008J 2026-01-15T14:20:34.559Z 2026-01-22T15:09:13.968Z
9201935 9201935 20260114030716_VLfwf UK008J 2026-01-15T14:20:09.472Z 2026-01-22T15:09:11.583Z
9201835 9201835 20260114025831_NMcYt UK008J 2026-01-15T14:19:53.341Z 2026-01-22T15:09:10.389Z
9201765 9201765 20260114024813_80hlf UK008J 2026-01-15T14:19:40.025Z 2026-01-22T15:09:09.127Z
9201624 9201624 20260114023653_S5TII UK008J 2026-01-15T14:19:12.607Z 2026-01-22T15:09:06.865Z
9201194 9201194 20260114015341_TFbPk UK008J 2026-01-15T14:17:45.547Z 2026-01-22T15:08:59.327Z
9200868 9200868 20260114011543_qSkJe UK008J 2026-01-15T14:16:43.526Z 2026-01-22T15:08:31.783Z
9200727 9200727 20260114005733_S8mHE UK008J 2026-01-15T14:16:14.021Z 2026-01-22T15:08:24.720Z
9199939 9199939 20260113215950_G8RK8 UK008J 2026-01-15T14:13:08.179Z 2026-01-22T15:08:05.925Z
9194720 9194720 20260112221653_pm5Hh UK008J 2026-01-14T14:10:23.951Z 2026-01-21T15:04:20.310Z
9180159 9180159 20260110192310_qk3bh UK008J 2026-01-12T14:06:01.008Z 2026-01-19T15:15:48.949Z
9174862 9174862 20260109233846_yGYK3 UK008J 2026-01-11T14:04:38.544Z 2026-01-18T15:07:14.322Z
9174853 9174853 20260109233713_NAJ6O UK008J 2026-01-11T14:04:37.584Z 2026-01-18T15:07:14.104Z
9174756 9174756 20260109222031_P0yps UK008J 2026-01-11T14:04:16.961Z 2026-01-18T15:07:09.457Z
9174631 9174631 20260109210935_4n4TV UK008J 2026-01-11T14:03:54.117Z 2026-01-18T15:06:56.147Z
9163496 9163496 20260107070204_Q5cDh UK008J 2026-01-08T14:09:17.100Z 2026-01-13T15:03:17.713Z
9163476 9163476 20260107065118_lXz3E UK008J 2026-01-08T14:09:14.222Z 2026-01-13T15:03:16.887Z
9163450 9163450 20260107064421_fKw3o UK008J 2026-01-08T14:09:11.689Z 2026-01-13T15:03:16.120Z
9163400 9163400 20260107063022_YXpF9 UK008J 2026-01-08T14:09:02.454Z 2026-01-13T15:03:13.795Z
9163352 9163352 20260107062632_FW203 UK008J 2026-01-08T14:08:51.184Z 2026-01-13T15:03:10.416Z
9163312 9163312 20260107061959_2i96T UK008J 2026-01-08T14:08:43.318Z 2026-01-13T15:03:08.881Z
9163304 9163304 20260107061802_Mlcc9 UK008J 2026-01-08T14:08:42.736Z 2026-01-13T15:03:08.723Z
9163297 9163297 20260107061719_do6d8 UK008J 2026-01-08T14:08:41.149Z 2026-01-13T15:03:08.302Z
9163272 9163272 20260107061451_bc1s4 UK008J 2026-01-08T14:08:38.944Z 2026-01-13T15:03:07.746Z
9162495 9162495 20260107030826_lUFi7 UK008J 2026-01-08T14:05:29.771Z 2026-01-13T15:02:14.021Z
9162472 9162472 20260107030238_hdUE3 UK008J 2026-01-08T14:05:24.055Z 2026-01-13T15:02:12.440Z
9162254 9162254 20260107011230_WKsrK UK008J 2026-01-08T14:03:59.637Z 2026-01-13T15:01:56.308Z
9160674 9160674 20260106065156_N8oXM UK008J 2026-01-07T14:13:22.505Z 2026-01-13T15:09:45.639Z
9159966 9159966 20260106042340_Nq2p2 UK008J 2026-01-07T14:10:57.057Z 2026-01-13T15:08:54.445Z
9159747 9159747 20260106033801_ZOF8Q UK008J 2026-01-07T14:10:18.872Z 2026-01-13T15:08:39.576Z
9159703 9159703 20260106032957_hyMQT UK008J 2026-01-07T14:10:07.895Z 2026-01-13T15:08:37.687Z
9159693 9159693 20260106032743_6381M UK008J 2026-01-07T14:10:07.255Z 2026-01-13T15:08:37.569Z
9159281 9159281 20260106021641_BOGpP UK008J 2026-01-07T14:08:54.961Z 2026-01-13T15:08:19.783Z
9159241 9159241 20260106021147_MWfwU UK008J 2026-01-07T14:08:48.385Z 2026-01-13T15:08:14.178Z
9158509 9158509 20260105225040_Ztvjr UK008J 2026-01-07T14:06:21.194Z 2026-01-13T15:07:25.686Z
9158344 9158344 20260105215728_fLdBD UK008J 2026-01-07T14:05:47.835Z 2026-01-13T15:07:18.892Z
9158326 9158326 20260105215558_p36mL UK008J 2026-01-07T14:05:45.678Z 2026-01-13T15:07:18.362Z
9158259 9158259 20260105213030_DvZd5 UK008J 2026-01-07T14:05:32.825Z 2026-01-13T15:07:15.382Z
9157833 9157833 20260105185854_ZcSiH UK008J 2026-01-07T14:03:48.637Z 2026-01-13T15:06:33.932Z
9157606 9157606 20260105180641_MoG3N UK008J 2026-01-07T14:02:51.234Z 2026-01-13T15:06:20.058Z
9157557 9157557 20260105175455_2eBCY UK008J 2026-01-07T14:02:38.723Z 2026-01-13T15:06:17.570Z
9157539 9157539 20260105174654_iYVeO UK008J 2026-01-07T14:02:32.524Z 2026-01-13T15:06:15.830Z
9157517 9157517 20260105173952_lDJ6R UK008J 2026-01-07T14:02:25.269Z 2026-01-13T15:06:08.066Z
9156130 9156130 20260104065245_2vQd3 UK008J 2026-01-06T14:38:38.458Z 2026-01-12T15:11:39.665Z
9154579 9154579 20260104050300_O23th UK008J 2026-01-06T14:35:44.088Z 2026-01-12T15:10:11.008Z
9154383 9154383 20260104045453_V6L8m UK008J 2026-01-06T14:35:24.340Z 2026-01-12T15:09:49.349Z
9154329 9154329 20260104045253_1LaEI UK008J 2026-01-06T14:35:20.256Z 2026-01-12T15:09:47.551Z
9154204 9154204 20260104044301_HdbVO UK008J 2026-01-06T14:35:01.384Z 2026-01-12T15:09:40.409Z
9154179 9154179 20260104044150_xy3V4 UK008J 2026-01-06T14:34:59.869Z 2026-01-12T15:09:39.563Z
9154040 9154040 20260104043205_rc3fm UK008J 2026-01-06T14:34:41.466Z 2026-01-12T15:09:33.510Z

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