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

582 rows where station_code = "NL001B" 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
8666340 8666340 20251201051713_EYUAk NL001B 2025-12-02T14:25:48.731Z 2025-12-05T14:36:54.613Z
8666226 8666226 20251201045459_3qvuw NL001B 2025-12-02T14:25:37.868Z 2025-12-05T14:36:43.736Z
8666158 8666158 20251201044323_ppSSz NL001B 2025-12-02T14:25:31.068Z 2025-12-05T14:36:34.515Z
8666117 8666117 20251201043917_PMePB NL001B 2025-12-02T14:25:15.738Z 2025-12-05T14:36:32.729Z
8665791 8665791 20251201035819_LaVH4 NL001B 2025-12-02T14:24:29.386Z 2025-12-05T14:36:19.391Z
8664361 8664361 20251201000912_vihjo NL001B 2025-12-02T14:20:47.566Z 2025-12-05T14:35:01.925Z
8664297 8664297 20251130235927_t00n3 NL001B 2025-12-02T14:20:40.334Z 2025-12-05T14:34:59.973Z
8653518 8653518 20251130022215_i7QWk NL001B 2025-12-01T14:23:38.404Z 2025-12-05T14:43:33.904Z
8652856 8652856 20251130013829_CZP2B NL001B 2025-12-01T14:22:15.201Z 2025-12-05T14:42:54.932Z
8652800 8652800 20251130013445_37MvC NL001B 2025-12-01T14:22:08.061Z 2025-12-05T14:42:52.777Z
8652738 8652738 20251130012929_uoytd NL001B 2025-12-01T14:22:03.094Z 2025-12-05T14:42:51.210Z
8652699 8652699 20251130012749_2v502 NL001B 2025-12-01T14:21:59.736Z 2025-12-05T14:42:50.332Z
8652093 8652093 20251130004542_h3YYY NL001B 2025-12-01T14:20:42.181Z 2025-12-05T14:42:19.361Z
8651875 8651875 20251130002959_6TnUX NL001B 2025-12-01T14:20:10.212Z 2025-12-05T14:42:10.157Z
8646196 8646196 20251129012248_6P2hC NL001B 2025-11-30T14:25:24.013Z 2025-12-05T14:51:35.458Z
8646165 8646165 20251129011734_APSSR NL001B 2025-11-30T14:25:18.121Z 2025-12-05T14:51:34.613Z
8645521 8645521 20251128223733_k7GeQ NL001B 2025-11-30T14:23:54.682Z 2025-12-05T14:50:49.100Z
8643659 8643659 20251128181158_y3Ivs NL001B 2025-11-30T14:20:31.692Z 2025-12-05T14:49:32.906Z
8621955 8621955 20251126171710_zkAKt NL001B 2025-11-28T14:17:08.282Z 2025-12-05T15:02:49.916Z
8608961 8608961 20251125225945_qw0ir NL001B 2025-11-27T14:17:07.384Z 2025-12-04T15:07:50.192Z
8608893 8608893 20251125225616_hZ3gw NL001B 2025-11-27T14:17:01.721Z 2025-12-04T15:07:49.644Z
8606925 8606925 20251125195650_dkizg NL001B 2025-11-27T14:11:49.051Z 2025-12-04T15:06:52.311Z
8606268 8606268 20251125182737_8IHm4 NL001B 2025-11-27T14:09:41.528Z 2025-12-04T15:06:43.290Z
8598642 8598642 20251125011250_J5xBf NL001B 2025-11-26T14:19:23.126Z 2025-12-02T15:08:01.498Z
8597708 8597708 20251125000259_b4UX6 NL001B 2025-11-26T14:17:24.952Z 2025-12-02T15:07:40.085Z
8596363 8596363 20251124205324_T3w2a NL001B 2025-11-26T14:14:25.981Z 2025-12-02T15:06:53.646Z
8596161 8596161 20251124200734_u0m9a NL001B 2025-11-26T14:13:51.259Z 2025-12-02T15:06:47.475Z
8591283 8591283 20251124040052_IglUR NL001B 2025-11-25T14:23:50.291Z 2025-12-02T15:12:57.761Z
8591271 8591271 20251124035932_mH9dl NL001B 2025-11-25T14:23:49.724Z 2025-12-02T15:12:57.738Z
8590966 8590966 20251124033052_EjMfr NL001B 2025-11-25T14:23:07.679Z 2025-12-02T15:12:56.424Z
8590633 8590633 20251124025947_DD53k NL001B 2025-11-25T14:22:19.794Z 2025-12-02T15:12:53.510Z
8589783 8589783 20251124015253_S83QM NL001B 2025-11-25T14:20:39.511Z 2025-12-02T15:12:35.738Z
8588406 8588406 20251123235403_kwGDn NL001B 2025-11-25T14:17:31.006Z 2025-12-02T15:11:41.204Z
8587985 8587985 20251123230634_Lj82k NL001B 2025-11-25T14:16:31.954Z 2025-12-02T15:11:23.565Z
8587017 8587017 20251123211254_h5WLa NL001B 2025-11-25T14:14:23.813Z 2025-12-02T15:11:05.590Z
8578715 8578715 20251122211855_eITbk NL001B 2025-11-24T14:12:25.212Z 2025-12-01T15:19:50.581Z
8568992 8568992 20251121054234_F6S8L NL001B 2025-11-23T14:31:50.527Z 2025-11-29T14:54:47.658Z
8568429 8568429 20251121051842_c4qJf NL001B 2025-11-23T14:31:07.394Z 2025-11-29T14:54:46.737Z
8567146 8567146 20251122041959_jw6mV NL001B 2025-11-23T14:19:00.601Z 2025-11-30T15:06:41.695Z
8567028 8567028 20251122034402_qDalj NL001B 2025-11-23T14:18:33.340Z 2025-11-30T15:06:32.854Z
8566598 8566598 20251122012426_ed9OH NL001B 2025-11-23T14:16:40.283Z 2025-11-30T15:05:54.690Z
8565982 8565982 20251121221721_3a23w NL001B 2025-11-23T14:14:46.435Z 2025-11-30T15:05:19.823Z
8565411 8565411 20251121202910_IdS9M NL001B 2025-11-23T14:13:16.061Z 2025-11-30T15:05:00.939Z
8564117 8564117 20251121175519_SmNjG NL001B 2025-11-23T14:10:05.641Z 2025-11-30T15:04:06.047Z
8560212 8560212 20251121044610_q2s2p NL001B 2025-11-22T14:42:35.652Z 2025-11-29T14:54:45.236Z
8560100 8560100 20251121044013_gttAd NL001B 2025-11-22T14:42:14.968Z 2025-11-29T14:54:44.991Z
8558769 8558769 20251121034107_akr8i NL001B 2025-11-22T14:41:14.165Z 2025-11-29T14:54:36.604Z
8557751 8557751 20251121025850_12kfB NL001B 2025-11-22T14:40:38.637Z 2025-11-29T14:54:34.656Z
8535911 8535911 20251120031208_NK55x NL001B 2025-11-21T14:17:08.087Z 2025-11-28T14:57:13.018Z
8535830 8535830 20251120030534_ln0K3 NL001B 2025-11-21T14:17:02.821Z 2025-11-28T14:57:10.198Z
8535821 8535821 20251120030454_bYGpp NL001B 2025-11-21T14:17:02.278Z 2025-11-28T14:57:07.911Z
8535161 8535161 20251120012444_iYVCG NL001B 2025-11-21T14:15:23.695Z 2025-11-28T14:56:19.057Z
8535157 8535157 20251120012357_E9UwG NL001B 2025-11-21T14:15:23.497Z 2025-11-28T14:56:18.952Z
8535086 8535086 20251120011337_rjpMQ NL001B 2025-11-21T14:15:16.642Z 2025-11-28T14:56:15.549Z
8534902 8534902 20251120004123_oH9b3 NL001B 2025-11-21T14:14:49.417Z 2025-11-28T14:56:05.208Z
8534524 8534524 20251119233455_Nrz9s NL001B 2025-11-21T14:14:00.820Z 2025-11-28T14:55:47.935Z
8506831 8506831 20251117221916_vlI2S NL001B 2025-11-19T14:13:44.020Z 2025-11-26T15:07:43.577Z
8505972 8505972 20251117205813_ReuO1 NL001B 2025-11-19T14:11:43.991Z 2025-11-26T15:07:40.430Z
8505952 8505952 20251117205638_gThu5 NL001B 2025-11-19T14:11:39.468Z 2025-11-26T15:07:40.287Z
8505702 8505702 20251117203653_PF7e7 NL001B 2025-11-19T14:11:10.113Z 2025-11-26T15:07:39.445Z
8504826 8504826 20251117192555_XNjM7 NL001B 2025-11-19T14:08:53.572Z 2025-11-26T15:07:33.620Z
8497217 8497217 20251117051856_kFjCO NL001B 2025-11-18T14:28:42.795Z 2025-11-25T15:10:40.274Z
8496726 8496726 20251117045247_MvBoC NL001B 2025-11-18T14:27:55.533Z 2025-11-25T15:10:20.775Z
8496377 8496377 20251117043458_3dqv1 NL001B 2025-11-18T14:27:39.453Z 2025-11-25T15:10:13.366Z
8491030 8491030 20251116211835_ipKCH NL001B 2025-11-18T14:16:09.653Z 2025-11-25T15:08:31.789Z
8489887 8489887 20251116175531_XVGmW NL001B 2025-11-18T14:11:53.431Z 2025-11-25T15:07:46.153Z
8489756 8489756 20251116173224_jFz7H NL001B 2025-11-18T14:11:20.774Z 2025-11-25T15:07:40.968Z
8456274 8456274 20251113182010_hXAcx NL001B 2025-11-15T14:10:49.452Z 2025-11-22T15:20:42.949Z
8456230 8456230 20251113181622_dncIJ NL001B 2025-11-15T14:10:44.154Z 2025-11-22T15:20:42.125Z
8455395 8455395 20251113170109_StvUD NL001B 2025-11-15T14:08:55.406Z 2025-11-22T15:20:12.718Z
8448944 8448944 20251113005215_yGowL NL001B 2025-11-14T14:18:56.533Z 2025-11-21T15:11:42.244Z
8448511 8448511 20251112232108_E7yhn NL001B 2025-11-14T14:17:31.614Z 2025-11-21T15:11:30.410Z
8448399 8448399 20251112230411_OKzx5 NL001B 2025-11-14T14:17:19.796Z 2025-11-21T15:11:27.383Z
8448320 8448320 20251112224728_WDhkw NL001B 2025-11-14T14:16:57.079Z 2025-11-21T15:11:26.209Z
8447812 8447812 20251112205134_TROdl NL001B 2025-11-14T14:15:23.799Z 2025-11-21T15:11:22.202Z
8447592 8447592 20251112201101_yqeWo NL001B 2025-11-14T14:14:38.145Z 2025-11-21T15:11:19.528Z
8446928 8446928 20251112183917_jwwL4 NL001B 2025-11-14T14:12:31.337Z 2025-11-21T15:11:14.769Z
8446736 8446736 20251112181239_Y5zZx NL001B 2025-11-14T14:11:53.058Z 2025-11-21T15:11:13.265Z
8446167 8446167 20251112165819_ZfNDy NL001B 2025-11-14T14:09:50.684Z 2025-11-21T15:11:07.879Z
8427710 8427710 20251111050344_CCe7Y NL001B 2025-11-12T14:28:58.211Z 2025-11-19T15:17:59.576Z
8427237 8427237 20251111041742_7hcE3 NL001B 2025-11-12T14:27:30.515Z 2025-11-19T15:17:48.395Z
8426984 8426984 20251111035829_UAsP6 NL001B 2025-11-12T14:26:46.592Z 2025-11-19T15:17:36.906Z
8413032 8413032 20251109215332_PGFk2 NL001B 2025-11-11T14:16:02.274Z 2025-11-18T15:20:17.753Z
8412308 8412308 20251109200618_8LpF7 NL001B 2025-11-11T14:13:35.000Z 2025-11-18T15:20:09.693Z
8412059 8412059 20251109194801_2n3T1 NL001B 2025-11-11T14:12:53.792Z 2025-11-18T15:20:06.394Z
8412000 8412000 20251109193938_ASMm3 NL001B 2025-11-11T14:12:43.985Z 2025-11-18T15:19:58.060Z
8411680 8411680 20251109191313_YH3WY NL001B 2025-11-11T14:11:38.775Z 2025-11-18T15:19:49.663Z
8411050 8411050 20251109180102_NwBfu NL001B 2025-11-11T14:09:37.294Z 2025-11-18T15:19:23.650Z
8410948 8410948 20251109175125_3UGsq NL001B 2025-11-11T14:09:13.110Z 2025-11-18T15:19:21.009Z
8397985 8397985 20251108031325_RzdnP NL001B 2025-11-09T14:13:49.675Z 2025-11-16T15:04:32.338Z
8397982 8397982 20251108031252_Q2w8g NL001B 2025-11-09T14:13:49.516Z 2025-11-16T15:04:32.310Z
8396898 8396898 20251107233549_y3c5x NL001B 2025-11-09T14:10:14.608Z 2025-11-16T15:03:47.261Z
8396881 8396881 20251107233134_rd3CM NL001B 2025-11-09T14:10:03.088Z 2025-11-16T15:03:44.787Z
8396659 8396659 20251107222603_D3iCE NL001B 2025-11-09T14:09:22.021Z 2025-11-16T15:03:36.402Z
8396585 8396585 20251107215607_sQ6u0 NL001B 2025-11-09T14:09:10.563Z 2025-11-16T15:03:34.436Z
8396509 8396509 20251107212251_6Efv2 NL001B 2025-11-09T14:08:50.259Z 2025-11-16T15:03:33.394Z
8396489 8396489 20251107211438_4DMQV NL001B 2025-11-09T14:08:46.810Z 2025-11-16T15:03:32.505Z
8396011 8396011 20251107190946_jq22e NL001B 2025-11-09T14:06:57.306Z 2025-11-16T15:03:04.485Z
8395921 8395921 20251107184730_cvzD0 NL001B 2025-11-09T14:06:32.197Z 2025-11-16T15:02:59.280Z
8395827 8395827 20251107182816_RcAKH NL001B 2025-11-09T14:06:05.774Z 2025-11-16T15:02:50.466Z

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