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

4,953 rows where station_code = "NL000U" 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
9259678 9259678 20260124230719_TU7zf NL000U 2026-01-26T14:18:04.344Z 2026-01-29T14:43:12.666Z
9251711 9251711 20260122221045_Q1xCM NL000U 2026-01-24T14:12:59.290Z 2026-01-29T14:52:02.998Z
9249527 9249527 20260122053807_pXdpi NL000U 2026-01-23T14:15:39.184Z 2026-01-29T14:58:43.326Z
9249504 9249504 20260122053218_KuYAx NL000U 2026-01-23T14:15:36.267Z 2026-01-29T14:58:41.968Z
9249462 9249462 20260122052642_Ua8l0 NL000U 2026-01-23T14:15:27.752Z 2026-01-29T14:58:40.657Z
9249436 9249436 20260122051847_tUAPn NL000U 2026-01-23T14:15:25.892Z 2026-01-29T14:58:37.113Z
9249184 9249184 20260122040146_RQRpe NL000U 2026-01-23T14:14:44.542Z 2026-01-29T14:58:15.850Z
9249123 9249123 20260122034355_aubx7 NL000U 2026-01-23T14:14:38.676Z 2026-01-29T14:58:13.839Z
9248847 9248847 20260122022633_nKehQ NL000U 2026-01-23T14:13:58.526Z 2026-01-29T14:57:49.457Z
9248807 9248807 20260122021518_tJE7l NL000U 2026-01-23T14:13:53.375Z 2026-01-29T14:57:47.324Z
9248642 9248642 20260122012604_WeCIL NL000U 2026-01-23T14:13:20.092Z 2026-01-29T14:57:38.187Z
9248512 9248512 20260122002430_t5tML NL000U 2026-01-23T14:12:57.596Z 2026-01-29T14:57:24.404Z
9248485 9248485 20260122001000_wEWNd NL000U 2026-01-23T14:12:54.125Z 2026-01-29T14:57:23.079Z
9248220 9248220 20260121222134_6NOow NL000U 2026-01-23T14:12:15.438Z 2026-01-29T14:57:08.997Z
9248120 9248120 20260121213828_Pi732 NL000U 2026-01-23T14:11:59.085Z 2026-01-29T14:56:55.640Z
9237588 9237588 20260120054030_6sndg NL000U 2026-01-21T14:27:04.792Z 2026-01-28T15:01:32.185Z
9237431 9237431 20260120051746_zQfEe NL000U 2026-01-21T14:26:29.754Z 2026-01-28T15:01:25.391Z
9237218 9237218 20260120045202_PDVA2 NL000U 2026-01-21T14:25:42.818Z 2026-01-28T15:01:03.551Z
9236707 9236707 20260120035014_3OGq4 NL000U 2026-01-21T14:23:44.405Z 2026-01-28T15:00:31.357Z
9236610 9236610 20260120034023_TpHgw NL000U 2026-01-21T14:23:31.870Z 2026-01-28T15:00:24.757Z
9236213 9236213 20260120024734_giZ3w NL000U 2026-01-21T14:21:58.556Z 2026-01-28T14:59:50.268Z
9236139 9236139 20260120023929_DyYnq NL000U 2026-01-21T14:21:36.112Z 2026-01-28T14:59:46.640Z
9235940 9235940 20260120022022_XH3Qz NL000U 2026-01-21T14:20:50.867Z 2026-01-28T14:59:29.662Z
9235922 9235922 20260120021759_tdiye NL000U 2026-01-21T14:20:45.737Z 2026-01-28T14:59:29.101Z
9235704 9235704 20260120015059_4lKy4 NL000U 2026-01-21T14:20:01.382Z 2026-01-28T14:59:16.670Z
9235597 9235597 20260120013748_lohp3 NL000U 2026-01-21T14:19:33.376Z 2026-01-28T14:59:11.544Z
9235442 9235442 20260120011405_3V1i8 NL000U 2026-01-21T14:18:54.595Z 2026-01-28T14:58:55.401Z
9235306 9235306 20260120005254_qQGsG NL000U 2026-01-21T14:18:26.039Z 2026-01-28T14:58:48.577Z
9234752 9234752 20260119231456_dQijU NL000U 2026-01-21T14:15:58.809Z 2026-01-28T14:58:04.354Z
9234606 9234606 20260119223509_Yuwef NL000U 2026-01-21T14:15:26.103Z 2026-01-28T14:57:56.245Z
9231032 9231032 20260119054654_58ccm NL000U 2026-01-20T14:30:58.599Z 2026-01-27T15:05:54.016Z
9230906 9230906 20260119052859_Q36D6 NL000U 2026-01-20T14:30:20.153Z 2026-01-27T15:05:35.888Z
9230782 9230782 20260119050819_QVfeM NL000U 2026-01-20T14:29:44.178Z 2026-01-27T15:05:26.260Z
9230042 9230042 20260119031522_352Vr NL000U 2026-01-20T14:25:36.840Z 2026-01-27T15:04:22.023Z
9230030 9230030 20260119031248_IGXFd NL000U 2026-01-20T14:25:31.815Z 2026-01-27T15:04:21.161Z
9223942 9223942 20260118025715_092mm NL000U 2026-01-19T14:21:56.532Z 2026-01-26T15:02:42.442Z
9223883 9223883 20260118024146_sUapK NL000U 2026-01-19T14:21:41.293Z 2026-01-26T15:02:39.974Z
9223728 9223728 20260118021317_5ceD4 NL000U 2026-01-19T14:20:46.836Z 2026-01-26T15:02:33.939Z
9223666 9223666 20260118015924_inFHS NL000U 2026-01-19T14:20:34.265Z 2026-01-26T15:02:31.490Z
9223529 9223529 20260118011208_q4C3Y NL000U 2026-01-19T14:19:45.210Z 2026-01-26T15:02:13.188Z
9223493 9223493 20260118005738_8PkPX NL000U 2026-01-19T14:19:33.821Z 2026-01-26T15:02:10.892Z
9223333 9223333 20260118001616_3nss5 NL000U 2026-01-19T14:18:47.843Z 2026-01-26T15:02:02.557Z
9222992 9222992 20260117220556_WDDnI NL000U 2026-01-19T14:17:14.009Z 2026-01-26T15:01:31.185Z
9222982 9222982 20260117215829_yGbcw NL000U 2026-01-19T14:17:11.508Z 2026-01-26T15:01:30.917Z
9222562 9222562 20260117195600_4PSI1 NL000U 2026-01-19T14:15:16.866Z 2026-01-26T15:01:13.573Z
9222423 9222423 20260117193016_8ag73 NL000U 2026-01-19T14:14:42.308Z 2026-01-26T15:00:53.128Z
9204018 9204018 20260114060337_Buh3O NL000U 2026-01-15T14:26:16.479Z 2026-01-22T15:10:17.029Z
9182704 9182704 20260111061514_iZZ5H NL000U 2026-01-12T14:15:27.856Z 2026-01-19T15:18:55.946Z
9182652 9182652 20260111060110_dmmLA NL000U 2026-01-12T14:15:19.884Z 2026-01-19T15:18:53.894Z
9182643 9182643 20260111060020_8jYhm NL000U 2026-01-12T14:15:16.451Z 2026-01-19T15:18:53.255Z
9182498 9182498 20260111053238_RWfQ7 NL000U 2026-01-12T14:14:45.930Z 2026-01-19T15:18:44.612Z
9182401 9182401 20260111052108_thmCb NL000U 2026-01-12T14:14:28.129Z 2026-01-19T15:18:30.999Z
9181621 9181621 20260111022740_RYJfs NL000U 2026-01-12T14:11:30.414Z 2026-01-19T15:17:40.741Z
9181535 9181535 20260111020500_7fuuD NL000U 2026-01-12T14:11:08.975Z 2026-01-19T15:17:23.428Z
9181467 9181467 20260111015350_jcprU NL000U 2026-01-12T14:10:53.639Z 2026-01-19T15:17:20.708Z
9181272 9181272 20260111011231_nPHO0 NL000U 2026-01-12T14:10:12.486Z 2026-01-19T15:17:10.580Z
9180974 9180974 20260110233759_amw8g NL000U 2026-01-12T14:09:06.928Z 2026-01-19T15:16:42.631Z
9180930 9180930 20260110232900_KFmSh NL000U 2026-01-12T14:08:57.641Z 2026-01-19T15:16:39.330Z
9180916 9180916 20260110232338_gEDQT NL000U 2026-01-12T14:08:52.778Z 2026-01-19T15:16:38.765Z
9162173 9162173 20260106235707_aCxNx NL000U 2026-01-08T14:03:20.133Z 2026-01-13T15:01:42.083Z
9124317 9124317 20251231055715_GRug7 NL000U 2026-01-02T14:44:31.812Z 2026-01-08T15:11:38.567Z
9124278 9124278 20251231054737_pz0CM NL000U 2026-01-02T14:44:07.057Z 2026-01-08T15:11:25.756Z
9124231 9124231 20251231053006_g0Lz2 NL000U 2026-01-02T14:43:19.104Z 2026-01-08T15:11:13.145Z
9124228 9124228 20251231053006_qld68 NL000U 2026-01-02T14:43:18.345Z 2026-01-08T15:11:12.996Z
9123940 9123940 20251231041329_rbnhz NL000U 2026-01-02T14:38:46.946Z 2026-01-08T15:09:43.449Z
9123921 9123921 20251231040446_3bNHl NL000U 2026-01-02T14:38:16.908Z 2026-01-08T15:09:28.869Z
9116351 9116351 20251231060520_aP2Um NL000U 2026-01-01T14:27:50.500Z 2026-01-08T15:11:44.806Z
9116199 9116199 20251231055714_T9RbE NL000U 2026-01-01T14:27:28.863Z 2026-01-08T15:11:38.449Z
9116057 9116057 20251231054737_dzDSK NL000U 2026-01-01T14:27:14.259Z 2026-01-01T14:57:54.633Z
9115813 9115813 20251231053006_GgFOf NL000U 2026-01-01T14:26:35.428Z 2026-01-08T15:11:13.066Z
9115621 9115621 20251231051910_yK39Y NL000U 2026-01-01T14:25:56.752Z 2026-01-08T15:10:57.589Z
9114353 9114353 20251231041329_QCqEF NL000U 2026-01-01T14:22:16.796Z 2026-01-08T15:09:43.561Z
9114187 9114187 20251231040445_kn9JQ NL000U 2026-01-01T14:21:45.317Z 2026-01-08T15:09:28.679Z
9111896 9111896 20251231015121_LGKrr NL000U 2026-01-01T14:13:12.859Z 2026-01-08T15:07:08.701Z
9099983 9099983 20251224203458_E1y6g NL000U 2025-12-30T15:43:11.325Z 2026-01-01T15:57:19.276Z
9099977 9099977 20251224200041_GmnXP NL000U 2025-12-30T15:43:05.489Z 2026-01-01T15:57:16.618Z
9099770 9099770 20251225062928_4c8Et NL000U 2025-12-30T15:31:51.016Z 2026-01-02T15:45:44.762Z
9099766 9099766 20251225061158_ri9H6 NL000U 2025-12-30T15:31:19.560Z 2026-01-02T15:45:41.108Z
9099752 9099752 20251225060102_XoGHt NL000U 2025-12-30T15:31:13.689Z 2026-01-02T15:45:38.833Z
9099727 9099727 20251225053807_2W1Od NL000U 2025-12-30T15:31:01.161Z 2026-01-02T15:45:32.466Z
9099723 9099723 20251225053308_u0nif NL000U 2025-12-30T15:30:58.519Z 2026-01-02T15:45:30.956Z
9099696 9099696 20251225052038_vWlk1 NL000U 2025-12-30T15:30:24.669Z 2026-01-02T15:45:07.227Z
9099609 9099609 20251225033740_bmzU3 NL000U 2025-12-30T15:28:46.845Z 2026-01-02T15:44:17.181Z
9099600 9099600 20251225032728_yUeAP NL000U 2025-12-30T15:28:15.351Z 2026-01-02T15:44:14.327Z
9099509 9099509 20251225015010_LRouS NL000U 2025-12-30T15:26:15.106Z 2026-01-02T15:43:08.463Z
9099484 9099484 20251225012731_XWtUw NL000U 2025-12-30T15:26:02.772Z 2026-01-02T15:43:00.333Z
9099463 9099463 20251225003842_1YIVK NL000U 2025-12-30T15:25:13.287Z 2026-01-02T15:42:46.226Z
9099447 9099447 20251224235531_FI9DD NL000U 2025-12-30T15:24:56.670Z 2026-01-02T15:42:16.839Z
9099443 9099443 20251224235521_6cAIn NL000U 2025-12-30T15:24:56.410Z 2026-01-02T15:42:16.719Z
9099395 9099395 20251224225559_fd0Xn NL000U 2025-12-30T15:24:09.918Z 2026-01-02T15:42:04.170Z
9092261 9092261 20251226235659_tf28w NL000U 2025-12-30T14:57:48.580Z 2026-01-04T15:24:43.782Z
9086818 9086818 20251228054140_qEhx5 NL000U 2025-12-30T14:42:09.385Z 2025-12-31T14:52:36.442Z
9086765 9086765 20251228053534_ZutQT NL000U 2025-12-30T14:42:02.306Z 2026-01-05T15:10:31.122Z
9086622 9086622 20251228051837_nWhQc NL000U 2025-12-30T14:41:38.027Z 2026-01-05T15:10:24.830Z
9086495 9086495 20251228050609_ERZUB NL000U 2025-12-30T14:41:14.617Z 2026-01-05T15:10:20.242Z
9086199 9086199 20251228043551_UN0yp NL000U 2025-12-30T14:40:29.824Z 2026-01-05T15:09:59.074Z
9085244 9085244 20251228030749_2RpQV NL000U 2025-12-30T14:38:01.916Z 2026-01-05T15:09:17.088Z
9085176 9085176 20251228030042_HrszS NL000U 2025-12-30T14:37:53.381Z 2025-12-31T14:50:59.532Z
9074568 9074568 20251225201249_cpdAT NL000U 2025-12-29T15:01:10.147Z 2026-01-02T15:48:33.800Z
9074533 9074533 20251225201041_h3brb NL000U 2025-12-29T15:01:07.269Z 2026-01-02T15:48:32.963Z

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