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

>10,000 rows count all where station_code = "HR0025" 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
9271806 9271806 20260127201938_CAViA HR0025 2026-01-29T14:23:57.072Z 2026-01-29T14:30:25.151Z
9267973 9267973 20260126050857_GH0Sk HR0025 2026-01-28T14:27:51.835Z 2026-01-29T14:39:04.599Z
9256490 9256490 20260120044304_r38g8 HR0025 2026-01-25T14:42:01.570Z 2026-01-28T15:01:00.184Z
9256489 9256489 20260120041636_oC6pL HR0025 2026-01-25T14:41:48.742Z 2026-01-28T15:00:47.685Z
9256487 9256487 20260120041226_2ZSnN HR0025 2026-01-25T14:41:46.842Z 2026-01-28T15:00:40.010Z
9256483 9256483 20260120032451_3USI9 HR0025 2026-01-25T14:41:16.909Z 2026-01-28T15:00:03.924Z
9256481 9256481 20260120023936_8iL2T HR0025 2026-01-25T14:40:50.752Z 2026-01-28T14:59:46.776Z
9256479 9256479 20260120023337_Gebi2 HR0025 2026-01-25T14:40:47.351Z 2026-01-28T14:59:44.139Z
9256476 9256476 20260120021746_3FoYK HR0025 2026-01-25T14:40:35.842Z 2026-01-28T14:59:28.643Z
9256472 9256472 20260120013656_9h2sK HR0025 2026-01-25T14:40:11.403Z 2026-01-28T14:59:03.637Z
9256470 9256470 20260120010711_p33EM HR0025 2026-01-25T14:39:53.124Z 2026-01-28T14:58:53.429Z
9256468 9256468 20260120000517_WtLS3 HR0025 2026-01-25T14:39:23.449Z 2026-01-28T14:58:24.211Z
9256467 9256467 20260119210108_Jqyk8 HR0025 2026-01-25T14:38:35.888Z 2026-01-28T14:57:33.662Z
9256463 9256463 20260119205743_JfuiA HR0025 2026-01-25T14:38:34.394Z 2026-01-28T14:57:31.540Z
9256458 9256458 20260119182133_B1fVn HR0025 2026-01-25T14:37:43.164Z 2026-01-28T14:56:47.809Z
9129024 9129024 20251228200457_fW5aX HR0025 2026-01-03T15:17:41.026Z 2026-01-05T15:14:42.916Z
9129020 9129020 20251229182815_2zF5J HR0025 2026-01-03T15:04:51.412Z 2026-01-06T15:21:29.569Z
9129017 9129017 20251229050519_QMLwf HR0025 2026-01-03T15:00:20.000Z 2026-01-06T15:18:27.220Z
9129016 9129016 20251229045328_4NRqE HR0025 2026-01-03T15:00:07.940Z 2026-01-06T15:18:22.403Z
9129014 9129014 20251229044952_Bb6Ev HR0025 2026-01-03T14:59:58.293Z 2026-01-06T15:18:20.620Z
9129009 9129009 20251229044317_dPUwW HR0025 2026-01-03T14:59:50.618Z 2026-01-06T15:18:17.771Z
9129007 9129007 20251229043849_fkjzi HR0025 2026-01-03T14:59:46.960Z 2026-01-06T15:18:16.163Z
9129005 9129005 20251229042539_7Ygwr HR0025 2026-01-03T14:59:31.675Z 2026-01-06T15:17:57.792Z
9129004 9129004 20251229042428_QFUKO HR0025 2026-01-03T14:59:29.913Z 2026-01-06T15:17:57.030Z
9129002 9129002 20251229042135_xvw9L HR0025 2026-01-03T14:59:24.341Z 2026-01-06T15:17:54.656Z
9129000 9129000 20251229041203_gZCTp HR0025 2026-01-03T14:59:17.422Z 2026-01-06T15:17:51.381Z
9128999 9128999 20251229040922_3o3Sh HR0025 2026-01-03T14:59:13.944Z 2026-01-06T15:17:49.566Z
9128997 9128997 20251229040418_YEl72 HR0025 2026-01-03T14:59:04.141Z 2026-01-06T15:17:47.294Z
9128995 9128995 20251229035611_gG6rZ HR0025 2026-01-03T14:58:57.362Z 2026-01-06T15:17:44.078Z
9128985 9128985 20251229033459_u6Csh HR0025 2026-01-03T14:58:28.049Z 2026-01-06T15:17:21.433Z
9128959 9128959 20251229012845_7T64i HR0025 2026-01-03T14:56:27.371Z 2026-01-06T15:16:04.278Z
9128957 9128957 20251229012657_pSyLD HR0025 2026-01-03T14:56:25.275Z 2026-01-06T15:16:03.499Z
9128955 9128955 20251229012532_gW7bJ HR0025 2026-01-03T14:56:23.830Z 2026-01-06T15:16:03.066Z
9128953 9128953 20251229012330_gpkkR HR0025 2026-01-03T14:56:22.213Z 2026-01-06T15:16:02.244Z
9128951 9128951 20251229011055_0g21p HR0025 2026-01-03T14:56:01.474Z 2026-01-06T15:15:54.946Z
9128949 9128949 20251229010809_x8zib HR0025 2026-01-03T14:56:00.222Z 2026-01-06T15:15:54.150Z
9128947 9128947 20251229005821_Nkv3o HR0025 2026-01-03T14:55:53.309Z 2026-01-06T15:15:40.583Z
9128941 9128941 20251229002056_8TaP6 HR0025 2026-01-03T14:55:25.407Z 2026-01-06T15:15:26.563Z
9128938 9128938 20251229000854_yOp7S HR0025 2026-01-03T14:55:20.245Z 2026-01-06T15:15:23.365Z
9128937 9128937 20251228235815_5HD8G HR0025 2026-01-03T14:55:14.186Z 2026-01-06T15:15:11.283Z
9128933 9128933 20251228234110_Ro0ag HR0025 2026-01-03T14:55:03.570Z 2026-01-06T15:15:05.292Z
9128926 9128926 20251228230539_27QEm HR0025 2026-01-03T14:54:37.262Z 2026-01-06T15:14:53.884Z
9128914 9128914 20251230050653_522Rn HR0025 2026-01-03T14:47:10.230Z 2026-01-07T15:09:10.988Z
9128912 9128912 20251230050110_Yd5H0 HR0025 2026-01-03T14:47:02.877Z 2026-01-07T15:09:08.729Z
9128910 9128910 20251230043302_QGo7P HR0025 2026-01-03T14:46:32.386Z 2026-01-07T15:08:46.649Z
9128908 9128908 20251230042922_I2tVh HR0025 2026-01-03T14:46:28.698Z 2026-01-07T15:08:43.604Z
9128907 9128907 20251230042125_f3xGT HR0025 2026-01-03T14:46:19.911Z 2026-01-07T15:08:39.332Z
9128904 9128904 20251230041905_DdH4N HR0025 2026-01-03T14:46:18.341Z 2026-01-07T15:08:38.372Z
9128902 9128902 20251230041844_V85XE HR0025 2026-01-03T14:46:17.813Z 2026-01-07T15:08:38.219Z
9128900 9128900 20251230041641_MpasO HR0025 2026-01-03T14:46:15.446Z 2026-01-07T15:08:37.709Z
9128898 9128898 20251230041220_J2F8H HR0025 2026-01-03T14:46:10.458Z 2026-01-07T15:08:36.124Z
9128897 9128897 20251230040747_CurDr HR0025 2026-01-03T14:46:05.576Z 2026-01-07T15:08:32.615Z
9128895 9128895 20251230035353_NxJi3 HR0025 2026-01-03T14:45:46.443Z 2026-01-07T15:08:17.424Z
9128893 9128893 20251230034408_xNFuu HR0025 2026-01-03T14:45:37.517Z 2026-01-07T15:08:12.066Z
9128890 9128890 20251230033603_NAXfL HR0025 2026-01-03T14:45:25.024Z 2026-01-07T15:08:07.270Z
9128889 9128889 20251230032656_sn4uG HR0025 2026-01-03T14:45:14.300Z 2026-01-07T15:08:01.010Z
9128887 9128887 20251230031839_j5JM2 HR0025 2026-01-03T14:45:05.041Z 2026-01-07T15:07:48.130Z
9128885 9128885 20251230031607_rhpuw HR0025 2026-01-03T14:45:00.164Z 2026-01-07T15:07:47.043Z
9128882 9128882 20251230030632_hyKQL HR0025 2026-01-03T14:44:49.037Z 2026-01-07T15:07:41.646Z
9128880 9128880 20251230030538_l11s5 HR0025 2026-01-03T14:44:47.902Z 2026-01-07T15:07:41.192Z
9128879 9128879 20251230030239_re0jb HR0025 2026-01-03T14:44:44.525Z 2026-01-07T15:07:39.205Z
9128877 9128877 20251230025905_SAdYk HR0025 2026-01-03T14:44:41.844Z 2026-01-07T15:07:38.102Z
9128875 9128875 20251230024611_yhG2w HR0025 2026-01-03T14:44:26.934Z 2026-01-07T15:07:31.702Z
9128873 9128873 20251230024149_dQ6RV HR0025 2026-01-03T14:44:23.638Z 2026-01-07T15:07:30.273Z
9128871 9128871 20251230020120_Gkz7j HR0025 2026-01-03T14:43:51.825Z 2026-01-07T15:07:03.445Z
9128868 9128868 20251230014223_ygtyy HR0025 2026-01-03T14:43:40.073Z 2026-01-07T15:06:50.096Z
9128867 9128867 20251230013227_OL2aZ HR0025 2026-01-03T14:43:32.450Z 2026-01-07T15:06:47.532Z
9128865 9128865 20251230011816_j6zge HR0025 2026-01-03T14:43:23.967Z 2026-01-07T15:06:41.831Z
9128863 9128863 20251230011154_RYJPn HR0025 2026-01-03T14:43:15.580Z 2026-01-07T15:06:39.409Z
9128861 9128861 20251230011006_0K6S2 HR0025 2026-01-03T14:43:15.194Z 2026-01-07T15:06:39.261Z
9128859 9128859 20251230005900_MRgok HR0025 2026-01-03T14:43:10.035Z 2026-01-07T15:06:37.078Z
9128856 9128856 20251230005049_pTgyp HR0025 2026-01-03T14:43:04.308Z 2026-01-07T15:06:34.092Z
9128853 9128853 20251230004405_rTIzf HR0025 2026-01-03T14:43:01.313Z 2026-01-07T15:06:32.685Z
9128852 9128852 20251230003409_G8hM9 HR0025 2026-01-03T14:42:57.122Z 2026-01-07T15:06:22.670Z
9128850 9128850 20251230001212_IYuy1 HR0025 2026-01-03T14:42:43.128Z 2026-01-07T15:06:16.477Z
9128848 9128848 20251230000732_8Xd5E HR0025 2026-01-03T14:42:39.677Z 2026-01-07T15:06:14.889Z
9128845 9128845 20251230000032_VSpY7 HR0025 2026-01-03T14:42:36.499Z 2026-01-07T15:06:13.340Z
9128843 9128843 20251229234622_SmCBK HR0025 2026-01-03T14:42:31.018Z 2026-01-07T15:06:11.005Z
9128841 9128841 20251229232134_yLbbo HR0025 2026-01-03T14:42:19.467Z 2026-01-07T15:06:06.648Z
9128839 9128839 20251229222847_VS28s HR0025 2026-01-03T14:42:09.315Z 2026-01-07T15:05:52.173Z
9128838 9128838 20251231050708_37aNJ HR0025 2026-01-03T14:34:01.089Z 2026-01-08T15:10:48.115Z
9128835 9128835 20251231050226_Onfj3 HR0025 2026-01-03T14:33:53.257Z 2026-01-08T15:10:44.665Z
9128833 9128833 20251231044832_9FGCT HR0025 2026-01-03T14:33:30.905Z 2026-01-08T15:10:26.391Z
9128831 9128831 20251231043944_D3gDU HR0025 2026-01-03T14:33:22.240Z 2026-01-08T15:10:18.612Z
9128828 9128828 20251231041911_VfBym HR0025 2026-01-03T14:32:46.160Z 2026-01-08T15:09:51.493Z
9128826 9128826 20251231041910_7BHoL HR0025 2026-01-03T14:32:45.733Z 2026-01-08T15:09:51.300Z
9128824 9128824 20251231040129_EgwpL HR0025 2026-01-03T14:32:09.334Z 2026-01-08T15:09:22.667Z
9128822 9128822 20251231035559_BluSV HR0025 2026-01-03T14:31:56.277Z 2026-01-08T15:09:16.517Z
9128820 9128820 20251231035132_Wdb2G HR0025 2026-01-03T14:31:46.028Z 2026-01-08T15:09:11.851Z
9128816 9128816 20251231033754_X57m9 HR0025 2026-01-03T14:31:18.913Z 2026-01-08T15:08:51.127Z
9128814 9128814 20251231033406_eFiml HR0025 2026-01-03T14:31:12.811Z 2026-01-08T15:08:47.770Z
9128810 9128810 20251231032513_aB2Nv HR0025 2026-01-03T14:31:00.647Z 2026-01-08T15:08:41.507Z
9128809 9128809 20251231032325_xbOB4 HR0025 2026-01-03T14:30:55.104Z 2026-01-08T15:08:39.391Z
9128807 9128807 20251231032056_dg8wc HR0025 2026-01-03T14:30:51.429Z 2026-01-08T15:08:38.360Z
9128805 9128805 20251231025718_UzmSP HR0025 2026-01-03T14:30:15.586Z 2026-01-08T15:08:11.983Z
9128803 9128803 20251231022151_WrSBn HR0025 2026-01-03T14:29:24.132Z 2026-01-08T15:07:39.183Z
9128801 9128801 20251231021659_V6hQw HR0025 2026-01-03T14:29:20.694Z 2026-01-08T15:07:36.975Z
9128799 9128799 20251231011324_mRqxW HR0025 2026-01-03T14:28:07.308Z 2026-01-08T15:06:42.217Z
9128798 9128798 20251231002353_k0lJT HR0025 2026-01-03T14:27:09.247Z 2026-01-08T15:06:08.374Z
9128796 9128796 20251230235636_KPcnE HR0025 2026-01-03T14:26:43.624Z 2026-01-08T15:05:49.526Z

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