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

6,141 rows where station_code = "GR0004" 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
8675113 8675113 20251202040204_ubA3R GR0004 2025-12-03T14:23:03.844Z 2025-12-05T14:28:11.556Z
8674382 8674382 20251202021421_geZJr GR0004 2025-12-03T14:21:33.852Z 2025-12-05T14:27:39.896Z
8674337 8674337 20251202020444_G5vzu GR0004 2025-12-03T14:21:26.592Z 2025-12-05T14:27:38.377Z
8674318 8674318 20251202015943_Ag085 GR0004 2025-12-03T14:21:24.177Z 2025-12-05T14:27:36.084Z
8674166 8674166 20251202014240_2JAE1 GR0004 2025-12-03T14:21:07.020Z 2025-12-05T14:27:31.390Z
8673972 8673972 20251202005439_31K5f GR0004 2025-12-03T14:20:30.811Z 2025-12-05T14:27:24.421Z
8673945 8673945 20251202004508_8yONJ GR0004 2025-12-03T14:20:25.549Z 2025-12-05T14:27:23.737Z
8673845 8673845 20251201235854_HgiVR GR0004 2025-12-03T14:20:10.569Z 2025-12-05T14:27:19.648Z
8663802 8663802 20251130220728_EKE1P GR0004 2025-12-02T14:19:11.948Z 2025-12-05T14:34:32.741Z
8663733 8663733 20251130214313_KKov4 GR0004 2025-12-02T14:18:59.308Z 2025-12-05T14:34:30.094Z
8663721 8663721 20251130213803_c462h GR0004 2025-12-02T14:18:57.578Z 2025-12-05T14:34:29.709Z
8604389 8604389 20251123224400_sudRB GR0004 2025-11-26T14:34:19.920Z 2025-12-02T15:11:19.922Z
8604386 8604386 20251123222618_PVKEq GR0004 2025-11-26T14:34:17.359Z 2025-12-02T15:11:18.751Z
8604374 8604374 20251123220117_3wpHF GR0004 2025-11-26T14:34:12.055Z 2025-12-02T15:11:12.559Z
8604355 8604355 20251123200944_EySYX GR0004 2025-11-26T14:33:17.642Z 2025-12-02T15:10:55.094Z
8604314 8604314 20251123165049_A4Ros GR0004 2025-11-26T14:31:39.037Z 2025-12-02T15:10:01.639Z
8596002 8596002 20251124192520_ocRS1 GR0004 2025-11-26T14:13:19.245Z 2025-12-02T15:06:28.411Z
8595507 8595507 20251124163542_e2wqz GR0004 2025-11-26T14:11:29.364Z 2025-12-02T15:05:59.893Z
8595497 8595497 20251124162828_TDnFe GR0004 2025-11-26T14:11:25.794Z 2025-12-02T15:05:59.691Z
8589354 8589354 20251124012650_shqjj GR0004 2025-11-25T14:19:44.195Z 2025-12-02T15:12:22.447Z
8588705 8588705 20251124002626_tlblt GR0004 2025-11-25T14:18:10.735Z 2025-11-25T14:28:10.943Z
8587842 8587842 20251123225152_dKgQ4 GR0004 2025-11-25T14:16:17.106Z 2025-12-02T15:11:20.799Z
8587540 8587540 20251123221413_jJ12Q GR0004 2025-11-25T14:15:29.660Z 2025-12-02T15:11:17.115Z
8587464 8587464 20251123220804_eymFx GR0004 2025-11-25T14:15:22.849Z 2025-12-02T15:11:13.757Z
8587364 8587364 20251123215534_3gdpH GR0004 2025-11-25T14:15:04.773Z 2025-12-02T15:11:11.515Z
8587217 8587217 20251123213611_BZVyM GR0004 2025-11-25T14:14:51.788Z 2025-12-02T15:11:09.398Z
8586139 8586139 20251123185106_ENI8d GR0004 2025-11-25T14:12:08.161Z 2025-12-02T15:10:44.241Z
8586077 8586077 20251123183957_0YM3Q GR0004 2025-11-25T14:11:47.499Z 2025-12-02T15:10:43.429Z
8579834 8579834 20251123012613_uP6WW GR0004 2025-11-24T14:15:17.331Z 2025-12-01T15:21:11.290Z
8579831 8579831 20251123012556_ro2Ct GR0004 2025-11-24T14:15:17.046Z 2025-12-01T15:21:11.162Z
8549280 8549280 20251120221425_yOo5H GR0004 2025-11-22T14:18:38.700Z 2025-11-29T14:54:24.424Z
8548462 8548462 20251120205744_79DAT GR0004 2025-11-22T14:16:55.542Z 2025-11-29T14:54:22.733Z
8548111 8548111 20251120203754_ogON8 GR0004 2025-11-22T14:16:19.604Z 2025-11-29T14:54:21.991Z
8547942 8547942 20251120202400_p43Pa GR0004 2025-11-22T14:15:57.285Z 2025-11-29T14:54:21.408Z
8547588 8547588 20251120200147_hAxNa GR0004 2025-11-22T14:15:18.843Z 2025-11-29T14:54:20.420Z
8493984 8493984 20251117021950_0HFCY GR0004 2025-11-18T14:23:25.231Z 2025-11-25T15:09:25.994Z
8493709 8493709 20251117020109_orSc6 GR0004 2025-11-18T14:22:52.108Z 2025-11-25T15:09:21.741Z
8493410 8493410 20251117014156_Fwv2A GR0004 2025-11-18T14:22:09.570Z 2025-11-25T15:09:12.907Z
8493309 8493309 20251117013415_LhK5a GR0004 2025-11-18T14:21:54.209Z 2025-11-25T15:09:03.485Z
8492740 8492740 20251117004957_euyUt GR0004 2025-11-18T14:20:28.246Z 2025-11-25T15:08:56.397Z
8492596 8492596 20251117004050_9pFFS GR0004 2025-11-18T14:20:17.908Z 2025-11-25T15:08:53.102Z
8492267 8492267 20251117001250_tvJDE GR0004 2025-11-18T14:19:28.092Z 2025-11-25T15:08:46.903Z
8491777 8491777 20251116231105_agPnG GR0004 2025-11-18T14:18:18.620Z 2025-11-25T15:08:41.936Z
8491489 8491489 20251116223954_K6idD GR0004 2025-11-18T14:17:34.521Z 2025-11-25T15:08:39.036Z
8491344 8491344 20251116222011_NC23T GR0004 2025-11-18T14:17:08.727Z 2025-11-25T15:08:36.858Z
8491337 8491337 20251116221918_RVG2K GR0004 2025-11-18T14:17:07.184Z 2025-11-25T15:08:36.748Z
8491198 8491198 20251116215201_STSr0 GR0004 2025-11-18T14:16:38.100Z 2025-11-25T15:08:33.594Z
8491143 8491143 20251116214014_KPGgY GR0004 2025-11-18T14:16:26.178Z 2025-11-25T15:08:33.278Z
8490779 8490779 20251116202428_Zsn3m GR0004 2025-11-18T14:15:17.398Z 2025-11-25T15:08:25.904Z
8489406 8489406 20251116162630_DnEm0 GR0004 2025-11-18T14:09:59.727Z 2025-11-25T15:07:29.482Z
8481773 8481773 20251116040532_fpnKK GR0004 2025-11-17T14:21:47.115Z 2025-11-24T15:05:07.611Z
8481532 8481532 20251116032448_3kolh GR0004 2025-11-17T14:21:16.774Z 2025-11-24T15:05:04.185Z
8481487 8481487 20251116031758_XyHSF GR0004 2025-11-17T14:21:04.425Z 2025-11-24T15:05:03.901Z
8481224 8481224 20251116021226_qMn28 GR0004 2025-11-17T14:20:16.822Z 2025-11-24T15:05:01.139Z
8481145 8481145 20251116015055_fiV6j GR0004 2025-11-17T14:20:03.541Z 2025-11-24T15:04:59.219Z
8481123 8481123 20251116014626_TM8n2 GR0004 2025-11-17T14:20:01.607Z 2025-11-24T15:04:59.048Z
8481082 8481082 20251116013624_mWMvK GR0004 2025-11-17T14:19:56.521Z 2025-11-24T15:04:58.738Z
8481006 8481006 20251116011602_KTyWn GR0004 2025-11-17T14:19:48.861Z 2025-11-24T15:04:58.057Z
8480944 8480944 20251116005817_h64iO GR0004 2025-11-17T14:19:29.057Z 2025-11-24T15:04:57.390Z
8480911 8480911 20251116004632_0LPeA GR0004 2025-11-17T14:19:26.094Z 2025-11-17T14:34:35.437Z
8480879 8480879 20251116003700_h1xkb GR0004 2025-11-17T14:19:21.449Z 2025-11-17T14:34:35.414Z
8480822 8480822 20251116001328_2x4k3 GR0004 2025-11-17T14:19:13.878Z 2025-11-24T15:04:56.352Z
8480783 8480783 20251115234434_KsvxC GR0004 2025-11-17T14:19:10.019Z 2025-11-17T14:34:35.349Z
8480759 8480759 20251115233301_0yqhg GR0004 2025-11-17T14:19:07.230Z 2025-11-24T15:04:55.868Z
8480705 8480705 20251115230936_cB23Q GR0004 2025-11-17T14:18:51.674Z 2025-11-24T15:04:55.431Z
8480700 8480700 20251115230825_Jai3A GR0004 2025-11-17T14:18:50.952Z 2025-11-24T15:04:55.399Z
8480559 8480559 20251115221228_E2S2i GR0004 2025-11-17T14:18:30.847Z 2025-11-24T15:04:54.110Z
8480539 8480539 20251115220357_Ps3PG GR0004 2025-11-17T14:18:28.680Z 2025-11-24T15:04:53.876Z
8480519 8480519 20251115215621_mJeBG GR0004 2025-11-17T14:18:27.032Z 2025-11-24T15:04:53.744Z
8480476 8480476 20251115214316_V1QlU GR0004 2025-11-17T14:18:22.664Z 2025-11-24T15:04:53.277Z
8480456 8480456 20251115213531_D52Fb GR0004 2025-11-17T14:18:20.096Z 2025-11-24T15:04:53.049Z
8480454 8480454 20251115213306_3jN5n GR0004 2025-11-17T14:18:19.998Z 2025-11-17T14:34:35.113Z
8480435 8480435 20251115212707_nXz26 GR0004 2025-11-17T14:18:18.233Z 2025-11-24T15:04:52.877Z
8480313 8480313 20251115205900_Jl85o GR0004 2025-11-17T14:17:50.462Z 2025-11-24T15:04:51.710Z
8480290 8480290 20251115205622_BRDK9 GR0004 2025-11-17T14:17:48.687Z 2025-11-24T15:04:51.497Z
8480059 8480059 20251115202807_04stk GR0004 2025-11-17T14:17:21.195Z 2025-11-17T14:34:34.946Z
8480027 8480027 20251115202225_3of5E GR0004 2025-11-17T14:17:16.689Z 2025-11-24T15:04:49.890Z
8479550 8479550 20251115193006_NIZqd GR0004 2025-11-17T14:16:15.606Z 2025-11-17T14:34:34.682Z
8478378 8478378 20251115170940_qO2gO GR0004 2025-11-17T14:13:22.312Z 2025-11-24T15:04:10.693Z
8477947 8477947 20251115162624_Essij GR0004 2025-11-17T14:12:16.750Z 2025-11-17T14:34:33.855Z
8469963 8469963 20251115035458_La9yq GR0004 2025-11-16T14:21:34.122Z 2025-11-23T15:17:59.107Z
8469885 8469885 20251115034651_d2s8m GR0004 2025-11-16T14:21:26.829Z 2025-11-23T15:17:58.455Z
8469559 8469559 20251115025842_iEELf GR0004 2025-11-16T14:20:37.115Z 2025-11-23T15:17:44.698Z
8469491 8469491 20251115025321_43UG8 GR0004 2025-11-16T14:20:15.151Z 2025-11-23T15:17:40.359Z
8469186 8469186 20251115021339_v4wsN GR0004 2025-11-16T14:19:33.469Z 2025-11-23T15:17:37.183Z
8468735 8468735 20251115010409_Lrtx4 GR0004 2025-11-16T14:18:29.731Z 2025-11-23T15:17:22.897Z
8468636 8468636 20251115004644_0Bz6c GR0004 2025-11-16T14:18:04.986Z 2025-11-23T15:17:18.732Z
8468454 8468454 20251115001516_R2zYb GR0004 2025-11-16T14:17:34.132Z 2025-11-23T15:17:16.306Z
8468392 8468392 20251115000135_Pzzau GR0004 2025-11-16T14:17:22.193Z 2025-11-23T15:17:16.023Z
8468371 8468371 20251114235625_H134C GR0004 2025-11-16T14:17:19.986Z 2025-11-23T15:17:15.915Z
8468303 8468303 20251114234255_1CfHm GR0004 2025-11-16T14:17:11.803Z 2025-11-23T15:17:15.461Z
8468284 8468284 20251114233458_l2w28 GR0004 2025-11-16T14:17:09.840Z 2025-11-23T15:17:15.286Z
8468251 8468251 20251114232556_BrSVA GR0004 2025-11-16T14:17:06.274Z 2025-11-23T15:17:15.042Z
8468202 8468202 20251114231817_iLibl GR0004 2025-11-16T14:16:49.637Z 2025-11-23T15:17:14.700Z
8468191 8468191 20251114231659_Mwh1W GR0004 2025-11-16T14:16:48.687Z 2025-11-23T15:17:14.664Z
8468145 8468145 20251114230652_vuYGx GR0004 2025-11-16T14:16:40.409Z 2025-11-23T15:17:14.420Z
8468125 8468125 20251114230101_5NV3z GR0004 2025-11-16T14:16:38.161Z 2025-11-23T15:17:14.322Z
8467895 8467895 20251114215329_IsXK2 GR0004 2025-11-16T14:15:56.491Z 2025-11-23T15:17:12.651Z
8467890 8467890 20251114214943_fFeEd GR0004 2025-11-16T14:15:55.720Z 2025-11-23T15:17:12.622Z
8467814 8467814 20251114211156_sMyNX GR0004 2025-11-16T14:15:44.162Z 2025-11-23T15:17:12.023Z

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