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

1,319 rows where station_code = "NL000W" 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
9256494 9256494 20260120054913_7nHgz NL000W 2026-01-25T14:42:37.834Z 2026-01-28T15:01:35.400Z
9256444 9256444 20260121230714_UHLVp NL000W 2026-01-25T14:26:30.465Z 2026-01-29T14:57:15.295Z
9249528 9249528 20260122053807_pXdpi NL000W 2026-01-23T14:15:39.184Z 2026-01-29T14:58:43.326Z
9249463 9249463 20260122052642_Ua8l0 NL000W 2026-01-23T14:15:27.752Z 2026-01-29T14:58:40.657Z
9237929 9237929 20260120062921_K2gvq NL000W 2026-01-21T14:28:06.063Z 2026-01-28T15:01:59.797Z
9236611 9236611 20260120034023_TpHgw NL000W 2026-01-21T14:23:31.870Z 2026-01-28T15:00:24.757Z
9224312 9224312 20260118041615_CvJ9k NL000W 2026-01-19T14:23:48.454Z 2026-01-26T15:03:13.103Z
9224264 9224264 20260118040646_BarRZ NL000W 2026-01-19T14:23:39.089Z 2026-01-26T15:03:11.213Z
9223884 9223884 20260118024146_sUapK NL000W 2026-01-19T14:21:41.293Z 2026-01-26T15:02:39.974Z
9223554 9223554 20260118011951_iCRcG NL000W 2026-01-19T14:19:56.077Z 2026-01-26T15:02:14.139Z
9223530 9223530 20260118011208_q4C3Y NL000W 2026-01-19T14:19:45.210Z 2026-01-26T15:02:13.188Z
9222563 9222563 20260117195600_4PSI1 NL000W 2026-01-19T14:15:16.866Z 2026-01-26T15:01:13.573Z
9195049 9195049 20260113000725_O1xzo NL000W 2026-01-14T14:11:50.135Z 2026-01-21T15:04:35.551Z
9194944 9194944 20260112234018_JOPTi NL000W 2026-01-14T14:11:23.704Z 2026-01-21T15:04:34.249Z
9182739 9182739 20260111062843_934Xv NL000W 2026-01-12T14:15:36.992Z 2026-01-19T15:18:57.718Z
9182702 9182702 20260111061514_ZTdys NL000W 2026-01-12T14:15:27.448Z 2026-01-19T15:18:55.812Z
9182662 9182662 20260111060110_fVIBO NL000W 2026-01-12T14:15:20.211Z 2026-01-19T15:18:53.995Z
9182653 9182653 20260111060110_dmmLA NL000W 2026-01-12T14:15:19.884Z 2026-01-19T15:18:53.894Z
9182407 9182407 20260111052108_5P62T NL000W 2026-01-12T14:14:28.532Z 2026-01-19T15:18:31.160Z
9182371 9182371 20260111051201_uUFaK NL000W 2026-01-12T14:14:16.820Z 2026-01-19T15:18:29.611Z
9181477 9181477 20260111015543_hXrfg NL000W 2026-01-12T14:10:54.974Z 2026-01-19T15:17:20.924Z
9181275 9181275 20260111011231_PrivI NL000W 2026-01-12T14:10:12.983Z 2026-01-19T15:17:10.686Z
9181162 9181162 20260111003722_C8Tvk NL000W 2026-01-12T14:09:47.960Z 2026-01-19T15:17:05.920Z
9180970 9180970 20260110233758_FEIBL NL000W 2026-01-12T14:09:06.575Z 2026-01-19T15:16:42.513Z
9180931 9180931 20260110232900_KFmSh NL000W 2026-01-12T14:08:57.641Z 2026-01-19T15:16:39.330Z
9099978 9099978 20251224200041_GmnXP NL000W 2025-12-30T15:43:05.489Z 2026-01-01T15:57:16.618Z
9099671 9099671 20251225044321_UvVGT NL000W 2025-12-30T15:30:00.259Z 2026-01-02T15:44:54.833Z
9099665 9099665 20251225044208_FXCzZ NL000W 2025-12-30T15:29:59.504Z 2026-01-02T15:44:54.374Z
9099588 9099588 20251225030846_F3qlS NL000W 2025-12-30T15:28:01.619Z 2026-01-02T15:44:08.371Z
9099578 9099578 20251225030644_A1nSR NL000W 2025-12-30T15:28:00.832Z 2026-01-02T15:44:06.440Z
9099464 9099464 20251225003842_1YIVK NL000W 2025-12-30T15:25:13.287Z 2026-01-02T15:42:46.232Z
9099444 9099444 20251224235521_6cAIn NL000W 2025-12-30T15:24:56.410Z 2026-01-02T15:42:16.719Z
9044019 9044019 20251224215153_Afxzg NL000W 2025-12-28T14:48:18.468Z 2026-01-01T15:57:26.050Z
9043241 9043241 20251224200041_8KFJa NL000W 2025-12-28T14:47:03.131Z 2026-01-01T15:57:16.576Z
9036637 9036637 20251224045752_xzCLu NL000W 2025-12-28T14:35:30.425Z 2025-12-28T14:48:35.096Z
9036593 9036593 20251224045137_HXup8 NL000W 2025-12-28T14:35:26.743Z 2026-01-01T15:54:37.647Z
9036289 9036289 20251224034537_aatol NL000W 2025-12-28T14:34:44.548Z 2026-01-01T15:54:08.172Z
9035941 9035941 20251224014635_23sQL NL000W 2025-12-28T14:33:39.060Z 2026-01-01T15:53:59.733Z
9031103 9031103 20251225051618_A1vXr NL000W 2025-12-28T14:20:09.389Z 2026-01-02T15:45:05.626Z
9030383 9030383 20251225044208_JR7Lt NL000W 2025-12-28T14:18:46.215Z 2026-01-02T15:44:54.323Z
9028523 9028523 20251225030846_s2nlD NL000W 2025-12-28T14:14:09.251Z 2026-01-02T15:44:08.270Z
9025956 9025956 20251225003842_djuW2 NL000W 2025-12-28T14:06:16.636Z 2026-01-02T15:42:46.186Z
9025376 9025376 20251224235521_lw6R9 NL000W 2025-12-28T14:04:21.220Z 2026-01-02T15:42:16.645Z
9024981 9024981 20251224232150_Omx9H NL000W 2025-12-28T14:02:56.264Z 2026-01-02T15:42:09.285Z
8708335 8708335 20251208035858_AgLxa NL000W 2025-12-09T14:29:22.003Z 2025-12-16T15:13:21.545Z
8708011 8708011 20251208030327_LrHpR NL000W 2025-12-09T14:28:27.998Z 2025-12-16T15:13:14.927Z
8606190 8606190 20251125181658_lST9E NL000W 2025-11-27T14:09:24.370Z 2025-12-04T15:06:31.540Z
8601520 8601520 20251125035245_pbVcl NL000W 2025-11-26T14:24:23.571Z 2025-12-02T15:09:09.592Z
8591688 8591688 20251124044515_3zZpA NL000W 2025-11-25T14:24:44.999Z 2025-12-02T15:12:59.935Z
8578107 8578107 20251122194141_MEGWB NL000W 2025-11-24T14:10:45.371Z 2025-12-01T15:19:08.837Z
8573706 8573706 20251122035600_35qkR NL000W 2025-11-23T14:41:55.307Z 2025-11-30T15:06:36.120Z
8568452 8568452 20251121051952_9Lo6v NL000W 2025-11-23T14:31:08.905Z 2025-11-29T14:54:46.820Z
8568441 8568441 20251121051942_qUi7K NL000W 2025-11-23T14:31:08.204Z 2025-11-29T14:54:46.782Z
8567038 8567038 20251122034821_GE42h NL000W 2025-11-23T14:18:34.883Z 2025-11-30T15:06:34.057Z
8566966 8566966 20251122032154_Sr6jC NL000W 2025-11-23T14:18:19.840Z 2025-11-30T15:06:28.518Z
8566927 8566927 20251122030050_WK47j NL000W 2025-11-23T14:18:06.893Z 2025-11-30T15:06:16.955Z
8566799 8566799 20251122022640_P7Sqd NL000W 2025-11-23T14:17:34.213Z 2025-11-30T15:06:09.310Z
8563602 8563602 20251121165222_e32AS NL000W 2025-11-23T14:08:49.175Z 2025-11-30T15:03:41.898Z
8563600 8563600 20251121165132_kkpF2 NL000W 2025-11-23T14:08:48.617Z 2025-11-30T15:03:41.827Z
8536943 8536943 20251120053821_9bXjU NL000W 2025-11-21T14:19:19.077Z 2025-11-28T14:58:19.834Z
8536864 8536864 20251120052633_cZiw4 NL000W 2025-11-21T14:19:13.320Z 2025-11-28T14:58:01.468Z
8536589 8536589 20251120043729_F9jth NL000W 2025-11-21T14:18:40.430Z 2025-11-28T14:57:42.209Z
8535142 8535142 20251120012018_GUzpG NL000W 2025-11-21T14:15:21.747Z 2025-11-28T14:56:18.592Z
8534975 8534975 20251120005354_BPCyk NL000W 2025-11-21T14:14:57.860Z 2025-11-28T14:56:10.387Z
8534850 8534850 20251120003132_VKtVk NL000W 2025-11-21T14:14:43.416Z 2025-11-28T14:56:03.257Z
8503461 8503461 20251117172632_WEeRN NL000W 2025-11-19T14:05:30.537Z 2025-11-26T15:06:28.638Z
8447452 8447452 20251112194936_2OARN NL000W 2025-11-14T14:14:09.967Z 2025-11-21T15:11:18.600Z
8446854 8446854 20251112182413_v7kqO NL000W 2025-11-14T14:12:06.865Z 2025-11-21T15:11:14.137Z
8427210 8427210 20251111041539_72Vq8 NL000W 2025-11-12T14:27:26.271Z 2025-11-19T15:17:46.857Z
8426189 8426189 20251111024218_a9X52 NL000W 2025-11-12T14:24:36.969Z 2025-11-19T15:16:59.930Z
8412988 8412988 20251109214216_QdfxK NL000W 2025-11-11T14:15:55.544Z 2025-11-18T15:20:17.395Z
8412795 8412795 20251109205914_48j3F NL000W 2025-11-11T14:15:15.229Z 2025-11-18T15:20:15.378Z
8412452 8412452 20251109202315_rJ0dP NL000W 2025-11-11T14:14:09.401Z 2025-11-18T15:20:11.321Z
8398605 8398605 20251108050950_ANwCa NL000W 2025-11-09T14:15:55.051Z 2025-11-16T15:04:55.461Z
8398311 8398311 20251108040823_oMR8y NL000W 2025-11-09T14:15:00.217Z 2025-11-16T15:04:43.187Z
8398157 8398157 20251108034354_1gMiD NL000W 2025-11-09T14:14:26.799Z 2025-11-16T15:04:38.820Z
8397711 8397711 20251108022610_zPZQf NL000W 2025-11-09T14:13:06.134Z 2025-11-16T15:04:25.843Z
8397166 8397166 20251108004941_CQFOU NL000W 2025-11-09T14:11:12.132Z 2025-11-16T15:04:08.664Z
8396294 8396294 20251107201811_s2hvr NL000W 2025-11-09T14:08:05.095Z 2025-11-16T15:03:26.476Z
8395798 8395798 20251107181629_y6evW NL000W 2025-11-09T14:05:58.862Z 2025-11-16T15:02:48.366Z
8395751 8395751 20251107180345_irlQC NL000W 2025-11-09T14:05:41.820Z 2025-11-16T15:02:42.685Z
8395683 8395683 20251107174335_BLPks NL000W 2025-11-09T14:05:28.281Z 2025-11-16T15:02:38.980Z
8391452 8391452 20251107025205_3yk6R NL000W 2025-11-08T14:14:48.357Z 2025-11-15T15:00:29.198Z
8391202 8391202 20251107021635_okRKg NL000W 2025-11-08T14:13:58.511Z 2025-11-15T15:00:23.789Z
8391163 8391163 20251107021252_B97Yi NL000W 2025-11-08T14:13:52.097Z 2025-11-15T15:00:20.381Z
8390267 8390267 20251107000041_aKeqE NL000W 2025-11-08T14:10:15.890Z 2025-11-15T14:59:58.436Z
8390216 8390216 20251106234722_oD3RQ NL000W 2025-11-08T14:10:06.213Z 2025-11-15T14:59:57.537Z
8386546 8386546 20251106050740_Ts4vW NL000W 2025-11-07T14:11:31.595Z 2025-11-14T15:08:43.692Z
8386542 8386542 20251106050658_QsvyN NL000W 2025-11-07T14:11:31.126Z 2025-11-14T15:08:43.681Z
8386233 8386233 20251106031155_un8nA NL000W 2025-11-07T14:10:12.612Z 2025-11-14T15:08:40.447Z
8385951 8385951 20251106020448_9RLzT NL000W 2025-11-07T14:08:58.678Z 2025-11-14T15:08:30.503Z
8385491 8385491 20251106001024_dF8Gl NL000W 2025-11-07T14:07:03.684Z 2025-11-14T15:08:15.340Z
8380433 8380433 20251105020109_yl4YR NL000W 2025-11-06T14:11:45.146Z 2025-11-13T15:14:53.505Z
8379733 8379733 20251104233124_xk6ag NL000W 2025-11-06T14:08:59.472Z 2025-11-13T15:14:30.019Z
8371029 8371029 20251104033058_e5yiN NL000W 2025-11-05T14:13:28.196Z 2025-11-12T15:10:54.863Z
8365665 8365665 20251103042043_02704 NL000W 2025-11-04T14:21:16.160Z 2025-11-11T15:07:51.144Z
8365587 8365587 20251103040016_4Hu2r NL000W 2025-11-04T14:20:54.936Z 2025-11-11T15:07:39.943Z
8365556 8365556 20251103034829_o4PZ7 NL000W 2025-11-04T14:20:49.786Z 2025-11-11T15:07:33.582Z
8365121 8365121 20251103015030_S9nCR NL000W 2025-11-04T14:19:14.135Z 2025-11-11T15:06:30.136Z
8364988 8364988 20251103011654_zo5yo NL000W 2025-11-04T14:18:53.392Z 2025-11-11T15:06:25.497Z

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