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,221 rows where station_code = "NL0014" 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
9610706 9610706 20260404211603_xCj14 NL0014 2026-04-06T12:10:48.832Z 2026-04-06T12:16:14.639Z
9610526 9610526 20260404201007_vl2cZ NL0014 2026-04-06T12:09:55.379Z 2026-04-06T12:16:14.589Z
9608972 9608972 20260404025347_eRTaC NL0014 2026-04-05T12:12:25.969Z 2026-04-06T12:20:54.236Z
9608940 9608940 20260404024202_4sFoR NL0014 2026-04-05T12:12:20.946Z 2026-04-06T12:20:52.148Z
9608900 9608900 20260404022738_0fFHf NL0014 2026-04-05T12:12:10.132Z 2026-04-06T12:20:49.503Z
9608839 9608839 20260404015526_Wza9K NL0014 2026-04-05T12:11:55.059Z 2026-04-06T12:20:42.494Z
9607062 9607062 20260404032332_95tYV NL0014 2026-04-05T12:00:17.704Z 2026-04-06T12:16:14.353Z
9607037 9607037 20260404031701_sYlh2 NL0014 2026-04-05T12:00:11.932Z 2026-04-06T12:16:14.347Z
9607026 9607026 20260404031503_Fs2Xs NL0014 2026-04-05T12:00:10.127Z 2026-04-06T12:16:14.344Z
9606920 9606920 20260403001418_AEbrb NL0014 2026-04-04T12:12:17.690Z 2026-04-06T12:23:56.311Z
9606867 9606867 20260402223325_2Gxhi NL0014 2026-04-04T12:12:01.426Z 2026-04-06T12:23:52.731Z
9606856 9606856 20260402223108_6yAdM NL0014 2026-04-04T12:12:00.212Z 2026-04-06T12:23:52.388Z
9606747 9606747 20260402200327_W4lqa NL0014 2026-04-04T12:11:23.312Z 2026-04-06T12:23:36.702Z
9602496 9602496 20260331215910_kkIk7 NL0014 2026-04-02T12:09:05.238Z 2026-04-06T12:29:14.679Z
9602420 9602420 20260331205730_R4wTt NL0014 2026-04-02T12:08:46.491Z 2026-04-06T12:29:06.938Z
9602334 9602334 20260331195930_uD2u3 NL0014 2026-04-02T12:08:27.285Z 2026-04-06T12:29:00.124Z
9600664 9600664 20260331003526_NLeSm NL0014 2026-04-01T12:11:26.341Z 2026-04-06T12:33:44.519Z
9600640 9600640 20260331002827_jT6np NL0014 2026-04-01T12:11:23.812Z 2026-04-06T12:33:43.592Z
9600595 9600595 20260330235216_p6Wok NL0014 2026-04-01T12:11:17.125Z 2026-04-06T12:33:41.769Z
9600555 9600555 20260330232811_4536b NL0014 2026-04-01T12:11:09.806Z 2026-04-06T12:33:34.112Z
9595339 9595339 20260330034403_LZyQ3 NL0014 2026-03-31T12:01:11.022Z 2026-04-06T12:29:58.777Z
9594970 9594970 20260329010951_3eoM6 NL0014 2026-03-30T12:10:41.898Z 2026-04-06T12:40:21.801Z
9594696 9594696 20260329000212_xAdLc NL0014 2026-03-30T12:10:10.884Z 2026-04-06T12:40:04.283Z
9594536 9594536 20260328225438_TTVmI NL0014 2026-03-30T12:09:46.968Z 2026-04-06T12:39:56.266Z
9594314 9594314 20260328212340_cn3Uy NL0014 2026-03-30T12:09:17.571Z 2026-04-06T12:39:47.746Z
9592872 9592872 20260329034244_1Z986 NL0014 2026-03-30T12:02:10.134Z 2026-04-06T12:34:38.303Z
9592818 9592818 20260329032827_S2Ws6 NL0014 2026-03-30T12:01:59.677Z 2026-04-06T12:34:29.454Z
9592677 9592677 20260329025813_8C8IN NL0014 2026-03-30T12:01:35.876Z 2026-04-06T12:34:20.719Z
9592418 9592418 20260329020446_XktRM NL0014 2026-03-30T12:00:56.013Z 2026-04-06T12:34:09.834Z
9592250 9592250 20260329013057_qnvgD NL0014 2026-03-30T12:00:28.586Z 2026-04-06T12:33:55.260Z
9588715 9588715 20260327003856_QNjg8 NL0014 2026-03-28T12:11:42.145Z 2026-04-04T12:42:28.726Z
9588697 9588697 20260327003359_Flo3i NL0014 2026-03-28T12:11:39.648Z 2026-04-04T12:42:27.310Z
9588644 9588644 20260327001518_4WhTd NL0014 2026-03-28T12:11:30.379Z 2026-04-04T12:42:23.505Z
9588512 9588512 20260326233120_vAKvo NL0014 2026-03-28T12:11:17.909Z 2026-04-04T12:42:17.224Z
9588449 9588449 20260326230205_812xx NL0014 2026-03-28T12:11:10.890Z 2026-04-04T12:42:08.718Z
9586069 9586069 20260327034702_5heIK NL0014 2026-03-28T12:02:06.535Z 2026-04-05T12:32:59.570Z
9586067 9586067 20260327034702_mBreK NL0014 2026-03-28T12:02:06.212Z 2026-04-05T12:32:59.451Z
9585999 9585999 20260327032608_DuYDC NL0014 2026-03-28T12:01:55.845Z 2026-04-05T12:32:55.903Z
9585936 9585936 20260327031251_WacC3 NL0014 2026-03-28T12:01:46.783Z 2026-04-05T12:32:53.534Z
9585460 9585460 20260327010511_whLpo NL0014 2026-03-28T12:00:24.255Z 2026-04-05T12:32:22.292Z
9585155 9585155 20260325233612_zhY96 NL0014 2026-03-27T12:16:52.069Z 2026-04-03T12:39:50.769Z
9581797 9581797 20260326035814_pp7M1 NL0014 2026-03-27T12:03:52.134Z 2026-04-04T12:39:20.842Z
9581689 9581689 20260326034309_iftVC NL0014 2026-03-27T12:03:40.200Z 2026-04-04T12:39:14.868Z
9581647 9581647 20260326033758_T26bI NL0014 2026-03-27T12:03:32.612Z 2026-04-04T12:39:13.053Z
9581394 9581394 20260326030633_35KhE NL0014 2026-03-27T12:02:58.049Z 2026-04-04T12:38:59.426Z
9580440 9580440 20260326004903_ad8O8 NL0014 2026-03-27T12:00:29.743Z 2026-04-04T12:38:10.479Z
9580436 9580436 20260326004832_GtcCp NL0014 2026-03-27T12:00:29.238Z 2026-04-04T12:38:10.307Z
9576764 9576764 20260325030614_56Gur NL0014 2026-03-26T12:03:14.498Z 2026-04-03T12:36:20.434Z
9576653 9576653 20260325024755_VEulJ NL0014 2026-03-26T12:02:54.609Z 2026-04-03T12:36:16.006Z
9575498 9575498 20260323224923_rsav4 NL0014 2026-03-25T12:21:16.367Z 2026-03-31T12:29:00.208Z
9571055 9571055 20260322234137_9BaGC NL0014 2026-03-24T12:24:17.310Z 2026-03-30T12:30:54.503Z
9571003 9571003 20260322233158_JujT6 NL0014 2026-03-24T12:24:08.384Z 2026-03-30T12:30:53.486Z
9570773 9570773 20260322224431_rnptg NL0014 2026-03-24T12:23:48.087Z 2026-03-30T12:30:49.200Z
9570608 9570608 20260322221453_3o1mf NL0014 2026-03-24T12:23:31.994Z 2026-03-30T12:30:46.499Z
9570028 9570028 20260322185633_z5TLd NL0014 2026-03-24T12:22:29.116Z 2026-03-30T12:30:26.592Z
9570002 9570002 20260322184945_EgZgT NL0014 2026-03-24T12:22:27.100Z 2026-03-30T12:30:26.153Z
9563015 9563015 20260323043655_3IF8K NL0014 2026-03-24T12:04:45.066Z 2026-03-31T12:26:32.351Z
9561101 9561101 20260321225934_2dPts NL0014 2026-03-23T12:12:11.662Z 2026-03-29T12:21:05.177Z
9560354 9560354 20260321210438_JJSij NL0014 2026-03-23T12:11:43.548Z 2026-03-29T12:20:59.399Z
9560257 9560257 20260321205343_Me3eg NL0014 2026-03-23T12:11:40.750Z 2026-03-29T12:20:58.798Z
9559967 9559967 20260321201412_gHMEB NL0014 2026-03-23T12:11:34.739Z 2026-03-29T12:20:56.926Z
9553467 9553467 20260322014425_Q27EY NL0014 2026-03-23T12:01:31.924Z 2026-03-30T12:27:41.631Z
9553251 9553251 20260322012655_ReWmP NL0014 2026-03-23T12:01:21.026Z 2026-03-30T12:27:38.460Z
9552959 9552959 20260322010017_GFoUW NL0014 2026-03-23T12:01:03.770Z 2026-03-30T12:27:32.969Z
9552851 9552851 20260322004749_guUI9 NL0014 2026-03-23T12:00:55.840Z 2026-03-30T12:27:31.253Z
9552784 9552784 20260322004038_b0imP NL0014 2026-03-23T12:00:50.940Z 2026-03-30T12:27:30.027Z
9552482 9552482 20260322001403_rxqrC NL0014 2026-03-23T12:00:28.269Z 2026-03-30T12:27:24.925Z
9551720 9551720 20260320211045_3l4pi NL0014 2026-03-22T12:26:58.394Z 2026-03-28T12:37:00.912Z
9541130 9541130 20260319193504_uztRY NL0014 2026-03-21T12:28:37.970Z 2026-03-27T12:42:34.332Z
9532125 9532125 20260320002124_DvXkE NL0014 2026-03-21T12:01:46.577Z 2026-03-28T12:33:24.777Z
9531440 9531440 20260318231007_rV0hY NL0014 2026-03-20T12:25:10.605Z 2026-03-26T12:39:19.373Z
9529596 9529596 20260318185757_cFbOQ NL0014 2026-03-20T12:23:20.391Z 2026-03-26T12:39:04.698Z
9519012 9519012 20260319014102_FQWMo NL0014 2026-03-20T12:03:46.342Z 2026-03-27T12:40:17.248Z
9518624 9518624 20260319011406_2opwi NL0014 2026-03-20T12:03:00.770Z 2026-03-27T12:40:12.061Z
9518462 9518462 20260319010227_0Uk7V NL0014 2026-03-20T12:02:37.630Z 2026-03-27T12:40:10.072Z
9507084 9507084 20260316201628_kRd20 NL0014 2026-03-18T12:19:51.373Z 2026-03-24T12:41:39.003Z
9494420 9494420 20260316021404_9swTC NL0014 2026-03-17T12:03:56.394Z 2026-03-24T12:40:47.510Z
9494195 9494195 20260316013922_p8G5l NL0014 2026-03-17T12:03:17.772Z 2026-03-24T12:40:45.141Z
9492865 9492865 20260314220548_V9129 NL0014 2026-03-16T12:29:06.608Z 2026-03-22T12:42:55.463Z
9492743 9492743 20260314215108_33wmS NL0014 2026-03-16T12:29:00.460Z 2026-03-22T12:42:54.191Z
9492741 9492741 20260314215108_VZUFS NL0014 2026-03-16T12:29:00.319Z 2026-03-22T12:42:54.189Z
9492728 9492728 20260314214835_WjBQX NL0014 2026-03-16T12:28:59.858Z 2026-03-22T12:42:54.182Z
9492674 9492674 20260314213459_cvITG NL0014 2026-03-16T12:28:55.531Z 2026-03-22T12:42:53.817Z
9492345 9492345 20260314203021_u2XzL NL0014 2026-03-16T12:28:27.040Z 2026-03-22T12:42:51.856Z
9485753 9485753 20260315035039_pCdi0 NL0014 2026-03-16T12:07:31.150Z 2026-03-23T12:21:53.749Z
9485363 9485363 20260315025650_GeSg8 NL0014 2026-03-16T12:06:09.855Z 2026-03-23T12:21:51.406Z
9485135 9485135 20260315023407_eP7vK NL0014 2026-03-16T12:05:24.941Z 2026-03-23T12:21:50.163Z
9484890 9484890 20260315015358_uU23M NL0014 2026-03-16T12:04:30.903Z 2026-03-23T12:21:48.822Z
9484861 9484861 20260315015119_WWC22 NL0014 2026-03-16T12:04:24.480Z 2026-03-23T12:21:48.714Z
9484652 9484652 20260315011932_maSU8 NL0014 2026-03-16T12:03:37.901Z 2026-03-23T12:21:47.676Z
9483835 9483835 20260314231937_pU0Lg NL0014 2026-03-16T12:00:49.760Z 2026-03-23T12:21:44.225Z
9467694 9467694 20260311223503_CPOLX NL0014 2026-03-13T12:19:41.901Z 2026-03-19T12:45:54.275Z
9467595 9467595 20260311221931_eY5E8 NL0014 2026-03-13T12:19:34.031Z 2026-03-19T12:45:53.647Z
9464387 9464387 20260312044110_TlaQj NL0014 2026-03-13T12:07:08.262Z 2026-03-20T12:36:39.748Z
9463929 9463929 20260312030627_ZvHJy NL0014 2026-03-13T12:05:40.049Z 2026-03-20T12:36:25.694Z
9460802 9460802 20260310222745_367Xi NL0014 2026-03-12T12:15:08.905Z 2026-03-18T12:40:19.687Z
9460401 9460401 20260310190638_SPVks NL0014 2026-03-12T12:14:01.283Z 2026-03-18T12:39:56.496Z
9457143 9457143 20260311024450_8DqE2 NL0014 2026-03-12T12:02:59.339Z 2026-03-19T12:44:29.156Z
9456797 9456797 20260311010109_9lnue NL0014 2026-03-12T12:01:49.042Z 2026-03-19T12:44:22.096Z
9456680 9456680 20260311002307_wPJ4Z NL0014 2026-03-12T12:01:24.408Z 2026-03-19T12:44:20.791Z

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