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

3,297 rows where station_code = "US001N" 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
8647886 8647886 20251129055521_nd9UM US001N 2025-11-30T14:29:21.028Z 2025-12-06T14:56:51.529Z
8582861 8582861 20251123085733_BzqgC US001N 2025-11-24T14:34:34.244Z 2025-12-01T15:22:28.688Z
8498445 8498445 20251117065138_eslyW US001N 2025-11-18T14:30:23.776Z 2025-11-18T14:30:23.776Z
8497786 8497786 20251117054819_Rycrs US001N 2025-11-18T14:29:30.608Z 2025-11-25T15:10:52.804Z
8495988 8495988 20251117041820_VtDGu US001N 2025-11-18T14:26:59.698Z 2025-11-25T15:10:05.940Z
8372142 8372142 20251104073040_o4REB US001N 2025-11-05T14:17:21.194Z 2025-11-12T15:11:14.410Z
8372074 8372074 20251104070823_iQr92 US001N 2025-11-05T14:17:06.312Z 2025-11-12T15:11:13.497Z
8371907 8371907 20251104061714_NKXXE US001N 2025-11-05T14:16:38.704Z 2025-11-12T15:11:10.690Z
8358081 8358081 20251102075745_pArqQ US001N 2025-11-03T14:44:21.274Z 2025-11-03T14:44:21.274Z
8357923 8357923 20251102073730_OA2qV US001N 2025-11-03T14:43:52.053Z 2025-11-10T15:10:04.042Z
8357572 8357572 20251102062925_qtF7s US001N 2025-11-03T14:43:11.820Z 2025-11-10T15:09:51.396Z
8357122 8357122 20251102044606_QMmBt US001N 2025-11-03T14:42:47.980Z 2025-11-10T15:09:10.004Z
8294159 8294159 20251028101921_RCLWp US001N 2025-10-30T12:40:52.079Z 2025-11-05T15:24:21.037Z
8276683 8276683 20251027091118_Ze51P US001N 2025-10-29T12:30:14.204Z 2025-11-04T15:47:03.296Z
8275489 8275489 20251027065723_UflRu US001N 2025-10-29T12:28:02.866Z 2025-11-04T15:46:06.573Z
8244300 8244300 20251025074731_Gr90V US001N 2025-10-27T12:37:44.065Z 2025-11-02T15:05:42.792Z
8226469 8226469 20251024093000_yVwXA US001N 2025-10-26T12:45:02.690Z 2025-11-01T13:11:25.792Z
8225804 8225804 20251024083818_pRlZ2 US001N 2025-10-26T12:43:50.181Z 2025-11-01T13:11:22.902Z
8225386 8225386 20251024080206_YuS3v US001N 2025-10-26T12:43:15.402Z 2025-11-01T13:11:21.759Z
8225336 8225336 20251024075733_D5zFI US001N 2025-10-26T12:43:12.667Z 2025-11-01T13:11:21.583Z
8225116 8225116 20251024073647_ul81G US001N 2025-10-26T12:43:03.684Z 2025-11-01T13:11:21.114Z
8224953 8224953 20251024072527_wtyQo US001N 2025-10-26T12:42:58.298Z 2025-11-01T13:11:20.767Z
8224618 8224618 20251024065317_g3O3V US001N 2025-10-26T12:42:16.370Z 2025-11-01T13:11:19.730Z
8224494 8224494 20251024064625_00Gq1 US001N 2025-10-26T12:41:56.196Z 2025-11-01T13:11:19.418Z
8224221 8224221 20251024061706_g83Fp US001N 2025-10-26T12:41:21.256Z 2025-11-01T13:11:18.668Z
8224002 8224002 20251024055329_3LHXQ US001N 2025-10-26T12:41:13.127Z 2025-11-01T13:11:17.957Z
8202666 8202666 20251023071613_3tS3t US001N 2025-10-25T12:22:06.718Z 2025-10-31T13:08:56.374Z
8202620 8202620 20251023071049_DDQpk US001N 2025-10-25T12:21:54.217Z 2025-10-31T13:08:56.213Z
8202612 8202612 20251023070827_pdc8N US001N 2025-10-25T12:21:52.900Z 2025-10-31T13:08:56.155Z
8185415 8185415 20251021095227_GAwpw US001N 2025-10-23T12:36:17.038Z 2025-10-29T13:08:08.070Z
8185272 8185272 20251021094205_2Vqmh US001N 2025-10-23T12:36:11.843Z 2025-10-29T13:08:06.563Z
8184054 8184054 20251021081737_IghmI US001N 2025-10-23T12:33:36.648Z 2025-10-29T13:07:55.149Z
8183934 8183934 20251021081126_5qQLN US001N 2025-10-23T12:33:22.030Z 2025-10-29T13:07:54.872Z
8183236 8183236 20251021071019_yvrPS US001N 2025-10-23T12:32:07.411Z 2025-10-29T13:07:50.213Z
8183147 8183147 20251021065700_BSGmU US001N 2025-10-23T12:31:51.764Z 2025-10-29T13:07:48.909Z
8136273 8136273 20251018081243_bCSKW US001N 2025-10-19T12:19:25.215Z 2025-10-26T13:16:15.075Z
8136178 8136178 20251018080512_7rM33 US001N 2025-10-19T12:19:20.173Z 2025-10-26T13:16:14.315Z
8126999 8126999 20251017093609_5aUp3 US001N 2025-10-18T12:34:46.538Z 2025-10-25T13:30:46.271Z
8123816 8123816 20251017041905_z41dO US001N 2025-10-18T12:27:32.310Z 2025-10-25T13:29:12.740Z
8115273 8115273 20251016091344_X9iYZ US001N 2025-10-17T12:17:59.827Z 2025-10-24T13:17:01.285Z
8115260 8115260 20251016091249_rwPXP US001N 2025-10-17T12:17:59.205Z 2025-10-24T13:17:01.206Z
8114690 8114690 20251016082005_asU1d US001N 2025-10-17T12:16:50.621Z 2025-10-24T13:16:58.418Z
8114649 8114649 20251016081523_81CCM US001N 2025-10-17T12:16:48.823Z 2025-10-24T13:16:58.219Z
8114511 8114511 20251016080157_OsiR3 US001N 2025-10-17T12:16:42.357Z 2025-10-24T13:16:57.321Z
8114263 8114263 20251016073525_F9M3o US001N 2025-10-17T12:16:02.691Z 2025-10-24T13:16:56.092Z
8114261 8114261 20251016073456_AXZe9 US001N 2025-10-17T12:16:02.516Z 2025-10-24T13:16:56.085Z
8114079 8114079 20251016070421_H2gYZ US001N 2025-10-17T12:15:45.751Z 2025-10-24T13:16:55.010Z
8076209 8076209 20251009081700_0TNyZ US001N 2025-10-10T12:11:50.192Z 2025-10-17T12:38:05.596Z
8058717 8058717 20251005093741_79dGA US001N 2025-10-07T12:02:37.756Z 2025-10-14T12:33:02.485Z
8058437 8058437 20251005084956_hTRtK US001N 2025-10-07T12:01:15.613Z 2025-10-14T12:32:44.978Z
8052035 8052035 20251003070955_DKbPW US001N 2025-10-04T12:45:32.390Z 2025-10-11T12:42:50.662Z
8045333 8045333 20251002090500_yhB0h US001N 2025-10-04T12:04:21.940Z 2025-10-11T12:37:46.473Z
8045079 8045079 20251002083310_qQcdp US001N 2025-10-04T12:03:13.254Z 2025-10-11T12:37:29.104Z
8044980 8044980 20251002082447_7dYHA US001N 2025-10-04T12:02:42.026Z 2025-10-11T12:37:14.203Z
7998744 7998744 20250929085354_a5Yr6 US001N 2025-09-30T12:04:54.619Z 2025-10-08T12:41:24.803Z
7976284 7976284 20250927090219_wFgCq US001N 2025-09-28T12:04:23.993Z 2025-10-05T13:04:34.357Z
7913056 7913056 20250922090018_yWI7L US001N 2025-09-24T12:12:33.229Z 2025-10-01T13:22:04.002Z
7907083 7907083 20250921015326_hHYeJ US001N 2025-09-22T12:37:38.498Z 2025-09-29T13:05:38.199Z
7899025 7899025 20250921083259_hJ3uG US001N 2025-09-22T12:08:09.621Z 2025-09-30T13:01:39.515Z
7899019 7899019 20250921080555_X74dL US001N 2025-09-22T12:08:05.481Z 2025-09-30T13:01:38.103Z
7899003 7899003 20250921075001_YgXSg US001N 2025-09-22T12:08:01.845Z 2025-09-30T13:01:37.162Z
7871861 7871861 20250918001518_utroD US001N 2025-09-19T12:32:21.983Z 2025-09-25T13:13:16.351Z
7831039 7831039 20250915003623_cXVLI US001N 2025-09-16T12:03:48.647Z 2025-09-22T13:02:03.501Z
7819585 7819585 20250913003235_h62vA US001N 2025-09-14T12:05:06.296Z 2025-09-21T13:08:17.344Z
7814184 7814184 20250912071044_M1gXo US001N 2025-09-13T12:18:13.476Z 2025-09-20T13:02:18.263Z
7796933 7796933 20250909074532_ptQBC US001N 2025-09-10T12:11:27.318Z 2025-09-17T12:56:58.409Z
7791819 7791819 20250908080415_uYgqw US001N 2025-09-09T12:11:15.287Z 2025-09-16T12:51:29.990Z
7765214 7765214 20250904090912_il95n US001N 2025-09-05T12:25:30.831Z 2025-09-12T12:52:07.687Z
7716786 7716786 20250831042522_rv8Mp US001N 2025-09-01T12:23:29.264Z 2025-09-08T12:53:15.033Z
7715673 7715673 20250831030133_Netab US001N 2025-09-01T12:21:23.709Z 2025-09-08T12:52:54.372Z
7696455 7696455 20250829040909_xZmee US001N 2025-08-30T12:28:51.340Z 2025-09-06T14:13:20.216Z
7696219 7696219 20250829031240_SDDK6 US001N 2025-08-30T12:28:16.504Z 2025-09-06T14:13:15.754Z
7695435 7695435 20250829010849_SUTRQ US001N 2025-08-30T12:26:12.265Z 2025-09-06T14:13:02.616Z
7675304 7675304 20250827064321_6qvwJ US001N 2025-08-28T12:27:36.054Z 2025-09-04T12:56:56.283Z
7675276 7675276 20250827063104_2Q8RM US001N 2025-08-28T12:27:34.569Z 2025-09-04T12:56:55.667Z
7672605 7672605 20250827004019_iSJpp US001N 2025-08-28T12:22:44.277Z 2025-09-04T12:56:18.590Z
7663721 7663721 20250826053117_Rw3vp US001N 2025-08-27T12:31:12.732Z 2025-09-03T12:53:07.523Z
7638274 7638274 20250824043817_Ct39w US001N 2025-08-25T12:31:05.392Z 2025-09-01T12:56:13.010Z
7638267 7638267 20250824042919_Lc4D2 US001N 2025-08-25T12:31:04.867Z 2025-09-01T12:56:12.995Z
7627145 7627145 20250824075113_AwuWY US001N 2025-08-25T12:00:54.155Z 2025-09-02T12:50:42.599Z
7627085 7627085 20250824072111_3e1QS US001N 2025-08-25T12:00:41.649Z 2025-09-02T12:50:41.135Z
7626580 7626580 20250823044316_2ekhv US001N 2025-08-24T12:27:32.338Z 2025-08-31T12:54:21.595Z
7615384 7615384 20250823064315_fn3Ae US001N 2025-08-24T12:00:59.100Z 2025-09-01T12:55:20.013Z
7615368 7615368 20250823063802_ja4bz US001N 2025-08-24T12:00:55.233Z 2025-09-01T12:55:18.161Z
7604707 7604707 20250822085015_lSiCG US001N 2025-08-23T12:03:16.585Z 2025-08-31T12:53:13.621Z
7604263 7604263 20250822063341_Yrjp9 US001N 2025-08-23T12:01:12.170Z 2025-08-31T12:53:05.443Z
7532898 7532898 20250816021835_CdncK US001N 2025-08-18T12:11:08.722Z 2025-08-24T12:47:43.473Z
7521725 7521725 20250815080659_GZkxM US001N 2025-08-17T12:21:51.779Z 2025-08-23T12:49:02.753Z
7521712 7521712 20250815075045_K6vV0 US001N 2025-08-17T12:21:50.993Z 2025-08-23T12:49:02.109Z
7521661 7521661 20250815070939_sb6EQ US001N 2025-08-17T12:21:47.462Z 2025-08-23T12:48:57.752Z
7521584 7521584 20250815053332_YKEZY US001N 2025-08-17T12:21:39.477Z 2025-08-23T12:48:51.888Z
7519213 7519213 20250815015657_RRbkO US001N 2025-08-17T12:17:30.968Z 2025-08-23T12:48:41.494Z
7486288 7486288 20250813015344_Y371w US001N 2025-08-15T12:30:38.044Z 2025-08-21T12:47:40.064Z
7486074 7486074 20250813014629_c46nW US001N 2025-08-15T12:29:56.954Z 2025-08-21T12:47:39.479Z
7366152 7366152 20250804054642_3Gmvi US001N 2025-08-06T12:15:26.515Z 2025-08-12T12:57:03.521Z
7352875 7352875 20250803083839_RfHsG US001N 2025-08-05T12:21:39.259Z 2025-08-11T12:54:33.679Z
7333879 7333879 20250802073805_XWza8 US001N 2025-08-04T12:28:32.856Z 2025-08-10T13:01:07.828Z
7333611 7333611 20250802070933_xdPfe US001N 2025-08-04T12:28:01.781Z 2025-08-10T13:00:56.175Z
7333385 7333385 20250802064110_5Z09O US001N 2025-08-04T12:27:48.102Z 2025-08-10T13:00:53.544Z
7293720 7293720 20250731044630_cOV88 US001N 2025-08-02T12:21:18.525Z 2025-08-08T12:56:33.482Z

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