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

6,180 rows where station_code = "US004P" 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
8683183 8683183 20251203063740_hP52e US004P 2025-12-04T14:18:46.522Z 2025-12-06T14:29:44.223Z
8682803 8682803 20251203060609_o43XD US004P 2025-12-04T14:18:02.577Z 2025-12-06T14:29:26.457Z
8682054 8682054 20251203044544_zk9td US004P 2025-12-04T14:16:17.536Z 2025-12-06T14:28:45.145Z
8681819 8681819 20251203041220_8upjW US004P 2025-12-04T14:15:41.137Z 2025-12-06T14:28:32.578Z
8681770 8681770 20251203040233_sbUTR US004P 2025-12-04T14:15:32.878Z 2025-12-06T14:28:30.249Z
8681767 8681767 20251203040133_HkjBe US004P 2025-12-04T14:15:32.223Z 2025-12-06T14:28:30.093Z
8681649 8681649 20251203033602_GEeK3 US004P 2025-12-04T14:15:11.575Z 2025-12-06T14:28:22.476Z
8681644 8681644 20251203033552_BHplq US004P 2025-12-04T14:15:10.948Z 2025-12-06T14:28:22.092Z
8681395 8681395 20251203030328_6LDT9 US004P 2025-12-04T14:14:37.541Z 2025-12-06T14:28:05.508Z
8681104 8681104 20251203022354_2gNQ2 US004P 2025-12-04T14:13:51.427Z 2025-12-06T14:27:49.475Z
8680987 8680987 20251203020657_pYlFE US004P 2025-12-04T14:13:30.853Z 2025-12-06T14:27:41.029Z
8677653 8677653 20251203113038_HoiqK US004P 2025-12-04T14:02:12.284Z 2025-12-06T14:19:54.268Z
8677612 8677612 20251203110203_I2Tyg US004P 2025-12-04T14:01:58.151Z 2025-12-06T14:19:44.536Z
8677484 8677484 20251203102046_uc5Gw US004P 2025-12-04T14:01:23.150Z 2025-12-06T14:19:31.907Z
8677201 8677201 20251203070750_mqLr8 US004P 2025-12-04T14:00:20.882Z 2025-12-06T14:18:14.688Z
8669762 8669762 20251202120811_Wxufd US004P 2025-12-03T14:05:22.888Z 2025-12-06T14:24:18.988Z
8669720 8669720 20251202120521_Q4CoD US004P 2025-12-03T14:05:16.572Z 2025-12-06T14:24:17.247Z
8669629 8669629 20251202114416_Y7BHi US004P 2025-12-03T14:04:45.165Z 2025-12-06T14:24:07.492Z
8669514 8669514 20251202112359_hFB3Q US004P 2025-12-03T14:04:14.756Z 2025-12-06T14:23:58.986Z
8669451 8669451 20251202111312_C0IXP US004P 2025-12-03T14:03:58.885Z 2025-12-06T14:23:55.493Z
8669442 8669442 20251202111151_vBFgy US004P 2025-12-03T14:03:53.161Z 2025-12-06T14:23:55.096Z
8669425 8669425 20251202111018_2cG3C US004P 2025-12-03T14:03:42.119Z 2025-12-06T14:23:53.735Z
8669410 8669410 20251202110847_VmTNC US004P 2025-12-03T14:03:39.237Z 2025-12-06T14:23:52.596Z
8669386 8669386 20251202110442_3a0Bb US004P 2025-12-03T14:03:31.970Z 2025-12-06T14:23:51.431Z
8669239 8669239 20251202103807_I8EF2 US004P 2025-12-03T14:02:58.325Z 2025-12-06T14:23:41.722Z
8669199 8669199 20251202103115_u4QBL US004P 2025-12-03T14:02:50.303Z 2025-12-06T14:23:39.657Z
8669160 8669160 20251202102447_SAOHr US004P 2025-12-03T14:02:45.675Z 2025-12-06T14:23:38.439Z
8669125 8669125 20251202101628_7XBFU US004P 2025-12-03T14:02:40.156Z 2025-12-06T14:23:34.772Z
8669123 8669123 20251202101606_cGxYQ US004P 2025-12-03T14:02:39.669Z 2025-12-06T14:23:34.379Z
8669099 8669099 20251202101216_aqbbr US004P 2025-12-03T14:02:24.402Z 2025-12-06T14:23:32.292Z
8669073 8669073 20251202100812_bTYNV US004P 2025-12-03T14:02:13.733Z 2025-12-06T14:23:30.373Z
8669039 8669039 20251202095558_F9Otc US004P 2025-12-03T14:02:05.408Z 2025-12-06T14:23:27.353Z
8669004 8669004 20251202095056_QcTPJ US004P 2025-12-03T14:01:59.254Z 2025-12-06T14:23:25.353Z
8668664 8668664 20251202081312_gSQxh US004P 2025-12-03T14:00:46.022Z 2025-12-06T14:23:01.543Z
8668316 8668316 20251130071734_XlCc1 US004P 2025-12-02T14:42:18.330Z 2025-12-06T14:50:30.237Z
8668210 8668210 20251130064101_Ah43H US004P 2025-12-02T14:42:11.359Z 2025-12-06T14:50:26.698Z
8668179 8668179 20251130063110_U3Q15 US004P 2025-12-02T14:42:08.704Z 2025-12-06T14:50:25.676Z
8668159 8668159 20251130062300_6ew7z US004P 2025-12-02T14:42:06.343Z 2025-12-06T14:50:24.810Z
8668095 8668095 20251130060114_fNK5X US004P 2025-12-02T14:42:00.654Z 2025-12-06T14:50:21.563Z
8668055 8668055 20251130054643_hsRwL US004P 2025-12-02T14:41:32.829Z 2025-12-06T14:50:01.736Z
8667955 8667955 20251130052418_Co2zX US004P 2025-12-02T14:41:23.008Z 2025-12-06T14:49:44.064Z
8667700 8667700 20251130032348_xvzPo US004P 2025-12-02T14:39:46.654Z 2025-12-06T14:48:45.168Z
8660221 8660221 20251130120749_x8aQb US004P 2025-12-02T14:06:57.604Z 2025-12-06T14:36:57.087Z
8660218 8660218 20251130120726_83M3H US004P 2025-12-02T14:06:56.905Z 2025-12-06T14:36:56.948Z
8660173 8660173 20251130120227_uD82k US004P 2025-12-02T14:06:48.451Z 2025-12-06T14:36:54.354Z
8660056 8660056 20251130114931_m75Al US004P 2025-12-02T14:06:22.569Z 2025-12-06T14:36:51.366Z
8659999 8659999 20251130114015_335o3 US004P 2025-12-02T14:06:07.515Z 2025-12-06T14:36:49.668Z
8659825 8659825 20251130111945_J3C3O US004P 2025-12-02T14:05:25.490Z 2025-12-06T14:36:43.508Z
8659810 8659810 20251130111733_uChwP US004P 2025-12-02T14:05:22.353Z 2025-12-06T14:36:42.747Z
8659757 8659757 20251130111312_FwGRC US004P 2025-12-02T14:05:14.680Z 2025-12-06T14:36:41.580Z
8659740 8659740 20251130111036_px8Vz US004P 2025-12-02T14:05:11.406Z 2025-12-06T14:36:41.091Z
8659672 8659672 20251130110333_0rVH5 US004P 2025-12-02T14:04:49.152Z 2025-12-06T14:36:32.374Z
8659576 8659576 20251130105025_1KMfx US004P 2025-12-02T14:04:32.295Z 2025-12-06T14:36:24.021Z
8659565 8659565 20251130104911_Lnezh US004P 2025-12-02T14:04:29.842Z 2025-12-06T14:36:23.635Z
8659551 8659551 20251130104715_TWkIt US004P 2025-12-02T14:04:23.103Z 2025-12-06T14:36:23.223Z
8659321 8659321 20251130100906_2Pbtt US004P 2025-12-02T14:03:29.117Z 2025-12-06T14:36:14.152Z
8659316 8659316 20251130100837_Dnrgp US004P 2025-12-02T14:03:28.244Z 2025-12-06T14:36:14.035Z
8659273 8659273 20251130100258_l62hk US004P 2025-12-02T14:03:21.089Z 2025-12-06T14:36:12.880Z
8659271 8659271 20251130100214_oRk4u US004P 2025-12-02T14:03:20.430Z 2025-12-06T14:36:12.819Z
8659103 8659103 20251130093228_EymFJ US004P 2025-12-02T14:02:34.214Z 2025-12-06T14:36:06.750Z
8659028 8659028 20251130091855_3pMUw US004P 2025-12-02T14:02:17.064Z 2025-12-06T14:36:03.222Z
8659016 8659016 20251130091807_oydBQ US004P 2025-12-02T14:02:09.698Z 2025-12-06T14:36:02.700Z
8659009 8659009 20251130091723_7izJL US004P 2025-12-02T14:02:07.373Z 2025-12-06T14:36:02.575Z
8658961 8658961 20251130090610_2N9uv US004P 2025-12-02T14:01:50.313Z 2025-12-06T14:35:59.664Z
8658936 8658936 20251130085914_tnZ7U US004P 2025-12-02T14:01:43.598Z 2025-12-06T14:35:55.350Z
8658919 8658919 20251130085650_K8W1I US004P 2025-12-02T14:01:38.354Z 2025-12-06T14:35:53.242Z
8658902 8658902 20251130085427_xcKUw US004P 2025-12-02T14:01:27.964Z 2025-12-06T14:35:49.841Z
8658877 8658877 20251130084603_0G5F2 US004P 2025-12-02T14:01:21.027Z 2025-12-06T14:35:44.422Z
8658874 8658874 20251130084409_DAjob US004P 2025-12-02T14:01:20.409Z 2025-12-06T14:35:44.347Z
8658868 8658868 20251130084253_KPxr3 US004P 2025-12-02T14:01:18.170Z 2025-12-06T14:35:44.012Z
8658783 8658783 20251130080555_rXOmr US004P 2025-12-02T14:00:50.054Z 2025-12-06T14:35:41.072Z
8638093 8638093 20251128082257_Jh0Nc US004P 2025-11-29T14:28:29.538Z 2025-12-06T15:04:07.922Z
8638043 8638043 20251128081213_bKNSM US004P 2025-11-29T14:28:26.163Z 2025-12-06T15:04:07.325Z
8637847 8637847 20251128065052_AmrSH US004P 2025-11-29T14:27:55.323Z 2025-12-06T15:04:04.861Z
8637825 8637825 20251128064833_RKDF4 US004P 2025-11-29T14:27:54.213Z 2025-12-06T15:04:04.667Z
8637784 8637784 20251128064041_2FuH3 US004P 2025-11-29T14:27:51.937Z 2025-12-06T15:04:04.123Z
8637706 8637706 20251128062144_grbbV US004P 2025-11-29T14:27:44.749Z 2025-12-06T15:04:03.164Z
8637697 8637697 20251128061758_SjJcl US004P 2025-11-29T14:27:43.836Z 2025-12-06T15:04:03.039Z
8637608 8637608 20251128055940_ALrY0 US004P 2025-11-29T14:27:37.498Z 2025-12-06T15:04:01.720Z
8636991 8636991 20251128044620_ECFhn US004P 2025-11-29T14:26:30.574Z 2025-12-06T15:03:54.350Z
8636813 8636813 20251128042928_0BmWU US004P 2025-11-29T14:26:13.811Z 2025-12-06T15:03:45.383Z
8635934 8635934 20251128025939_bGasL US004P 2025-11-29T14:24:39.594Z 2025-12-06T15:02:54.265Z
8635608 8635608 20251128023143_4YswM US004P 2025-11-29T14:23:56.008Z 2025-12-06T15:02:47.186Z
8634269 8634269 20251128003346_8c1Wu US004P 2025-11-29T14:21:08.896Z 2025-12-06T15:01:56.895Z
8627814 8627814 20251128113846_x9y3f US004P 2025-11-29T14:04:33.660Z 2025-12-06T14:51:25.427Z
8627765 8627765 20251128113533_Ki2vU US004P 2025-11-29T14:04:27.827Z 2025-12-06T14:51:24.831Z
8627655 8627655 20251128112451_s9zHg US004P 2025-11-29T14:04:11.201Z 2025-12-06T14:51:22.773Z
8627381 8627381 20251128105444_Od9tL US004P 2025-11-29T14:03:27.763Z 2025-12-06T14:51:17.208Z
8627095 8627095 20251128101837_WceTp US004P 2025-11-29T14:02:40.284Z 2025-12-06T14:51:12.643Z
8626723 8626723 20251128092812_lMV58 US004P 2025-11-29T14:01:19.683Z 2025-12-06T14:50:41.405Z
8626563 8626563 20251128085951_N9ipp US004P 2025-11-29T14:00:44.111Z 2025-12-06T14:50:36.270Z
8626523 8626523 20251128085220_cwPtL US004P 2025-11-29T14:00:37.534Z 2025-12-06T14:50:35.287Z
8626310 8626310 20251126085114_cMHzI US004P 2025-11-28T14:38:45.810Z 2025-12-04T15:12:14.689Z
8626304 8626304 20251126084835_BIa2t US004P 2025-11-28T14:38:39.467Z 2025-12-04T15:12:11.554Z
8626295 8626295 20251126084648_mIugl US004P 2025-11-28T14:38:36.298Z 2025-12-04T15:12:11.256Z
8626276 8626276 20251126084114_azNtO US004P 2025-11-28T14:38:29.765Z 2025-12-04T15:12:10.327Z
8626213 8626213 20251126081547_jEEmC US004P 2025-11-28T14:38:10.200Z 2025-12-04T15:12:00.820Z
8626188 8626188 20251126080641_2nM9M US004P 2025-11-28T14:38:04.546Z 2025-12-04T15:11:57.655Z
8626170 8626170 20251126080323_MTDqS US004P 2025-11-28T14:38:00.479Z 2025-12-04T15:11:55.016Z
8626140 8626140 20251126075144_w5R3Y US004P 2025-11-28T14:37:47.787Z 2025-12-04T15:11:53.541Z

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