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

4,389 rows where station_code = "NL000D" 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
8666392 8666392 20251201053312_Iv9RT NL000D 2025-12-02T14:25:56.114Z 2025-12-05T14:36:56.992Z
8665981 8665981 20251201041621_NPNtR NL000D 2025-12-02T14:25:01.390Z 2025-12-05T14:36:25.763Z
8665826 8665826 20251201040200_x5K2d NL000D 2025-12-02T14:24:32.377Z 2025-12-05T14:36:20.624Z
8665792 8665792 20251201035831_dTBbl NL000D 2025-12-02T14:24:29.635Z 2025-12-05T14:36:19.481Z
8664892 8664892 20251201015921_0Kt03 NL000D 2025-12-02T14:22:18.071Z 2025-12-05T14:35:35.246Z
8664888 8664888 20251201015709_NBfEF NL000D 2025-12-02T14:22:17.237Z 2025-12-05T14:35:34.957Z
8664748 8664748 20251201013414_tD5OX NL000D 2025-12-02T14:22:00.939Z 2025-12-05T14:35:16.717Z
8664741 8664741 20251201013340_aY3jH NL000D 2025-12-02T14:22:00.033Z 2025-12-05T14:35:16.484Z
8664700 8664700 20251201012700_ZadQw NL000D 2025-12-02T14:21:50.495Z 2025-12-05T14:35:14.996Z
8664672 8664672 20251201012040_aRbRe NL000D 2025-12-02T14:21:46.396Z 2025-12-05T14:35:12.210Z
8664645 8664645 20251201011617_pEZhN NL000D 2025-12-02T14:21:42.153Z 2025-12-05T14:35:11.433Z
8664531 8664531 20251201005300_ftr9D NL000D 2025-12-02T14:21:16.462Z 2025-12-05T14:35:07.448Z
8664506 8664506 20251201004307_LtxzA NL000D 2025-12-02T14:21:13.782Z 2025-12-05T14:35:06.497Z
8664427 8664427 20251201002532_ZMt5v NL000D 2025-12-02T14:21:03.102Z 2025-12-05T14:35:03.773Z
8664208 8664208 20251130234012_32Xwp NL000D 2025-12-02T14:20:29.379Z 2025-12-05T14:34:56.659Z
8663655 8663655 20251130211618_LJnZD NL000D 2025-12-02T14:18:47.729Z 2025-12-05T14:34:27.138Z
8663571 8663571 20251130210539_D9at7 NL000D 2025-12-02T14:18:30.448Z 2025-12-05T14:34:24.840Z
8663543 8663543 20251130205945_6XZUn NL000D 2025-12-02T14:18:25.901Z 2025-12-05T14:34:23.572Z
8653589 8653589 20251130022755_Xio3d NL000D 2025-12-01T14:23:44.811Z 2025-12-05T14:43:35.743Z
8653067 8653067 20251130015425_KNjkR NL000D 2025-12-01T14:22:43.999Z 2025-12-05T14:43:02.494Z
8646514 8646514 20251129021330_og4R8 NL000D 2025-11-30T14:26:06.143Z 2025-12-05T14:51:43.639Z
8646019 8646019 20251129004757_fvF6v NL000D 2025-11-30T14:25:04.482Z 2025-12-05T14:51:31.187Z
8645482 8645482 20251128222229_Yt262 NL000D 2025-11-30T14:23:47.961Z 2025-12-05T14:50:39.985Z
8645235 8645235 20251128205756_gIzB2 NL000D 2025-11-30T14:23:17.901Z 2025-12-05T14:50:33.808Z
8599084 8599084 20251125014433_qNYZd NL000D 2025-11-26T14:20:19.733Z 2025-12-02T15:08:19.819Z
8598962 8598962 20251125013759_EZv3M NL000D 2025-11-26T14:20:07.361Z 2025-12-02T15:08:15.088Z
8598384 8598384 20251125005301_Ke3nl NL000D 2025-11-26T14:18:43.450Z 2025-12-02T15:07:53.334Z
8597040 8597040 20251124224846_2R6xx NL000D 2025-11-26T14:15:55.065Z 2025-12-02T15:07:22.621Z
8596959 8596959 20251124223829_w30nX NL000D 2025-11-26T14:15:49.607Z 2025-12-02T15:07:20.520Z
8596848 8596848 20251124221915_0L1Qw NL000D 2025-11-26T14:15:38.251Z 2025-12-02T15:07:15.318Z
8595961 8595961 20251124191335_JewdB NL000D 2025-11-26T14:13:11.883Z 2025-12-02T15:06:23.697Z
8589937 8589937 20251124020809_ZouMA NL000D 2025-11-25T14:20:58.502Z 2025-12-02T15:12:40.399Z
8589424 8589424 20251124013343_k34TV NL000D 2025-11-25T14:20:03.191Z 2025-12-02T15:12:28.435Z
8589109 8589109 20251124010305_3xZOS NL000D 2025-11-25T14:19:04.438Z 2025-12-02T15:12:09.002Z
8581543 8581543 20251123005021_Bijox NL000D 2025-11-24T14:31:46.174Z 2025-12-01T15:20:55.943Z
8581245 8581245 20251122222842_7P3Nl NL000D 2025-11-24T14:31:21.661Z 2025-12-01T15:20:04.764Z
8579754 8579754 20251123010611_S9CPW NL000D 2025-11-24T14:15:05.596Z 2025-12-01T15:21:00.359Z
8579049 8579049 20251122221150_sH8p2 NL000D 2025-11-24T14:13:22.966Z 2025-11-24T14:13:22.966Z
8579036 8579036 20251122221125_ffSXz NL000D 2025-11-24T14:13:21.810Z 2025-12-01T15:19:58.875Z
8578611 8578611 20251122210311_YKaDX NL000D 2025-11-24T14:12:12.344Z 2025-12-01T15:19:48.903Z
8577972 8577972 20251122191945_7BnWf NL000D 2025-11-24T14:10:20.368Z 2025-11-24T14:10:20.368Z
8577474 8577474 20251122181459_89X99 NL000D 2025-11-24T14:08:44.469Z 2025-12-01T15:18:51.392Z
8577034 8577034 20251122170911_cq0ht NL000D 2025-11-24T14:07:23.625Z 2025-12-01T15:18:42.668Z
8574029 8574029 20251122050032_22bWk NL000D 2025-11-23T14:42:12.323Z 2025-11-30T15:06:55.795Z
8572546 8572546 20251122010917_f1VqY NL000D 2025-11-23T14:39:30.660Z 2025-11-23T14:39:30.660Z
8571980 8571980 20251121230600_HgsHy NL000D 2025-11-23T14:37:53.346Z 2025-11-30T15:05:29.662Z
8568548 8568548 20251121052355_CxdgJ NL000D 2025-11-23T14:31:12.536Z 2025-11-29T14:54:46.951Z
8568529 8568529 20251121052231_V2VIp NL000D 2025-11-23T14:31:11.272Z 2025-11-29T14:54:46.918Z
8567348 8567348 20251122054829_V23eh NL000D 2025-11-23T14:19:34.176Z 2025-11-30T15:07:04.832Z
8567148 8567148 20251122042035_40wsx NL000D 2025-11-23T14:19:00.917Z 2025-11-30T15:06:41.802Z
8567141 8567141 20251122041918_XhRxh NL000D 2025-11-23T14:19:00.282Z 2025-11-30T15:06:41.592Z
8567072 8567072 20251122035833_BqiSB NL000D 2025-11-23T14:18:40.568Z 2025-11-30T15:06:36.360Z
8566607 8566607 20251122012804_Tqh3j NL000D 2025-11-23T14:16:41.347Z 2025-11-30T15:05:54.940Z
8566419 8566419 20251122003320_GJzSM NL000D 2025-11-23T14:16:07.339Z 2025-11-30T15:05:47.851Z
8566321 8566321 20251122000856_g1ZCm NL000D 2025-11-23T14:15:47.163Z 2025-11-23T14:15:47.163Z
8566242 8566242 20251121234343_86rE3 NL000D 2025-11-23T14:15:34.412Z 2025-11-30T15:05:39.367Z
8566196 8566196 20251121233020_d0OyW NL000D 2025-11-23T14:15:27.159Z 2025-11-30T15:05:36.469Z
8566053 8566053 20251121223246_QgUuC NL000D 2025-11-23T14:14:56.348Z 2025-11-30T15:05:20.582Z
8566018 8566018 20251121222612_GZD0L NL000D 2025-11-23T14:14:52.824Z 2025-11-30T15:05:20.196Z
8565990 8565990 20251121221846_tXaHJ NL000D 2025-11-23T14:14:48.462Z 2025-11-30T15:05:19.963Z
8565818 8565818 20251121213241_gvwr9 NL000D 2025-11-23T14:14:18.919Z 2025-11-30T15:05:11.120Z
8565808 8565808 20251121212402_5gpbK NL000D 2025-11-23T14:14:17.303Z 2025-11-30T15:05:10.561Z
8565739 8565739 20251121210823_1yJkc NL000D 2025-11-23T14:13:58.600Z 2025-11-30T15:05:08.182Z
8565536 8565536 20251121204528_VwAch NL000D 2025-11-23T14:13:38.642Z 2025-11-30T15:05:05.533Z
8565353 8565353 20251121202126_B1yi8 NL000D 2025-11-23T14:13:11.229Z 2025-11-30T15:04:55.095Z
8560377 8560377 20251121045143_ThsSE NL000D 2025-11-22T14:42:51.491Z 2025-11-29T14:54:45.647Z
8560328 8560328 20251121045030_Kjkz8 NL000D 2025-11-22T14:42:50.946Z 2025-11-29T14:54:45.600Z
8559034 8559034 20251121035047_QELEI NL000D 2025-11-22T14:41:44.387Z 2025-11-29T14:54:37.004Z
8558665 8558665 20251121033710_j7YvW NL000D 2025-11-22T14:41:09.591Z 2025-11-29T14:54:36.513Z
8557729 8557729 20251121025704_rG4tz NL000D 2025-11-22T14:40:37.933Z 2025-11-29T14:54:34.512Z
8557702 8557702 20251121025610_HR8eX NL000D 2025-11-22T14:40:37.415Z 2025-11-29T14:54:34.484Z
8557016 8557016 20251121022756_VWrMN NL000D 2025-11-22T14:39:49.553Z 2025-11-29T14:54:33.332Z
8556125 8556125 20251121013902_2bUBx NL000D 2025-11-22T14:39:02.815Z 2025-11-29T14:54:31.847Z
8556114 8556114 20251121013819_IGi5F NL000D 2025-11-22T14:39:02.335Z 2025-11-29T14:54:31.841Z
8556107 8556107 20251121013732_bGR2P NL000D 2025-11-22T14:39:02.094Z 2025-11-29T14:54:31.809Z
8536870 8536870 20251120052758_0nULU NL000D 2025-11-21T14:19:14.058Z 2025-11-28T14:58:02.049Z
8536818 8536818 20251120051609_5aD8C NL000D 2025-11-21T14:19:09.804Z 2025-11-28T14:57:58.864Z
8536756 8536756 20251120050700_TO3Uq NL000D 2025-11-21T14:18:57.712Z 2025-11-28T14:57:50.702Z
8536706 8536706 20251120050131_zRyWe NL000D 2025-11-21T14:18:52.333Z 2025-11-28T14:57:49.740Z
8536694 8536694 20251120045937_eHw8u NL000D 2025-11-21T14:18:51.144Z 2025-11-28T14:57:48.687Z
8536512 8536512 20251120042830_3mxyA NL000D 2025-11-21T14:18:26.442Z 2025-11-28T14:57:40.198Z
8536425 8536425 20251120042030_Dh3q3 NL000D 2025-11-21T14:18:15.686Z 2025-11-28T14:57:37.233Z
8536414 8536414 20251120041928_213Dw NL000D 2025-11-21T14:18:14.093Z 2025-11-28T14:57:35.806Z
8536169 8536169 20251120034441_lmJwi NL000D 2025-11-21T14:17:43.051Z 2025-11-28T14:57:26.125Z
8535810 8535810 20251120030324_M24Mx NL000D 2025-11-21T14:17:01.251Z 2025-11-28T14:57:05.249Z
8535200 8535200 20251120012950_TBa17 NL000D 2025-11-21T14:15:29.848Z 2025-11-28T14:56:21.765Z
8535135 8535135 20251120011731_gEuOy NL000D 2025-11-21T14:15:20.450Z 2025-11-28T14:56:18.305Z
8534908 8534908 20251120004252_2hDSU NL000D 2025-11-21T14:14:50.251Z 2025-11-28T14:56:05.883Z
8506270 8506270 20251117211638_W6xmJ NL000D 2025-11-19T14:12:31.616Z 2025-11-26T15:07:41.225Z
8505406 8505406 20251117201122_6mmHb NL000D 2025-11-19T14:10:22.081Z 2025-11-26T15:07:38.357Z
8505279 8505279 20251117200154_Etvos NL000D 2025-11-19T14:09:55.320Z 2025-11-26T15:07:37.877Z
8505261 8505261 20251117195957_hQh8L NL000D 2025-11-19T14:09:49.786Z 2025-11-26T15:07:37.749Z
8491465 8491465 20251116223449_OSSw3 NL000D 2025-11-18T14:17:32.402Z 2025-11-25T15:08:37.617Z
8491420 8491420 20251116223020_lv8I3 NL000D 2025-11-18T14:17:27.872Z 2025-11-25T15:08:37.429Z
8491411 8491411 20251116222810_ji4h2 NL000D 2025-11-18T14:17:18.586Z 2025-11-25T15:08:37.358Z
8491310 8491310 20251116221300_jJ2Nz NL000D 2025-11-18T14:17:02.808Z 2025-11-25T15:08:36.518Z
8491248 8491248 20251116220341_iu4Iq NL000D 2025-11-18T14:16:56.032Z 2025-11-25T15:08:35.215Z
8489544 8489544 20251116165623_7rXqX NL000D 2025-11-18T14:10:33.031Z 2025-11-25T15:07:31.251Z
8449628 8449628 20251113023516_vQJAj NL000D 2025-11-14T14:21:01.796Z 2025-11-21T15:12:10.885Z
8449313 8449313 20251113014851_uZvlR NL000D 2025-11-14T14:20:11.719Z 2025-11-21T15:11:58.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