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

4,105 rows where station_code = "GR0005" 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
9598495 9598495 20260330004541_Uavsy GR0005 2026-03-31T12:10:45.837Z 2026-04-06T12:36:35.467Z
9595138 9595138 20260330023318_UI8yU GR0005 2026-03-31T12:00:34.961Z 2026-04-06T12:29:42.131Z
9595099 9595099 20260330022211_Od6gU GR0005 2026-03-31T12:00:28.650Z 2026-04-06T12:29:40.507Z
9580811 9580811 20260326013743_LrB0o GR0005 2026-03-27T12:01:28.870Z 2026-04-04T12:38:30.268Z
9580494 9580494 20260326005548_1wD8P GR0005 2026-03-27T12:00:38.380Z 2026-04-04T12:38:12.244Z
9492871 9492871 20260314220740_l4YR3 GR0005 2026-03-16T12:29:07.074Z 2026-03-22T12:42:55.499Z
9492325 9492325 20260314202129_1d7D5 GR0005 2026-03-16T12:28:23.060Z 2026-03-22T12:42:51.639Z
9476571 9476571 20260314031606_PoVrg GR0005 2026-03-15T12:06:21.770Z 2026-03-22T12:41:57.863Z
9475880 9475880 20260314021623_cM8l4 GR0005 2026-03-15T12:04:23.773Z 2026-03-22T12:41:52.532Z
9475576 9475576 20260314014220_vjT5G GR0005 2026-03-15T12:03:30.378Z 2026-03-22T12:41:43.354Z
9474778 9474778 20260313235646_54OdC GR0005 2026-03-15T12:01:20.304Z 2026-03-22T12:41:24.179Z
9474310 9474310 20260312222839_2TP2j GR0005 2026-03-14T12:22:36.132Z 2026-03-20T12:37:17.768Z
9469448 9469448 20260313025030_SLwF0 GR0005 2026-03-14T12:04:18.112Z 2026-03-21T12:48:39.538Z
9469064 9469064 20260313013848_BbxVW GR0005 2026-03-14T12:02:49.323Z 2026-03-21T12:48:33.050Z
9468700 9468700 20260313002045_SjQrI GR0005 2026-03-14T12:01:26.649Z 2026-03-21T12:48:27.996Z
9463464 9463464 20260312015316_v6ZUK GR0005 2026-03-13T12:04:16.810Z 2026-03-20T12:36:22.753Z
9463232 9463232 20260312011900_extth GR0005 2026-03-13T12:03:33.944Z 2026-03-20T12:36:21.394Z
9456218 9456218 20260309222254_OOceB GR0005 2026-03-11T12:15:51.670Z 2026-03-17T12:42:58.979Z
9456189 9456189 20260309221121_BP2Lr GR0005 2026-03-11T12:15:48.401Z 2026-03-17T12:42:57.725Z
9455689 9455689 20260309194044_1iApW GR0005 2026-03-11T12:14:47.577Z 2026-03-17T12:42:37.650Z
9415695 9415695 20260302031406_V0s6C GR0005 2026-03-03T14:01:12.805Z 2026-03-10T12:35:48.042Z
9401805 9401805 20260227014024_D6iJ9 GR0005 2026-02-28T14:02:18.655Z 2026-03-07T14:46:09.169Z
9401795 9401795 20260227013552_dTW57 GR0005 2026-02-28T14:02:15.069Z 2026-03-07T14:46:04.292Z
9401754 9401754 20260227012746_MYhhO GR0005 2026-02-28T14:02:06.246Z 2026-03-07T14:46:02.267Z
9401366 9401366 20260226231033_T34Xv GR0005 2026-02-28T14:00:15.542Z 2026-03-07T14:45:40.579Z
9401234 9401234 20260225225058_0RY3t GR0005 2026-02-27T14:16:42.277Z 2026-03-05T14:39:10.834Z
9398375 9398375 20260226033220_xbxly GR0005 2026-02-27T14:05:10.006Z 2026-03-06T14:43:41.809Z
9397536 9397536 20260226015445_p3kGJ GR0005 2026-02-27T14:02:45.592Z 2026-03-06T14:43:12.977Z
9397500 9397500 20260226015128_szYM0 GR0005 2026-02-27T14:02:38.643Z 2026-03-06T14:43:11.854Z
9397419 9397419 20260226013704_L38iP GR0005 2026-02-27T14:02:24.562Z 2026-03-06T14:43:09.416Z
9383267 9383267 20260224023920_aziy3 GR0005 2026-02-25T14:00:47.109Z 2026-03-04T14:17:37.008Z
9381546 9381546 20260222230917_GpuKm GR0005 2026-02-24T14:24:53.104Z 2026-02-24T14:24:53.104Z
9381473 9381473 20260222224940_SUANA GR0005 2026-02-24T14:24:47.507Z 2026-02-24T14:24:47.507Z
9381356 9381356 20260222215934_2bbja GR0005 2026-02-24T14:24:34.301Z 2026-02-24T14:24:34.301Z
9381237 9381237 20260222212222_dhfbe GR0005 2026-02-24T14:24:26.343Z 2026-02-24T14:24:26.343Z
9381208 9381208 20260222211410_wVVaH GR0005 2026-02-24T14:24:24.346Z 2026-02-24T14:24:24.346Z
9380575 9380575 20260222200001_kF5gB GR0005 2026-02-24T14:23:27.943Z 2026-02-24T14:23:27.943Z
9373331 9373331 20260223024606_RI2Zs GR0005 2026-02-24T14:02:40.001Z 2026-03-03T14:31:01.461Z
9372711 9372711 20260223005719_m1Y2X GR0005 2026-02-24T14:01:18.403Z 2026-03-03T14:30:44.722Z
9372433 9372433 20260223001311_NeZGz GR0005 2026-02-24T14:00:34.409Z 2026-03-03T14:30:40.437Z
9358364 9358364 20260221003331_G44sA GR0005 2026-02-22T14:00:23.042Z 2026-03-02T14:20:45.131Z
9351997 9351997 20260218004025_nPTzm GR0005 2026-02-20T14:02:47.013Z 2026-02-26T14:40:15.462Z
9349693 9349693 20260218185029_jX1u3 GR0005 2026-02-20T14:01:58.507Z 2026-02-27T14:35:52.377Z
9344620 9344620 20260218041113_ZOGyA GR0005 2026-02-20T14:01:15.379Z 2026-02-27T14:34:13.616Z
9344562 9344562 20260218035512_8jZSt GR0005 2026-02-20T14:01:14.891Z 2026-02-27T14:34:12.587Z
9344437 9344437 20260218031902_aGWI5 GR0005 2026-02-20T14:01:13.859Z 2026-02-27T14:34:09.395Z
9344270 9344270 20260218023240_aubAA GR0005 2026-02-20T14:01:05.176Z 2026-02-27T14:34:06.152Z
9344148 9344148 20260218014638_RZ3MZ GR0005 2026-02-20T14:01:04.905Z 2026-02-27T14:34:03.839Z
9344115 9344115 20260218013359_naE7U GR0005 2026-02-20T14:01:04.796Z 2026-02-27T14:34:03.259Z
9341070 9341070 20260219031501_MEgAD GR0005 2026-02-20T14:00:55.363Z 2026-02-28T14:43:44.894Z
9341026 9341026 20260219020132_pNTCf GR0005 2026-02-20T14:00:55.050Z 2026-02-28T14:43:41.375Z
9340949 9340949 20260219003259_GBk64 GR0005 2026-02-20T14:00:54.558Z 2026-02-28T14:43:28.506Z
9272118 9272118 20260128000700_C5RWl GR0005 2026-01-29T14:25:42.609Z 2026-02-05T14:49:25.425Z
9234811 9234811 20260119233115_TSo8J GR0005 2026-01-21T14:16:13.378Z 2026-01-28T14:58:14.634Z
9218136 9218136 20260117005442_YVn60 GR0005 2026-01-18T14:10:40.063Z 2026-01-25T14:58:01.522Z
9218119 9218119 20260117002124_0JOOK GR0005 2026-01-18T14:10:34.039Z 2026-01-25T14:58:00.835Z
9218112 9218112 20260117001408_m4k38 GR0005 2026-01-18T14:10:31.933Z 2026-01-25T14:58:00.572Z
9217814 9217814 20260116195724_e7mcf GR0005 2026-01-18T14:09:07.841Z 2026-01-25T14:57:48.715Z
9207394 9207394 20260115012205_5Jqfg GR0005 2026-01-16T14:08:35.305Z 2026-01-22T15:03:20.711Z
9207375 9207375 20260115011634_I3V31 GR0005 2026-01-16T14:08:29.573Z 2026-01-22T15:03:20.218Z
9207296 9207296 20260115004448_Gf1jb GR0005 2026-01-16T14:08:08.881Z 2026-01-22T15:03:17.969Z
9207133 9207133 20260114222808_FKHNM GR0005 2026-01-16T14:07:17.058Z 2026-01-22T15:03:11.503Z
9207030 9207030 20260114204626_1vl5E GR0005 2026-01-16T14:06:45.901Z 2026-01-22T15:02:56.287Z
9202342 9202342 20260114033143_bjWc6 GR0005 2026-01-15T14:21:06.102Z 2026-01-22T15:09:16.465Z
9201872 9201872 20260114030257_4hjrI GR0005 2026-01-15T14:20:03.651Z 2026-01-22T15:09:11.035Z
9201847 9201847 20260114030005_mz5iy GR0005 2026-01-15T14:19:54.555Z 2026-01-22T15:09:10.529Z
9201175 9201175 20260114015121_F3B2H GR0005 2026-01-15T14:17:43.141Z 2026-01-22T15:08:59.023Z
9200895 9200895 20260114011837_kMKHv GR0005 2026-01-15T14:16:47.973Z 2026-01-22T15:08:33.475Z
9200805 9200805 20260114010505_QJNOb GR0005 2026-01-15T14:16:32.706Z 2026-01-22T15:08:26.595Z
9200608 9200608 20260114003309_fg3wq GR0005 2026-01-15T14:15:45.103Z 2026-01-22T15:08:21.641Z
9200080 9200080 20260113224823_SU3Vo GR0005 2026-01-15T14:13:43.318Z 2026-01-22T15:08:09.228Z
9198670 9198670 20260113173222_PuCC3 GR0005 2026-01-15T14:06:21.212Z 2026-01-22T15:07:00.337Z
9195958 9195958 20260113034114_A67sE GR0005 2026-01-14T14:15:44.754Z 2026-01-21T15:04:55.228Z
9195915 9195915 20260113032529_3S1vJ GR0005 2026-01-14T14:15:34.540Z 2026-01-21T15:04:49.645Z
9195656 9195656 20260113021109_sHsGk GR0005 2026-01-14T14:14:16.944Z 2026-01-21T15:04:45.004Z
9195344 9195344 20260113010910_3Jd8m GR0005 2026-01-14T14:12:56.784Z 2026-01-21T15:04:39.285Z
9194806 9194806 20260112225005_LrhdA GR0005 2026-01-14T14:10:45.743Z 2026-01-21T15:04:21.350Z
9194023 9194023 20260112164230_Br52E GR0005 2026-01-14T14:06:38.001Z 2026-01-21T15:03:18.147Z
9187813 9187813 20260111185546_coT8W GR0005 2026-01-13T14:09:01.445Z 2026-01-20T15:20:55.854Z
9171573 9171573 20260108231521_VN32V GR0005 2026-01-10T14:08:10.725Z 2026-01-17T15:24:07.599Z
9171421 9171421 20260108213956_7aJbe GR0005 2026-01-10T14:07:19.743Z 2026-01-17T15:23:48.604Z
9171324 9171324 20260108210413_pXcMY GR0005 2026-01-10T14:06:43.248Z 2026-01-17T15:23:44.053Z
9127049 9127049 20260102021234_L6ddW GR0005 2026-01-03T14:08:07.308Z 2026-01-09T14:49:24.733Z
9127028 9127028 20260102020704_0iVAl GR0005 2026-01-03T14:08:01.286Z 2026-01-09T14:49:23.676Z
9126934 9126934 20260102014007_RCG6G GR0005 2026-01-03T14:07:31.491Z 2026-01-09T14:49:19.100Z
9121945 9121945 20260101035145_1R9Df GR0005 2026-01-02T14:10:22.296Z 2026-01-09T14:52:47.381Z
9121636 9121636 20260101004645_03wO9 GR0005 2026-01-02T14:08:22.506Z 2026-01-09T14:52:24.426Z
9121602 9121602 20260101002440_xBuiF GR0005 2026-01-02T14:08:15.268Z 2026-01-09T14:52:22.194Z
9102631 9102631 20251230032015_stXau GR0005 2025-12-31T14:14:42.830Z 2026-01-07T15:07:48.835Z
9101920 9101920 20251230015902_sJSME GR0005 2025-12-31T14:11:13.712Z 2026-01-07T15:07:02.268Z
9101690 9101690 20251230011721_Hr3Qz GR0005 2025-12-31T14:09:59.400Z 2026-01-07T15:06:41.611Z
9101461 9101461 20251230003301_F5pdu GR0005 2025-12-31T14:08:45.940Z 2026-01-07T15:06:22.316Z
9101383 9101383 20251230001349_fIf2a GR0005 2025-12-31T14:08:16.770Z 2026-01-07T15:06:17.189Z
9101271 9101271 20251229234514_fJuA3 GR0005 2025-12-31T14:07:35.550Z 2026-01-07T15:06:10.476Z
9100809 9100809 20251229211744_UmY0h GR0005 2025-12-31T14:04:53.009Z 2026-01-07T15:05:39.556Z
9100613 9100613 20251229205000_wrTE7 GR0005 2025-12-31T14:03:55.051Z 2026-01-07T15:05:25.469Z
9091898 9091898 20251228201211_WO8GT GR0005 2025-12-30T14:53:29.808Z 2026-01-05T15:14:44.070Z
9084248 9084248 20251228012447_6U372 GR0005 2025-12-30T14:35:07.242Z 2026-01-05T15:08:36.895Z
9078017 9078017 20251229012401_25lGg GR0005 2025-12-30T14:11:05.484Z 2026-01-06T15:16:02.464Z
9077956 9077956 20251229011927_y6DHC GR0005 2025-12-30T14:10:36.047Z 2026-01-06T15:16:00.238Z

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