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,575 rows where station_code = "GR0007" 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
9273052 9273052 20260128042952_fE4Vf GR0007 2026-01-29T14:28:33.643Z 2026-01-29T14:30:25.742Z
9273009 9273009 20260128042050_AkaKb GR0007 2026-01-29T14:28:25.332Z 2026-01-29T14:30:25.734Z
9272243 9272243 20260128005536_lOplo GR0007 2026-01-29T14:26:01.124Z 2026-01-29T14:30:25.313Z
9272194 9272194 20260128003908_kTtab GR0007 2026-01-29T14:25:54.070Z 2026-01-29T14:30:25.297Z
9272192 9272192 20260128003852_z8lB4 GR0007 2026-01-29T14:25:53.600Z 2026-01-29T14:30:25.296Z
9272175 9272175 20260128003229_IoKOl GR0007 2026-01-29T14:25:51.757Z 2026-01-29T14:30:25.294Z
9272173 9272173 20260128003146_qv1n2 GR0007 2026-01-29T14:25:51.329Z 2026-01-29T14:30:25.293Z
9272128 9272128 20260128001449_ljkVr GR0007 2026-01-29T14:25:44.160Z 2026-01-29T14:30:25.285Z
9272119 9272119 20260128000700_C5RWl GR0007 2026-01-29T14:25:42.613Z 2026-01-29T14:30:25.283Z
9272072 9272072 20260127234619_cynuC GR0007 2026-01-29T14:25:28.366Z 2026-01-29T14:30:25.274Z
9271962 9271962 20260127222412_cYSE7 GR0007 2026-01-29T14:25:08.566Z 2026-01-29T14:30:25.253Z
9271957 9271957 20260127222211_Tz5N4 GR0007 2026-01-29T14:25:03.602Z 2026-01-29T14:30:25.240Z
9271926 9271926 20260127220000_Uz222 GR0007 2026-01-29T14:24:56.582Z 2026-01-29T14:30:25.231Z
9271889 9271889 20260127213948_xnhAx GR0007 2026-01-29T14:24:50.649Z 2026-01-29T14:30:25.225Z
9271842 9271842 20260127205504_ju64b GR0007 2026-01-29T14:24:23.379Z 2026-01-29T14:30:25.196Z
9271670 9271670 20260127190844_tij8W GR0007 2026-01-29T14:22:15.890Z 2026-01-29T14:30:25.016Z
9234812 9234812 20260119233115_TSo8J GR0007 2026-01-21T14:16:13.379Z 2026-01-28T14:58:14.634Z
9218120 9218120 20260117002124_0JOOK GR0007 2026-01-18T14:10:34.039Z 2026-01-25T14:58:00.835Z
9218094 9218094 20260116235208_cBFO0 GR0007 2026-01-18T14:10:25.751Z 2026-01-25T14:57:58.757Z
9218084 9218084 20260116233628_y0TP1 GR0007 2026-01-18T14:10:22.423Z 2026-01-25T14:57:58.238Z
9218041 9218041 20260116224806_qreLc GR0007 2026-01-18T14:10:08.795Z 2026-01-25T14:57:56.390Z
9218031 9218031 20260116223444_mZlXX GR0007 2026-01-18T14:10:03.652Z 2026-01-25T14:57:55.854Z
9218029 9218029 20260116222858_sqOVo GR0007 2026-01-18T14:10:03.050Z 2026-01-25T14:57:55.797Z
9217867 9217867 20260116201751_glWSp GR0007 2026-01-18T14:09:21.656Z 2026-01-25T14:57:50.262Z
9207388 9207388 20260115012058_jEEtm GR0007 2026-01-16T14:08:33.118Z 2026-01-22T15:03:20.530Z
9207357 9207357 20260115010901_qcG4m GR0007 2026-01-16T14:08:23.876Z 2026-01-22T15:03:19.701Z
9207331 9207331 20260115010403_qXR2q GR0007 2026-01-16T14:08:18.924Z 2026-01-22T15:03:19.142Z
9207297 9207297 20260115004448_Gf1jb GR0007 2026-01-16T14:08:08.881Z 2026-01-22T15:03:17.969Z
9207258 9207258 20260115002352_vn3aE GR0007 2026-01-16T14:07:58.951Z 2026-01-22T15:03:16.482Z
9207243 9207243 20260115001428_NcDsw GR0007 2026-01-16T14:07:54.254Z 2026-01-22T15:03:15.770Z
9207196 9207196 20260114234154_cD4WQ GR0007 2026-01-16T14:07:38.114Z 2026-01-22T15:03:14.218Z
9207134 9207134 20260114222808_FKHNM GR0007 2026-01-16T14:07:17.058Z 2026-01-22T15:03:11.503Z
9207099 9207099 20260114214359_HiaK4 GR0007 2026-01-16T14:07:06.408Z 2026-01-22T15:03:10.252Z
9207090 9207090 20260114213830_ahV0K GR0007 2026-01-16T14:07:04.589Z 2026-01-22T15:03:10.066Z
9207046 9207046 20260114210329_b22Sw GR0007 2026-01-16T14:06:51.101Z 2026-01-22T15:02:59.123Z
9207031 9207031 20260114204626_1vl5E GR0007 2026-01-16T14:06:45.901Z 2026-01-22T15:02:56.287Z
9206687 9206687 20260114181922_R7S6r GR0007 2026-01-16T14:05:04.891Z 2026-01-22T15:02:33.551Z
9206665 9206665 20260114181620_kju5W GR0007 2026-01-16T14:04:59.634Z 2026-01-22T15:02:33.171Z
9202799 9202799 20260114040828_GjCO0 GR0007 2026-01-15T14:22:22.584Z 2026-01-22T15:09:41.565Z
9202626 9202626 20260114035542_apdKF GR0007 2026-01-15T14:21:47.778Z 2026-01-22T15:09:23.803Z
9202546 9202546 20260114034706_rx58F GR0007 2026-01-15T14:21:38.114Z 2026-01-22T15:09:22.678Z
9202343 9202343 20260114033143_bjWc6 GR0007 2026-01-15T14:21:06.102Z 2026-01-22T15:09:16.465Z
9202282 9202282 20260114032551_XMw72 GR0007 2026-01-15T14:20:52.213Z 2026-01-22T15:09:15.752Z
9201873 9201873 20260114030257_4hjrI GR0007 2026-01-15T14:20:03.651Z 2026-01-22T15:09:11.035Z
9201848 9201848 20260114030005_mz5iy GR0007 2026-01-15T14:19:54.555Z 2026-01-22T15:09:10.529Z
9201659 9201659 20260114023826_pgyX2 GR0007 2026-01-15T14:19:14.602Z 2026-01-22T15:09:07.025Z
9201615 9201615 20260114023557_ERo6S GR0007 2026-01-15T14:19:11.554Z 2026-01-22T15:09:06.818Z
9201426 9201426 20260114021717_seeWs GR0007 2026-01-15T14:18:37.757Z 2026-01-22T15:09:03.604Z
9201177 9201177 20260114015121_F3B2H GR0007 2026-01-15T14:17:43.141Z 2026-01-22T15:08:59.023Z
9200807 9200807 20260114010505_QJNOb GR0007 2026-01-15T14:16:32.706Z 2026-01-22T15:08:26.595Z
9200609 9200609 20260114003309_fg3wq GR0007 2026-01-15T14:15:45.103Z 2026-01-22T15:08:21.641Z
9200572 9200572 20260114002606_q4h3p GR0007 2026-01-15T14:15:38.912Z 2026-01-22T15:08:18.455Z
9200138 9200138 20260113225541_XbGwi GR0007 2026-01-15T14:13:54.631Z 2026-01-22T15:08:10.271Z
9200081 9200081 20260113224823_SU3Vo GR0007 2026-01-15T14:13:43.318Z 2026-01-22T15:08:09.228Z
9199988 9199988 20260113221317_mF20Y GR0007 2026-01-15T14:13:25.599Z 2026-01-22T15:08:07.139Z
9199923 9199923 20260113215610_vzQ1h GR0007 2026-01-15T14:13:04.339Z 2026-01-22T15:08:05.508Z
9199228 9199228 20260113192834_W75Xn GR0007 2026-01-15T14:09:54.622Z 2026-01-22T15:07:17.424Z
9199155 9199155 20260113191221_5gY3G GR0007 2026-01-15T14:09:33.037Z 2026-01-22T15:07:15.309Z
9198923 9198923 20260113183404_GXxim GR0007 2026-01-15T14:08:21.481Z 2026-01-22T15:07:09.427Z
9198921 9198921 20260113183324_F2S81 GR0007 2026-01-15T14:08:20.805Z 2026-01-22T15:07:09.356Z
9198770 9198770 20260113175549_in6bq GR0007 2026-01-15T14:07:08.424Z 2026-01-22T15:07:03.825Z
9198671 9198671 20260113173222_PuCC3 GR0007 2026-01-15T14:06:21.215Z 2026-01-22T15:07:00.337Z
9196116 9196116 20260113044427_6Zdv0 GR0007 2026-01-14T14:16:44.340Z 2026-01-21T15:05:28.321Z
9196086 9196086 20260113042958_DVgwC GR0007 2026-01-14T14:16:30.467Z 2026-01-21T15:05:25.782Z
9196033 9196033 20260113041014_mTkhx GR0007 2026-01-14T14:16:11.279Z 2026-01-21T15:05:11.612Z
9196018 9196018 20260113040036_khIp3 GR0007 2026-01-14T14:16:07.323Z 2026-01-21T15:05:10.433Z
9195965 9195965 20260113034242_fTcZD GR0007 2026-01-14T14:15:47.206Z 2026-01-21T15:04:56.807Z
9195961 9195961 20260113034130_bgngj GR0007 2026-01-14T14:15:45.568Z 2026-01-21T15:04:56.320Z
9195959 9195959 20260113034114_A67sE GR0007 2026-01-14T14:15:44.754Z 2026-01-21T15:04:55.228Z
9195941 9195941 20260113033358_x1c1z GR0007 2026-01-14T14:15:40.298Z 2026-01-21T15:04:50.395Z
9195917 9195917 20260113032529_3S1vJ GR0007 2026-01-14T14:15:34.540Z 2026-01-21T15:04:49.645Z
9195785 9195785 20260113024850_txLk3 GR0007 2026-01-14T14:14:52.892Z 2026-01-21T15:04:47.571Z
9195732 9195732 20260113023528_weDSh GR0007 2026-01-14T14:14:39.289Z 2026-01-21T15:04:46.487Z
9195679 9195679 20260113021656_8NeRS GR0007 2026-01-14T14:14:21.442Z 2026-01-21T15:04:45.474Z
9195657 9195657 20260113021109_sHsGk GR0007 2026-01-14T14:14:16.944Z 2026-01-21T15:04:45.004Z
9195444 9195444 20260113012646_GpKx0 GR0007 2026-01-14T14:13:19.990Z 2026-01-21T15:04:40.618Z
9195315 9195315 20260113010124_OWTt8 GR0007 2026-01-14T14:12:52.328Z 2026-01-21T15:04:39.009Z
9195174 9195174 20260113003316_1s2Nz GR0007 2026-01-14T14:12:18.483Z 2026-01-21T15:04:37.335Z
9195133 9195133 20260113002456_PHYy0 GR0007 2026-01-14T14:12:07.645Z 2026-01-21T15:04:36.760Z
9194961 9194961 20260112234431_3CO2G GR0007 2026-01-14T14:11:30.392Z 2026-01-21T15:04:34.372Z
9194903 9194903 20260112232011_wSGM3 GR0007 2026-01-14T14:11:13.720Z 2026-01-21T15:04:33.871Z
9194881 9194881 20260112231222_VqDNQ GR0007 2026-01-14T14:11:08.508Z 2026-01-21T15:04:33.669Z
9194841 9194841 20260112230329_llrOS GR0007 2026-01-14T14:10:54.296Z 2026-01-21T15:04:26.685Z
9194752 9194752 20260112223213_YET1z GR0007 2026-01-14T14:10:31.854Z 2026-01-21T15:04:20.613Z
9194685 9194685 20260112215858_EHJa3 GR0007 2026-01-14T14:10:15.894Z 2026-01-21T15:04:19.994Z
9194347 9194347 20260112200203_FYzWP GR0007 2026-01-14T14:08:45.280Z 2026-01-21T15:03:50.752Z
9194142 9194142 20260112182112_XV1Qb GR0007 2026-01-14T14:07:35.116Z 2026-01-21T15:03:33.621Z
9194024 9194024 20260112164230_Br52E GR0007 2026-01-14T14:06:38.002Z 2026-01-21T15:03:18.147Z
9187814 9187814 20260111185546_coT8W GR0007 2026-01-13T14:09:01.448Z 2026-01-20T15:20:55.854Z
9171838 9171838 20260109034837_yigiB GR0007 2026-01-10T14:09:57.243Z 2026-01-17T15:24:37.348Z
9171640 9171640 20260109001356_VCGhW GR0007 2026-01-10T14:08:37.835Z 2026-01-17T15:24:13.124Z
9171574 9171574 20260108231521_VN32V GR0007 2026-01-10T14:08:10.725Z 2026-01-17T15:24:07.599Z
9171554 9171554 20260108230209_S2b1S GR0007 2026-01-10T14:08:05.074Z 2026-01-17T15:24:06.744Z
9171544 9171544 20260108224418_Qcq4U GR0007 2026-01-10T14:08:02.041Z 2026-01-17T15:24:06.210Z
9171509 9171509 20260108222635_lhxhT GR0007 2026-01-10T14:07:48.392Z 2026-01-17T15:24:04.505Z
9171422 9171422 20260108213956_7aJbe GR0007 2026-01-10T14:07:19.743Z 2026-01-17T15:23:48.604Z
9171394 9171394 20260108212842_ng6yk GR0007 2026-01-10T14:07:10.555Z 2026-01-17T15:23:47.297Z
9171368 9171368 20260108211704_SO5gO GR0007 2026-01-10T14:06:58.799Z 2026-01-17T15:23:46.080Z
9171325 9171325 20260108210413_pXcMY GR0007 2026-01-10T14:06:43.265Z 2026-01-17T15:23:44.053Z
9171233 9171233 20260108201544_1n1yW GR0007 2026-01-10T14:06:07.725Z 2026-01-17T15:23:38.002Z

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