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,053 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
9272118 9272118 20260128000700_C5RWl GR0005 2026-01-29T14:25:42.609Z 2026-01-29T14:30:25.283Z
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
9076043 9076043 20251228205152_2R3KC GR0005 2025-12-30T14:01:14.265Z 2026-01-06T15:14:11.676Z
8995357 8995357 20251218001101_3MlfX GR0005 2025-12-26T15:05:45.086Z 2025-12-26T15:05:45.086Z
8995172 8995172 20251217232006_BJwUH GR0005 2025-12-26T15:05:11.032Z 2025-12-26T15:05:11.032Z
8994897 8994897 20251217215313_TbS9k GR0005 2025-12-26T15:04:44.790Z 2025-12-26T15:04:44.790Z
8994319 8994319 20251219004745_D7VhB GR0005 2025-12-26T14:54:30.786Z 2025-12-27T15:29:00.442Z
8994115 8994115 20251219002146_270TM GR0005 2025-12-26T14:54:05.485Z 2025-12-27T15:28:50.344Z
8994034 8994034 20251219000840_NDp1W GR0005 2025-12-26T14:54:01.233Z 2025-12-27T15:28:47.767Z
8993635 8993635 20251218230137_jjyMw GR0005 2025-12-26T14:53:20.440Z 2025-12-27T15:28:01.556Z
8985456 8985456 20251218021243_V2R9p GR0005 2025-12-26T14:34:49.867Z 2025-12-27T15:18:59.872Z
8985172 8985172 20251218012814_DS6zF GR0005 2025-12-26T14:33:09.682Z 2025-12-27T15:18:54.975Z
8976613 8976613 20251219032448_1W5Qn GR0005 2025-12-26T14:10:21.725Z 2025-12-28T15:17:26.946Z
8975604 8975604 20251219013311_RT2F9 GR0005 2025-12-26T14:07:24.789Z 2025-12-28T15:17:15.533Z
8962622 8962622 20251216033728_MxygK GR0005 2025-12-25T14:36:24.393Z 2025-12-25T14:36:24.393Z
8962566 8962566 20251216033217_WzExJ GR0005 2025-12-25T14:36:17.776Z 2025-12-25T14:36:17.776Z
8961996 8961996 20251216023914_bocQv GR0005 2025-12-25T14:34:24.574Z 2025-12-25T14:34:24.574Z
8961830 8961830 20251216022110_G0G4h GR0005 2025-12-25T14:33:50.320Z 2025-12-25T14:33:50.320Z
8961694 8961694 20251217213516_14AMS GR0005 2025-12-25T14:33:15.825Z 2025-12-26T15:04:41.569Z
8961349 8961349 20251217205340_VEWSe GR0005 2025-12-25T14:32:26.135Z 2025-12-26T15:04:28.681Z
8961270 8961270 20251217203955_rEJYE GR0005 2025-12-25T14:32:15.304Z 2025-12-26T15:04:25.301Z
8961075 8961075 20251217200928_jP6Is GR0005 2025-12-25T14:31:36.131Z 2025-12-26T15:04:11.525Z
8961033 8961033 20251217200045_lsYno GR0005 2025-12-25T14:31:31.096Z 2025-12-26T15:04:09.942Z
8947442 8947442 20251214223433_vgUg7 GR0005 2025-12-24T15:04:20.374Z 2025-12-24T15:04:20.374Z
8946973 8946973 20251214221110_oUYn0 GR0005 2025-12-24T15:04:12.589Z 2025-12-24T15:04:12.589Z
8946921 8946921 20251214220836_KrppX GR0005 2025-12-24T15:04:11.981Z 2025-12-24T15:04:11.981Z
8946233 8946233 20251214213155_cJmm3 GR0005 2025-12-24T15:03:07.077Z 2025-12-24T15:03:07.077Z
8946191 8946191 20251214213027_jwkvy GR0005 2025-12-24T15:03:02.041Z 2025-12-24T15:03:02.041Z
8945207 8945207 20251214205328_BsO7C GR0005 2025-12-24T15:02:40.386Z 2025-12-24T15:02:40.386Z
8945191 8945191 20251214205256_Gs327 GR0005 2025-12-24T15:02:39.935Z 2025-12-24T15:02:39.935Z
8944224 8944224 20251214201928_BuQO4 GR0005 2025-12-24T15:00:26.868Z 2025-12-24T15:00:26.868Z
8943012 8943012 20251214193625_x4e0G GR0005 2025-12-24T14:59:22.433Z 2025-12-24T14:59:22.433Z
8942315 8942315 20251214191645_wkIz3 GR0005 2025-12-24T14:58:23.157Z 2025-12-24T14:58:23.157Z
8941719 8941719 20251214185743_l8kVg GR0005 2025-12-24T14:57:50.762Z 2025-12-24T14:57:50.762Z
8896982 8896982 20251214024512_IYj8P GR0005 2025-12-22T14:12:20.312Z 2025-12-23T14:27:56.018Z
8893652 8893652 20251214021809_5gahJ GR0005 2025-12-22T14:11:59.226Z 2025-12-23T14:27:51.665Z
8893275 8893275 20251214021428_Qx5p6 GR0005 2025-12-22T14:11:54.494Z 2025-12-23T14:27:49.365Z
8874591 8874591 20251214025506_Y81un GR0005 2025-12-22T14:00:11.163Z 2025-12-24T14:12:18.070Z
8873903 8873903 20251214010847_u6AC8 GR0005 2025-12-21T14:11:05.477Z 2025-12-23T14:27:36.736Z
8873818 8873818 20251214010811_2MO4Y GR0005 2025-12-21T14:11:04.946Z 2025-12-23T14:27:36.671Z
8858563 8858563 20251213210910_oF1GA GR0005 2025-12-21T14:06:51.649Z 2025-12-23T14:25:02.204Z
8856075 8856075 20251213202952_WKdBX GR0005 2025-12-20T14:11:14.413Z 2025-12-20T14:21:14.162Z
8851199 8851199 20251213235943_0mZZJ GR0005 2025-12-19T14:20:58.968Z 2025-12-23T14:26:42.921Z
8850953 8850953 20251213235709_spNx2 GR0005 2025-12-19T14:20:48.568Z 2025-12-23T14:26:40.959Z
8850863 8850863 20251213235630_dgk2E GR0005 2025-12-19T14:20:44.755Z 2025-12-23T14:26:40.034Z
8850591 8850591 20251213235347_R37f0 GR0005 2025-12-19T14:20:38.895Z 2025-12-23T14:26:35.637Z
8849491 8849491 20251213234348_6tdpQ GR0005 2025-12-19T14:19:25.804Z 2025-12-23T14:26:18.433Z
8849003 8849003 20251213234017_h31Bq GR0005 2025-12-19T14:18:52.016Z 2025-12-23T14:26:13.459Z
8848020 8848020 20251213233027_cBCXa GR0005 2025-12-19T14:18:04.330Z 2025-12-23T14:25:54.763Z
8847978 8847978 20251213232958_8giC8 GR0005 2025-12-19T14:18:03.850Z 2025-12-23T14:25:54.701Z
8847464 8847464 20251213232517_ujabe GR0005 2025-12-19T14:17:32.279Z 2025-12-23T14:25:52.240Z
8845423 8845423 20251213230303_Fkznh GR0005 2025-12-19T14:15:37.044Z 2025-12-23T14:25:26.687Z
8840450 8840450 20251213221830_H5qq0 GR0005 2025-12-18T14:42:27.394Z 2025-12-18T14:42:27.394Z
8839949 8839949 20251213221243_gUVep GR0005 2025-12-18T14:41:38.926Z 2025-12-18T14:41:38.926Z

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