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

696 rows where station_code = "NL001D" 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
9616579 9616579 20260406032411_3oey6 NL001D 2026-04-07T12:13:04.967Z 2026-04-07T12:13:20.008Z
9616353 9616353 20260406025434_9V0Jo NL001D 2026-04-07T12:12:39.469Z 2026-04-07T12:13:19.966Z
9615162 9615162 20260406004306_u3NKS NL001D 2026-04-07T12:10:06.786Z 2026-04-07T12:13:19.745Z
9614870 9614870 20260406000302_xhwtS NL001D 2026-04-07T12:09:32.488Z 2026-04-07T12:13:19.690Z
9614682 9614682 20260405234027_5jA6N NL001D 2026-04-07T12:09:15.171Z 2026-04-07T12:13:19.655Z
9614558 9614558 20260405232304_EM1od NL001D 2026-04-07T12:08:56.860Z 2026-04-07T12:13:19.627Z
9614294 9614294 20260405224800_sPE6A NL001D 2026-04-07T12:08:21.366Z 2026-04-07T12:13:19.566Z
9613623 9613623 20260405205750_02Xdu NL001D 2026-04-07T12:07:00.185Z 2026-04-07T12:13:19.422Z
9610758 9610758 20260404213457_0163z NL001D 2026-04-06T12:11:06.265Z 2026-04-07T12:15:32.198Z
9610465 9610465 20260404193517_qlWfQ NL001D 2026-04-06T12:09:38.553Z 2026-04-07T12:15:10.990Z
9610463 9610463 20260404193402_L3lDZ NL001D 2026-04-06T12:09:38.103Z 2026-04-07T12:15:10.856Z
9606904 9606904 20260402232610_HFsQe NL001D 2026-04-04T12:12:12.668Z 2026-04-07T12:20:20.638Z
9606862 9606862 20260402223238_qUaOW NL001D 2026-04-04T12:12:00.865Z 2026-04-07T12:20:19.525Z
9604620 9604620 20260401222546_tSaq9 NL001D 2026-04-03T12:10:53.126Z 2026-04-07T12:21:45.382Z
9604544 9604544 20260401200430_6kkzX NL001D 2026-04-03T12:10:17.719Z 2026-04-07T12:21:29.787Z
9602624 9602624 20260401002923_rG5lq NL001D 2026-04-02T12:09:34.094Z 2026-04-07T12:23:37.845Z
9602595 9602595 20260401000712_RdLYq NL001D 2026-04-02T12:09:28.298Z 2026-04-07T12:23:36.880Z
9602540 9602540 20260331225035_xScKY NL001D 2026-04-02T12:09:15.858Z 2026-04-07T12:23:35.388Z
9602428 9602428 20260331210253_XeLVR NL001D 2026-04-02T12:08:48.201Z 2026-04-07T12:23:31.368Z
9600665 9600665 20260331003526_NLeSm NL001D 2026-04-01T12:11:26.341Z 2026-04-07T12:26:22.277Z
9600642 9600642 20260331002827_jT6np NL001D 2026-04-01T12:11:23.812Z 2026-04-07T12:26:20.970Z
9600597 9600597 20260330235216_p6Wok NL001D 2026-04-01T12:11:17.125Z 2026-04-07T12:26:09.001Z
9600331 9600331 20260330202024_V4uPV NL001D 2026-04-01T12:10:18.585Z 2026-04-07T12:25:59.891Z
9594698 9594698 20260329000212_xAdLc NL001D 2026-03-30T12:10:10.884Z 2026-04-06T12:40:04.283Z
9592679 9592679 20260329025813_8C8IN NL001D 2026-03-30T12:01:35.876Z 2026-04-07T12:26:38.330Z
9592252 9592252 20260329013057_qnvgD NL001D 2026-03-30T12:00:28.586Z 2026-04-07T12:26:29.338Z
9588656 9588656 20260327001951_hy6cn NL001D 2026-03-28T12:11:32.179Z 2026-04-04T12:42:24.838Z
9588646 9588646 20260327001518_4WhTd NL001D 2026-03-28T12:11:30.379Z 2026-04-04T12:42:23.505Z
9588583 9588583 20260326235948_9MaIy NL001D 2026-03-28T12:11:25.124Z 2026-04-04T12:42:20.079Z
9588370 9588370 20260326221051_qx3oy NL001D 2026-03-28T12:10:57.462Z 2026-04-04T12:42:01.729Z
9588361 9588361 20260326220608_42qt5 NL001D 2026-03-28T12:10:56.611Z 2026-04-04T12:42:01.028Z
9586140 9586140 20260327041211_gqO6Q NL001D 2026-03-28T12:02:20.220Z 2026-04-05T12:33:03.319Z
9586052 9586052 20260327034230_YuBum NL001D 2026-03-28T12:02:03.430Z 2026-04-05T12:32:58.358Z
9585642 9585642 20260327020038_UY0F5 NL001D 2026-03-28T12:00:52.583Z 2026-04-05T12:32:31.410Z
9585635 9585635 20260327015907_izhST NL001D 2026-03-28T12:00:51.464Z 2026-04-05T12:32:31.103Z
9585520 9585520 20260327012552_uYmTC NL001D 2026-03-28T12:00:33.448Z 2026-04-05T12:32:24.898Z
9585214 9585214 20260325234131_RxOFn NL001D 2026-03-27T12:16:54.602Z 2026-04-03T12:39:51.490Z
9585156 9585156 20260325233612_zhY96 NL001D 2026-03-27T12:16:52.069Z 2026-04-03T12:39:50.769Z
9585008 9585008 20260325230442_SOTaf NL001D 2026-03-27T12:16:31.667Z 2026-04-03T12:39:46.422Z
9584466 9584466 20260325200003_QUAfH NL001D 2026-03-27T12:15:23.418Z 2026-04-03T12:39:15.315Z
9584365 9584365 20260325192442_jDMxs NL001D 2026-03-27T12:15:05.813Z 2026-04-03T12:39:11.385Z
9581993 9581993 20260326042033_v1mna NL001D 2026-03-27T12:04:21.071Z 2026-04-04T12:39:34.053Z
9581691 9581691 20260326034309_iftVC NL001D 2026-03-27T12:03:40.200Z 2026-04-04T12:39:14.868Z
9581345 9581345 20260326025549_CEFk9 NL001D 2026-03-27T12:02:48.634Z 2026-04-04T12:38:53.604Z
9581132 9581132 20260326022752_oeob8 NL001D 2026-03-27T12:02:12.280Z 2026-04-04T12:38:43.554Z
9579491 9579491 20260324205756_kbHz2 NL001D 2026-03-26T12:13:48.482Z 2026-04-02T12:37:12.352Z
9579485 9579485 20260324205636_VZKOe NL001D 2026-03-26T12:13:48.076Z 2026-04-02T12:37:12.234Z
9571127 9571127 20260322235015_goXdL NL001D 2026-03-24T12:24:22.122Z 2026-03-30T12:30:55.614Z
9571086 9571086 20260322234337_JxgGM NL001D 2026-03-24T12:24:19.292Z 2026-03-30T12:30:54.924Z
9571044 9571044 20260322234050_l23I7 NL001D 2026-03-24T12:24:12.267Z 2026-03-30T12:30:54.408Z
9571004 9571004 20260322233158_JujT6 NL001D 2026-03-24T12:24:08.384Z 2026-03-30T12:30:53.486Z
9570835 9570835 20260322225748_6QmCJ NL001D 2026-03-24T12:23:53.208Z 2026-03-30T12:30:50.099Z
9570774 9570774 20260322224431_rnptg NL001D 2026-03-24T12:23:48.087Z 2026-03-30T12:30:49.200Z
9570609 9570609 20260322221453_3o1mf NL001D 2026-03-24T12:23:31.994Z 2026-03-30T12:30:46.499Z
9570541 9570541 20260322215845_4KDqP NL001D 2026-03-24T12:23:26.120Z 2026-03-30T12:30:45.085Z
9570433 9570433 20260322212030_xD6bM NL001D 2026-03-24T12:23:16.728Z 2026-03-30T12:30:42.878Z
9561780 9561780 20260323004250_nt4mR NL001D 2026-03-24T12:01:16.756Z 2026-03-31T12:25:53.580Z
9561682 9561682 20260323002329_QGc7Q NL001D 2026-03-24T12:00:55.129Z 2026-03-31T12:25:50.493Z
9561638 9561638 20260323001657_8Khw0 NL001D 2026-03-24T12:00:45.804Z 2026-03-31T12:25:49.236Z
9561602 9561602 20260323000801_Za15f NL001D 2026-03-24T12:00:36.543Z 2026-03-31T12:25:48.171Z
9561593 9561593 20260323000734_1kj2N NL001D 2026-03-24T12:00:34.480Z 2026-03-31T12:25:47.970Z
9561543 9561543 20260323000004_zC8BS NL001D 2026-03-24T12:00:22.848Z 2026-03-31T12:25:46.467Z
9561203 9561203 20260321230744_h8e9X NL001D 2026-03-23T12:12:13.527Z 2026-03-29T12:21:05.615Z
9561047 9561047 20260321225010_vu6n6 NL001D 2026-03-23T12:12:10.515Z 2026-03-29T12:21:04.846Z
9560932 9560932 20260321223642_dXnNm NL001D 2026-03-23T12:12:07.807Z 2026-03-29T12:21:04.000Z
9560922 9560922 20260321223550_Hu8tJ NL001D 2026-03-23T12:12:07.466Z 2026-03-29T12:21:03.954Z
9560836 9560836 20260321222304_2QR88 NL001D 2026-03-23T12:12:05.011Z 2026-03-29T12:21:03.277Z
9559968 9559968 20260321201412_gHMEB NL001D 2026-03-23T12:11:34.739Z 2026-03-29T12:20:56.926Z
9559888 9559888 20260321200509_N6VhR NL001D 2026-03-23T12:11:33.127Z 2026-03-29T12:20:56.323Z
9559662 9559662 20260321190607_2gtNw NL001D 2026-03-23T12:11:25.700Z 2026-03-29T12:20:42.388Z
9559636 9559636 20260321185352_w5IsK NL001D 2026-03-23T12:11:16.503Z 2026-03-29T12:20:42.255Z
9555194 9555194 20260322041526_M4ZUD NL001D 2026-03-23T12:03:14.563Z 2026-03-30T12:28:22.718Z
9554980 9554980 20260322035044_PdnVZ NL001D 2026-03-23T12:02:59.926Z 2026-03-30T12:28:12.541Z
9554555 9554555 20260322031711_5yTOv NL001D 2026-03-23T12:02:40.268Z 2026-03-30T12:28:05.480Z
9554449 9554449 20260322030910_I2SDS NL001D 2026-03-23T12:02:32.243Z 2026-03-30T12:28:03.920Z
9553954 9553954 20260322022843_vfHOv NL001D 2026-03-23T12:02:03.112Z 2026-03-30T12:27:55.867Z
9553872 9553872 20260322022244_sv0Ew NL001D 2026-03-23T12:01:56.595Z 2026-03-30T12:27:53.901Z
9553823 9553823 20260322021812_T2p2n NL001D 2026-03-23T12:01:53.546Z 2026-03-30T12:27:53.071Z
9553685 9553685 20260322020554_lI69O NL001D 2026-03-23T12:01:45.807Z 2026-03-30T12:27:50.937Z
9553654 9553654 20260322020438_O7yd1 NL001D 2026-03-23T12:01:45.014Z 2026-03-30T12:27:50.753Z
9553642 9553642 20260322020313_y4SAZ NL001D 2026-03-23T12:01:44.108Z 2026-03-30T12:27:50.455Z
9553150 9553150 20260322012032_vfAuT NL001D 2026-03-23T12:01:15.819Z 2026-03-30T12:27:35.739Z
9553133 9553133 20260322011618_K9C4T NL001D 2026-03-23T12:01:14.637Z 2026-03-30T12:27:35.458Z
9552347 9552347 20260321235439_GTYNI NL001D 2026-03-23T12:00:16.128Z 2026-03-30T12:27:22.592Z
9552044 9552044 20260320224139_70CHs NL001D 2026-03-22T12:27:24.159Z 2026-03-28T12:37:05.840Z
9551872 9551872 20260320220152_n2n3P NL001D 2026-03-22T12:27:14.565Z 2026-03-28T12:37:03.405Z
9551853 9551853 20260320215416_ffGe4 NL001D 2026-03-22T12:27:06.694Z 2026-03-28T12:37:02.972Z
9551794 9551794 20260320213533_UPiCe NL001D 2026-03-22T12:27:03.087Z 2026-03-28T12:37:02.197Z
9551548 9551548 20260320201659_2rpui NL001D 2026-03-22T12:26:47.222Z 2026-03-28T12:36:57.831Z
9551214 9551214 20260320185614_BOyWZ NL001D 2026-03-22T12:26:18.475Z 2026-03-28T12:36:41.105Z
9551174 9551174 20260320184418_JOSdS NL001D 2026-03-22T12:26:15.139Z 2026-03-28T12:36:40.651Z
9541982 9541982 20260319222116_t0Xbd NL001D 2026-03-21T12:29:33.080Z 2026-03-27T12:42:43.687Z
9541791 9541791 20260319214456_uU7kG NL001D 2026-03-21T12:29:22.324Z 2026-03-27T12:42:41.759Z
9541309 9541309 20260319201449_EDnUq NL001D 2026-03-21T12:28:48.885Z 2026-03-27T12:42:36.343Z
9534770 9534770 20260320041945_OSQ3j NL001D 2026-03-21T12:08:49.647Z 2026-03-28T12:34:21.806Z
9530748 9530748 20260318213456_E3F28 NL001D 2026-03-20T12:24:45.251Z 2026-03-26T12:39:15.198Z
9530685 9530685 20260318212409_OJU2b NL001D 2026-03-20T12:24:35.699Z 2026-03-26T12:39:14.800Z
9530448 9530448 20260318205445_JClmV NL001D 2026-03-20T12:24:24.033Z 2026-03-26T12:39:12.380Z
9530350 9530350 20260318204026_8UqXH NL001D 2026-03-20T12:24:19.013Z 2026-03-26T12:39:11.399Z
9521124 9521124 20260319035420_P0a93 NL001D 2026-03-20T12:07:32.749Z 2026-03-27T12:40:51.803Z

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