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

3,186 rows where station_code = "HR002M" 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
7871764 7871764 20250918000719_8o9Dh HR002M 2025-09-19T12:32:10.951Z 2025-09-25T13:13:15.841Z
7871735 7871735 20250918000409_wlxuw HR002M 2025-09-19T12:31:55.763Z 2025-09-25T13:13:15.693Z
7871463 7871463 20250917233830_1Hqqo HR002M 2025-09-19T12:31:23.999Z 2025-09-25T13:13:08.941Z
7871447 7871447 20250917233701_Kz4dN HR002M 2025-09-19T12:31:23.053Z 2025-09-25T13:13:08.875Z
7871411 7871411 20250917233246_CRgCZ HR002M 2025-09-19T12:31:20.914Z 2025-09-25T13:13:08.775Z
7871378 7871378 20250917232832_wGIXb HR002M 2025-09-19T12:31:18.658Z 2025-09-25T13:13:08.047Z
7871355 7871355 20250917232512_Vo6it HR002M 2025-09-19T12:31:16.606Z 2025-09-25T13:13:07.107Z
7871212 7871212 20250917230913_Ntg59 HR002M 2025-09-19T12:30:40.868Z 2025-09-25T13:13:03.318Z
7871186 7871186 20250917230736_I63OK HR002M 2025-09-19T12:30:36.988Z 2025-09-25T13:13:03.213Z
7871113 7871113 20250917225932_uITO4 HR002M 2025-09-19T12:30:29.618Z 2025-09-25T13:13:02.801Z
7871011 7871011 20250917224914_IoLdW HR002M 2025-09-19T12:30:22.156Z 2025-09-25T13:13:02.276Z
7870961 7870961 20250917224505_fAnVh HR002M 2025-09-19T12:30:18.417Z 2025-09-25T13:13:01.978Z
7870881 7870881 20250917223627_3ePuU HR002M 2025-09-19T12:29:54.285Z 2025-09-25T13:13:00.720Z
7870872 7870872 20250917223538_2Ulrw HR002M 2025-09-19T12:29:51.683Z 2025-09-25T13:13:00.547Z
7870838 7870838 20250917223317_eP7Mr HR002M 2025-09-19T12:29:49.028Z 2025-09-25T13:13:00.253Z
7870832 7870832 20250917223302_1C2fu HR002M 2025-09-19T12:29:48.592Z 2025-09-25T13:13:00.236Z
7870448 7870448 20250917215017_T5y22 HR002M 2025-09-19T12:28:48.267Z 2025-09-25T13:12:57.593Z
7870403 7870403 20250917214455_VmSVg HR002M 2025-09-19T12:28:44.522Z 2025-09-25T13:12:57.126Z
7870363 7870363 20250917213945_m392x HR002M 2025-09-19T12:28:40.852Z 2025-09-25T13:12:56.876Z
7870081 7870081 20250917205758_bKEMD HR002M 2025-09-19T12:27:55.920Z 2025-09-25T13:12:52.750Z
7869959 7869959 20250917204434_oMrzp HR002M 2025-09-19T12:27:29.846Z 2025-09-25T13:12:51.532Z
7869792 7869792 20250917202320_Er3Xo HR002M 2025-09-19T12:27:04.176Z 2025-09-25T13:12:49.144Z
7869676 7869676 20250917200821_HVLFV HR002M 2025-09-19T12:26:39.181Z 2025-09-25T13:12:46.595Z
7869599 7869599 20250917195956_HdMI2 HR002M 2025-09-19T12:26:22.565Z 2025-09-25T13:12:45.143Z
7869501 7869501 20250917194629_skFj1 HR002M 2025-09-19T12:26:12.299Z 2025-09-25T13:12:43.339Z
7869401 7869401 20250917193249_ssaiR HR002M 2025-09-19T12:25:47.027Z 2025-09-25T13:12:39.468Z
7869322 7869322 20250917191624_LgMlL HR002M 2025-09-19T12:25:27.999Z 2025-09-25T13:12:37.614Z
7869282 7869282 20250917190845_PMlcN HR002M 2025-09-19T12:25:22.581Z 2025-09-25T13:12:35.442Z
7869195 7869195 20250917185100_hbriK HR002M 2025-09-19T12:25:13.707Z 2025-09-25T13:12:33.060Z
7869149 7869149 20250917183625_53Ez2 HR002M 2025-09-19T12:25:01.776Z 2025-09-25T13:12:30.387Z
7869137 7869137 20250917182938_cVZLc HR002M 2025-09-19T12:24:55.949Z 2025-09-25T13:12:29.905Z
7869125 7869125 20250917182439_GNbrF HR002M 2025-09-19T12:24:54.368Z 2025-09-25T13:12:29.725Z
7869102 7869102 20250917181929_4MYma HR002M 2025-09-19T12:24:45.904Z 2025-09-25T13:12:28.503Z
7866309 7866309 20250918033654_vJbKH HR002M 2025-09-19T12:09:46.013Z 2025-09-27T12:46:29.100Z
7866242 7866242 20250918032812_dnYX3 HR002M 2025-09-19T12:09:23.330Z 2025-09-27T12:46:27.938Z
7866128 7866128 20250918031559_l0WGr HR002M 2025-09-19T12:09:03.154Z 2025-09-27T12:46:26.234Z
7866121 7866121 20250918031447_BHCeG HR002M 2025-09-19T12:09:02.003Z 2025-09-27T12:46:26.209Z
7866119 7866119 20250918031431_ErHDn HR002M 2025-09-19T12:09:01.543Z 2025-09-27T12:46:26.105Z
7866117 7866117 20250918031427_3eHc6 HR002M 2025-09-19T12:09:01.104Z 2025-09-27T12:46:26.090Z
7866010 7866010 20250918030506_dtPka HR002M 2025-09-19T12:08:31.898Z 2025-09-27T12:46:25.125Z
7866008 7866008 20250918030504_b738E HR002M 2025-09-19T12:08:31.374Z 2025-09-27T12:46:25.098Z
7866005 7866005 20250918030502_z97B8 HR002M 2025-09-19T12:08:31.063Z 2025-09-27T12:46:25.027Z
7865901 7865901 20250918025651_msdSm HR002M 2025-09-19T12:08:04.274Z 2025-09-27T12:46:22.798Z
7865754 7865754 20250918024430_WqR2x HR002M 2025-09-19T12:07:24.660Z 2025-09-27T12:46:17.962Z
7865637 7865637 20250918023201_hA6ru HR002M 2025-09-19T12:07:01.172Z 2025-09-27T12:46:16.706Z
7865596 7865596 20250918022907_OYAPq HR002M 2025-09-19T12:06:43.566Z 2025-09-27T12:46:14.673Z
7865528 7865528 20250918022153_CIHuF HR002M 2025-09-19T12:06:29.247Z 2025-09-27T12:46:12.027Z
7865505 7865505 20250918021949_Ju28E HR002M 2025-09-19T12:06:25.948Z 2025-09-27T12:46:11.796Z
7865486 7865486 20250918021905_k401Z HR002M 2025-09-19T12:06:22.998Z 2025-09-27T12:46:11.702Z
7865484 7865484 20250918021839_rYegF HR002M 2025-09-19T12:06:22.627Z 2025-09-27T12:46:11.010Z
7865442 7865442 20250918021455_pjRaK HR002M 2025-09-19T12:06:15.947Z 2025-09-27T12:46:10.624Z
7865378 7865378 20250918020853_ezhpP HR002M 2025-09-19T12:05:55.195Z 2025-09-27T12:46:10.323Z
7865288 7865288 20250918020139_Yfslj HR002M 2025-09-19T12:05:29.475Z 2025-09-27T12:46:08.666Z
7865246 7865246 20250918015844_vbvH3 HR002M 2025-09-19T12:05:17.976Z 2025-09-27T12:46:06.432Z
7865221 7865221 20250918015524_cXxbn HR002M 2025-09-19T12:05:12.560Z 2025-09-27T12:46:05.892Z
7865138 7865138 20250918015101_8rirH HR002M 2025-09-19T12:04:48.604Z 2025-09-27T12:46:04.319Z
7865081 7865081 20250918014715_8peuj HR002M 2025-09-19T12:04:33.212Z 2025-09-27T12:46:02.421Z
7865047 7865047 20250918014355_476nA HR002M 2025-09-19T12:04:26.796Z 2025-09-27T12:46:02.035Z
7865020 7865020 20250918014158_lHXTy HR002M 2025-09-19T12:04:15.899Z 2025-09-27T12:46:01.832Z
7865018 7865018 20250918014137_0iDOd HR002M 2025-09-19T12:04:15.279Z 2025-09-27T12:46:01.804Z
7864993 7864993 20250918014005_MNCRJ HR002M 2025-09-19T12:04:07.755Z 2025-09-27T12:46:01.459Z
7864965 7864965 20250918013801_1FrAJ HR002M 2025-09-19T12:04:01.507Z 2025-09-27T12:46:01.077Z
7864858 7864858 20250918012715_ox072 HR002M 2025-09-19T12:03:29.906Z 2025-09-27T12:46:00.066Z
7864761 7864761 20250918011647_cArWh HR002M 2025-09-19T12:02:56.835Z 2025-09-27T12:45:58.400Z
7864740 7864740 20250918011506_H2Vi3 HR002M 2025-09-19T12:02:52.357Z 2025-09-27T12:45:58.126Z
7864644 7864644 20250918010753_AwCHd HR002M 2025-09-19T12:02:27.460Z 2025-09-27T12:45:52.653Z
7864579 7864579 20250918010354_1gPbU HR002M 2025-09-19T12:02:13.627Z 2025-09-27T12:45:52.004Z
7864527 7864527 20250918005622_aSPRV HR002M 2025-09-19T12:01:51.817Z 2025-09-27T12:45:47.141Z
7864509 7864509 20250918005418_5UHcW HR002M 2025-09-19T12:01:46.513Z 2025-09-27T12:45:46.648Z
7864368 7864368 20250918004332_um6Dv HR002M 2025-09-19T12:01:15.542Z 2025-09-27T12:45:44.162Z
7864293 7864293 20250918003545_eJrUu HR002M 2025-09-19T12:01:03.083Z 2025-09-27T12:45:43.475Z
7862666 7862666 20250916200030_Yxk5y HR002M 2025-09-18T12:33:13.277Z 2025-09-24T13:17:26.543Z
7862580 7862580 20250916194838_hHzq5 HR002M 2025-09-18T12:33:03.363Z 2025-09-24T13:17:23.759Z
7856110 7856110 20250915225735_8GL4X HR002M 2025-09-17T12:37:26.320Z 2025-09-22T13:06:04.365Z
7856097 7856097 20250915225558_kZzFs HR002M 2025-09-17T12:37:25.857Z 2025-09-22T13:06:04.342Z
7855990 7855990 20250915224529_x7m23 HR002M 2025-09-17T12:37:21.485Z 2025-09-22T13:06:02.142Z
7855985 7855985 20250915224442_fQar4 HR002M 2025-09-17T12:37:21.347Z 2025-09-22T13:06:02.106Z
7855829 7855829 20250915222933_rOgzz HR002M 2025-09-17T12:37:15.078Z 2025-09-22T13:05:59.589Z
7855713 7855713 20250915221604_9AjV9 HR002M 2025-09-17T12:37:11.635Z 2025-09-22T13:05:58.477Z
7855698 7855698 20250915221444_rmPFJ HR002M 2025-09-17T12:37:11.183Z 2025-09-22T13:05:58.078Z
7855661 7855661 20250915221121_RcYte HR002M 2025-09-17T12:37:10.230Z 2025-09-22T13:05:57.964Z
7855650 7855650 20250915220955_3JPXs HR002M 2025-09-17T12:37:01.873Z 2025-09-22T13:05:57.760Z
7855606 7855606 20250915220603_JgcQJ HR002M 2025-09-17T12:36:51.415Z 2025-09-22T13:05:57.455Z
7855549 7855549 20250915215758_hPclo HR002M 2025-09-17T12:36:36.446Z 2025-09-22T13:05:56.539Z
7855504 7855504 20250915215317_BR9wq HR002M 2025-09-17T12:36:27.417Z 2025-09-22T13:05:55.779Z
7855493 7855493 20250915214911_e0s77 HR002M 2025-09-17T12:36:27.075Z 2025-09-22T13:05:55.548Z
7855472 7855472 20250915214633_f83R6 HR002M 2025-09-17T12:36:25.980Z 2025-09-22T13:05:54.668Z
7855470 7855470 20250915214632_bbuzI HR002M 2025-09-17T12:36:25.915Z 2025-09-22T13:05:54.659Z
7855311 7855311 20250915212601_wa238 HR002M 2025-09-17T12:36:18.132Z 2025-09-22T13:05:50.355Z
7855149 7855149 20250915211205_mEpyg HR002M 2025-09-17T12:36:10.740Z 2025-09-22T13:05:48.272Z
7854963 7854963 20250915205454_gFx6w HR002M 2025-09-17T12:35:56.795Z 2025-09-22T13:05:46.440Z
7854801 7854801 20250915204631_PuWpN HR002M 2025-09-17T12:35:27.547Z 2025-09-22T13:05:43.678Z
7854777 7854777 20250915204421_vJd0M HR002M 2025-09-17T12:35:20.887Z 2025-09-22T13:05:43.447Z
7854625 7854625 20250915203115_8MBlt HR002M 2025-09-17T12:35:09.448Z 2025-09-22T13:05:41.268Z
7854564 7854564 20250915202327_3blHa HR002M 2025-09-17T12:35:05.834Z 2025-09-22T13:05:40.471Z
7854530 7854530 20250915201731_kRhq6 HR002M 2025-09-17T12:35:04.034Z 2025-09-22T13:05:39.963Z
7854515 7854515 20250915201653_sgRrk HR002M 2025-09-17T12:35:03.525Z 2025-09-22T13:05:39.693Z
7854470 7854470 20250915201221_F22M3 HR002M 2025-09-17T12:35:00.491Z 2025-09-22T13:05:38.767Z
7854362 7854362 20250915195926_citO1 HR002M 2025-09-17T12:34:31.710Z 2025-09-22T13:05:36.384Z
7853984 7853984 20250915192108_1cm76 HR002M 2025-09-17T12:34:06.755Z 2025-09-22T13:05:24.382Z

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