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

3,286 rows where station_code = "NL000Z" 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
8666860 8666860 20251201053501_1RbWX NL000Z 2025-12-02T14:30:24.388Z 2025-12-05T14:36:57.333Z
8666375 8666375 20251201052555_hnlKq NL000Z 2025-12-02T14:25:54.507Z 2025-12-05T14:36:55.980Z
8666272 8666272 20251201050614_IgdvS NL000Z 2025-12-02T14:25:41.704Z 2025-12-05T14:36:52.778Z
8666100 8666100 20251201043547_HQVaT NL000Z 2025-12-02T14:25:13.965Z 2025-12-05T14:36:32.234Z
8666034 8666034 20251201042504_n5Fkj NL000Z 2025-12-02T14:25:07.028Z 2025-12-05T14:36:27.650Z
8666013 8666013 20251201042408_QraRT NL000Z 2025-12-02T14:25:05.781Z 2025-12-05T14:36:27.086Z
8665975 8665975 20251201041534_7uhTE NL000Z 2025-12-02T14:25:00.520Z 2025-12-05T14:36:25.528Z
8665957 8665957 20251201041333_f9qkJ NL000Z 2025-12-02T14:24:58.687Z 2025-12-05T14:36:24.933Z
8665936 8665936 20251201041145_J12w3 NL000Z 2025-12-02T14:24:56.223Z 2025-12-05T14:36:24.415Z
8665842 8665842 20251201040239_3D9tP NL000Z 2025-12-02T14:24:34.458Z 2025-12-05T14:36:21.272Z
8665780 8665780 20251201035710_k51QT NL000Z 2025-12-02T14:24:28.275Z 2025-12-05T14:36:18.974Z
8665757 8665757 20251201035457_NG8V2 NL000Z 2025-12-02T14:24:25.720Z 2025-12-05T14:36:18.268Z
8665728 8665728 20251201035153_EA0V6 NL000Z 2025-12-02T14:24:22.288Z 2025-12-05T14:36:17.320Z
8665694 8665694 20251201035042_2FHf4 NL000Z 2025-12-02T14:24:20.125Z 2025-12-05T14:36:16.225Z
8665662 8665662 20251201034809_O712O NL000Z 2025-12-02T14:24:17.070Z 2025-12-05T14:36:15.264Z
8665607 8665607 20251201034318_t8XIO NL000Z 2025-12-02T14:24:02.931Z 2025-12-05T14:36:13.454Z
8665581 8665581 20251201033748_1PZDZ NL000Z 2025-12-02T14:23:56.233Z 2025-12-05T14:36:12.292Z
8665576 8665576 20251201033708_yyUZz NL000Z 2025-12-02T14:23:55.906Z 2025-12-05T14:36:12.237Z
8665478 8665478 20251201032341_MVTpD NL000Z 2025-12-02T14:23:45.001Z 2025-12-05T14:36:08.725Z
8665397 8665397 20251201031528_ZnteE NL000Z 2025-12-02T14:23:37.451Z 2025-12-05T14:35:54.694Z
8665071 8665071 20251201022455_BKtLt NL000Z 2025-12-02T14:22:45.104Z 2025-12-05T14:35:41.534Z
8665003 8665003 20251201021548_UjnEt NL000Z 2025-12-02T14:22:35.434Z 2025-12-05T14:35:38.715Z
8664946 8664946 20251201020718_ENvOg NL000Z 2025-12-02T14:22:29.979Z 2025-12-05T14:35:37.181Z
8664732 8664732 20251201013155_Rf68B NL000Z 2025-12-02T14:21:59.659Z 2025-12-05T14:35:16.372Z
8664717 8664717 20251201013025_wj6pG NL000Z 2025-12-02T14:21:57.545Z 2025-12-05T14:35:15.831Z
8664690 8664690 20251201012522_KoCGR NL000Z 2025-12-02T14:21:48.370Z 2025-12-05T14:35:14.644Z
8664678 8664678 20251201012155_op9Z8 NL000Z 2025-12-02T14:21:47.043Z 2025-12-05T14:35:12.434Z
8664661 8664661 20251201011912_bVezI NL000Z 2025-12-02T14:21:45.159Z 2025-12-05T14:35:11.992Z
8664619 8664619 20251201011244_LyPVA NL000Z 2025-12-02T14:21:38.566Z 2025-12-05T14:35:10.654Z
8664611 8664611 20251201011111_POMSz NL000Z 2025-12-02T14:21:37.589Z 2025-12-05T14:35:10.287Z
8664591 8664591 20251201010424_y1iGl NL000Z 2025-12-02T14:21:35.177Z 2025-12-05T14:35:09.519Z
8664580 8664580 20251201005932_4lY2y NL000Z 2025-12-02T14:21:32.658Z 2025-12-05T14:35:09.096Z
8664570 8664570 20251201005748_SOPKM NL000Z 2025-12-02T14:21:22.663Z 2025-12-05T14:35:08.825Z
8664512 8664512 20251201004325_ICtsY NL000Z 2025-12-02T14:21:14.117Z 2025-12-05T14:35:06.639Z
8664459 8664459 20251201003417_Qg2Q2 NL000Z 2025-12-02T14:21:07.345Z 2025-12-05T14:35:04.774Z
8664416 8664416 20251201002240_Pm2IL NL000Z 2025-12-02T14:21:01.898Z 2025-12-05T14:35:03.453Z
8664377 8664377 20251201001239_S9AdZ NL000Z 2025-12-02T14:20:49.109Z 2025-12-05T14:35:02.351Z
8664332 8664332 20251201000344_G5UER NL000Z 2025-12-02T14:20:43.509Z 2025-12-05T14:35:00.829Z
8664313 8664313 20251201000153_3U5MD NL000Z 2025-12-02T14:20:41.570Z 2025-12-05T14:35:00.372Z
8664291 8664291 20251130235905_3IXSh NL000Z 2025-12-02T14:20:39.477Z 2025-12-05T14:34:59.740Z
8664197 8664197 20251130233824_jRXQN NL000Z 2025-12-02T14:20:18.385Z 2025-12-05T14:34:56.364Z
8664049 8664049 20251130230954_2yllk NL000Z 2025-12-02T14:20:00.313Z 2025-12-05T14:34:43.112Z
8664014 8664014 20251130230224_c1yZf NL000Z 2025-12-02T14:19:55.827Z 2025-12-05T14:34:41.869Z
8653940 8653940 20251130024834_ua2zM NL000Z 2025-12-01T14:24:30.860Z 2025-12-05T14:43:43.039Z
8645741 8645741 20251128234347_KkA89 NL000Z 2025-11-30T14:24:28.373Z 2025-12-05T14:51:11.042Z
8645645 8645645 20251128231645_irvHI NL000Z 2025-11-30T14:24:20.206Z 2025-12-05T14:51:01.802Z
8645590 8645590 20251128230211_WlGIN NL000Z 2025-11-30T14:24:14.600Z 2025-12-05T14:50:52.803Z
8645578 8645578 20251128225918_cgK3P NL000Z 2025-11-30T14:24:13.503Z 2025-12-05T14:50:52.376Z
8645571 8645571 20251128225844_0Gcst NL000Z 2025-11-30T14:24:12.858Z 2025-12-05T14:50:52.046Z
8645546 8645546 20251128224341_kKPRd NL000Z 2025-11-30T14:23:57.133Z 2025-12-05T14:50:50.181Z
8645531 8645531 20251128223933_dMKlZ NL000Z 2025-11-30T14:23:55.980Z 2025-12-05T14:50:49.510Z
8645523 8645523 20251128223750_wC7pO NL000Z 2025-11-30T14:23:54.995Z 2025-12-05T14:50:49.169Z
8645502 8645502 20251128222803_jJ0ot NL000Z 2025-11-30T14:23:51.120Z 2025-12-05T14:50:44.294Z
8645407 8645407 20251128215951_SG2wA NL000Z 2025-11-30T14:23:40.903Z 2025-12-05T14:50:38.370Z
8645401 8645401 20251128215642_Ev2iu NL000Z 2025-11-30T14:23:40.096Z 2025-12-05T14:50:38.277Z
8645336 8645336 20251128212131_37OYy NL000Z 2025-11-30T14:23:34.953Z 2025-12-05T14:50:36.897Z
8645263 8645263 20251128210738_jHCNw NL000Z 2025-11-30T14:23:30.211Z 2025-12-05T14:50:35.589Z
8644922 8644922 20251128201513_ZK0PM NL000Z 2025-11-30T14:22:52.576Z 2025-12-05T14:50:29.393Z
8623642 8623642 20251127013328_UHgUy NL000Z 2025-11-28T14:22:18.641Z 2025-12-05T15:04:05.814Z
8623608 8623608 20251127012412_FyWtL NL000Z 2025-11-28T14:22:14.925Z 2025-12-05T15:04:04.458Z
8623409 8623409 20251127002627_ae2nn NL000Z 2025-11-28T14:21:40.313Z 2025-12-05T15:03:49.518Z
8623375 8623375 20251127001633_VcAAz NL000Z 2025-11-28T14:21:36.102Z 2025-12-05T15:03:45.178Z
8623023 8623023 20251126223043_03nIW NL000Z 2025-11-28T14:20:30.265Z 2025-12-05T15:03:25.884Z
8622948 8622948 20251126221244_Jcger NL000Z 2025-11-28T14:20:22.111Z 2025-12-05T15:03:20.546Z
8622775 8622775 20251126211946_PRoUM NL000Z 2025-11-28T14:19:52.304Z 2025-12-05T15:03:06.291Z
8622706 8622706 20251126204722_JlHhk NL000Z 2025-11-28T14:19:43.206Z 2025-12-05T15:03:05.255Z
8622645 8622645 20251126202955_H1ikK NL000Z 2025-11-28T14:19:37.289Z 2025-12-05T15:03:04.538Z
8622638 8622638 20251126202417_EHsOn NL000Z 2025-11-28T14:19:36.317Z 2025-12-05T15:03:04.430Z
8622552 8622552 20251126195326_k5m3h NL000Z 2025-11-28T14:19:11.887Z 2025-12-05T15:03:03.368Z
8622550 8622550 20251126195325_syU4p NL000Z 2025-11-28T14:19:09.886Z 2025-12-05T15:03:03.299Z
8622199 8622199 20251126181133_gK6Yy NL000Z 2025-11-28T14:18:06.844Z 2025-12-05T15:02:53.454Z
8622070 8622070 20251126174344_NgqNG NL000Z 2025-11-28T14:17:36.561Z 2025-12-05T15:02:51.497Z
8622058 8622058 20251126174102_vRWN9 NL000Z 2025-11-28T14:17:34.708Z 2025-12-05T15:02:51.279Z
8621977 8621977 20251126172120_ECmFO NL000Z 2025-11-28T14:17:12.225Z 2025-12-05T15:02:50.191Z
8621869 8621869 20251126164738_SY5yK NL000Z 2025-11-28T14:16:55.453Z 2025-12-05T15:02:48.793Z
8616451 8616451 20251126060123_D0Qe4 NL000Z 2025-11-27T14:31:12.468Z 2025-12-04T15:11:39.679Z
8616380 8616380 20251126055511_607qg NL000Z 2025-11-27T14:31:08.076Z 2025-12-04T15:11:38.665Z
8609609 8609609 20251125235228_78Fkk NL000Z 2025-11-27T14:18:33.740Z 2025-12-04T15:07:55.714Z
8602607 8602607 20251125050831_ydjlq NL000Z 2025-11-26T14:26:10.281Z 2025-12-02T15:09:31.746Z
8602358 8602358 20251125045033_YKeOF NL000Z 2025-11-26T14:25:35.418Z 2025-12-02T15:09:30.618Z
8602306 8602306 20251125044648_pu0fR NL000Z 2025-11-26T14:25:31.155Z 2025-12-02T15:09:30.354Z
8591770 8591770 20251124045354_78b30 NL000Z 2025-11-25T14:25:06.578Z 2025-12-02T15:13:00.419Z
8591671 8591671 20251124044354_byNSg NL000Z 2025-11-25T14:24:43.649Z 2025-12-02T15:12:59.883Z
8591644 8591644 20251124043949_8JWuz NL000Z 2025-11-25T14:24:41.926Z 2025-12-02T15:12:59.778Z
8591638 8591638 20251124043907_UjlGS NL000Z 2025-11-25T14:24:41.310Z 2025-12-02T15:12:59.751Z
8591523 8591523 20251124042231_en9q1 NL000Z 2025-11-25T14:24:29.137Z 2025-12-02T15:12:59.149Z
8591399 8591399 20251124041109_1Bx1b NL000Z 2025-11-25T14:24:18.491Z 2025-12-02T15:12:58.531Z
8591010 8591010 20251124033537_PWRWb NL000Z 2025-11-25T14:23:14.586Z 2025-12-02T15:12:56.603Z
8590831 8590831 20251124032002_vitw5 NL000Z 2025-11-25T14:22:53.672Z 2025-12-02T15:12:55.699Z
8590818 8590818 20251124031555_1cS6v NL000Z 2025-11-25T14:22:51.813Z 2025-12-02T15:12:55.596Z
8590808 8590808 20251124031259_sbbbD NL000Z 2025-11-25T14:22:50.481Z 2025-12-02T15:12:55.551Z
8590686 8590686 20251124030321_bpPzk NL000Z 2025-11-25T14:22:22.701Z 2025-12-02T15:12:54.201Z
8590477 8590477 20251124024508_POK92 NL000Z 2025-11-25T14:22:06.008Z 2025-12-02T15:12:48.646Z
8590225 8590225 20251124022933_FhpG3 NL000Z 2025-11-25T14:21:33.472Z 2025-12-02T15:12:43.400Z
8590114 8590114 20251124022317_CLyUm NL000Z 2025-11-25T14:21:24.848Z 2025-12-02T15:12:42.442Z
8590034 8590034 20251124021714_0vziO NL000Z 2025-11-25T14:21:08.954Z 2025-12-02T15:12:41.533Z
8589667 8589667 20251124014548_9eYHM NL000Z 2025-11-25T14:20:18.820Z 2025-12-02T15:12:33.111Z
8589435 8589435 20251124013403_NNPN3 NL000Z 2025-11-25T14:20:04.483Z 2025-12-02T15:12:30.732Z
8589430 8589430 20251124013357_Bfs4f NL000Z 2025-11-25T14:20:04.008Z 2025-12-02T15:12:30.578Z
8588730 8588730 20251124002750_W2RJO NL000Z 2025-11-25T14:18:12.431Z 2025-12-02T15:11:51.103Z

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