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

6,475 rows where station_code = "NL000S" 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
9610659 9610659 20260404210147_Z9H47 NL000S 2026-04-06T12:10:36.152Z 2026-04-06T12:16:14.628Z
9607061 9607061 20260404032332_95tYV NL000S 2026-04-05T12:00:17.704Z 2026-04-06T12:16:14.353Z
9607025 9607025 20260404031503_Fs2Xs NL000S 2026-04-05T12:00:10.127Z 2026-04-06T12:16:14.344Z
9607023 9607023 20260404031435_YxiA9 NL000S 2026-04-05T12:00:09.613Z 2026-04-06T12:16:14.343Z
9606887 9606887 20260402230334_OUfjW NL000S 2026-04-04T12:12:09.671Z 2026-04-06T12:23:54.090Z
9606859 9606859 20260402223238_qUaOW NL000S 2026-04-04T12:12:00.865Z 2026-04-06T12:23:52.588Z
9606821 9606821 20260402215753_s7zu2 NL000S 2026-04-04T12:11:50.588Z 2026-04-06T12:23:46.944Z
9606794 9606794 20260402211737_9XdBF NL000S 2026-04-04T12:11:44.067Z 2026-04-06T12:23:44.638Z
9602416 9602416 20260331205730_R4wTt NL000S 2026-04-02T12:08:46.491Z 2026-04-06T12:29:06.938Z
9602332 9602332 20260331195930_uD2u3 NL000S 2026-04-02T12:08:27.285Z 2026-04-06T12:29:00.124Z
9602298 9602298 20260331193105_S3xh0 NL000S 2026-04-02T12:08:14.975Z 2026-04-06T12:28:56.517Z
9600742 9600742 20260331014031_oQZdI NL000S 2026-04-01T12:11:42.308Z 2026-04-06T12:33:49.206Z
9600706 9600706 20260331011928_ptMGM NL000S 2026-04-01T12:11:35.759Z 2026-04-06T12:33:46.924Z
9600638 9600638 20260331002827_jT6np NL000S 2026-04-01T12:11:23.812Z 2026-04-06T12:33:43.592Z
9600534 9600534 20260330231507_dyALT NL000S 2026-04-01T12:11:06.412Z 2026-04-06T12:33:32.933Z
9598648 9598648 20260331020814_gYzu9 NL000S 2026-04-01T12:00:20.023Z 2026-04-06T12:26:41.883Z
9595405 9595405 20260330035314_jVK2Q NL000S 2026-03-31T12:01:18.233Z 2026-04-06T12:30:01.473Z
9595338 9595338 20260330034403_LZyQ3 NL000S 2026-03-31T12:01:11.017Z 2026-04-06T12:29:58.777Z
9594750 9594750 20260329001956_qyu25 NL000S 2026-03-30T12:10:16.334Z 2026-04-06T12:40:14.927Z
9592931 9592931 20260329035703_P44A8 NL000S 2026-03-30T12:02:21.298Z 2026-04-06T12:34:41.034Z
9592756 9592756 20260329031840_e4453 NL000S 2026-03-30T12:01:51.852Z 2026-04-06T12:34:27.024Z
9592655 9592655 20260329025213_RIUhu NL000S 2026-03-30T12:01:32.110Z 2026-04-06T12:34:19.648Z
9592592 9592592 20260329024143_23nD4 NL000S 2026-03-30T12:01:23.610Z 2026-04-06T12:34:16.773Z
9592475 9592475 20260329021403_F6y2Y NL000S 2026-03-30T12:01:04.506Z 2026-04-06T12:34:11.927Z
9592417 9592417 20260329020446_XktRM NL000S 2026-03-30T12:00:55.904Z 2026-04-06T12:34:09.834Z
9588705 9588705 20260327003606_g14u1 NL000S 2026-03-28T12:11:40.938Z 2026-04-04T12:42:28.089Z
9588695 9588695 20260327003359_Flo3i NL000S 2026-03-28T12:11:39.648Z 2026-04-04T12:42:27.309Z
9588641 9588641 20260327001518_4WhTd NL000S 2026-03-28T12:11:30.379Z 2026-04-04T12:42:23.505Z
9588508 9588508 20260326233120_vAKvo NL000S 2026-03-28T12:11:17.909Z 2026-04-04T12:42:17.224Z
9588228 9588228 20260326191418_m3GcJ NL000S 2026-03-28T12:10:31.367Z 2026-04-04T12:41:44.182Z
9586149 9586149 20260327041407_d2SbU NL000S 2026-03-28T12:02:20.963Z 2026-04-05T12:33:03.468Z
9586094 9586094 20260327035246_XoxQu NL000S 2026-03-28T12:02:09.471Z 2026-04-05T12:33:00.703Z
9586091 9586091 20260327035116_YDYRS NL000S 2026-03-28T12:02:09.019Z 2026-04-05T12:33:00.541Z
9585995 9585995 20260327032608_DuYDC NL000S 2026-03-28T12:01:55.845Z 2026-04-05T12:32:55.903Z
9585744 9585744 20260327021909_0w3T8 NL000S 2026-03-28T12:01:10.857Z 2026-04-05T12:32:37.195Z
9585736 9585736 20260327021758_IMZG3 NL000S 2026-03-28T12:01:09.805Z 2026-04-05T12:32:36.811Z
9585689 9585689 20260327020620_NlvMa NL000S 2026-03-28T12:01:01.294Z 2026-04-05T12:32:34.821Z
9585422 9585422 20260327005601_knKzP NL000S 2026-03-28T12:00:17.082Z 2026-04-05T12:32:20.503Z
9584907 9584907 20260325223638_TISB1 NL000S 2026-03-27T12:16:20.967Z 2026-04-03T12:39:43.844Z
9584901 9584901 20260325223534_11onj NL000S 2026-03-27T12:16:19.641Z 2026-04-03T12:39:43.593Z
9584513 9584513 20260325202431_Xo8ST NL000S 2026-03-27T12:15:32.709Z 2026-04-03T12:39:17.963Z
9584449 9584449 20260325195303_tIzNB NL000S 2026-03-27T12:15:19.810Z 2026-04-03T12:39:14.272Z
9581800 9581800 20260326035815_XoEgE NL000S 2026-03-27T12:03:52.484Z 2026-04-04T12:39:20.899Z
9580423 9580423 20260326004711_amF5Y NL000S 2026-03-27T12:00:26.650Z 2026-04-04T12:38:09.709Z
9579419 9579419 20260324201635_owyyC NL000S 2026-03-26T12:13:37.322Z 2026-04-02T12:37:08.988Z
9579381 9579381 20260324193243_w9JFi NL000S 2026-03-26T12:13:31.070Z 2026-04-02T12:37:07.144Z
9576763 9576763 20260325030614_56Gur NL000S 2026-03-26T12:03:14.486Z 2026-04-03T12:36:20.434Z
9571051 9571051 20260322234137_9BaGC NL000S 2026-03-24T12:24:17.310Z 2026-03-30T12:30:54.503Z
9570999 9570999 20260322233158_JujT6 NL000S 2026-03-24T12:24:08.384Z 2026-03-30T12:30:53.486Z
9570920 9570920 20260322231244_Uxn7f NL000S 2026-03-24T12:24:01.990Z 2026-03-30T12:30:52.100Z
9570899 9570899 20260322231005_coHTS NL000S 2026-03-24T12:23:59.685Z 2026-03-30T12:30:51.638Z
9570671 9570671 20260322222738_W2y1Z NL000S 2026-03-24T12:23:37.289Z 2026-03-30T12:30:47.497Z
9570642 9570642 20260322222139_xAiO7 NL000S 2026-03-24T12:23:34.543Z 2026-03-30T12:30:46.963Z
9570636 9570636 20260322222138_mP8SW NL000S 2026-03-24T12:23:34.164Z 2026-03-30T12:30:46.856Z
9570473 9570473 20260322213644_7L7Qd NL000S 2026-03-24T12:23:20.214Z 2026-03-30T12:30:43.751Z
9561969 9561969 20260323010244_khoc4 NL000S 2026-03-24T12:01:43.550Z 2026-03-31T12:25:57.712Z
9561819 9561819 20260323004819_Mw2w6 NL000S 2026-03-24T12:01:23.671Z 2026-03-31T12:25:54.290Z
9561704 9561704 20260323002948_We2MB NL000S 2026-03-24T12:01:00.325Z 2026-03-31T12:25:51.354Z
9561437 9561437 20260321233329_G93HJ NL000S 2026-03-23T12:12:19.131Z 2026-03-29T12:21:07.293Z
9561280 9561280 20260321231513_lJg00 NL000S 2026-03-23T12:12:15.255Z 2026-03-29T12:21:06.054Z
9561177 9561177 20260321230633_kiKa0 NL000S 2026-03-23T12:12:13.143Z 2026-03-29T12:21:05.519Z
9561158 9561158 20260321230401_3NKnS NL000S 2026-03-23T12:12:12.511Z 2026-03-29T12:21:05.388Z
9560911 9560911 20260321223458_dxJO9 NL000S 2026-03-23T12:12:07.212Z 2026-03-29T12:21:03.859Z
9560580 9560580 20260321214324_9VOkg NL000S 2026-03-23T12:11:54.259Z 2026-03-29T12:21:01.554Z
9560255 9560255 20260321205343_Me3eg NL000S 2026-03-23T12:11:40.750Z 2026-03-29T12:20:58.798Z
9554918 9554918 20260322034512_QABB2 NL000S 2026-03-23T12:02:56.765Z 2026-03-30T12:28:11.592Z
9554735 9554735 20260322033229_HP5Fm NL000S 2026-03-23T12:02:48.483Z 2026-03-30T12:28:08.111Z
9554697 9554697 20260322032634_Pam1q NL000S 2026-03-23T12:02:46.629Z 2026-03-30T12:28:07.396Z
9553464 9553464 20260322014425_Q27EY NL000S 2026-03-23T12:01:31.924Z 2026-03-30T12:27:41.631Z
9553426 9553426 20260322014117_GVgdj NL000S 2026-03-23T12:01:29.152Z 2026-03-30T12:27:40.795Z
9553263 9553263 20260322012857_9gMwq NL000S 2026-03-23T12:01:21.857Z 2026-03-30T12:27:38.644Z
9553247 9553247 20260322012655_ReWmP NL000S 2026-03-23T12:01:21.026Z 2026-03-30T12:27:38.460Z
9552946 9552946 20260322005828_C5tI4 NL000S 2026-03-23T12:01:03.034Z 2026-03-30T12:27:32.805Z
9552849 9552849 20260322004749_guUI9 NL000S 2026-03-23T12:00:55.840Z 2026-03-30T12:27:31.253Z
9552780 9552780 20260322004038_b0imP NL000S 2026-03-23T12:00:50.940Z 2026-03-30T12:27:30.027Z
9552679 9552679 20260322003042_iNxJF NL000S 2026-03-23T12:00:42.365Z 2026-03-30T12:27:27.955Z
9552619 9552619 20260322002442_zA5eD NL000S 2026-03-23T12:00:37.803Z 2026-03-30T12:27:27.107Z
9552480 9552480 20260322001403_rxqrC NL000S 2026-03-23T12:00:28.253Z 2026-03-30T12:27:24.925Z
9474296 9474296 20260312222347_XQ7vC NL000S 2026-03-14T12:22:30.935Z 2026-03-20T12:37:17.369Z
9474016 9474016 20260312192452_V4MjO NL000S 2026-03-14T12:21:44.355Z 2026-03-20T12:37:14.597Z
9473971 9473971 20260312183451_EtGr8 NL000S 2026-03-14T12:21:35.329Z 2026-03-20T12:37:13.927Z
9467692 9467692 20260311223503_CPOLX NL000S 2026-03-13T12:19:41.901Z 2026-03-19T12:45:54.275Z
9467461 9467461 20260311214825_hNlJk NL000S 2026-03-13T12:19:16.417Z 2026-03-19T12:45:52.481Z
9467140 9467140 20260311202033_SM3H6 NL000S 2026-03-13T12:18:30.648Z 2026-03-19T12:45:49.035Z
9467076 9467076 20260311195432_Gz3VV NL000S 2026-03-13T12:18:16.690Z 2026-03-19T12:45:47.838Z
9466951 9466951 20260311190535_vNHd1 NL000S 2026-03-13T12:17:46.513Z 2026-03-19T12:45:45.090Z
9464426 9464426 20260312045718_kNWcO NL000S 2026-03-13T12:07:14.124Z 2026-03-20T12:36:40.737Z
9464416 9464416 20260312045413_0l2DO NL000S 2026-03-13T12:07:12.495Z 2026-03-20T12:36:40.632Z
9464400 9464400 20260312045039_24feH NL000S 2026-03-13T12:07:10.229Z 2026-03-20T12:36:40.061Z
9464336 9464336 20260312043022_f2ZSc NL000S 2026-03-13T12:07:00.562Z 2026-03-20T12:36:38.043Z
9464252 9464252 20260312040516_iRJJh NL000S 2026-03-13T12:06:42.811Z 2026-03-20T12:36:34.434Z
9464214 9464214 20260312035947_RcYic NL000S 2026-03-13T12:06:37.802Z 2026-03-20T12:36:33.618Z
9464210 9464210 20260312035712_IaAVJ NL000S 2026-03-13T12:06:37.333Z 2026-03-20T12:36:33.588Z
9464162 9464162 20260312034808_WHC3B NL000S 2026-03-13T12:06:29.821Z 2026-03-20T12:36:31.600Z
9464072 9464072 20260312032933_iBh0P NL000S 2026-03-13T12:06:10.034Z 2026-03-20T12:36:29.035Z
9463837 9463837 20260312025213_H3amn NL000S 2026-03-13T12:05:23.932Z 2026-03-20T12:36:25.214Z
9463702 9463702 20260312022923_awqvx NL000S 2026-03-13T12:04:55.441Z 2026-03-20T12:36:24.178Z
9463577 9463577 20260312020800_duV3a NL000S 2026-03-13T12:04:34.024Z 2026-03-20T12:36:23.436Z
9463555 9463555 20260312020703_A3Pwi NL000S 2026-03-13T12:04:30.714Z 2026-03-20T12:36:23.331Z
9463511 9463511 20260312020356_XUHBI NL000S 2026-03-13T12:04:24.701Z 2026-03-20T12:36:23.049Z

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