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

5,228 rows where station_code = "US002Y" 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
8682008 8682008 20251203043751_ZXNaO US002Y 2025-12-04T14:16:09.226Z 2025-12-05T14:22:11.211Z
8681641 8681641 20251203033552_BHplq US002Y 2025-12-04T14:15:10.948Z 2025-12-05T14:21:44.690Z
8677651 8677651 20251203113038_HoiqK US002Y 2025-12-04T14:02:12.283Z 2025-12-05T14:14:34.909Z
8677482 8677482 20251203102046_uc5Gw US002Y 2025-12-04T14:01:23.150Z 2025-12-05T14:14:34.856Z
8669760 8669760 20251202120811_Wxufd US002Y 2025-12-03T14:05:22.888Z 2025-12-05T14:17:46.217Z
8669577 8669577 20251202113641_H76sf US002Y 2025-12-03T14:04:36.703Z 2025-12-05T14:17:33.433Z
8669454 8669454 20251202111319_8Qhzd US002Y 2025-12-03T14:03:59.808Z 2025-12-05T14:17:22.082Z
8669452 8669452 20251202111318_F7Smg US002Y 2025-12-03T14:03:59.381Z 2025-12-05T14:17:21.917Z
8669423 8669423 20251202111018_2cG3C US002Y 2025-12-03T14:03:42.118Z 2025-12-05T14:17:20.431Z
8669140 8669140 20251202101851_nZ2Ql US002Y 2025-12-03T14:02:42.657Z 2025-12-05T14:16:54.278Z
8669121 8669121 20251202101606_cGxYQ US002Y 2025-12-03T14:02:39.669Z 2025-12-05T14:16:53.030Z
8669071 8669071 20251202100812_bTYNV US002Y 2025-12-03T14:02:13.733Z 2025-12-05T14:16:48.795Z
8668662 8668662 20251202081312_gSQxh US002Y 2025-12-03T14:00:46.005Z 2025-12-05T14:14:54.413Z
8668351 8668351 20251130073549_aIz24 US002Y 2025-12-02T14:42:20.404Z 2025-12-05T14:46:07.127Z
8668093 8668093 20251130060114_fNK5X US002Y 2025-12-02T14:42:00.654Z 2025-12-05T14:45:35.758Z
8667821 8667821 20251130041726_A3sql US002Y 2025-12-02T14:40:29.939Z 2025-12-05T14:44:38.765Z
8660219 8660219 20251130120749_x8aQb US002Y 2025-12-02T14:06:57.604Z 2025-12-05T14:30:49.480Z
8660054 8660054 20251130114931_m75Al US002Y 2025-12-02T14:06:22.569Z 2025-12-05T14:30:42.182Z
8659879 8659879 20251130112529_CdQdc US002Y 2025-12-02T14:05:41.548Z 2025-12-05T14:30:34.753Z
8659823 8659823 20251130111945_J3C3O US002Y 2025-12-02T14:05:25.489Z 2025-12-05T14:30:32.715Z
8659807 8659807 20251130111733_uChwP US002Y 2025-12-02T14:05:22.353Z 2025-12-05T14:30:31.997Z
8659755 8659755 20251130111312_FwGRC US002Y 2025-12-02T14:05:14.680Z 2025-12-05T14:30:30.576Z
8659670 8659670 20251130110333_0rVH5 US002Y 2025-12-02T14:04:49.152Z 2025-12-05T14:30:27.124Z
8659579 8659579 20251130105053_ypyWz US002Y 2025-12-02T14:04:33.441Z 2025-12-05T14:30:23.968Z
8659563 8659563 20251130104911_Lnezh US002Y 2025-12-02T14:04:29.842Z 2025-12-05T14:30:23.102Z
8659319 8659319 20251130100906_2Pbtt US002Y 2025-12-02T14:03:29.117Z 2025-12-05T14:30:01.648Z
8659269 8659269 20251130100214_oRk4u US002Y 2025-12-02T14:03:20.430Z 2025-12-05T14:29:59.851Z
8659014 8659014 20251130091807_oydBQ US002Y 2025-12-02T14:02:09.698Z 2025-12-05T14:29:49.676Z
8658975 8658975 20251130090945_us1Xz US002Y 2025-12-02T14:01:58.792Z 2025-12-05T14:29:47.888Z
8658927 8658927 20251130085751_Swbgr US002Y 2025-12-02T14:01:40.652Z 2025-12-05T14:29:44.301Z
8658917 8658917 20251130085650_K8W1I US002Y 2025-12-02T14:01:38.354Z 2025-12-05T14:29:41.062Z
8658900 8658900 20251130085427_xcKUw US002Y 2025-12-02T14:01:27.964Z 2025-12-05T14:29:34.660Z
8658875 8658875 20251130084603_0G5F2 US002Y 2025-12-02T14:01:21.027Z 2025-12-05T14:29:33.713Z
8638091 8638091 20251128082257_Jh0Nc US002Y 2025-11-29T14:28:29.538Z 2025-12-05T15:00:45.851Z
8638085 8638085 20251128082101_zjF9X US002Y 2025-11-29T14:28:29.091Z 2025-12-05T15:00:45.760Z
8638063 8638063 20251128081725_MPmW2 US002Y 2025-11-29T14:28:27.603Z 2025-12-05T15:00:45.477Z
8638041 8638041 20251128081213_bKNSM US002Y 2025-11-29T14:28:26.163Z 2025-12-05T15:00:45.107Z
8637782 8637782 20251128064041_2FuH3 US002Y 2025-11-29T14:27:51.937Z 2025-12-05T15:00:27.093Z
8637695 8637695 20251128061758_SjJcl US002Y 2025-11-29T14:27:43.836Z 2025-12-05T15:00:14.941Z
8637606 8637606 20251128055940_ALrY0 US002Y 2025-11-29T14:27:37.498Z 2025-12-05T15:00:10.195Z
8636811 8636811 20251128042928_0BmWU US002Y 2025-11-29T14:26:13.811Z 2025-12-05T14:59:30.177Z
8627871 8627871 20251128114733_wCalP US002Y 2025-11-29T14:04:40.185Z 2025-12-05T14:47:07.605Z
8627378 8627378 20251128105444_Od9tL US002Y 2025-11-29T14:03:27.763Z 2025-12-05T14:46:58.444Z
8627176 8627176 20251128103305_vyAp3 US002Y 2025-11-29T14:02:53.662Z 2025-12-05T14:46:54.752Z
8626721 8626721 20251128092812_lMV58 US002Y 2025-11-29T14:01:19.608Z 2025-12-05T14:46:17.516Z
8626302 8626302 20251126084835_BIa2t US002Y 2025-11-28T14:38:39.467Z 2025-12-04T15:12:11.554Z
8626292 8626292 20251126084609_MXGG0 US002Y 2025-11-28T14:38:35.176Z 2025-12-04T15:12:11.214Z
8626286 8626286 20251126084532_tUoQb US002Y 2025-11-28T14:38:32.995Z 2025-12-04T15:12:10.851Z
8626267 8626267 20251126083939_u7uEa US002Y 2025-11-28T14:38:27.823Z 2025-12-04T15:12:09.591Z
8626211 8626211 20251126081547_jEEmC US002Y 2025-11-28T14:38:10.200Z 2025-12-04T15:12:00.820Z
8626186 8626186 20251126080641_2nM9M US002Y 2025-11-28T14:38:04.546Z 2025-12-04T15:11:57.655Z
8626168 8626168 20251126080323_MTDqS US002Y 2025-11-28T14:38:00.479Z 2025-12-04T15:11:55.016Z
8626118 8626118 20251126074037_pw1on US002Y 2025-11-28T14:37:43.261Z 2025-12-04T15:11:52.947Z
8626084 8626084 20251126072741_58fBH US002Y 2025-11-28T14:37:38.794Z 2025-12-04T15:11:52.136Z
8626070 8626070 20251126072412_lgVRZ US002Y 2025-11-28T14:37:34.627Z 2025-12-04T15:11:51.355Z
8625863 8625863 20251126060121_2IoYc US002Y 2025-11-28T14:37:17.794Z 2025-12-04T15:11:39.659Z
8625810 8625810 20251126053502_Aan2W US002Y 2025-11-28T14:37:09.587Z 2025-12-04T15:11:35.051Z
8625798 8625798 20251126052629_OowWi US002Y 2025-11-28T14:36:41.823Z 2025-12-04T15:11:33.558Z
8625750 8625750 20251126045205_2asmU US002Y 2025-11-28T14:36:20.946Z 2025-12-04T15:11:27.145Z
8625650 8625650 20251126035523_ZbM9o US002Y 2025-11-28T14:35:30.384Z 2025-12-04T15:10:27.235Z
8625628 8625628 20251126034346_A4isk US002Y 2025-11-28T14:35:25.409Z 2025-12-04T15:10:01.732Z
8625583 8625583 20251126031214_aQHNm US002Y 2025-11-28T14:35:11.620Z 2025-12-04T15:09:39.334Z
8625553 8625553 20251126025912_k70BI US002Y 2025-11-28T14:35:05.917Z 2025-12-04T15:09:36.497Z
8625506 8625506 20251126022439_Ti32Z US002Y 2025-11-28T14:34:26.918Z 2025-12-04T15:09:29.032Z
8625412 8625412 20251126003811_pWQQ3 US002Y 2025-11-28T14:33:20.513Z 2025-12-04T15:08:04.016Z
8623476 8623476 20251127004918_08VA2 US002Y 2025-11-28T14:21:48.751Z 2025-12-05T15:03:55.913Z
8620311 8620311 20251126121344_aGtSD US002Y 2025-11-28T14:12:24.811Z 2025-12-05T15:01:46.844Z
8620088 8620088 20251126114338_8V7CT US002Y 2025-11-28T14:11:35.226Z 2025-12-05T15:01:27.896Z
8619828 8619828 20251126110431_CQed5 US002Y 2025-11-28T14:10:32.375Z 2025-12-05T15:01:09.865Z
8619578 8619578 20251126102857_cLadc US002Y 2025-11-28T14:09:30.499Z 2025-12-05T15:01:02.165Z
8619507 8619507 20251126101942_kTeep US002Y 2025-11-28T14:09:14.520Z 2025-12-05T15:01:00.473Z
8619296 8619296 20251126094610_KXcf6 US002Y 2025-11-28T14:08:17.355Z 2025-12-05T15:00:55.766Z
8619282 8619282 20251126094206_WoS8N US002Y 2025-11-28T14:08:14.116Z 2025-12-05T15:00:55.384Z
8619225 8619225 20251126093158_mq0x2 US002Y 2025-11-28T14:07:54.960Z 2025-12-05T15:00:53.836Z
8618413 8618413 20251127121616_50CHI US002Y 2025-11-28T14:04:28.659Z 2025-12-05T14:54:15.215Z
8618349 8618349 20251127120724_Hte9K US002Y 2025-11-28T14:04:18.717Z 2025-12-05T14:54:13.801Z
8593538 8593538 20251125115133_X963v US002Y 2025-11-26T14:02:28.434Z 2025-12-04T15:05:19.509Z
8593524 8593524 20251125114758_k5C9C US002Y 2025-11-26T14:02:26.051Z 2025-12-04T15:05:19.190Z
8593459 8593459 20251125112748_GOi6N US002Y 2025-11-26T14:02:15.764Z 2025-12-04T15:05:18.246Z
8593439 8593439 20251125112434_JQFnK US002Y 2025-11-26T14:02:11.603Z 2025-12-04T15:05:17.983Z
8593436 8593436 20251125112255_57YtK US002Y 2025-11-26T14:02:11.165Z 2025-12-04T15:05:17.974Z
8593392 8593392 20251125111416_oZJ3P US002Y 2025-11-26T14:01:55.896Z 2025-12-04T15:05:17.056Z
8593378 8593378 20251125111029_EhUkR US002Y 2025-11-26T14:01:52.568Z 2025-12-04T15:05:16.718Z
8593217 8593217 20251125103813_nZepA US002Y 2025-11-26T14:01:18.728Z 2025-12-04T15:05:13.458Z
8593113 8593113 20251125101222_wQqrK US002Y 2025-11-26T14:00:53.880Z 2025-12-04T15:05:11.598Z
8592865 8592865 20251123091004_wv3vY US002Y 2025-11-25T14:37:15.001Z 2025-12-01T15:22:29.467Z
8583875 8583875 20251123100410_7y3zR US002Y 2025-11-25T14:04:20.966Z 2025-12-02T15:09:43.657Z
8583020 8583020 20251123094228_uh9PG US002Y 2025-11-24T14:34:45.691Z 2025-12-01T15:22:30.854Z
8582978 8582978 20251123092604_fYw7B US002Y 2025-11-24T14:34:40.765Z 2025-12-01T15:22:30.257Z
8582957 8582957 20251123091906_eCQjA US002Y 2025-11-24T14:34:39.440Z 2025-12-01T15:22:30.033Z
8582920 8582920 20251123091131_hYvCo US002Y 2025-11-24T14:34:37.348Z 2025-12-01T15:22:29.506Z
8582917 8582917 20251123091025_rdUUw US002Y 2025-11-24T14:34:37.268Z 2025-12-01T15:22:29.496Z
8582842 8582842 20251123085254_qgYTR US002Y 2025-11-24T14:34:33.326Z 2025-12-01T15:22:28.530Z
8582817 8582817 20251123084234_GouTk US002Y 2025-11-24T14:34:32.072Z 2025-12-01T15:22:28.290Z
8582750 8582750 20251123081951_QXwnR US002Y 2025-11-24T14:34:28.975Z 2025-12-01T15:22:27.532Z
8582484 8582484 20251123063231_VRHGh US002Y 2025-11-24T14:33:42.017Z 2025-12-01T15:22:24.406Z
8581807 8581807 20251123023358_12JQM US002Y 2025-11-24T14:32:39.428Z 2025-12-01T15:21:41.829Z
8581793 8581793 20251123022650_eP37T US002Y 2025-11-24T14:32:38.437Z 2025-12-01T15:21:37.472Z
8581692 8581692 20251123014228_w3VCo US002Y 2025-11-24T14:32:32.307Z 2025-12-01T15:21:15.125Z
8581124 8581124 20251122095130_zabFj US002Y 2025-11-24T14:29:33.899Z 2025-11-30T15:07:21.570Z

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