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

>10,000 rows count all where station_code = "US001P" 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
9596065 9596065 20260330105818_v8Ef3 US001P 2026-03-31T12:03:19.014Z 2026-04-07T12:24:40.444Z
9595903 9595903 20260330095753_ww5Yk US001P 2026-03-31T12:02:47.420Z 2026-04-07T12:24:18.530Z
9595828 9595828 20260330091103_i7t6e US001P 2026-03-31T12:02:38.497Z 2026-04-07T12:24:16.610Z
9593505 9593505 20260329113218_XF6h0 US001P 2026-03-30T12:04:12.497Z 2026-04-07T12:27:12.637Z
9593503 9593503 20260329112821_PuQxx US001P 2026-03-30T12:04:12.117Z 2026-04-07T12:27:12.546Z
9593458 9593458 20260329105550_K2acE US001P 2026-03-30T12:04:01.188Z 2026-04-07T12:27:10.675Z
9593432 9593432 20260329103912_w2LI2 US001P 2026-03-30T12:03:56.924Z 2026-04-07T12:27:09.995Z
9593422 9593422 20260329103719_ucyol US001P 2026-03-30T12:03:54.841Z 2026-04-07T12:27:09.791Z
9593360 9593360 20260329095054_Q9Ey2 US001P 2026-03-30T12:03:43.936Z 2026-04-07T12:27:08.222Z
9590854 9590854 20260328113455_R0tt1 US001P 2026-03-29T12:03:23.899Z 2026-04-06T12:38:37.470Z
9590847 9590847 20260328113254_55P0k US001P 2026-03-29T12:03:23.283Z 2026-04-06T12:38:37.225Z
9590651 9590651 20260328103607_tIdHU US001P 2026-03-29T12:03:04.782Z 2026-04-06T12:38:29.213Z
9590622 9590622 20260328102722_4VOOj US001P 2026-03-29T12:03:01.712Z 2026-04-06T12:38:27.771Z
9590608 9590608 20260328102146_FYWIy US001P 2026-03-29T12:02:59.823Z 2026-04-06T12:38:26.804Z
9590590 9590590 20260328101629_5ooX6 US001P 2026-03-29T12:02:58.310Z 2026-04-06T12:38:26.089Z
9590568 9590568 20260328100538_q5InL US001P 2026-03-29T12:02:55.450Z 2026-04-06T12:38:24.551Z
9590494 9590494 20260328093825_sOPJT US001P 2026-03-29T12:02:47.670Z 2026-04-06T12:38:12.540Z
9590476 9590476 20260328092341_KQ7G6 US001P 2026-03-29T12:02:44.015Z 2026-04-06T12:38:11.558Z
9590435 9590435 20260328091321_bN9zO US001P 2026-03-29T12:02:39.255Z 2026-04-06T12:38:09.727Z
9590286 9590286 20260328080236_oP2ti US001P 2026-03-29T12:02:22.244Z 2026-04-06T12:37:59.777Z
9590252 9590252 20260328075216_Wg0aH US001P 2026-03-29T12:02:19.838Z 2026-04-06T12:37:58.556Z
9590230 9590230 20260328073920_UgVu3 US001P 2026-03-29T12:02:16.134Z 2026-04-06T12:37:57.476Z
9590211 9590211 20260328073247_EDJ4Z US001P 2026-03-29T12:02:13.851Z 2026-04-06T12:37:56.542Z
9590192 9590192 20260328072939_kXma8 US001P 2026-03-29T12:02:12.105Z 2026-04-06T12:37:55.724Z
9589557 9589557 20260328034616_nUzxs US001P 2026-03-29T12:01:25.594Z 2026-04-06T12:37:27.565Z
9587123 9587123 20260327111727_vLEr1 US001P 2026-03-28T12:04:49.818Z 2026-04-05T12:34:02.847Z
9586988 9586988 20260327103801_UCBea US001P 2026-03-28T12:04:30.135Z 2026-04-05T12:33:57.249Z
9586944 9586944 20260327102153_EnINi US001P 2026-03-28T12:04:24.190Z 2026-04-05T12:33:55.355Z
9586396 9586396 20260327070724_P3Muc US001P 2026-03-28T12:02:59.131Z 2026-04-05T12:33:23.499Z
9586369 9586369 20260327064940_LWoRg US001P 2026-03-28T12:02:55.715Z 2026-04-05T12:33:22.541Z
9583200 9583200 20260326113713_997Gn US001P 2026-03-27T12:08:01.899Z 2026-04-04T12:40:56.264Z
9583176 9583176 20260326113201_192mn US001P 2026-03-27T12:07:56.994Z 2026-04-04T12:40:55.114Z
9583163 9583163 20260326112924_2zowP US001P 2026-03-27T12:07:55.812Z 2026-04-04T12:40:54.715Z
9582973 9582973 20260326103103_F1AlF US001P 2026-03-27T12:07:22.265Z 2026-04-04T12:40:38.627Z
9582962 9582962 20260326102821_faO5V US001P 2026-03-27T12:07:20.995Z 2026-04-04T12:40:38.233Z
9582784 9582784 20260326092430_BnRya US001P 2026-03-27T12:06:47.251Z 2026-04-04T12:40:28.110Z
9582671 9582671 20260326090119_jUQju US001P 2026-03-27T12:06:30.494Z 2026-04-04T12:40:18.388Z
9582534 9582534 20260326081822_b1jqW US001P 2026-03-27T12:06:04.819Z 2026-04-04T12:40:07.472Z
9582519 9582519 20260326081420_LkM4X US001P 2026-03-27T12:06:01.819Z 2026-04-04T12:40:06.218Z
9582454 9582454 20260326074146_aple1 US001P 2026-03-27T12:05:50.650Z 2026-04-04T12:40:01.897Z
9582445 9582445 20260326073342_gEkY2 US001P 2026-03-27T12:05:47.381Z 2026-04-04T12:40:01.355Z
9582401 9582401 20260326071812_AGqgT US001P 2026-03-27T12:05:40.170Z 2026-04-04T12:39:59.609Z
9582306 9582306 20260326064107_VJa5n US001P 2026-03-27T12:05:20.366Z 2026-04-04T12:39:49.620Z
9582297 9582297 20260326062755_0oFMN US001P 2026-03-27T12:05:18.486Z 2026-04-04T12:39:49.201Z
9582248 9582248 20260326054541_22col US001P 2026-03-27T12:05:06.287Z 2026-04-04T12:39:45.258Z
9582236 9582236 20260326053400_OCM9N US001P 2026-03-27T12:05:03.606Z 2026-04-04T12:39:44.066Z
9582098 9582098 20260326043627_Rejlu US001P 2026-03-27T12:04:37.192Z 2026-04-04T12:39:37.637Z
9582070 9582070 20260326043023_333Bg US001P 2026-03-27T12:04:31.491Z 2026-04-04T12:39:36.683Z
9582050 9582050 20260326042439_YnhXh US001P 2026-03-27T12:04:29.599Z 2026-04-04T12:39:36.283Z
9582046 9582046 20260326042330_CK5cn US001P 2026-03-27T12:04:28.447Z 2026-04-04T12:39:35.941Z
9581442 9581442 20260326031409_WgOgu US001P 2026-03-27T12:03:08.683Z 2026-04-04T12:39:06.063Z
9578507 9578507 20260325120742_k6E3J US001P 2026-03-26T12:07:46.967Z 2026-04-03T12:38:06.256Z
9578332 9578332 20260325112402_aE6hD US001P 2026-03-26T12:07:21.047Z 2026-04-03T12:37:59.074Z
9578270 9578270 20260325110421_FCdIh US001P 2026-03-26T12:07:10.844Z 2026-04-03T12:37:45.992Z
9578234 9578234 20260325105208_U3HC5 US001P 2026-03-26T12:07:05.371Z 2026-04-03T12:37:44.219Z
9578169 9578169 20260325103756_eh7By US001P 2026-03-26T12:06:53.491Z 2026-04-03T12:37:41.895Z
9578133 9578133 20260325101900_GWhxX US001P 2026-03-26T12:06:48.757Z 2026-04-03T12:37:38.593Z
9578057 9578057 20260325094615_HE4XP US001P 2026-03-26T12:06:39.725Z 2026-04-03T12:37:35.461Z
9577945 9577945 20260325092109_qyFh1 US001P 2026-03-26T12:06:24.539Z 2026-04-03T12:37:32.008Z
9577909 9577909 20260325091305_itcZ2 US001P 2026-03-26T12:06:19.998Z 2026-04-03T12:37:30.676Z
9577856 9577856 20260325085855_VKZx0 US001P 2026-03-26T12:06:14.163Z 2026-04-03T12:37:29.250Z
9577727 9577727 20260325081730_2X5fc US001P 2026-03-26T12:05:56.290Z 2026-04-03T12:37:24.791Z
9577702 9577702 20260325081019_WMI3u US001P 2026-03-26T12:05:54.094Z 2026-04-03T12:37:23.330Z
9577650 9577650 20260325075824_B2soZ US001P 2026-03-26T12:05:46.152Z 2026-04-03T12:37:12.291Z
9577646 9577646 20260325075809_d44rI US001P 2026-03-26T12:05:45.265Z 2026-04-03T12:37:12.076Z
9577624 9577624 20260325075026_AXbxd US001P 2026-03-26T12:05:39.988Z 2026-04-03T12:37:11.123Z
9577584 9577584 20260325073504_akdCp US001P 2026-03-26T12:05:34.913Z 2026-04-03T12:37:09.376Z
9577562 9577562 20260325072504_4CQv3 US001P 2026-03-26T12:05:31.651Z 2026-04-03T12:37:06.769Z
9577431 9577431 20260325061109_9ovzq US001P 2026-03-26T12:05:08.042Z 2026-04-03T12:37:01.487Z
9577403 9577403 20260325054613_TX2GO US001P 2026-03-26T12:05:02.395Z 2026-04-03T12:37:00.531Z
9577361 9577361 20260325051547_W0sDC US001P 2026-03-26T12:04:55.333Z 2026-04-03T12:36:58.794Z
9576824 9576824 20260325031358_d0jdx US001P 2026-03-26T12:03:24.639Z 2026-04-03T12:36:22.454Z
9573338 9573338 20260324115313_fHLlK US001P 2026-03-25T12:07:45.674Z 2026-04-02T12:36:05.313Z
9573279 9573279 20260324114449_zguT6 US001P 2026-03-25T12:07:37.949Z 2026-04-02T12:36:02.607Z
9573164 9573164 20260324112601_pTTap US001P 2026-03-25T12:07:18.073Z 2026-04-02T12:35:57.919Z
9573155 9573155 20260324112447_NZiYI US001P 2026-03-25T12:07:16.506Z 2026-04-02T12:35:57.507Z
9572902 9572902 20260324104809_7cf4T US001P 2026-03-25T12:06:40.726Z 2026-04-02T12:35:43.124Z
9572817 9572817 20260324102924_3L956 US001P 2026-03-25T12:06:23.178Z 2026-04-02T12:35:39.251Z
9572811 9572811 20260324102819_6pzg3 US001P 2026-03-25T12:06:22.147Z 2026-04-02T12:35:38.999Z
9572793 9572793 20260324102226_WSsJR US001P 2026-03-25T12:06:19.644Z 2026-04-02T12:35:38.363Z
9572522 9572522 20260324092212_hKLGp US001P 2026-03-25T12:05:27.561Z 2026-04-02T12:35:28.587Z
9572486 9572486 20260324091307_TTEes US001P 2026-03-25T12:05:19.253Z 2026-04-02T12:35:26.709Z
9572393 9572393 20260324085425_RBE2c US001P 2026-03-25T12:04:56.412Z 2026-04-02T12:35:22.748Z
9572391 9572391 20260324085406_i3Av9 US001P 2026-03-25T12:04:55.722Z 2026-04-02T12:35:22.617Z
9572270 9572270 20260324082446_rfsrR US001P 2026-03-25T12:04:30.723Z 2026-04-02T12:35:11.855Z
9572192 9572192 20260324080245_iSOXR US001P 2026-03-25T12:04:12.084Z 2026-04-02T12:35:07.256Z
9565248 9565248 20260323115259_8ylje US001P 2026-03-24T12:09:43.454Z 2026-03-31T12:27:31.842Z
9564979 9564979 20260323113330_TxE3A US001P 2026-03-24T12:09:09.607Z 2026-03-31T12:27:20.230Z
9564735 9564735 20260323110420_PvlQU US001P 2026-03-24T12:08:40.653Z 2026-03-31T12:27:14.466Z
9564238 9564238 20260323101612_KZycS US001P 2026-03-24T12:07:41.923Z 2026-03-31T12:27:05.728Z
9564100 9564100 20260323095801_iUPK8 US001P 2026-03-24T12:07:25.556Z 2026-03-31T12:27:02.513Z
9563149 9563149 20260323072102_pjqM2 US001P 2026-03-24T12:05:15.524Z 2026-03-31T12:26:36.463Z
9563127 9563127 20260323070553_HZwIn US001P 2026-03-24T12:05:10.759Z 2026-03-31T12:26:35.734Z
9556954 9556954 20260322121858_tFgnq US001P 2026-03-23T12:05:23.351Z 2026-03-30T12:29:16.730Z
9556879 9556879 20260322120300_7YjCF US001P 2026-03-23T12:05:18.698Z 2026-03-30T12:29:13.737Z
9556754 9556754 20260322113317_wVjAi US001P 2026-03-23T12:05:11.244Z 2026-03-30T12:29:10.200Z
9556561 9556561 20260322110735_W7FDN US001P 2026-03-23T12:04:56.969Z 2026-03-30T12:29:04.871Z
9556384 9556384 20260322102034_ctXPc US001P 2026-03-23T12:04:44.109Z 2026-03-30T12:28:59.376Z
9556283 9556283 20260322095804_ZLDxj US001P 2026-03-23T12:04:37.357Z 2026-03-30T12:28:56.687Z
9556134 9556134 20260322092210_h64Ab US001P 2026-03-23T12:04:23.565Z 2026-03-30T12:28:45.729Z

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