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 = "HR000P" 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
9611036 9611036 20260404233543_7ixH7 HR000P 2026-04-06T12:12:42.723Z 2026-04-06T12:16:14.717Z
9611011 9611011 20260404232220_78YBL HR000P 2026-04-06T12:12:34.223Z 2026-04-06T12:16:14.712Z
9610466 9610466 20260404193948_C46q4 HR000P 2026-04-06T12:09:39.270Z 2026-04-06T12:16:14.572Z
9608774 9608774 20260404012112_9bwjQ HR000P 2026-04-05T12:11:39.081Z 2026-04-06T12:20:36.241Z
9608700 9608700 20260404005104_4V3tD HR000P 2026-04-05T12:11:21.045Z 2026-04-06T12:20:31.724Z
9608695 9608695 20260404004825_Ou03e HR000P 2026-04-05T12:11:19.675Z 2026-04-06T12:20:31.362Z
9608693 9608693 20260404004811_bBrWE HR000P 2026-04-05T12:11:19.065Z 2026-04-06T12:20:31.208Z
9608526 9608526 20260403233146_wD52A HR000P 2026-04-05T12:10:44.606Z 2026-04-06T12:20:18.727Z
9608409 9608409 20260403225929_lUxM7 HR000P 2026-04-05T12:10:22.743Z 2026-04-06T12:20:11.380Z
9608385 9608385 20260403224931_fi8Gp HR000P 2026-04-05T12:10:18.643Z 2026-04-06T12:20:09.787Z
9584458 9584458 20260325195810_EcoOy HR000P 2026-03-27T12:15:22.264Z 2026-04-03T12:39:14.987Z
9576951 9576951 20260325032905_L9ane HR000P 2026-03-26T12:03:44.702Z 2026-04-03T12:36:26.775Z
9576933 9576933 20260325032713_OCC9H HR000P 2026-03-26T12:03:42.607Z 2026-04-03T12:36:26.263Z
9576857 9576857 20260325031739_NELzb HR000P 2026-03-26T12:03:31.090Z 2026-04-03T12:36:23.889Z
9576805 9576805 20260325031049_CNm9D HR000P 2026-03-26T12:03:21.253Z 2026-04-03T12:36:21.711Z
9576731 9576731 20260325030136_z9Rbw HR000P 2026-03-26T12:03:08.977Z 2026-04-03T12:36:19.264Z
9576724 9576724 20260325030026_T22ww HR000P 2026-03-26T12:03:08.370Z 2026-04-03T12:36:19.173Z
9576680 9576680 20260325025307_E3jG6 HR000P 2026-03-26T12:02:59.275Z 2026-04-03T12:36:17.215Z
9576604 9576604 20260325024112_BBigP HR000P 2026-03-26T12:02:46.498Z 2026-04-03T12:36:14.386Z
9576336 9576336 20260325015532_FgaEV HR000P 2026-03-26T12:01:58.363Z 2026-04-03T12:35:53.740Z
9575098 9575098 20260323184120_p2hSv HR000P 2026-03-25T12:20:16.965Z 2026-03-31T12:28:48.227Z
9575043 9575043 20260323182649_m0x7s HR000P 2026-03-25T12:20:11.704Z 2026-03-31T12:28:47.180Z
9571130 9571130 20260322235023_3xfF8 HR000P 2026-03-24T12:24:22.561Z 2026-03-30T12:30:55.737Z
9571012 9571012 20260322233725_1uAlT HR000P 2026-03-24T12:24:09.368Z 2026-03-30T12:30:53.727Z
9562818 9562818 20260323031942_YWQ99 HR000P 2026-03-24T12:04:09.403Z 2026-03-31T12:26:26.825Z
9562657 9562657 20260323025820_j1QTJ HR000P 2026-03-24T12:03:42.571Z 2026-03-31T12:26:16.900Z
9562381 9562381 20260323021613_a9dCY HR000P 2026-03-24T12:02:57.584Z 2026-03-31T12:26:09.117Z
9562325 9562325 20260323020859_JRVgC HR000P 2026-03-24T12:02:49.978Z 2026-03-31T12:26:07.848Z
9562307 9562307 20260323020553_4u1hg HR000P 2026-03-24T12:02:47.576Z 2026-03-31T12:26:07.383Z
9562060 9562060 20260323012747_mHRMK HR000P 2026-03-24T12:02:03.082Z 2026-03-31T12:26:00.600Z
9561984 9561984 20260323010903_AzZAO HR000P 2026-03-24T12:01:46.273Z 2026-03-31T12:25:58.304Z
9561850 9561850 20260323005037_aNfBJ HR000P 2026-03-24T12:01:28.041Z 2026-03-31T12:25:55.119Z
9561571 9561571 20260323000514_pTy5l HR000P 2026-03-24T12:00:31.242Z 2026-03-31T12:25:47.391Z
9542244 9542244 20260319230506_89Fsv HR000P 2026-03-21T12:29:53.638Z 2026-03-27T12:42:50.847Z
9542240 9542240 20260319230506_RKCSM HR000P 2026-03-21T12:29:53.592Z 2026-03-27T12:42:50.763Z
9541794 9541794 20260319214545_EK3K1 HR000P 2026-03-21T12:29:22.747Z 2026-03-27T12:42:41.912Z
9541735 9541735 20260319213532_TLAe2 HR000P 2026-03-21T12:29:19.263Z 2026-03-27T12:42:41.190Z
9534407 9534407 20260320034833_I2weP HR000P 2026-03-21T12:07:55.187Z 2026-03-28T12:34:18.035Z
9534355 9534355 20260320034444_5YayL HR000P 2026-03-21T12:07:46.254Z 2026-03-28T12:34:17.564Z
9534342 9534342 20260320034214_iModM HR000P 2026-03-21T12:07:43.704Z 2026-03-28T12:34:17.414Z
9534177 9534177 20260320033358_mx3Pz HR000P 2026-03-21T12:07:22.319Z 2026-03-28T12:34:15.515Z
9533977 9533977 20260320031347_VyI7O HR000P 2026-03-21T12:06:49.034Z 2026-03-28T12:34:03.022Z
9533904 9533904 20260320030818_6tA5a HR000P 2026-03-21T12:06:35.504Z 2026-03-28T12:34:02.080Z
9533759 9533759 20260320025601_RMyTL HR000P 2026-03-21T12:06:13.104Z 2026-03-28T12:34:00.231Z
9533675 9533675 20260320025128_ldK6p HR000P 2026-03-21T12:06:01.089Z 2026-03-28T12:33:58.372Z
9533654 9533654 20260320024901_EI0pL HR000P 2026-03-21T12:05:57.225Z 2026-03-28T12:33:57.574Z
9533417 9533417 20260320023026_4LaFn HR000P 2026-03-21T12:05:24.579Z 2026-03-28T12:33:53.007Z
9533336 9533336 20260320022431_RM2Yu HR000P 2026-03-21T12:05:11.378Z 2026-03-28T12:33:52.110Z
9533194 9533194 20260320021110_xjTu8 HR000P 2026-03-21T12:04:45.925Z 2026-03-28T12:33:50.209Z
9533025 9533025 20260320015029_Aw2ll HR000P 2026-03-21T12:04:15.337Z 2026-03-28T12:33:47.781Z
9532908 9532908 20260320013728_KLilb HR000P 2026-03-21T12:03:56.389Z 2026-03-28T12:33:46.275Z
9532659 9532659 20260320011729_VPXGo HR000P 2026-03-21T12:03:21.627Z 2026-03-28T12:33:35.038Z
9532572 9532572 20260320010750_bKHxB HR000P 2026-03-21T12:03:05.869Z 2026-03-28T12:33:34.151Z
9532309 9532309 20260320004656_0wdvO HR000P 2026-03-21T12:02:21.522Z 2026-03-28T12:33:27.569Z
9532209 9532209 20260320003728_NmExB HR000P 2026-03-21T12:02:04.417Z 2026-03-28T12:33:25.853Z
9532177 9532177 20260320003017_4U5h2 HR000P 2026-03-21T12:01:56.065Z 2026-03-28T12:33:25.349Z
9532170 9532170 20260320002606_dttqU HR000P 2026-03-21T12:01:54.417Z 2026-03-28T12:33:25.237Z
9532162 9532162 20260320002550_ZSBFe HR000P 2026-03-21T12:01:53.023Z 2026-03-28T12:33:25.122Z
9532103 9532103 20260320001856_w1vA1 HR000P 2026-03-21T12:01:43.796Z 2026-03-28T12:33:24.650Z
9531853 9531853 20260319235609_iZtDA HR000P 2026-03-21T12:01:02.468Z 2026-03-28T12:33:22.233Z
9531623 9531623 20260319232954_EQ2tm HR000P 2026-03-21T12:00:22.316Z 2026-03-28T12:33:19.287Z
9531546 9531546 20260319232448_n11ja HR000P 2026-03-21T12:00:12.576Z 2026-03-28T12:33:18.247Z
9531141 9531141 20260318223521_NDq0G HR000P 2026-03-20T12:24:59.078Z 2026-03-26T12:39:17.718Z
9530835 9530835 20260318215111_gLaON HR000P 2026-03-20T12:24:49.015Z 2026-03-26T12:39:16.035Z
9520059 9520059 20260319024929_k7Sxf HR000P 2026-03-20T12:05:36.177Z 2026-03-27T12:40:38.369Z
9518780 9518780 20260319012452_3FnM3 HR000P 2026-03-20T12:03:19.909Z 2026-03-27T12:40:13.764Z
9517882 9517882 20260319000927_N8NBV HR000P 2026-03-20T12:01:28.417Z 2026-03-27T12:40:04.513Z
9517603 9517603 20260318234655_s7q2f HR000P 2026-03-20T12:00:48.955Z 2026-03-27T12:40:01.408Z
9517563 9517563 20260318233941_ebSJR HR000P 2026-03-20T12:00:43.676Z 2026-03-27T12:40:00.962Z
9506597 9506597 20260316183314_8PS34 HR000P 2026-03-18T12:19:03.813Z 2026-03-24T12:41:33.745Z
9501568 9501568 20260315224245_uZfFs HR000P 2026-03-17T12:25:14.856Z 2026-03-23T12:22:44.908Z
9501561 9501561 20260315224153_xvLoB HR000P 2026-03-17T12:25:14.367Z 2026-03-23T12:22:44.883Z
9501486 9501486 20260315222744_zfhY3 HR000P 2026-03-17T12:25:05.192Z 2026-03-23T12:22:44.702Z
9501410 9501410 20260315221316_bw580 HR000P 2026-03-17T12:24:57.804Z 2026-03-23T12:22:44.326Z
9501375 9501375 20260315220547_yO3oi HR000P 2026-03-17T12:24:54.905Z 2026-03-23T12:22:44.159Z
9501359 9501359 20260315220357_gQjCA HR000P 2026-03-17T12:24:53.374Z 2026-03-23T12:22:44.096Z
9501163 9501163 20260315212301_A4mOO HR000P 2026-03-17T12:24:33.488Z 2026-03-23T12:22:43.438Z
9501062 9501062 20260315205028_0NKPp HR000P 2026-03-17T12:24:22.000Z 2026-03-23T12:22:42.909Z
9501034 9501034 20260315204202_IcRkn HR000P 2026-03-17T12:24:20.033Z 2026-03-23T12:22:42.829Z
9494989 9494989 20260316034917_ZZMcS HR000P 2026-03-17T12:05:45.017Z 2026-03-24T12:40:52.223Z
9494778 9494778 20260316030054_c5NTU HR000P 2026-03-17T12:04:55.902Z 2026-03-24T12:40:49.989Z
9494616 9494616 20260316023723_Y03uE HR000P 2026-03-17T12:04:24.123Z 2026-03-24T12:40:48.781Z
9494587 9494587 20260316023135_zjpK3 HR000P 2026-03-17T12:04:18.315Z 2026-03-24T12:40:48.487Z
9494580 9494580 20260316022952_2Kmqb HR000P 2026-03-17T12:04:17.281Z 2026-03-24T12:40:48.431Z
9494564 9494564 20260316022850_bAPWY HR000P 2026-03-17T12:04:15.556Z 2026-03-24T12:40:48.239Z
9494516 9494516 20260316022559_aakyh HR000P 2026-03-17T12:04:09.809Z 2026-03-24T12:40:48.013Z
9494488 9494488 20260316022433_3RrNU HR000P 2026-03-17T12:04:07.320Z 2026-03-24T12:40:47.868Z
9494443 9494443 20260316021850_oPlx0 HR000P 2026-03-17T12:03:58.946Z 2026-03-24T12:40:47.617Z
9494327 9494327 20260316015641_dyadq HR000P 2026-03-17T12:03:38.588Z 2026-03-24T12:40:46.950Z
9494306 9494306 20260316015400_E6mZy HR000P 2026-03-17T12:03:35.291Z 2026-03-24T12:40:46.877Z
9494270 9494270 20260316014839_btIdM HR000P 2026-03-17T12:03:29.431Z 2026-03-24T12:40:46.438Z
9494233 9494233 20260316014331_OZI1E HR000P 2026-03-17T12:03:23.754Z 2026-03-24T12:40:46.005Z
9494206 9494206 20260316014115_NYzhS HR000P 2026-03-17T12:03:20.388Z 2026-03-24T12:40:45.202Z
9494203 9494203 20260316014039_2gNza HR000P 2026-03-17T12:03:19.873Z 2026-03-24T12:40:45.199Z
9494182 9494182 20260316013605_B3b2e HR000P 2026-03-17T12:03:13.845Z 2026-03-24T12:40:44.968Z
9494048 9494048 20260316011838_Tn1R8 HR000P 2026-03-17T12:02:53.030Z 2026-03-24T12:40:44.236Z
9493997 9493997 20260316010858_qA7Ea HR000P 2026-03-17T12:02:42.989Z 2026-03-24T12:40:43.852Z
9493962 9493962 20260316010157_v87fy HR000P 2026-03-17T12:02:33.892Z 2026-03-24T12:40:43.571Z
9493939 9493939 20260316005854_itKzD HR000P 2026-03-17T12:02:29.162Z 2026-03-24T12:40:43.335Z
9493924 9493924 20260316005735_05pMM HR000P 2026-03-17T12:02:27.195Z 2026-03-24T12:40:43.205Z

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