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

5,127 rows where station_code = "NL000Q" 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
9267435 9267435 20260127005847_8PgsE NL000Q 2026-01-28T14:21:40.557Z 2026-01-29T14:35:00.495Z
9267391 9267391 20260127001859_Qzi7L NL000Q 2026-01-28T14:21:30.944Z 2026-01-29T14:34:56.959Z
9259890 9259890 20260125010313_jyVbx NL000Q 2026-01-26T14:19:12.087Z 2026-01-29T14:43:33.669Z
9256448 9256448 20260122042140_4b6dZ NL000Q 2026-01-25T14:27:36.141Z 2026-01-29T14:58:19.164Z
9254934 9254934 20260123231815_o37cV NL000Q 2026-01-25T14:11:21.911Z 2026-01-29T14:46:56.094Z
9249555 9249555 20260122054827_fO1dl NL000Q 2026-01-23T14:15:42.078Z 2026-01-29T14:58:44.486Z
9249469 9249469 20260122052653_vgaDn NL000Q 2026-01-23T14:15:28.211Z 2026-01-29T14:58:40.882Z
9249414 9249414 20260122051139_7Dauy NL000Q 2026-01-23T14:15:19.701Z 2026-01-29T14:58:29.462Z
9249346 9249346 20260122050221_2uYtC NL000Q 2026-01-23T14:15:12.807Z 2026-01-29T14:58:26.930Z
9249271 9249271 20260122043324_3xqfa NL000Q 2026-01-23T14:15:05.724Z 2026-01-29T14:58:21.072Z
9249241 9249241 20260122042140_oJZQs NL000Q 2026-01-23T14:15:02.495Z 2026-01-29T14:58:19.346Z
9249045 9249045 20260122032015_23ZHg NL000Q 2026-01-23T14:14:29.791Z 2026-01-29T14:58:10.607Z
9248649 9248649 20260122012920_XF3r6 NL000Q 2026-01-23T14:13:21.142Z 2026-01-29T14:57:38.597Z
9248509 9248509 20260122002339_jhiHX NL000Q 2026-01-23T14:12:57.094Z 2026-01-29T14:57:24.275Z
9248448 9248448 20260121234922_8yI9g NL000Q 2026-01-23T14:12:49.144Z 2026-01-29T14:57:19.396Z
9248269 9248269 20260121224322_mSktm NL000Q 2026-01-23T14:12:22.785Z 2026-01-29T14:57:11.136Z
9248231 9248231 20260121222452_4qTRz NL000Q 2026-01-23T14:12:16.392Z 2026-01-29T14:57:09.223Z
9241706 9241706 20260120214125_dme2A NL000Q 2026-01-22T14:14:12.886Z 2026-01-29T15:02:57.979Z
9237698 9237698 20260120055126_ZpJ7O NL000Q 2026-01-21T14:27:26.314Z 2026-01-28T15:01:36.798Z
9237347 9237347 20260120050606_0izva NL000Q 2026-01-21T14:26:03.249Z 2026-01-28T15:01:20.898Z
9236471 9236471 20260120032331_2skAG NL000Q 2026-01-21T14:22:55.553Z 2026-01-28T15:00:03.298Z
9236141 9236141 20260120023955_bhmDP NL000Q 2026-01-21T14:21:36.538Z 2026-01-28T14:59:46.894Z
9235759 9235759 20260120015654_skq4M NL000Q 2026-01-21T14:20:09.861Z 2026-01-28T14:59:19.397Z
9235542 9235542 20260120013041_GXAVN NL000Q 2026-01-21T14:19:21.533Z 2026-01-28T14:59:01.497Z
9224400 9224400 20260118043514_AgrzT NL000Q 2026-01-19T14:24:12.424Z 2026-01-26T15:03:17.259Z
9223959 9223959 20260118030117_cMoqX NL000Q 2026-01-19T14:22:05.002Z 2026-01-26T15:02:46.045Z
9223814 9223814 20260118022544_g7SQw NL000Q 2026-01-19T14:21:15.667Z 2026-01-26T15:02:36.964Z
9223434 9223434 20260118003951_3PhQT NL000Q 2026-01-19T14:19:19.671Z 2026-01-26T15:02:06.674Z
9223041 9223041 20260117223055_rBaxc NL000Q 2026-01-19T14:17:23.993Z 2026-01-26T15:01:33.087Z
9222974 9222974 20260117215701_qUMSb NL000Q 2026-01-19T14:17:08.238Z 2026-01-26T15:01:30.672Z
9182156 9182156 20260111043005_Fo1EY NL000Q 2026-01-12T14:13:30.142Z 2026-01-19T15:18:17.635Z
9182081 9182081 20260111041607_WZF0I NL000Q 2026-01-12T14:13:11.258Z 2026-01-19T15:18:14.832Z
9181488 9181488 20260111015612_SxVfi NL000Q 2026-01-12T14:10:56.973Z 2026-01-19T15:17:21.243Z
9181168 9181168 20260111004050_cf2w7 NL000Q 2026-01-12T14:09:49.379Z 2026-01-19T15:17:06.265Z
9181138 9181138 20260111003250_DtTSO NL000Q 2026-01-12T14:09:41.923Z 2026-01-19T15:17:05.063Z
9162116 9162116 20260106214143_r7DID NL000Q 2026-01-08T14:03:01.761Z 2026-01-13T15:01:37.092Z
9162086 9162086 20260106204214_adbbx NL000Q 2026-01-08T14:02:42.793Z 2026-01-13T15:01:34.354Z
9159819 9159819 20260106040049_l9tG8 NL000Q 2026-01-07T14:10:31.802Z 2026-01-13T15:08:48.887Z
9123436 9123436 20251231005031_MsyFN NL000Q 2026-01-02T14:27:41.280Z 2026-01-08T15:06:21.493Z
9119821 9119821 20251230190549_3zpA8 NL000Q 2026-01-01T14:57:22.429Z 2026-01-01T14:58:02.025Z
9116631 9116631 20251231062846_Juoqk NL000Q 2026-01-01T14:28:31.055Z 2026-01-08T15:11:57.164Z
9116346 9116346 20251231060516_NmuDI NL000Q 2026-01-01T14:27:49.814Z 2026-01-08T15:11:44.571Z
9116288 9116288 20251231060032_EYsgr NL000Q 2026-01-01T14:27:42.274Z 2026-01-08T15:11:41.496Z
9114863 9114863 20251231043340_BU4th NL000Q 2026-01-01T14:23:42.009Z 2026-01-08T15:10:11.883Z
9114449 9114449 20251231041751_D0wcF NL000Q 2026-01-01T14:22:33.443Z 2026-01-08T15:09:48.840Z
9113159 9113159 20251231031316_pU1k3 NL000Q 2026-01-01T14:17:45.432Z 2026-01-08T15:08:32.685Z
9112929 9112929 20251231030010_4P32Y NL000Q 2026-01-01T14:16:49.291Z 2026-01-08T15:08:14.184Z
9110387 9110387 20251230225757_UY1jO NL000Q 2026-01-01T14:07:00.964Z 2026-01-08T15:05:20.595Z
9110213 9110213 20251230223550_rQ2wH NL000Q 2026-01-01T14:06:21.399Z 2026-01-01T14:57:49.338Z
9110105 9110105 20251230222007_unvPX NL000Q 2026-01-01T14:05:53.028Z 2026-01-08T15:05:01.866Z
9109901 9109901 20251230211756_EbgHC NL000Q 2026-01-01T14:04:31.249Z 2026-01-08T15:04:44.592Z
9109676 9109676 20251230201640_Ukl9t NL000Q 2026-01-01T14:02:44.503Z 2026-01-01T14:57:48.391Z
9100016 9100016 20251224220554_M6Z9E NL000Q 2025-12-30T15:43:28.860Z 2026-01-01T15:57:28.754Z
9100010 9100010 20251224220418_bwUwO NL000Q 2025-12-30T15:43:27.435Z 2026-01-01T15:57:28.475Z
9099989 9099989 20251224211226_YTazZ NL000Q 2025-12-30T15:43:18.023Z 2026-01-01T15:57:22.220Z
9099768 9099768 20251225062928_4c8Et NL000Q 2025-12-30T15:31:51.016Z 2026-01-02T15:45:44.762Z
9099648 9099648 20251225042520_8lvqr NL000Q 2025-12-30T15:29:43.349Z 2026-01-02T15:44:48.908Z
9099643 9099643 20251225040813_211yz NL000Q 2025-12-30T15:29:01.451Z 2026-01-02T15:44:28.354Z
9099636 9099636 20251225040310_5UFPb NL000Q 2025-12-30T15:28:58.480Z 2026-01-02T15:44:26.545Z
9099505 9099505 20251225014621_yA7Y5 NL000Q 2025-12-30T15:26:12.553Z 2026-01-02T15:43:07.534Z
9099392 9099392 20251224224758_e5SXE NL000Q 2025-12-30T15:24:06.775Z 2026-01-02T15:42:02.239Z
9047865 9047865 20251223221247_PiLAz NL000Q 2025-12-28T14:57:15.447Z 2025-12-31T15:43:48.832Z
9047832 9047832 20251223213854_mSt2b NL000Q 2025-12-28T14:57:13.651Z 2025-12-31T15:43:48.405Z
9044092 9044092 20251224220553_HV4AU NL000Q 2025-12-28T14:48:22.259Z 2026-01-01T15:57:28.710Z
9044072 9044072 20251224220418_dQ2iH NL000Q 2025-12-28T14:48:21.521Z 2026-01-01T15:57:28.346Z
9043880 9043880 20251224213433_BzbbT NL000Q 2025-12-28T14:48:11.915Z 2026-01-01T15:57:24.072Z
9043787 9043787 20251224211938_o792E NL000Q 2025-12-28T14:48:07.371Z 2025-12-29T15:08:02.074Z
9043742 9043742 20251224211225_6fEo0 NL000Q 2025-12-28T14:47:48.314Z 2026-01-01T15:57:22.172Z
9043498 9043498 20251224203539_llIBD NL000Q 2025-12-28T14:47:33.928Z 2026-01-01T15:57:19.397Z
9042782 9042782 20251224190314_KmgVV NL000Q 2025-12-28T14:46:13.428Z 2026-01-01T15:57:10.301Z
9042440 9042440 20251224180505_enhmX NL000Q 2025-12-28T14:45:49.226Z 2026-01-01T15:56:44.255Z
9042406 9042406 20251224175911_MrMls NL000Q 2025-12-28T14:45:32.067Z 2026-01-01T15:56:39.789Z
9042359 9042359 20251224175526_aJxJj NL000Q 2025-12-28T14:45:25.494Z 2026-01-01T15:56:39.217Z
9042053 9042053 20251224165140_mKk27 NL000Q 2025-12-28T14:44:42.433Z 2025-12-29T15:07:04.389Z
9037173 9037173 20251224061315_YFJIM NL000Q 2025-12-28T14:36:44.396Z 2026-01-01T15:54:44.743Z
9037142 9037142 20251224061040_Mldiu NL000Q 2025-12-28T14:36:42.142Z 2026-01-01T15:54:44.451Z
9037116 9037116 20251224060557_B2sTv NL000Q 2025-12-28T14:36:39.935Z 2026-01-01T15:54:44.204Z
9037098 9037098 20251224060213_UCpN7 NL000Q 2025-12-28T14:36:31.810Z 2026-01-01T15:54:43.964Z
9036669 9036669 20251224050212_PBq1r NL000Q 2025-12-28T14:35:33.523Z 2026-01-01T15:54:38.423Z
9036550 9036550 20251224044737_Lhwlm NL000Q 2025-12-28T14:35:24.210Z 2025-12-28T14:48:35.053Z
9036468 9036468 20251224042943_oMsPH NL000Q 2025-12-28T14:35:01.942Z 2025-12-28T14:48:34.993Z
9036456 9036456 20251224042718_0I3xk NL000Q 2025-12-28T14:35:01.155Z 2026-01-01T15:54:35.703Z
9036315 9036315 20251224035629_U3L5j NL000Q 2025-12-28T14:34:47.375Z 2026-01-01T15:54:13.799Z
9036295 9036295 20251224034754_31uNc NL000Q 2025-12-28T14:34:45.297Z 2026-01-01T15:54:08.794Z
9036270 9036270 20251224033857_TsZpY NL000Q 2025-12-28T14:34:42.039Z 2026-01-01T15:54:05.818Z
9036216 9036216 20251224032533_M2KgY NL000Q 2025-12-28T14:34:24.761Z 2026-01-01T15:54:05.184Z
9036176 9036176 20251224031039_HKowI NL000Q 2025-12-28T14:34:19.211Z 2026-01-01T15:54:04.564Z
9036167 9036167 20251224030638_2Q7Bv NL000Q 2025-12-28T14:34:17.860Z 2026-01-01T15:54:04.448Z
9036096 9036096 20251224024040_ebHAM NL000Q 2025-12-28T14:34:09.144Z 2026-01-01T15:54:03.370Z
9036034 9036034 20251224021803_3lgFw NL000Q 2025-12-28T14:34:02.705Z 2026-01-01T15:54:02.596Z
9036017 9036017 20251224021454_lwEgn NL000Q 2025-12-28T14:34:01.109Z 2026-01-01T15:54:02.443Z
9036006 9036006 20251224020916_2b9Ky NL000Q 2025-12-28T14:33:58.825Z 2025-12-28T14:48:34.767Z
9035999 9035999 20251224020609_izMgH NL000Q 2025-12-28T14:33:48.579Z 2026-01-01T15:54:02.106Z
9035925 9035925 20251224014146_gh1ux NL000Q 2025-12-28T14:33:37.438Z 2025-12-28T14:48:34.736Z
9035895 9035895 20251224012346_z4Ie3 NL000Q 2025-12-28T14:33:33.741Z 2025-12-28T14:48:34.723Z
9035883 9035883 20251224012201_QqLTj NL000Q 2025-12-28T14:33:31.980Z 2026-01-01T15:53:58.701Z
9035874 9035874 20251224011908_tyH1r NL000Q 2025-12-28T14:33:31.220Z 2026-01-01T15:53:58.566Z
9035804 9035804 20251224004647_jSsDC NL000Q 2025-12-28T14:33:21.696Z 2026-01-01T15:53:57.443Z
9035794 9035794 20251224004111_THvFP NL000Q 2025-12-28T14:33:20.706Z 2026-01-01T15:53:57.414Z
9035779 9035779 20251224003319_EUhV4 NL000Q 2025-12-28T14:33:14.595Z 2025-12-28T14:48:34.655Z

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