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

1,127 rows where station_code = "PT0003" 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
9634992 9634992 20260408221811_Kuua3 PT0003 2026-04-10T12:06:33.285Z 2026-04-10T12:14:23.338Z
9634592 9634592 20260408211853_3S85e PT0003 2026-04-10T12:05:29.149Z 2026-04-10T12:14:23.267Z
9633731 9633731 20260408041449_vdd9s PT0003 2026-04-09T12:28:26.121Z 2026-04-10T12:21:33.781Z
9616502 9616502 20260406030932_eAG95 PT0003 2026-04-07T12:12:57.764Z 2026-04-10T12:29:06.386Z
9615682 9615682 20260406014212_4vWzI PT0003 2026-04-07T12:11:22.650Z 2026-04-10T12:28:17.323Z
9614398 9614398 20260405230313_Q2Msz PT0003 2026-04-07T12:08:36.266Z 2026-04-10T12:27:53.122Z
9611949 9611949 20260406041300_rLoea PT0003 2026-04-07T12:00:16.591Z 2026-04-10T12:21:40.455Z
9609295 9609295 20260405041459_3kHAm PT0003 2026-04-06T12:01:01.008Z 2026-04-10T12:26:11.348Z
9586181 9586181 20260327042920_62krN PT0003 2026-03-28T12:02:27.378Z 2026-04-05T12:33:06.798Z
9586124 9586124 20260327040717_qay2P PT0003 2026-03-28T12:02:16.172Z 2026-04-05T12:33:02.448Z
9585770 9585770 20260327022543_qE2MD PT0003 2026-03-28T12:01:16.135Z 2026-04-05T12:32:44.431Z
9585644 9585644 20260327020152_BL3AI PT0003 2026-03-28T12:00:53.014Z 2026-04-05T12:32:31.598Z
9507421 9507421 20260316223222_Cgvqk PT0003 2026-03-18T12:20:26.602Z 2026-03-24T12:41:47.388Z
9506921 9506921 20260316195502_kX4Be PT0003 2026-03-18T12:19:39.687Z 2026-03-24T12:41:35.994Z
9502509 9502509 20260317041648_aDsRa PT0003 2026-03-18T12:03:05.212Z 2026-03-25T12:41:50.659Z
9502416 9502416 20260317034533_LKLmG PT0003 2026-03-18T12:02:45.142Z 2026-03-25T12:41:49.528Z
9502199 9502199 20260317023830_vb3qz PT0003 2026-03-18T12:01:53.783Z 2026-03-25T12:41:47.409Z
9502131 9502131 20260317021425_CVM0y PT0003 2026-03-18T12:01:38.499Z 2026-03-25T12:41:46.426Z
9495210 9495210 20260316044717_3OIbm PT0003 2026-03-17T12:06:26.554Z 2026-03-24T12:41:04.417Z
9495077 9495077 20260316040518_2FBro PT0003 2026-03-17T12:06:00.444Z 2026-03-24T12:40:55.160Z
9494743 9494743 20260316025157_FFBLL PT0003 2026-03-17T12:04:48.129Z 2026-03-24T12:40:49.594Z
9494467 9494467 20260316022036_qv3gI PT0003 2026-03-17T12:04:01.280Z 2026-03-24T12:40:47.688Z
9486101 9486101 20260315045142_hlVaG PT0003 2026-03-16T12:08:40.376Z 2026-03-23T12:21:55.342Z
9470333 9470333 20260313051419_cP8ML PT0003 2026-03-14T12:07:03.092Z 2026-03-21T12:49:07.531Z
9470302 9470302 20260313050734_uPMK3 PT0003 2026-03-14T12:06:56.468Z 2026-03-21T12:49:07.293Z
9469924 9469924 20260313040403_68JlK PT0003 2026-03-14T12:05:58.953Z 2026-03-21T12:49:04.318Z
9468789 9468789 20260313004032_MybeI PT0003 2026-03-14T12:01:47.481Z 2026-03-21T12:48:29.096Z
9462720 9462720 20260312000508_L6r5Z PT0003 2026-03-13T12:01:56.818Z 2026-03-20T12:36:17.629Z
9412033 9412033 20260228233327_14M3Q PT0003 2026-03-02T14:00:18.674Z 2026-03-09T12:39:16.995Z
9412028 9412028 20260228233005_kirwH PT0003 2026-03-02T14:00:17.725Z 2026-03-09T12:39:16.833Z
9411894 9411894 20260227222011_4LH3W PT0003 2026-03-01T14:09:16.315Z 2026-03-07T14:51:21.828Z
9409712 9409712 20260228042627_acUSl PT0003 2026-03-01T14:02:04.960Z 2026-03-08T12:41:28.433Z
9409617 9409617 20260228040359_5H31L PT0003 2026-03-01T14:01:51.748Z 2026-03-08T12:41:24.622Z
9407953 9407953 20260226224637_ql3rq PT0003 2026-02-28T14:22:55.077Z 2026-03-06T14:45:24.545Z
9399278 9399278 20260226053323_TxLe3 PT0003 2026-02-27T14:07:21.311Z 2026-03-06T14:44:14.375Z
9399202 9399202 20260226051936_HJGva PT0003 2026-02-27T14:07:13.216Z 2026-03-06T14:44:12.867Z
9399048 9399048 20260226044228_34Z6s PT0003 2026-02-27T14:06:49.269Z 2026-03-06T14:44:08.781Z
9398387 9398387 20260226033400_Dz3cW PT0003 2026-02-27T14:05:12.394Z 2026-03-06T14:43:42.751Z
9373792 9373792 20260223042103_WI0RB PT0003 2026-02-24T14:03:56.549Z 2026-03-03T14:31:09.682Z
9373383 9373383 20260223025659_03raK PT0003 2026-02-24T14:02:48.359Z 2026-03-03T14:31:02.362Z
9372975 9372975 20260223014716_h5Ph6 PT0003 2026-02-24T14:01:51.500Z 2026-03-03T14:30:49.421Z
9372918 9372918 20260223012854_wWcwJ PT0003 2026-02-24T14:01:41.869Z 2026-03-03T14:30:48.665Z
9372644 9372644 20260223004945_V7T1W PT0003 2026-02-24T14:01:06.655Z 2026-03-03T14:30:43.836Z
9372482 9372482 20260223002034_O52n3 PT0003 2026-02-24T14:00:43.031Z 2026-03-03T14:30:41.175Z
9365735 9365735 20260222054330_QNXo3 PT0003 2026-02-23T14:04:50.586Z 2026-02-24T14:15:34.691Z
9365712 9365712 20260222053746_iBcKN PT0003 2026-02-23T14:04:46.596Z 2026-02-24T14:15:33.671Z
9365680 9365680 20260222052359_UBvrY PT0003 2026-02-23T14:04:34.300Z 2026-02-24T14:15:31.358Z
9364932 9364932 20260222012011_6Ufou PT0003 2026-02-23T14:01:24.172Z 2026-02-24T14:14:41.993Z
9358576 9358576 20260221023743_Rg3O5 PT0003 2026-02-22T14:01:22.838Z 2026-03-02T14:20:49.066Z
8374971 8374971 20251103053912_RH24G PT0003 2025-11-05T14:33:30.961Z 2025-11-11T15:08:10.198Z
8374734 8374734 20251103044421_kjMQ2 PT0003 2025-11-05T14:33:07.534Z 2025-11-11T15:08:06.500Z
8374676 8374676 20251103043019_2FADi PT0003 2025-11-05T14:32:48.016Z 2025-11-11T15:08:03.997Z
8374649 8374649 20251103042304_8VyhY PT0003 2025-11-05T14:32:39.131Z 2025-11-11T15:07:54.050Z
8374566 8374566 20251103040758_Va209 PT0003 2025-11-05T14:32:25.185Z 2025-11-11T15:07:43.869Z
8374560 8374560 20251103040659_IKVrw PT0003 2025-11-05T14:32:24.409Z 2025-11-11T15:07:43.716Z
8374480 8374480 20251103035405_GrzTU PT0003 2025-11-05T14:32:14.876Z 2025-11-11T15:07:35.340Z
8374408 8374408 20251103033818_Ipfj2 PT0003 2025-11-05T14:31:50.009Z 2025-11-11T15:07:29.578Z
8373697 8373697 20251102235329_1rnNd PT0003 2025-11-05T14:28:49.575Z 2025-11-11T15:06:17.318Z
8373565 8373565 20251102221721_rXsDp PT0003 2025-11-05T14:27:54.300Z 2025-11-11T15:05:59.707Z
8373550 8373550 20251102215145_9FKJT PT0003 2025-11-05T14:27:45.499Z 2025-11-11T15:05:44.178Z
8373475 8373475 20251102201952_u0nzu PT0003 2025-11-05T14:27:02.027Z 2025-11-11T15:05:08.464Z
8318836 8318836 20251030014241_AXJfQ PT0003 2025-11-01T12:23:26.563Z 2025-11-07T15:13:32.429Z
8314535 8314535 20251030010045_1rxTT PT0003 2025-10-31T12:39:10.314Z 2025-11-07T15:13:22.903Z
8314418 8314418 20251030005312_EhWtm PT0003 2025-10-31T12:39:05.066Z 2025-11-07T15:13:20.992Z
8314335 8314335 20251030005016_zaSIZ PT0003 2025-10-31T12:38:48.133Z 2025-11-07T15:13:20.280Z
8313573 8313573 20251030001331_F3Vye PT0003 2025-10-31T12:38:04.006Z 2025-11-07T15:12:41.678Z
8311767 8311767 20251029222057_tvw4S PT0003 2025-10-31T12:35:56.706Z 2025-11-07T15:11:31.754Z
8310419 8310419 20251029194551_vqZk7 PT0003 2025-10-31T12:34:29.919Z 2025-11-07T15:10:49.327Z
8281757 8281757 20251028014207_cxAej PT0003 2025-10-29T12:41:51.233Z 2025-11-05T15:21:34.013Z
8281725 8281725 20251028013934_kK2rK PT0003 2025-10-29T12:41:49.984Z 2025-10-29T12:41:49.984Z
8281031 8281031 20251028004306_2b4kn PT0003 2025-10-29T12:40:24.451Z 2025-11-05T15:21:17.329Z
8281000 8281000 20251028003829_24Rgz PT0003 2025-10-29T12:40:22.943Z 2025-11-05T15:21:16.955Z
8280465 8280465 20251027233910_yoGbC PT0003 2025-10-29T12:39:18.402Z 2025-11-05T15:21:04.339Z
8279960 8279960 20251027223903_IGK7e PT0003 2025-10-29T12:38:22.057Z 2025-11-05T15:20:53.725Z
8279618 8279618 20251027215330_hZeHj PT0003 2025-10-29T12:37:34.148Z 2025-11-05T15:20:44.263Z
8251423 8251423 20251026204546_sZEx3 PT0003 2025-10-28T12:11:26.541Z 2025-11-04T15:41:41.453Z
8215050 8215050 20251024011833_5sr7o PT0003 2025-10-26T12:30:08.995Z 2025-11-01T13:10:22.510Z
8211360 8211360 20251023205716_nlzGY PT0003 2025-10-26T12:23:28.360Z 2025-11-01T13:10:03.716Z
8210297 8210297 20251023190811_MK573 PT0003 2025-10-26T12:20:33.891Z 2025-11-01T13:09:47.419Z
8143984 8143984 20251019002637_V3ulC PT0003 2025-10-20T12:16:01.642Z 2025-10-27T13:10:09.562Z
8134837 8134837 20251018053447_OdDxp PT0003 2025-10-19T12:16:32.572Z 2025-10-26T13:16:00.466Z
8134726 8134726 20251018051631_GJEyU PT0003 2025-10-19T12:16:22.637Z 2025-10-26T13:15:59.345Z
8134663 8134663 20251018050650_Grtp2 PT0003 2025-10-19T12:16:17.508Z 2025-10-26T13:15:58.229Z
8134460 8134460 20251018044105_68CFf PT0003 2025-10-19T12:15:42.079Z 2025-10-26T13:15:56.125Z
8134321 8134321 20251018042429_DG7I1 PT0003 2025-10-19T12:15:32.232Z 2025-10-26T13:15:55.146Z
8134260 8134260 20251018041757_A75l2 PT0003 2025-10-19T12:15:26.393Z 2025-10-26T13:15:53.476Z
8134247 8134247 20251018041635_zmufY PT0003 2025-10-19T12:15:25.767Z 2025-10-26T13:15:53.432Z
8134068 8134068 20251018040011_xwcLl PT0003 2025-10-19T12:14:48.295Z 2025-10-26T13:15:51.250Z
8133885 8133885 20251018034240_efn6P PT0003 2025-10-19T12:14:33.162Z 2025-10-26T13:15:48.118Z
8133762 8133762 20251018033133_mQaHP PT0003 2025-10-19T12:14:00.375Z 2025-10-26T13:15:46.208Z
8133677 8133677 20251018032235_nPowj PT0003 2025-10-19T12:13:50.666Z 2025-10-26T13:15:45.147Z
8133097 8133097 20251018022834_bxmx0 PT0003 2025-10-19T12:12:17.975Z 2025-10-26T13:15:39.516Z
8132858 8132858 20251018020658_f7ztS PT0003 2025-10-19T12:11:33.436Z 2025-10-26T13:15:37.021Z
8132577 8132577 20251018013241_720Qk PT0003 2025-10-19T12:10:47.541Z 2025-10-26T13:15:22.888Z
8132077 8132077 20251018002147_V3P44 PT0003 2025-10-19T12:09:22.796Z 2025-10-26T13:15:16.894Z
8131767 8131767 20251017233605_V6ww8 PT0003 2025-10-19T12:08:31.924Z 2025-10-26T13:15:12.370Z
8124190 8124190 20251017052658_W1omi PT0003 2025-10-18T12:28:45.845Z 2025-10-25T13:29:18.264Z
8124006 8124006 20251017045657_NYGSn PT0003 2025-10-18T12:28:05.733Z 2025-10-25T13:29:15.725Z
8123937 8123937 20251017044513_AOoA3 PT0003 2025-10-18T12:27:58.367Z 2025-10-25T13:29:14.788Z
8123770 8123770 20251017041532_AOmmT PT0003 2025-10-18T12:27:18.892Z 2025-10-25T13:29:12.114Z

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