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

819 rows where station_code = "NL001A" 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
9610530 9610530 20260404201155_i6PPU NL001A 2026-04-06T12:09:56.703Z 2026-04-06T12:16:14.591Z
9602459 9602459 20260331211825_xqg3u NL001A 2026-04-02T12:08:57.259Z 2026-04-06T12:29:10.460Z
9595448 9595448 20260330040730_avaUL NL001A 2026-03-31T12:01:26.829Z 2026-04-06T12:30:04.143Z
9594523 9594523 20260328224920_QUzit NL001A 2026-03-30T12:09:45.101Z 2026-04-06T12:39:55.706Z
9594407 9594407 20260328221306_KIiW5 NL001A 2026-03-30T12:09:30.456Z 2026-04-06T12:39:51.296Z
9594381 9594381 20260328220407_tHFT0 NL001A 2026-03-30T12:09:26.834Z 2026-04-06T12:39:50.322Z
9592402 9592402 20260329020233_3urRE NL001A 2026-03-30T12:00:53.113Z 2026-04-06T12:34:09.115Z
9588502 9588502 20260326232612_ddHqW NL001A 2026-03-28T12:11:17.311Z 2026-04-04T12:42:16.991Z
9588473 9588473 20260326231606_JAFfu NL001A 2026-03-28T12:11:14.060Z 2026-04-04T12:42:09.976Z
9588296 9588296 20260326205825_6UDi2 NL001A 2026-03-28T12:10:48.563Z 2026-04-04T12:41:55.708Z
9585975 9585975 20260327032133_hRVqU NL001A 2026-03-28T12:01:54.311Z 2026-04-05T12:32:55.377Z
9585875 9585875 20260327025635_qJZHB NL001A 2026-03-28T12:01:38.035Z 2026-04-05T12:32:50.943Z
9570762 9570762 20260322224335_k8nEv NL001A 2026-03-24T12:23:47.414Z 2026-03-30T12:30:49.057Z
9570628 9570628 20260322221849_nSTZu NL001A 2026-03-24T12:23:33.443Z 2026-03-30T12:30:46.784Z
9570363 9570363 20260322204625_xxUTo NL001A 2026-03-24T12:23:04.356Z 2026-03-30T12:30:40.847Z
9559803 9559803 20260321195037_M8bpF NL001A 2026-03-23T12:11:30.668Z 2026-03-29T12:20:55.421Z
9551959 9551959 20260320222350_HA4z4 NL001A 2026-03-22T12:27:19.530Z 2026-03-28T12:37:04.962Z
9551287 9551287 20260320191015_zPQor NL001A 2026-03-22T12:26:23.425Z 2026-03-28T12:36:41.886Z
9541437 9541437 20260319203835_kz59r NL001A 2026-03-21T12:28:56.335Z 2026-03-27T12:42:37.630Z
9532771 9532771 20260320012540_VOeH1 NL001A 2026-03-21T12:03:34.761Z 2026-03-28T12:33:43.393Z
9530682 9530682 20260318212345_vW6Xb NL001A 2026-03-20T12:24:35.578Z 2026-03-26T12:39:14.766Z
9530437 9530437 20260318205439_KUqzo NL001A 2026-03-20T12:24:23.870Z 2026-03-26T12:39:12.350Z
9521616 9521616 20260319042930_KjZts NL001A 2026-03-20T12:08:17.114Z 2026-03-27T12:40:56.162Z
9517224 9517224 20260317225752_BMxkv NL001A 2026-03-19T12:27:20.956Z 2026-03-25T12:43:09.495Z
9516794 9516794 20260317215857_6xpR7 NL001A 2026-03-19T12:26:47.884Z 2026-03-25T12:43:07.001Z
9516185 9516185 20260317201023_DN5GK NL001A 2026-03-19T12:25:44.775Z 2026-03-25T12:42:50.756Z
9515990 9515990 20260317193956_Pq7gH NL001A 2026-03-19T12:25:26.260Z 2026-03-25T12:42:45.283Z
9511322 9511322 20260318034646_7Dd1O NL001A 2026-03-19T12:09:56.997Z 2026-03-26T12:37:35.786Z
9509665 9509665 20260318020555_UXFRf NL001A 2026-03-19T12:05:55.203Z 2026-03-26T12:37:06.908Z
9495040 9495040 20260316040118_aT7JK NL001A 2026-03-17T12:05:53.380Z 2026-03-24T12:40:53.737Z
9485900 9485900 20260315040704_umqv3 NL001A 2026-03-16T12:07:58.211Z 2026-03-23T12:21:54.461Z
9485431 9485431 20260315030435_bY3QD NL001A 2026-03-16T12:06:25.396Z 2026-03-23T12:21:52.236Z
9485260 9485260 20260315024422_u2PgI NL001A 2026-03-16T12:05:50.735Z 2026-03-23T12:21:50.655Z
9485017 9485017 20260315021541_DCqpz NL001A 2026-03-16T12:04:57.712Z 2026-03-23T12:21:49.598Z
9484849 9484849 20260315014928_LQtwJ NL001A 2026-03-16T12:04:21.850Z 2026-03-23T12:21:48.672Z
9483614 9483614 20260314225458_V2Gkh NL001A 2026-03-16T12:00:10.830Z 2026-03-23T12:21:43.266Z
9467684 9467684 20260311223410_bpmeO NL001A 2026-03-13T12:19:41.295Z 2026-03-19T12:45:54.246Z
9466965 9466965 20260311191411_hZmZM NL001A 2026-03-13T12:17:50.010Z 2026-03-19T12:45:45.596Z
9463752 9463752 20260312023930_Kd2Tf NL001A 2026-03-13T12:05:06.620Z 2026-03-20T12:36:24.532Z
9463080 9463080 20260312010228_j35ls NL001A 2026-03-13T12:03:04.806Z 2026-03-20T12:36:19.662Z
9463052 9463052 20260312005814_E8HJo NL001A 2026-03-13T12:02:59.401Z 2026-03-20T12:36:19.528Z
9462952 9462952 20260312004234_i13H8 NL001A 2026-03-13T12:02:44.294Z 2026-03-20T12:36:19.120Z
9462721 9462721 20260312000511_3duRP NL001A 2026-03-13T12:01:57.291Z 2026-03-20T12:36:17.645Z
9462654 9462654 20260311235436_D4UZs NL001A 2026-03-13T12:01:44.483Z 2026-03-20T12:36:17.324Z
9462448 9462448 20260311232014_9CMLB NL001A 2026-03-13T12:01:03.730Z 2026-03-20T12:36:16.072Z
9462314 9462314 20260311225330_Wbx4G NL001A 2026-03-13T12:00:29.143Z 2026-03-20T12:36:15.062Z
9456877 9456877 20260311013004_89ieF NL001A 2026-03-12T12:02:04.537Z 2026-03-19T12:44:23.072Z
9456622 9456622 20260311001614_dSdzq NL001A 2026-03-12T12:01:17.043Z 2026-03-19T12:44:19.242Z
9451393 9451393 20260310020310_5Hgkb NL001A 2026-03-11T12:02:39.956Z 2026-03-18T12:38:45.758Z
9451095 9451095 20260310004200_P2Kc0 NL001A 2026-03-11T12:01:43.699Z 2026-03-18T12:38:40.493Z
9430766 9430766 20260304205046_sfUwA NL001A 2026-03-06T14:24:17.196Z 2026-03-12T12:33:41.590Z
9425235 9425235 20260303184557_fjLy0 NL001A 2026-03-05T14:14:21.188Z 2026-03-11T12:28:48.398Z
9422283 9422283 20260303234645_jhhcf NL001A 2026-03-05T14:00:43.961Z 2026-03-12T12:32:25.148Z
9420416 9420416 20260302194048_4u3Kq NL001A 2026-03-04T14:04:46.652Z 2026-03-10T12:36:50.915Z
9419341 9419341 20260303030821_53dLX NL001A 2026-03-04T14:01:14.913Z 2026-03-11T12:27:58.823Z
9412168 9412168 20260301011751_GSAWt NL001A 2026-03-02T14:00:43.936Z 2026-03-09T12:39:22.183Z
9398537 9398537 20260226034602_MZQL1 NL001A 2026-02-27T14:05:35.871Z 2026-03-06T14:43:46.378Z
9397189 9397189 20260226010313_5Jmt4 NL001A 2026-02-27T14:01:43.224Z 2026-03-06T14:43:03.500Z
9372847 9372847 20260223011731_32An5 NL001A 2026-02-24T14:01:34.056Z 2026-03-03T14:30:47.681Z
9372297 9372297 20260222234328_swVVh NL001A 2026-02-24T14:00:09.213Z 2026-03-03T14:30:38.299Z
9358572 9358572 20260221023514_w2df3 NL001A 2026-02-22T14:01:21.145Z 2026-03-02T14:20:48.990Z
9358473 9358473 20260221013640_KyVDb NL001A 2026-02-22T14:00:57.849Z 2026-03-02T14:20:47.145Z
9329912 9329912 20260214212121_0hLq7 NL001A 2026-02-16T14:21:41.381Z 2026-02-23T14:47:38.321Z
9313687 9313687 20260209235248_6T1no NL001A 2026-02-11T14:18:16.895Z 2026-02-18T15:02:18.803Z
9313579 9313579 20260209213942_AKnmY NL001A 2026-02-11T14:17:39.126Z 2026-02-18T15:02:04.804Z
9311805 9311805 20260210041250_sxB5P NL001A 2026-02-11T14:01:14.072Z 2026-02-18T14:55:29.589Z
9311753 9311753 20260210033321_a9ya9 NL001A 2026-02-11T14:00:51.385Z 2026-02-18T14:55:26.244Z
9302843 9302843 20260207021523_08ES3 NL001A 2026-02-08T14:24:02.429Z 2026-02-15T15:01:05.976Z
9298572 9298572 20260207034824_kTCAo NL001A 2026-02-08T14:00:16.232Z 2026-02-16T14:55:19.992Z
9298570 9298570 20260207034652_0zIIC NL001A 2026-02-08T14:00:14.346Z 2026-02-16T14:55:19.759Z
9288766 9288766 20260204044942_wPXMs NL001A 2026-02-05T14:00:24.890Z 2026-02-13T14:52:54.414Z
9288558 9288558 20260202214906_8U8cl NL001A 2026-02-04T14:10:40.757Z 2026-02-11T14:50:59.698Z
9260396 9260396 20260125041458_dwUA5 NL001A 2026-01-26T14:21:33.905Z 2026-02-02T14:49:46.460Z
9260394 9260394 20260125041336_BrA0G NL001A 2026-01-26T14:21:33.420Z 2026-02-02T14:49:46.284Z
9260356 9260356 20260125035451_0q0h8 NL001A 2026-01-26T14:21:23.266Z 2026-02-02T14:49:43.967Z
9249577 9249577 20260122055414_V2Pib NL001A 2026-01-23T14:15:44.495Z 2026-01-30T14:55:46.563Z
9249365 9249365 20260122050259_TBIjR NL001A 2026-01-23T14:15:13.869Z 2026-01-30T14:55:39.127Z
9249124 9249124 20260122034355_aubx7 NL001A 2026-01-23T14:14:38.676Z 2026-01-30T14:55:14.411Z
9248618 9248618 20260122011627_qRyKi NL001A 2026-01-23T14:13:17.007Z 2026-01-30T14:54:52.291Z
9248460 9248460 20260121235249_Qfz4s NL001A 2026-01-23T14:12:50.729Z 2026-01-30T14:54:31.636Z
9247909 9247909 20260121202901_aS980 NL001A 2026-01-23T14:11:26.684Z 2026-01-30T14:54:06.882Z
9247792 9247792 20260121194929_nY2p5 NL001A 2026-01-23T14:11:08.634Z 2026-01-30T14:53:48.207Z
9237472 9237472 20260120052113_CgjAa NL001A 2026-01-21T14:26:42.460Z 2026-01-28T15:01:27.223Z
9237063 9237063 20260120043236_zafHM NL001A 2026-01-21T14:25:10.591Z 2026-01-28T15:00:56.172Z
9234884 9234884 20260119234549_TisNP NL001A 2026-01-21T14:16:34.856Z 2026-01-28T14:58:18.856Z
9223592 9223592 20260118013512_JurMV NL001A 2026-01-19T14:20:05.661Z 2026-01-26T15:02:28.132Z
9222983 9222983 20260117215829_yGbcw NL001A 2026-01-19T14:17:11.508Z 2026-01-26T15:01:30.917Z
9222137 9222137 20260117182157_PIPIQ NL001A 2026-01-19T14:13:27.483Z 2026-01-26T15:00:41.298Z
9217768 9217768 20260116193922_KhllP NL001A 2026-01-18T14:08:53.878Z 2026-01-25T14:57:47.028Z
9204351 9204351 20260114062945_Iq2hr NL001A 2026-01-15T14:27:07.024Z 2026-01-22T15:10:25.337Z
9195379 9195379 20260113011524_kroUC NL001A 2026-01-14T14:13:06.639Z 2026-01-21T15:04:39.691Z
9181641 9181641 20260111022938_sejqQ NL001A 2026-01-12T14:11:35.822Z 2026-01-19T15:17:41.845Z
9181415 9181415 20260111014104_dy3uf NL001A 2026-01-12T14:10:44.619Z 2026-01-19T15:17:17.142Z
9159327 9159327 20260106022154_MxXN2 NL001A 2026-01-07T14:08:59.364Z 2026-01-13T15:08:20.945Z
9158999 9158999 20260106012219_Oklbc NL001A 2026-01-07T14:07:57.584Z 2026-01-13T15:07:56.700Z
9149171 9149171 20260104190912_Gwmtd NL001A 2026-01-06T14:04:08.745Z 2026-01-13T15:11:46.398Z
9148755 9148755 20260104171846_kKLwX NL001A 2026-01-06T14:02:08.124Z 2026-01-13T15:11:17.475Z
9129576 9129576 20260102231957_Tyyh7 NL001A 2026-01-04T14:04:52.537Z 2026-01-10T14:57:54.393Z
9118768 9118768 20251230060726_XWtp4 NL001A 2026-01-01T14:50:36.378Z 2026-01-07T15:09:47.642Z
9110059 9110059 20251230221121_sf2Ce NL001A 2026-01-01T14:05:35.975Z 2026-01-08T15:04:56.750Z

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