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,078 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
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
8123743 8123743 20251017041056_x88iO PT0003 2025-10-18T12:27:14.082Z 2025-10-25T13:29:11.823Z
8122842 8122842 20251017024036_QOASv PT0003 2025-10-18T12:24:48.873Z 2025-10-25T13:28:56.377Z
8122796 8122796 20251017023137_9OuK3 PT0003 2025-10-18T12:24:44.850Z 2025-10-25T13:28:52.242Z
8122186 8122186 20251017012910_VJ1PG PT0003 2025-10-18T12:22:56.807Z 2025-10-25T13:28:19.287Z
8121561 8121561 20251017000526_h5rdP PT0003 2025-10-18T12:20:46.449Z 2025-10-25T13:27:40.906Z
8120361 8120361 20251016200708_GR2Ah PT0003 2025-10-18T12:16:26.715Z 2025-10-25T13:26:21.919Z
8104694 8104694 20251015023912_hjo22 PT0003 2025-10-16T12:16:59.796Z 2025-10-23T13:08:52.080Z
8103946 8103946 20251015001857_rYugR PT0003 2025-10-16T12:14:17.965Z 2025-10-23T13:08:37.860Z
8103867 8103867 20251015000025_THZnR PT0003 2025-10-16T12:13:52.931Z 2025-10-23T13:08:35.131Z
8099558 8099558 20251014053036_42ACy PT0003 2025-10-15T12:19:25.669Z 2025-10-22T13:10:14.461Z
8099378 8099378 20251014040611_qQGtC PT0003 2025-10-15T12:18:46.039Z 2025-10-22T13:10:08.606Z
8098397 8098397 20251014001032_vmkO3 PT0003 2025-10-15T12:15:55.884Z 2025-10-22T13:09:53.833Z
8098096 8098096 20251013230142_u0jWr PT0003 2025-10-15T12:15:05.032Z 2025-10-22T13:09:47.604Z
8097899 8097899 20251013222448_vhAZA PT0003 2025-10-15T12:14:24.130Z 2025-10-22T13:09:44.765Z
8097333 8097333 20251013192653_68813 PT0003 2025-10-15T12:12:30.413Z 2025-10-22T13:09:30.765Z
8093435 8093435 20251013043729_I2RKx PT0003 2025-10-14T12:13:26.392Z 2025-10-21T13:09:48.254Z
8087781 8087781 20251012034737_gK3Lq PT0003 2025-10-13T12:12:03.000Z 2025-10-20T13:03:46.253Z
8087697 8087697 20251012033005_KExxL PT0003 2025-10-13T12:11:39.032Z 2025-10-20T13:03:45.033Z
8087178 8087178 20251012020325_DeIYP PT0003 2025-10-13T12:10:27.317Z 2025-10-20T13:03:32.543Z
8087065 8087065 20251012013410_EWSyz PT0003 2025-10-13T12:09:53.365Z 2025-10-20T13:03:31.586Z
8087035 8087035 20251012012839_g3Izd PT0003 2025-10-13T12:09:50.042Z 2025-10-20T13:03:31.298Z
8086792 8086792 20251012003440_TQM6K PT0003 2025-10-13T12:09:07.373Z 2025-10-20T13:03:29.724Z
8086768 8086768 20251012002611_DLmXe PT0003 2025-10-13T12:09:02.466Z 2025-10-20T13:03:29.396Z
8086728 8086728 20251012001906_Nro2Q PT0003 2025-10-13T12:08:59.231Z 2025-10-20T13:03:29.097Z
8086480 8086480 20251011233146_NT5Fi PT0003 2025-10-13T12:08:15.102Z 2025-10-20T13:03:26.351Z
8085546 8085546 20251011200637_JD5gO PT0003 2025-10-13T12:06:13.660Z 2025-10-20T13:03:11.406Z
8085443 8085443 20251011194440_jXT3x PT0003 2025-10-13T12:05:52.917Z 2025-10-20T13:03:05.823Z
8071285 8071285 20251006053124_WNX8j PT0003 2025-10-08T12:15:17.008Z 2025-10-14T12:35:07.527Z
8071283 8071283 20251006052254_2O2iH PT0003 2025-10-08T12:15:16.498Z 2025-10-14T12:35:07.335Z
8071281 8071281 20251005231831_KP0qa PT0003 2025-10-08T12:14:04.601Z 2025-10-14T12:34:11.848Z
8071279 8071279 20251005214755_nj3BQ PT0003 2025-10-08T12:13:55.032Z 2025-10-14T12:33:50.383Z
8071277 8071277 20251005194856_F8B2g PT0003 2025-10-08T12:13:38.321Z 2025-10-14T12:33:34.357Z
8043415 8043415 20251002043436_lKpIL PT0003 2025-10-03T12:40:05.714Z 2025-10-10T12:42:13.985Z
8043360 8043360 20251002042833_3fhYa PT0003 2025-10-03T12:40:04.159Z 2025-10-10T12:42:12.991Z
8042898 8042898 20251002034634_aQNn6 PT0003 2025-10-03T12:38:55.423Z 2025-10-10T12:41:55.937Z
8040997 8040997 20251002013505_79Ylg PT0003 2025-10-03T12:35:24.288Z 2025-10-10T12:40:50.518Z
8040671 8040671 20251002010939_g2IYD PT0003 2025-10-03T12:34:54.631Z 2025-10-10T12:40:31.477Z
8039871 8039871 20251002000504_vAI3r PT0003 2025-10-03T12:33:40.396Z 2025-10-10T12:40:08.564Z
8038938 8038938 20251001222756_JprD9 PT0003 2025-10-03T12:31:34.533Z 2025-10-10T12:39:54.378Z
8031683 8031683 20251001043028_azd2R PT0003 2025-10-02T12:47:55.892Z 2025-10-09T12:39:44.022Z
8031518 8031518 20251001040420_ZbbH2 PT0003 2025-10-02T12:47:22.134Z 2025-10-09T12:39:37.033Z
8031448 8031448 20251001035344_5hgub PT0003 2025-10-02T12:47:15.909Z 2025-10-09T12:39:34.187Z
8031406 8031406 20251001034704_FIQW1 PT0003 2025-10-02T12:47:12.423Z 2025-10-09T12:39:33.486Z
8030546 8030546 20251001023502_ePrAD PT0003 2025-10-02T12:45:47.572Z 2025-10-09T12:39:19.632Z
8030160 8030160 20251001020433_kS324 PT0003 2025-10-02T12:44:59.545Z 2025-10-09T12:39:16.123Z
8028534 8028534 20251001001139_Eywt4 PT0003 2025-10-02T12:26:51.612Z 2025-10-09T12:38:51.834Z
8027326 8027326 20250930222146_1u0K9 PT0003 2025-10-02T12:23:30.024Z 2025-10-09T12:38:14.270Z
8027211 8027211 20250930220558_TclMv PT0003 2025-10-02T12:23:06.839Z 2025-10-09T12:38:11.968Z
8026999 8026999 20250930214324_ROU6o PT0003 2025-10-02T12:22:28.408Z 2025-10-09T12:38:08.945Z

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