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

682 rows where station_code = "NL001B" 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
9267392 9267392 20260127001859_Qzi7L NL001B 2026-01-28T14:21:30.969Z 2026-01-29T14:34:56.959Z
9260458 9260458 20260125043616_vGbgi NL001B 2026-01-26T14:21:52.941Z 2026-01-29T14:44:16.108Z
9260369 9260369 20260125040104_Kr1hx NL001B 2026-01-26T14:21:25.799Z 2026-01-29T14:44:08.568Z
9260357 9260357 20260125035451_0q0h8 NL001B 2026-01-26T14:21:23.266Z 2026-01-29T14:44:07.711Z
9259247 9259247 20260124195850_GSg2A NL001B 2026-01-26T14:16:20.170Z 2026-01-29T14:42:44.467Z
9249659 9249659 20260122061351_aqzTX NL001B 2026-01-23T14:15:51.141Z 2026-01-29T14:58:48.255Z
9249584 9249584 20260122055856_sA1yr NL001B 2026-01-23T14:15:45.410Z 2026-01-29T14:58:45.902Z
9248949 9248949 20260122025335_RdoGu NL001B 2026-01-23T14:14:09.403Z 2026-01-29T14:57:55.928Z
9248809 9248809 20260122021518_tJE7l NL001B 2026-01-23T14:13:53.375Z 2026-01-29T14:57:47.324Z
9248500 9248500 20260122001525_DR2kK NL001B 2026-01-23T14:12:56.262Z 2026-01-29T14:57:23.814Z
9248107 9248107 20260121213445_3Ikfw NL001B 2026-01-23T14:11:57.147Z 2026-01-29T14:56:54.915Z
9237700 9237700 20260120055126_ZpJ7O NL001B 2026-01-21T14:27:26.314Z 2026-01-28T15:01:36.798Z
9237330 9237330 20260120050417_4ZPCo NL001B 2026-01-21T14:25:59.208Z 2026-01-28T15:01:20.107Z
9236883 9236883 20260120041332_2NjL7 NL001B 2026-01-21T14:24:25.564Z 2026-01-28T15:00:40.581Z
9235345 9235345 20260120005844_aWFzF NL001B 2026-01-21T14:18:39.087Z 2026-01-28T14:58:50.244Z
9224638 9224638 20260118052545_p41h8 NL001B 2026-01-19T14:25:15.952Z 2026-01-26T15:03:43.301Z
9224542 9224542 20260118050958_1Acd6 NL001B 2026-01-19T14:24:48.549Z 2026-01-26T15:03:23.092Z
9224486 9224486 20260118045930_A3IN3 NL001B 2026-01-19T14:24:37.218Z 2026-01-26T15:03:20.883Z
9223961 9223961 20260118030117_cMoqX NL001B 2026-01-19T14:22:05.002Z 2026-01-26T15:02:46.045Z
9223893 9223893 20260118024359_5V48m NL001B 2026-01-19T14:21:43.684Z 2026-01-26T15:02:40.399Z
9223815 9223815 20260118022544_g7SQw NL001B 2026-01-19T14:21:15.667Z 2026-01-26T15:02:36.964Z
9223436 9223436 20260118003951_3PhQT NL001B 2026-01-19T14:19:19.671Z 2026-01-26T15:02:06.674Z
9223183 9223183 20260117233807_eOnDV NL001B 2026-01-19T14:18:05.012Z 2026-01-26T15:01:57.003Z
9222424 9222424 20260117193016_8ag73 NL001B 2026-01-19T14:14:42.321Z 2026-01-26T15:00:53.128Z
9203830 9203830 20260114054131_Cbnqr NL001B 2026-01-15T14:25:38.144Z 2026-01-22T15:10:13.992Z
9182644 9182644 20260111060020_8jYhm NL001B 2026-01-12T14:15:16.451Z 2026-01-19T15:18:53.255Z
9182142 9182142 20260111042913_tg7eq NL001B 2026-01-12T14:13:27.057Z 2026-01-19T15:18:17.258Z
9181765 9181765 20260111030418_XPnXP NL001B 2026-01-12T14:12:04.600Z 2026-01-19T15:17:47.724Z
9181140 9181140 20260111003250_DtTSO NL001B 2026-01-12T14:09:41.940Z 2026-01-19T15:17:05.063Z
9159000 9159000 20260106012219_Oklbc NL001B 2026-01-07T14:07:57.584Z 2026-01-13T15:07:56.700Z
9154817 9154817 20260104051618_4BTNf NL001B 2026-01-06T14:36:13.907Z 2026-01-12T15:10:20.871Z
9154815 9154815 20260104051618_jy2jS NL001B 2026-01-06T14:36:13.527Z 2026-01-12T15:10:20.722Z
9144238 9144238 20260104023828_qxvce NL001B 2026-01-05T14:18:51.395Z 2026-01-05T14:30:33.897Z
9124106 9124106 20251231044907_o2pid NL001B 2026-01-02T14:41:07.991Z 2026-01-08T15:10:26.570Z
9116632 9116632 20251231062846_Juoqk NL001B 2026-01-01T14:28:31.055Z 2026-01-08T15:11:57.164Z
9114452 9114452 20251231041751_D0wcF NL001B 2026-01-01T14:22:33.443Z 2026-01-08T15:09:48.840Z
9112931 9112931 20251231030010_4P32Y NL001B 2026-01-01T14:16:49.291Z 2026-01-08T15:08:14.184Z
9110388 9110388 20251230225757_UY1jO NL001B 2026-01-01T14:07:00.964Z 2026-01-08T15:05:20.595Z
9110060 9110060 20251230221121_sf2Ce NL001B 2026-01-01T14:05:35.975Z 2026-01-08T15:04:56.750Z
9103173 9103173 20251230040345_loSWZ NL001B 2025-12-31T14:16:48.448Z 2026-01-07T15:08:30.308Z
9103144 9103144 20251230040104_CXVfw NL001B 2025-12-31T14:16:42.114Z 2026-01-07T15:08:20.963Z
9102056 9102056 20251230022024_f32tK NL001B 2025-12-31T14:11:54.407Z 2026-01-07T15:07:09.535Z
9073961 9073961 20251225185332_3L0vD NL001B 2025-12-29T15:00:00.238Z 2025-12-29T15:00:00.238Z
9073871 9073871 20251225183754_wp7eT NL001B 2025-12-29T14:59:56.258Z 2026-01-02T15:47:59.636Z
9073800 9073800 20251225182910_PzRK2 NL001B 2025-12-29T14:59:53.857Z 2026-01-02T15:47:58.181Z
9073366 9073366 20251225173413_7kksa NL001B 2025-12-29T14:59:14.286Z 2026-01-02T15:47:49.967Z
9071298 9071298 20251226182015_KJ2XF NL001B 2025-12-29T14:49:07.108Z 2026-01-03T15:42:46.421Z
9065665 9065665 20251226052334_QKSOW NL001B 2025-12-29T14:38:57.349Z 2026-01-03T15:37:03.774Z
9065000 9065000 20251226044719_m8qzb NL001B 2025-12-29T14:37:53.506Z 2026-01-03T15:36:34.101Z
9064899 9064899 20251226044106_iB3y0 NL001B 2025-12-29T14:37:45.628Z 2026-01-03T15:36:30.210Z
9064199 9064199 20251226035402_dF9bJ NL001B 2025-12-29T14:36:33.951Z 2026-01-03T15:35:52.582Z
9064148 9064148 20251226035202_5XKis NL001B 2025-12-29T14:36:30.088Z 2026-01-03T15:35:51.167Z
9063328 9063328 20251226030544_t2zsG NL001B 2025-12-29T14:35:01.060Z 2026-01-03T15:35:12.460Z
9063176 9063176 20251226025903_sJ14X NL001B 2025-12-29T14:34:47.186Z 2026-01-03T15:35:06.443Z
9061526 9061526 20251226010814_zh9IU NL001B 2025-12-29T14:31:32.788Z 2026-01-03T15:33:41.706Z
9060787 9060787 20251226001131_Zqf9X NL001B 2025-12-29T14:30:08.442Z 2026-01-03T15:33:08.578Z
9059880 9059880 20251225230605_IW3RU NL001B 2025-12-29T14:28:19.250Z 2026-01-03T15:32:23.425Z
9059594 9059594 20251225223610_ZTKyI NL001B 2025-12-29T14:27:30.198Z 2026-01-03T15:32:05.569Z
9053472 9053472 20251227014332_3qzwj NL001B 2025-12-29T14:12:37.448Z 2026-01-04T15:26:19.254Z
9052473 9052473 20251227005422_usjdI NL001B 2025-12-29T14:10:06.213Z 2025-12-30T14:58:29.614Z
9051834 9051834 20251227001318_7ua8t NL001B 2025-12-29T14:08:05.235Z 2026-01-04T15:24:53.951Z
9051622 9051622 20251226235722_4l6on NL001B 2025-12-29T14:07:18.663Z 2026-01-04T15:24:44.033Z
9051283 9051283 20251226233417_wM3dk NL001B 2025-12-29T14:06:23.204Z 2026-01-04T15:24:24.122Z
9042787 9042787 20251224190401_Z69M7 NL001B 2025-12-28T14:46:15.196Z 2026-01-01T15:57:10.336Z
9042362 9042362 20251224175526_aJxJj NL001B 2025-12-28T14:45:25.495Z 2026-01-01T15:56:39.217Z
9037100 9037100 20251224060213_UCpN7 NL001B 2025-12-28T14:36:31.810Z 2026-01-01T15:54:43.964Z
9036259 9036259 20251224033818_rT30I NL001B 2025-12-28T14:34:41.452Z 2025-12-28T14:48:34.890Z
9036055 9036055 20251224022602_2m2E3 NL001B 2025-12-28T14:34:04.788Z 2026-01-01T15:54:02.810Z
9036020 9036020 20251224021454_lwEgn NL001B 2025-12-28T14:34:01.109Z 2026-01-01T15:54:02.443Z
9035917 9035917 20251224013406_YpkgH NL001B 2025-12-28T14:33:35.894Z 2026-01-01T15:53:59.224Z
9035811 9035811 20251224005028_DvS0O NL001B 2025-12-28T14:33:22.509Z 2026-01-01T15:53:57.580Z
9035773 9035773 20251224002532_a2JGk NL001B 2025-12-28T14:33:09.571Z 2026-01-01T15:53:57.092Z
9035704 9035704 20251223235739_yOj22 NL001B 2025-12-28T14:33:02.430Z 2026-01-01T15:53:56.224Z
9035684 9035684 20251223234414_33Lnq NL001B 2025-12-28T14:32:59.629Z 2026-01-01T15:53:55.887Z
9032497 9032497 20251225062928_vrxy7 NL001B 2025-12-28T14:22:55.392Z 2026-01-02T15:45:44.678Z
9032459 9032459 20251225062530_OiK3f NL001B 2025-12-28T14:22:49.202Z 2026-01-02T15:45:43.888Z
9031906 9031906 20251225055123_p5juJ NL001B 2025-12-28T14:21:46.442Z 2026-01-02T15:45:36.438Z
9029817 9029817 20251225041712_rUdx0 NL001B 2025-12-28T14:17:21.096Z 2026-01-02T15:44:32.907Z
9028485 9028485 20251225030628_dCj3e NL001B 2025-12-28T14:14:05.195Z 2026-01-02T15:44:05.934Z
9028022 9028022 20251225024447_rcAak NL001B 2025-12-28T14:12:45.543Z 2026-01-02T15:43:42.059Z
9027327 9027327 20251225021200_8ZGyz NL001B 2025-12-28T14:10:51.757Z 2026-01-02T15:43:31.462Z
9026192 9026192 20251225005125_P8Wgl NL001B 2025-12-28T14:07:04.011Z 2026-01-02T15:42:51.018Z
9025782 9025782 20251225002644_ZieG3 NL001B 2025-12-28T14:05:41.840Z 2026-01-02T15:42:29.471Z
9025484 9025484 20251225000248_B32HJ NL001B 2025-12-28T14:04:45.232Z 2026-01-02T15:42:20.042Z
9025399 9025399 20251224235642_RRt5w NL001B 2025-12-28T14:04:25.276Z 2026-01-02T15:42:17.281Z
9025129 9025129 20251224233540_sW20j NL001B 2025-12-28T14:03:30.235Z 2026-01-02T15:42:11.453Z
9015808 9015808 20251221233026_Hk6KJ NL001B 2025-12-27T14:55:14.979Z 2025-12-27T14:55:14.979Z
8998111 8998111 20251222051631_iE0kl NL001B 2025-12-27T14:12:29.224Z 2025-12-30T15:46:43.571Z
8997491 8997491 20251222042439_tWDa9 NL001B 2025-12-27T14:09:59.160Z 2025-12-30T15:46:37.318Z
8996918 8996918 20251222031729_NBjza NL001B 2025-12-27T14:07:11.575Z 2025-12-30T15:46:30.919Z
8996208 8996208 20251222014044_erPhQ NL001B 2025-12-27T14:03:37.696Z 2025-12-30T15:45:45.375Z
8995805 8995805 20251222002823_n0Rqs NL001B 2025-12-27T14:01:35.892Z 2025-12-28T14:57:24.855Z
8995662 8995662 20251221234347_jW1RL NL001B 2025-12-27T14:00:39.346Z 2025-12-30T15:45:37.293Z
8984853 8984853 20251220000551_cb22h NL001B 2025-12-26T14:31:26.665Z 2025-12-28T15:23:55.539Z
8983667 8983667 20251219222003_sqC6K NL001B 2025-12-26T14:29:31.638Z 2025-12-28T15:23:42.762Z
8983523 8983523 20251219220236_hJdKF NL001B 2025-12-26T14:29:13.246Z 2025-12-28T15:23:40.642Z
8982560 8982560 20251219195714_wCmMw NL001B 2025-12-26T14:27:13.386Z 2025-12-28T15:22:11.792Z
8982456 8982456 20251219194436_nbgdX NL001B 2025-12-26T14:27:02.092Z 2025-12-28T15:22:09.576Z
8974126 8974126 20251220020601_QVrIQ NL001B 2025-12-26T14:03:50.863Z 2025-12-29T15:22:39.106Z
8974109 8974109 20251220020327_1P0LX NL001B 2025-12-26T14:03:48.036Z 2025-12-29T15:22:38.961Z

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