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

521 rows where station_code = "NL001E" 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
9260522 9260522 20260125050421_a2SqN NL001E 2026-01-26T14:22:06.111Z 2026-01-29T14:44:19.962Z
9260434 9260434 20260125042637_nAiJH NL001E 2026-01-26T14:21:48.697Z 2026-01-29T14:44:12.827Z
9260397 9260397 20260125041458_dwUA5 NL001E 2026-01-26T14:21:33.905Z 2026-01-29T14:44:10.379Z
9260395 9260395 20260125041336_BrA0G NL001E 2026-01-26T14:21:33.420Z 2026-01-29T14:44:10.223Z
9260391 9260391 20260125041248_zI5DI NL001E 2026-01-26T14:21:32.918Z 2026-01-29T14:44:10.026Z
9249578 9249578 20260122055414_V2Pib NL001E 2026-01-23T14:15:44.495Z 2026-01-29T14:58:45.444Z
9249305 9249305 20260122044217_YKP9m NL001E 2026-01-23T14:15:08.821Z 2026-01-29T14:58:22.551Z
9249125 9249125 20260122034355_aubx7 NL001E 2026-01-23T14:14:38.676Z 2026-01-29T14:58:13.839Z
9249088 9249088 20260122033141_J5gi0 NL001E 2026-01-23T14:14:33.848Z 2026-01-29T14:58:12.229Z
9248721 9248721 20260122015158_dCyzq NL001E 2026-01-23T14:13:31.186Z 2026-01-29T14:57:42.811Z
9248619 9248619 20260122011627_qRyKi NL001E 2026-01-23T14:13:17.007Z 2026-01-29T14:57:37.078Z
9248523 9248523 20260122002733_XnK4C NL001E 2026-01-23T14:12:59.653Z 2026-01-29T14:57:24.794Z
9248461 9248461 20260121235249_Qfz4s NL001E 2026-01-23T14:12:50.729Z 2026-01-29T14:57:19.979Z
9248358 9248358 20260121231158_JwjjD NL001E 2026-01-23T14:12:38.339Z 2026-01-29T14:57:15.481Z
9248346 9248346 20260121230345_jJqKh NL001E 2026-01-23T14:12:33.451Z 2026-01-29T14:57:14.829Z
9247910 9247910 20260121202901_aS980 NL001E 2026-01-23T14:11:26.684Z 2026-01-29T14:56:43.437Z
9237830 9237830 20260120060954_djfcV NL001E 2026-01-21T14:27:44.372Z 2026-01-28T15:01:43.897Z
9237064 9237064 20260120043236_zafHM NL001E 2026-01-21T14:25:10.591Z 2026-01-28T15:00:56.172Z
9236769 9236769 20260120035728_qYVgI NL001E 2026-01-21T14:23:59.809Z 2026-01-28T15:00:33.999Z
9236659 9236659 20260120034451_YgkQV NL001E 2026-01-21T14:23:37.881Z 2026-01-28T15:00:27.904Z
9235347 9235347 20260120005906_mxgN2 NL001E 2026-01-21T14:18:39.577Z 2026-01-28T14:58:50.389Z
9234885 9234885 20260119234549_TisNP NL001E 2026-01-21T14:16:34.856Z 2026-01-28T14:58:18.856Z
9223480 9223480 20260118005132_S8m8V NL001E 2026-01-19T14:19:30.315Z 2026-01-26T15:02:08.405Z
9222993 9222993 20260117220556_WDDnI NL001E 2026-01-19T14:17:14.009Z 2026-01-26T15:01:31.185Z
9222966 9222966 20260117214831_xcy3C NL001E 2026-01-19T14:17:01.346Z 2026-01-26T15:01:30.278Z
9222911 9222911 20260117212137_NS63I NL001E 2026-01-19T14:16:46.176Z 2026-01-26T15:01:25.476Z
9222759 9222759 20260117204337_p2ccW NL001E 2026-01-19T14:16:08.267Z 2026-01-26T15:01:19.897Z
9222138 9222138 20260117182157_PIPIQ NL001E 2026-01-19T14:13:27.483Z 2026-01-26T15:00:41.298Z
9217769 9217769 20260116193922_KhllP NL001E 2026-01-18T14:08:53.902Z 2026-01-25T14:57:47.028Z
9206633 9206633 20260114180039_SHamX NL001E 2026-01-16T14:04:51.679Z 2026-01-22T15:02:32.152Z
9204357 9204357 20260114063012_sQYhw NL001E 2026-01-15T14:27:08.175Z 2026-01-22T15:10:25.378Z
9204352 9204352 20260114062945_Iq2hr NL001E 2026-01-15T14:27:07.044Z 2026-01-22T15:10:25.337Z
9204214 9204214 20260114061616_qhG6f NL001E 2026-01-15T14:26:50.702Z 2026-01-22T15:10:22.516Z
9204019 9204019 20260114060337_Buh3O NL001E 2026-01-15T14:26:16.497Z 2026-01-22T15:10:17.029Z
9203897 9203897 20260114054927_bVuJ5 NL001E 2026-01-15T14:25:48.794Z 2026-01-22T15:10:15.194Z
9203439 9203439 20260114045730_IrTtE NL001E 2026-01-15T14:24:25.844Z 2026-01-22T15:10:07.766Z
9195380 9195380 20260113011524_kroUC NL001E 2026-01-14T14:13:06.653Z 2026-01-21T15:04:39.691Z
9194897 9194897 20260112231929_E2YNK NL001E 2026-01-14T14:11:11.644Z 2026-01-21T15:04:33.781Z
9182334 9182334 20260111050237_vp58F NL001E 2026-01-12T14:14:11.265Z 2026-01-19T15:18:26.628Z
9181642 9181642 20260111022938_sejqQ NL001E 2026-01-12T14:11:35.822Z 2026-01-19T15:17:41.845Z
9181416 9181416 20260111014104_dy3uf NL001E 2026-01-12T14:10:44.635Z 2026-01-19T15:17:17.142Z
9181082 9181082 20260111001338_GuX6D NL001E 2026-01-12T14:09:30.453Z 2026-01-19T15:16:48.170Z
9160382 9160382 20260106054220_7FNPK NL001E 2026-01-07T14:12:26.031Z 2026-01-13T15:09:23.509Z
9160188 9160188 20260106050000_adAZu NL001E 2026-01-07T14:11:40.538Z 2026-01-13T15:09:06.491Z
9159550 9159550 20260106030459_9E5gE NL001E 2026-01-07T14:09:43.038Z 2026-01-13T15:08:30.436Z
9159328 9159328 20260106022154_MxXN2 NL001E 2026-01-07T14:08:59.364Z 2026-01-13T15:08:20.945Z
9158660 9158660 20260105235534_2iv1n NL001E 2026-01-07T14:06:55.171Z 2026-01-13T15:07:41.224Z
9158519 9158519 20260105230124_umtAb NL001E 2026-01-07T14:06:23.532Z 2026-01-13T15:07:26.325Z
9146939 9146939 20260104044923_uBmVZ NL001E 2026-01-05T14:23:18.317Z 2026-01-12T15:09:42.771Z
9144805 9144805 20260104025501_RTyfR NL001E 2026-01-05T14:19:36.416Z 2026-01-12T15:07:17.499Z
9144558 9144558 20260104024843_nGxbo NL001E 2026-01-05T14:19:22.826Z 2026-01-12T15:07:10.323Z
9144505 9144505 20260104024620_2990M NL001E 2026-01-05T14:19:12.154Z 2026-01-12T15:07:08.805Z
9143213 9143213 20260104020112_2M19Y NL001E 2026-01-05T14:17:17.707Z 2026-01-12T15:06:17.795Z
9143209 9143209 20260104020059_SXHx2 NL001E 2026-01-05T14:17:17.656Z 2026-01-12T15:06:17.747Z
9143189 9143189 20260104015955_RsmJ8 NL001E 2026-01-05T14:17:14.609Z 2026-01-12T15:06:16.907Z
9140246 9140246 20260104000635_7RwaY NL001E 2026-01-05T14:12:52.548Z 2026-01-12T15:04:03.107Z
9139980 9139980 20260103235236_ryw5g NL001E 2026-01-05T14:12:20.388Z 2026-01-12T15:03:54.965Z
9137526 9137526 20260103211753_lZeqD NL001E 2026-01-05T14:08:35.929Z 2026-01-12T15:02:13.528Z
9137378 9137378 20260103210741_qnGiN NL001E 2026-01-05T14:08:23.694Z 2026-01-12T15:02:08.737Z
9137369 9137369 20260103210656_GyL7J NL001E 2026-01-05T14:08:22.801Z 2026-01-12T15:02:08.482Z
9137337 9137337 20260103210320_krO29 NL001E 2026-01-05T14:08:20.391Z 2026-01-12T15:02:07.118Z
9127562 9127562 20260102043017_MSrQP NL001E 2026-01-03T14:10:46.110Z 2026-01-09T14:49:58.275Z
9123767 9123767 20251231031331_tuqX1 NL001E 2026-01-02T14:34:54.497Z 2026-01-08T15:08:33.461Z
9123761 9123761 20251231031331_rICd2 NL001E 2026-01-02T14:34:54.124Z 2026-01-08T15:08:33.223Z
9123721 9123721 20251231030827_XSddD NL001E 2026-01-02T14:34:26.470Z 2026-01-08T15:08:20.662Z
9123615 9123615 20251231022317_Bufpg NL001E 2026-01-02T14:32:10.748Z 2026-01-08T15:07:41.048Z
9118769 9118769 20251230060726_XWtp4 NL001E 2026-01-01T14:50:36.378Z 2026-01-07T15:09:47.642Z
9118761 9118761 20251230054952_oMOiS NL001E 2026-01-01T14:50:06.571Z 2026-01-07T15:09:40.630Z
9118721 9118721 20251230045255_O5BJN NL001E 2026-01-01T14:48:18.797Z 2026-01-07T15:09:04.567Z
9118695 9118695 20251230033919_Gqa9B NL001E 2026-01-01T14:45:33.462Z 2026-01-07T15:08:08.823Z
9115736 9115736 20251231052548_rqo7r NL001E 2026-01-01T14:26:18.442Z 2026-01-08T15:11:10.431Z
9114358 9114358 20251231041408_Xt4rm NL001E 2026-01-01T14:22:18.045Z 2026-01-08T15:09:43.881Z
9114201 9114201 20251231040604_3Efb4 NL001E 2026-01-01T14:21:47.764Z 2026-01-08T15:09:29.956Z
9113168 9113168 20251231031331_3w4XJ NL001E 2026-01-01T14:17:47.791Z 2026-01-01T14:57:52.783Z
9113031 9113031 20251231030827_wo8jx NL001E 2026-01-01T14:17:19.236Z 2026-01-08T15:08:20.815Z
9112995 9112995 20251231030440_5Sxv1 NL001E 2026-01-01T14:17:02.953Z 2026-01-08T15:08:16.981Z
9112724 9112724 20251231024848_jAFK3 NL001E 2026-01-01T14:16:07.365Z 2026-01-08T15:08:04.800Z
9112384 9112384 20251231022316_v3thF NL001E 2026-01-01T14:14:55.266Z 2026-01-08T15:07:40.818Z
9112039 9112039 20251231015859_Tug3Q NL001E 2026-01-01T14:13:42.031Z 2026-01-08T15:07:15.111Z
9110014 9110014 20251230220214_G4l2l NL001E 2026-01-01T14:05:23.287Z 2026-01-08T15:04:54.568Z
9110004 9110004 20251230215843_j37B3 NL001E 2026-01-01T14:05:19.235Z 2026-01-08T15:04:53.902Z
9109850 9109850 20251230210604_ZJGro NL001E 2026-01-01T14:04:07.933Z 2026-01-08T15:04:34.305Z
9104384 9104384 20251230054952_9fcvu NL001E 2025-12-31T14:21:04.683Z 2026-01-07T15:09:40.730Z
9103688 9103688 20251230045255_IzgKN NL001E 2025-12-31T14:18:52.697Z 2026-01-07T15:09:04.775Z
9102856 9102856 20251230033919_9mtpg NL001E 2025-12-31T14:15:35.094Z 2026-01-07T15:08:08.693Z
9102738 9102738 20251230032946_zUEA6 NL001E 2025-12-31T14:15:05.278Z 2026-01-07T15:08:02.766Z
9101654 9101654 20251230011337_YNHdk NL001E 2025-12-31T14:09:50.835Z 2026-01-07T15:06:39.990Z
9091715 9091715 20251228194707_nfkB4 NL001E 2025-12-30T14:53:14.198Z 2026-01-05T15:14:24.006Z
9075245 9075245 20251225212018_v10sh NL001E 2025-12-29T15:01:37.439Z 2026-01-02T15:48:47.055Z
9075032 9075032 20251225205755_5lVkS NL001E 2025-12-29T15:01:26.561Z 2026-01-02T15:48:42.838Z
9074149 9074149 20251225191838_FfWA9 NL001E 2025-12-29T15:00:06.271Z 2026-01-02T15:48:08.540Z
9073906 9073906 20251225184253_52Z7h NL001E 2025-12-29T14:59:58.007Z 2025-12-29T14:59:58.007Z
9073699 9073699 20251225181726_sfezT NL001E 2025-12-29T14:59:50.597Z 2026-01-02T15:47:56.466Z
9071277 9071277 20251226181736_RDEEe NL001E 2025-12-29T14:49:05.470Z 2026-01-03T15:42:45.606Z
9066350 9066350 20251226060910_ke3gu NL001E 2025-12-29T14:39:54.152Z 2026-01-03T15:37:47.894Z
9066291 9066291 20251226060437_qPGJs NL001E 2025-12-29T14:39:49.150Z 2026-01-03T15:37:36.441Z
9065600 9065600 20251226051948_WNxig NL001E 2025-12-29T14:38:43.561Z 2026-01-03T15:37:01.869Z
9064408 9064408 20251226040842_KVAnR NL001E 2025-12-29T14:36:50.526Z 2026-01-03T15:36:12.965Z
9063773 9063773 20251226033201_QPVtC NL001E 2025-12-29T14:35:53.900Z 2026-01-03T15:35:39.059Z
9063713 9063713 20251226032932_VSFey NL001E 2025-12-29T14:35:50.298Z 2026-01-03T15:35:36.125Z

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