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

9,966 rows where station_code = "GR0002" 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
9272665 9272665 20260128025655_QxqvG GR0002 2026-01-29T14:27:25.502Z 2026-01-29T14:30:25.435Z
9272455 9272455 20260128021000_pVWDI GR0002 2026-01-29T14:26:47.240Z 2026-01-29T14:30:25.350Z
9272381 9272381 20260128015144_hJsTO GR0002 2026-01-29T14:26:33.719Z 2026-01-29T14:30:25.339Z
9272378 9272378 20260128015112_KHI36 GR0002 2026-01-29T14:26:33.298Z 2026-01-29T14:30:25.338Z
9272332 9272332 20260128013848_z8RWj GR0002 2026-01-29T14:26:27.055Z 2026-01-29T14:30:25.331Z
9272138 9272138 20260128001739_Ra2S2 GR0002 2026-01-29T14:25:46.122Z 2026-01-29T14:30:25.287Z
9272135 9272135 20260128001704_kxl1q GR0002 2026-01-29T14:25:45.633Z 2026-01-29T14:30:25.287Z
9272132 9272132 20260128001624_QVLVv GR0002 2026-01-29T14:25:45.136Z 2026-01-29T14:30:25.286Z
9271610 9271610 20260127183556_p27t3 GR0002 2026-01-29T14:21:47.308Z 2026-01-29T14:30:24.972Z
9234967 9234967 20260119235647_DSFVZ GR0002 2026-01-21T14:16:50.952Z 2026-01-28T14:58:22.713Z
9234924 9234924 20260119235237_DRJ2O GR0002 2026-01-21T14:16:42.113Z 2026-01-28T14:58:21.040Z
9218179 9218179 20260117013153_A7cy5 GR0002 2026-01-18T14:10:52.822Z 2026-01-25T14:58:03.426Z
9218177 9218177 20260117013037_xAqWt GR0002 2026-01-18T14:10:52.210Z 2026-01-25T14:58:03.252Z
9218160 9218160 20260117011641_imALt GR0002 2026-01-18T14:10:47.326Z 2026-01-25T14:58:02.562Z
9218140 9218140 20260117005855_3RMNC GR0002 2026-01-18T14:10:41.250Z 2026-01-25T14:58:01.762Z
9218107 9218107 20260117001058_NIak9 GR0002 2026-01-18T14:10:30.579Z 2026-01-25T14:58:00.450Z
9218068 9218068 20260116232827_6A7CY GR0002 2026-01-18T14:10:17.249Z 2026-01-25T14:57:57.407Z
9218043 9218043 20260116225622_dB6Bh GR0002 2026-01-18T14:10:09.529Z 2026-01-25T14:57:56.464Z
9213437 9213437 20260116033203_R3lbP GR0002 2026-01-17T14:16:53.505Z 2026-01-24T15:12:14.031Z
9213238 9213238 20260116024246_zL4hI GR0002 2026-01-17T14:16:01.545Z 2026-01-24T15:11:50.758Z
9213011 9213011 20260116015155_12qjm GR0002 2026-01-17T14:14:56.314Z 2026-01-24T15:11:37.167Z
9212941 9212941 20260116014135_BUBEf GR0002 2026-01-17T14:14:41.513Z 2026-01-24T15:11:35.033Z
9212825 9212825 20260116011252_6vrL5 GR0002 2026-01-17T14:14:07.009Z 2026-01-24T15:11:28.308Z
9212512 9212512 20260115223452_CmRuh GR0002 2026-01-17T14:12:22.246Z 2026-01-24T15:10:59.341Z
9211638 9211638 20260115170446_rfovC GR0002 2026-01-17T14:07:36.615Z 2026-01-24T15:09:42.888Z
9208096 9208096 20260115041254_vE1IQ GR0002 2026-01-16T14:11:18.716Z 2026-01-22T15:04:01.151Z
9207854 9207854 20260115031923_s662n GR0002 2026-01-16T14:10:25.619Z 2026-01-22T15:03:54.967Z
9207835 9207835 20260115031604_eTVGK GR0002 2026-01-16T14:10:20.067Z 2026-01-22T15:03:54.203Z
9207403 9207403 20260115012739_0qy7A GR0002 2026-01-16T14:08:37.665Z 2026-01-22T15:03:20.981Z
9207110 9207110 20260114220055_eLm5a GR0002 2026-01-16T14:07:10.377Z 2026-01-22T15:03:10.738Z
9207092 9207092 20260114214131_mKtG5 GR0002 2026-01-16T14:07:05.150Z 2026-01-22T15:03:10.136Z
9207060 9207060 20260114211415_QjDcd GR0002 2026-01-16T14:06:56.200Z 2026-01-22T15:03:02.904Z
9207035 9207035 20260114205437_LRE3o GR0002 2026-01-16T14:06:48.231Z 2026-01-22T15:02:56.548Z
9202884 9202884 20260114041444_yp1UW GR0002 2026-01-15T14:22:42.449Z 2026-01-22T15:09:58.696Z
9202651 9202651 20260114035833_Ap1ZH GR0002 2026-01-15T14:21:56.077Z 2026-01-22T15:09:24.345Z
9201401 9201401 20260114021330_D09Hg GR0002 2026-01-15T14:18:33.613Z 2026-01-22T15:09:03.038Z
9200227 9200227 20260113232009_pR0GR GR0002 2026-01-15T14:14:16.636Z 2026-01-22T15:08:11.831Z
9199637 9199637 20260113204100_r0z2j GR0002 2026-01-15T14:11:50.424Z 2026-01-22T15:07:57.667Z
9199571 9199571 20260113203045_gQ0o2 GR0002 2026-01-15T14:11:31.488Z 2026-01-22T15:07:33.052Z
9196126 9196126 20260113045016_MgZ9Y GR0002 2026-01-14T14:16:47.831Z 2026-01-21T15:05:28.511Z
9196087 9196087 20260113043052_6Ie94 GR0002 2026-01-14T14:16:31.043Z 2026-01-21T15:05:25.865Z
9195849 9195849 20260113030608_pxe1B GR0002 2026-01-14T14:15:13.443Z 2026-01-21T15:04:48.613Z
9195757 9195757 20260113024326_zCmJ7 GR0002 2026-01-14T14:14:47.120Z 2026-01-21T15:04:47.195Z
9195689 9195689 20260113021754_R0tfe GR0002 2026-01-14T14:14:23.476Z 2026-01-21T15:04:45.631Z
9195611 9195611 20260113020252_Wa8yQ GR0002 2026-01-14T14:14:08.295Z 2026-01-21T15:04:42.988Z
9195490 9195490 20260113013624_uhewq GR0002 2026-01-14T14:13:35.613Z 2026-01-21T15:04:41.424Z
9195298 9195298 20260113005820_Ik0b5 GR0002 2026-01-14T14:12:47.673Z 2026-01-21T15:04:38.703Z
9195226 9195226 20260113004311_oT3yZ GR0002 2026-01-14T14:12:31.004Z 2026-01-21T15:04:37.716Z
9195169 9195169 20260113003200_LQ5UL GR0002 2026-01-14T14:12:17.198Z 2026-01-21T15:04:37.224Z
9195033 9195033 20260113000522_Pc2K5 GR0002 2026-01-14T14:11:46.386Z 2026-01-21T15:04:35.358Z
9194835 9194835 20260112230145_RkKM7 GR0002 2026-01-14T14:10:52.002Z 2026-01-21T15:04:23.579Z
9194689 9194689 20260112220112_LSdxc GR0002 2026-01-14T14:10:17.995Z 2026-01-21T15:04:20.093Z
9194654 9194654 20260112214248_2zRF2 GR0002 2026-01-14T14:10:11.324Z 2026-01-21T15:04:19.659Z
9194605 9194605 20260112213320_UW7QY GR0002 2026-01-14T14:09:59.696Z 2026-01-21T15:04:19.227Z
9194487 9194487 20260112210029_IBCpq GR0002 2026-01-14T14:09:26.706Z 2026-01-21T15:04:17.402Z
9194296 9194296 20260112193824_I6B2O GR0002 2026-01-14T14:08:33.427Z 2026-01-21T15:03:47.601Z
9194200 9194200 20260112184934_rcGA2 GR0002 2026-01-14T14:07:58.897Z 2026-01-21T15:03:39.822Z
9194134 9194134 20260112181536_nQv7l GR0002 2026-01-14T14:07:33.602Z 2026-01-21T15:03:33.190Z
9194131 9194131 20260112181248_EHEK0 GR0002 2026-01-14T14:07:32.661Z 2026-01-21T15:03:32.814Z
9187867 9187867 20260111191337_CNwb7 GR0002 2026-01-13T14:09:16.084Z 2026-01-20T15:20:58.550Z
9187724 9187724 20260111183507_js8Lk GR0002 2026-01-13T14:08:34.783Z 2026-01-20T15:20:42.629Z
9171912 9171912 20260109044237_606Cu GR0002 2026-01-10T14:10:30.559Z 2026-01-17T15:24:42.446Z
9171911 9171911 20260109044133_o1cBW GR0002 2026-01-10T14:10:29.092Z 2026-01-17T15:24:42.299Z
9171869 9171869 20260109041125_NKAXP GR0002 2026-01-10T14:10:10.168Z 2026-01-17T15:24:39.194Z
9171859 9171859 20260109040601_OzJmr GR0002 2026-01-10T14:10:06.973Z 2026-01-17T15:24:38.500Z
9171821 9171821 20260109033821_mC9l7 GR0002 2026-01-10T14:09:50.592Z 2026-01-17T15:24:35.637Z
9171790 9171790 20260109032602_V3cQi GR0002 2026-01-10T14:09:35.953Z 2026-01-17T15:24:33.960Z
9171769 9171769 20260109031028_lQp7L GR0002 2026-01-10T14:09:28.915Z 2026-01-17T15:24:32.461Z
9171757 9171757 20260109025540_pE0ES GR0002 2026-01-10T14:09:21.250Z 2026-01-17T15:24:25.041Z
9171752 9171752 20260109024728_plq56 GR0002 2026-01-10T14:09:19.753Z 2026-01-17T15:24:24.070Z
9171731 9171731 20260109021715_jzs8h GR0002 2026-01-10T14:09:13.012Z 2026-01-17T15:24:22.916Z
9171613 9171613 20260108235532_7rkBB GR0002 2026-01-10T14:08:25.111Z 2026-01-17T15:24:09.768Z
9171569 9171569 20260108231414_JZT7S GR0002 2026-01-10T14:08:09.825Z 2026-01-17T15:24:07.463Z
9128994 9128994 20251229035611_gG6rZ GR0002 2026-01-03T14:58:57.362Z 2026-01-06T15:17:44.078Z
9128979 9128979 20251229030854_b3WWL GR0002 2026-01-03T14:58:01.895Z 2026-01-06T15:17:08.748Z
9128696 9128696 20260101174723_h7tzz GR0002 2026-01-03T14:23:01.169Z 2026-01-09T14:54:22.668Z
9127173 9127173 20260102025724_8kvVG GR0002 2026-01-03T14:08:55.132Z 2026-01-09T14:49:31.680Z
9127147 9127147 20260102024736_t6ha0 GR0002 2026-01-03T14:08:45.053Z 2026-01-09T14:49:30.175Z
9127123 9127123 20260102023925_BfAX3 GR0002 2026-01-03T14:08:33.401Z 2026-01-09T14:49:29.069Z
9127083 9127083 20260102022300_goyV6 GR0002 2026-01-03T14:08:22.254Z 2026-01-09T14:49:26.469Z
9127070 9127070 20260102021810_UeuEJ GR0002 2026-01-03T14:08:17.332Z 2026-01-09T14:49:25.553Z
9127033 9127033 20260102020744_936No GR0002 2026-01-03T14:08:02.405Z 2026-01-09T14:49:23.894Z
9126826 9126826 20260102005646_h2Ab2 GR0002 2026-01-03T14:06:55.879Z 2026-01-09T14:49:05.151Z
9126761 9126761 20260102003920_pf0kJ GR0002 2026-01-03T14:06:34.361Z 2026-01-09T14:49:01.131Z
9126722 9126722 20260102002200_ckQMx GR0002 2026-01-03T14:06:21.034Z 2026-01-09T14:48:59.135Z
9126674 9126674 20260101235850_wqKTo GR0002 2026-01-03T14:05:59.822Z 2026-01-09T14:48:56.948Z
9126568 9126568 20260101225218_5wypO GR0002 2026-01-03T14:05:20.543Z 2026-01-09T14:48:51.292Z
9126547 9126547 20260101224411_SwTVs GR0002 2026-01-03T14:05:12.643Z 2026-01-09T14:48:50.189Z
9126535 9126535 20260101223427_tuTkD GR0002 2026-01-03T14:05:07.790Z 2026-01-09T14:48:49.176Z
9126492 9126492 20260101214848_5fdoU GR0002 2026-01-03T14:04:50.918Z 2026-01-09T14:48:46.814Z
9126464 9126464 20260101211106_ibh2V GR0002 2026-01-03T14:04:30.355Z 2026-01-09T14:48:43.164Z
9122170 9122170 20260101044456_av0bB GR0002 2026-01-02T14:11:36.099Z 2026-01-09T14:53:04.986Z
9122150 9122150 20260101043943_BuBi0 GR0002 2026-01-02T14:11:30.940Z 2026-01-09T14:53:03.793Z
9122029 9122029 20260101041102_qJdm7 GR0002 2026-01-02T14:10:48.578Z 2026-01-09T14:52:57.024Z
9122015 9122015 20260101040942_vDwN6 GR0002 2026-01-02T14:10:46.480Z 2026-01-09T14:52:56.582Z
9121940 9121940 20260101034915_bqS1z GR0002 2026-01-02T14:10:20.698Z 2026-01-09T14:52:47.179Z
9121921 9121921 20260101034224_lqKo2 GR0002 2026-01-02T14:10:13.917Z 2026-01-09T14:52:46.491Z
9121864 9121864 20260101031727_ZWEok GR0002 2026-01-02T14:09:55.423Z 2026-01-09T14:52:43.132Z
9121835 9121835 20260101030825_cwnW2 GR0002 2026-01-02T14:09:44.138Z 2026-01-09T14:52:41.714Z
9121786 9121786 20260101024357_NfCe6 GR0002 2026-01-02T14:09:25.477Z 2026-01-09T14:52:38.781Z

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