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

2,326 rows where station_code = "NL0017" 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
9262642 9262642 20260125225315_ZLSVN NL0017 2026-01-27T14:14:33.370Z 2026-01-29T14:38:30.903Z
9262591 9262591 20260125204004_nZqt1 NL0017 2026-01-27T14:13:56.575Z 2026-01-29T14:38:23.059Z
9262577 9262577 20260125202403_xeDN2 NL0017 2026-01-27T14:13:45.099Z 2026-01-29T14:38:20.733Z
9260138 9260138 20260125024251_v3yZh NL0017 2026-01-26T14:20:23.546Z 2026-01-29T14:43:50.623Z
9260113 9260113 20260125023752_hQYXr NL0017 2026-01-26T14:20:18.760Z 2026-01-29T14:43:49.208Z
9260035 9260035 20260125021118_0SzvQ NL0017 2026-01-26T14:19:51.422Z 2026-01-29T14:43:42.683Z
9259904 9259904 20260125010823_h3psa NL0017 2026-01-26T14:19:14.527Z 2026-01-29T14:43:34.355Z
9259761 9259761 20260124235926_TUBoJ NL0017 2026-01-26T14:18:30.592Z 2026-01-29T14:43:17.819Z
9256456 9256456 20260119172841_agiq3 NL0017 2026-01-25T14:37:32.118Z 2026-01-28T14:56:28.669Z
9256166 9256166 20260124060541_uK3i3 NL0017 2026-01-25T14:16:05.510Z 2026-01-29T14:48:26.923Z
9249686 9249686 20260122062927_ZuDX3 NL0017 2026-01-23T14:15:54.237Z 2026-01-29T14:58:49.451Z
9249531 9249531 20260122053807_pXdpi NL0017 2026-01-23T14:15:39.184Z 2026-01-29T14:58:43.326Z
9249464 9249464 20260122052642_Ua8l0 NL0017 2026-01-23T14:15:27.752Z 2026-01-29T14:58:40.657Z
9249364 9249364 20260122050259_TBIjR NL0017 2026-01-23T14:15:13.869Z 2026-01-29T14:58:27.312Z
9249244 9249244 20260122042258_sAwli NL0017 2026-01-23T14:15:02.856Z 2026-01-29T14:58:19.545Z
9249189 9249189 20260122040200_336lu NL0017 2026-01-23T14:14:44.910Z 2026-01-29T14:58:15.989Z
9249185 9249185 20260122040146_RQRpe NL0017 2026-01-23T14:14:44.543Z 2026-01-29T14:58:15.850Z
9249174 9249174 20260122035558_IleiC NL0017 2026-01-23T14:14:42.918Z 2026-01-29T14:58:15.226Z
9249154 9249154 20260122034845_ENkWs NL0017 2026-01-23T14:14:40.616Z 2026-01-29T14:58:14.549Z
9249087 9249087 20260122033141_J5gi0 NL0017 2026-01-23T14:14:33.848Z 2026-01-29T14:58:12.229Z
9248948 9248948 20260122025335_RdoGu NL0017 2026-01-23T14:14:09.403Z 2026-01-29T14:57:55.928Z
9248808 9248808 20260122021518_tJE7l NL0017 2026-01-23T14:13:53.375Z 2026-01-29T14:57:47.324Z
9248514 9248514 20260122002430_t5tML NL0017 2026-01-23T14:12:57.596Z 2026-01-29T14:57:24.404Z
9248499 9248499 20260122001525_DR2kK NL0017 2026-01-23T14:12:56.262Z 2026-01-29T14:57:23.814Z
9248486 9248486 20260122001000_wEWNd NL0017 2026-01-23T14:12:54.125Z 2026-01-29T14:57:23.079Z
9248223 9248223 20260121222134_6NOow NL0017 2026-01-23T14:12:15.438Z 2026-01-29T14:57:08.997Z
9248106 9248106 20260121213445_3Ikfw NL0017 2026-01-23T14:11:57.147Z 2026-01-29T14:56:54.915Z
9248050 9248050 20260121211638_ulnmV NL0017 2026-01-23T14:11:47.647Z 2026-01-29T14:56:52.459Z
9248017 9248017 20260121211048_ETy31 NL0017 2026-01-23T14:11:43.574Z 2026-01-29T14:56:48.432Z
9247791 9247791 20260121194929_nY2p5 NL0017 2026-01-23T14:11:08.634Z 2026-01-29T14:56:37.749Z
9236797 9236797 20260120040007_niMHP NL0017 2026-01-21T14:24:14.546Z 2026-01-28T15:00:36.518Z
9236427 9236427 20260120031502_TI7g1 NL0017 2026-01-21T14:22:47.419Z 2026-01-28T14:59:59.590Z
9236082 9236082 20260120023253_AQD3B NL0017 2026-01-21T14:21:23.830Z 2026-01-28T14:59:43.884Z
9235843 9235843 20260120020713_TQDyT NL0017 2026-01-21T14:20:32.588Z 2026-01-28T14:59:23.739Z
9235705 9235705 20260120015059_4lKy4 NL0017 2026-01-21T14:20:01.382Z 2026-01-28T14:59:16.671Z
9235658 9235658 20260120014359_y3hVB NL0017 2026-01-21T14:19:50.021Z 2026-01-28T14:59:14.879Z
9235446 9235446 20260120011411_0H5wt NL0017 2026-01-21T14:18:55.121Z 2026-01-28T14:58:55.613Z
9235437 9235437 20260120011253_Xtmy3 NL0017 2026-01-21T14:18:53.856Z 2026-01-28T14:58:55.211Z
9235404 9235404 20260120010528_MP3aK NL0017 2026-01-21T14:18:48.253Z 2026-01-28T14:58:53.019Z
9235203 9235203 20260120004314_9NdDi NL0017 2026-01-21T14:17:54.091Z 2026-01-28T14:58:43.379Z
9234753 9234753 20260119231456_dQijU NL0017 2026-01-21T14:15:58.809Z 2026-01-28T14:58:04.354Z
9234643 9234643 20260119224314_rPXK6 NL0017 2026-01-21T14:15:33.084Z 2026-01-28T14:57:57.975Z
9234607 9234607 20260119223509_Yuwef NL0017 2026-01-21T14:15:26.104Z 2026-01-28T14:57:56.245Z
9231033 9231033 20260119054654_58ccm NL0017 2026-01-20T14:30:58.599Z 2026-01-27T15:05:54.016Z
9230907 9230907 20260119052859_Q36D6 NL0017 2026-01-20T14:30:20.153Z 2026-01-27T15:05:35.888Z
9230783 9230783 20260119050819_QVfeM NL0017 2026-01-20T14:29:44.178Z 2026-01-27T15:05:26.260Z
9224541 9224541 20260118050958_1Acd6 NL0017 2026-01-19T14:24:48.549Z 2026-01-26T15:03:23.092Z
9224515 9224515 20260118050554_226dh NL0017 2026-01-19T14:24:42.299Z 2026-01-26T15:03:22.089Z
9224485 9224485 20260118045930_A3IN3 NL0017 2026-01-19T14:24:37.218Z 2026-01-26T15:03:20.883Z
9224314 9224314 20260118041615_CvJ9k NL0017 2026-01-19T14:23:48.454Z 2026-01-26T15:03:13.103Z
9223921 9223921 20260118025222_n3Byw NL0017 2026-01-19T14:21:51.364Z 2026-01-26T15:02:41.609Z
9223885 9223885 20260118024146_sUapK NL0017 2026-01-19T14:21:41.293Z 2026-01-26T15:02:39.974Z
9223531 9223531 20260118011208_q4C3Y NL0017 2026-01-19T14:19:45.210Z 2026-01-26T15:02:13.188Z
9223301 9223301 20260118000846_OV59c NL0017 2026-01-19T14:18:37.101Z 2026-01-26T15:02:01.555Z
9195050 9195050 20260113000725_O1xzo NL0017 2026-01-14T14:11:50.135Z 2026-01-21T15:04:35.551Z
9182647 9182647 20260111060020_rnTwg NL0017 2026-01-12T14:15:16.912Z 2026-01-19T15:18:53.357Z
9182429 9182429 20260111052346_3JpaV NL0017 2026-01-12T14:14:32.042Z 2026-01-19T15:18:31.924Z
9182408 9182408 20260111052108_5P62T NL0017 2026-01-12T14:14:28.532Z 2026-01-19T15:18:31.160Z
9181539 9181539 20260111020702_HFVyt NL0017 2026-01-12T14:11:09.432Z 2026-01-19T15:17:23.549Z
9181466 9181466 20260111015349_F9JXo NL0017 2026-01-12T14:10:53.174Z 2026-01-19T15:17:20.586Z
9180741 9180741 20260110220501_s93tq NL0017 2026-01-12T14:08:12.710Z 2026-01-19T15:16:30.343Z
9180675 9180675 20260110213134_QZs38 NL0017 2026-01-12T14:07:57.679Z 2026-01-19T15:16:27.038Z
9162046 9162046 20260106185417_4CjJH NL0017 2026-01-08T14:02:10.679Z 2026-01-13T15:01:26.182Z
9144995 9144995 20260104030045_1UdxR NL0017 2026-01-05T14:19:47.517Z 2026-01-12T15:07:21.020Z
9130610 9130610 20260103034750_HHU5S NL0017 2026-01-04T14:10:54.662Z 2026-01-10T14:59:25.278Z
9125979 9125979 20251230173408_h98dj NL0017 2026-01-02T15:06:41.379Z 2026-01-07T15:12:26.034Z
9124315 9124315 20251231055714_T9RbE NL0017 2026-01-02T14:44:31.407Z 2026-01-08T15:11:38.449Z
9124279 9124279 20251231054737_pz0CM NL0017 2026-01-02T14:44:07.057Z 2026-01-08T15:11:25.756Z
9124229 9124229 20251231053006_qld68 NL0017 2026-01-02T14:43:18.345Z 2026-01-08T15:11:12.996Z
9124140 9124140 20251231045504_bZD0N NL0017 2026-01-02T14:41:34.774Z 2026-01-08T15:10:38.503Z
9124105 9124105 20251231044907_o2pid NL0017 2026-01-02T14:41:07.991Z 2026-01-08T15:10:26.570Z
9123977 9123977 20251231041751_D0wcF NL0017 2026-01-02T14:39:09.076Z 2026-01-08T15:09:48.840Z
9123876 9123876 20251231035452_sG2Gp NL0017 2026-01-02T14:37:26.239Z 2026-01-08T15:09:15.429Z
9123810 9123810 20251231033136_oysKi NL0017 2026-01-02T14:35:55.789Z 2026-01-08T15:08:46.059Z
9123375 9123375 20251230235313_UOAkg NL0017 2026-01-02T14:25:37.190Z 2026-01-08T15:05:47.263Z
9123352 9123352 20251230234642_VlUxs NL0017 2026-01-02T14:25:22.081Z 2026-01-08T15:05:43.594Z
9123285 9123285 20251230224644_5WC43 NL0017 2026-01-02T14:23:49.226Z 2026-01-08T15:05:16.716Z
9123229 9123229 20251230215455_F1G7D NL0017 2026-01-02T14:22:01.030Z 2026-01-08T15:04:53.112Z
9118703 9118703 20251230040620_Q10Vl NL0017 2026-01-01T14:46:34.386Z 2026-01-07T15:08:31.402Z
9118699 9118699 20251230035420_SNszy NL0017 2026-01-01T14:46:14.703Z 2026-01-07T15:08:18.073Z
9104173 9104173 20251230053505_1maNd NL0017 2025-12-31T14:20:31.781Z 2026-01-07T15:09:33.320Z
9103172 9103172 20251230040345_loSWZ NL0017 2025-12-31T14:16:48.448Z 2026-01-07T15:08:30.308Z
9103080 9103080 20251230035420_YrG9t NL0017 2025-12-31T14:16:22.194Z 2026-01-07T15:08:17.969Z
9101916 9101916 20251230015645_UZlv0 NL0017 2025-12-31T14:11:12.473Z 2026-01-07T15:07:01.960Z
9101900 9101900 20251230015439_poEmt NL0017 2025-12-31T14:11:07.832Z 2026-01-07T15:07:00.954Z
9101428 9101428 20251230002221_h2BKK NL0017 2025-12-31T14:08:34.307Z 2026-01-07T15:06:20.996Z
9091777 9091777 20251228195555_VS3zZ NL0017 2025-12-30T14:53:19.886Z 2026-01-05T15:14:26.145Z
9091561 9091561 20251228192423_VnYgj NL0017 2025-12-30T14:52:50.474Z 2026-01-05T15:14:17.783Z
9077047 9077047 20251228233932_PBj0v NL0017 2025-12-30T14:06:17.101Z 2025-12-31T14:32:13.573Z
9076253 9076253 20251228213358_LgGGp NL0017 2025-12-30T14:02:37.732Z 2026-01-06T15:14:20.438Z
9075345 9075345 20251225212736_yredn NL0017 2025-12-29T15:02:01.391Z 2026-01-02T15:48:50.271Z
9074460 9074460 20251225200328_DNtgP NL0017 2025-12-29T15:00:55.980Z 2026-01-02T15:48:31.828Z
9074057 9074057 20251225190602_Kz2zg NL0017 2025-12-29T15:00:03.745Z 2026-01-02T15:48:06.411Z
9073870 9073870 20251225183754_wp7eT NL0017 2025-12-29T14:59:56.258Z 2026-01-02T15:47:59.636Z
9073697 9073697 20251225181726_sfezT NL0017 2025-12-29T14:59:50.597Z 2026-01-02T15:47:56.466Z
9073515 9073515 20251225175536_J7s4R NL0017 2025-12-29T14:59:20.590Z 2026-01-02T15:47:52.626Z
9072717 9072717 20251225030002_5QUQs NL0017 2025-12-29T14:55:17.300Z 2026-01-02T15:43:50.091Z
9072121 9072121 20251226202446_R9aca NL0017 2025-12-29T14:50:24.459Z 2026-01-03T15:43:42.682Z
9071872 9071872 20251226194514_AkfW6 NL0017 2025-12-29T14:50:11.154Z 2026-01-03T15:43:30.924Z
9071297 9071297 20251226182015_KJ2XF NL0017 2025-12-29T14:49:07.108Z 2026-01-03T15:42:46.421Z

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