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

5,052 rows where station_code = "NL000P" 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
8666815 8666815 20251201035145_J4RVT NL000P 2025-12-02T14:28:02.532Z 2025-12-05T14:36:17.235Z
8666532 8666532 20251201061221_OWcpl NL000P 2025-12-02T14:26:24.286Z 2025-12-05T14:37:02.079Z
8666516 8666516 20251201060239_SpNw2 NL000P 2025-12-02T14:26:22.262Z 2025-12-05T14:37:00.975Z
8666471 8666471 20251201054456_edZYH NL000P 2025-12-02T14:26:16.864Z 2025-12-05T14:36:59.330Z
8666278 8666278 20251201050706_agbKN NL000P 2025-12-02T14:25:42.021Z 2025-12-05T14:36:52.849Z
8666154 8666154 20251201044323_ppSSz NL000P 2025-12-02T14:25:31.068Z 2025-12-05T14:36:34.515Z
8666115 8666115 20251201043917_PMePB NL000P 2025-12-02T14:25:15.738Z 2025-12-05T14:36:32.729Z
8666095 8666095 20251201043527_3Y05f NL000P 2025-12-02T14:25:13.084Z 2025-12-05T14:36:32.100Z
8665983 8665983 20251201041623_vrr5A NL000P 2025-12-02T14:25:01.696Z 2025-12-05T14:36:25.839Z
8665909 8665909 20251201040925_uQ3du NL000P 2025-12-02T14:24:54.351Z 2025-12-05T14:36:23.860Z
8665830 8665830 20251201040221_M4g9U NL000P 2025-12-02T14:24:33.158Z 2025-12-05T14:36:21.039Z
8665789 8665789 20251201035819_LaVH4 NL000P 2025-12-02T14:24:29.386Z 2025-12-05T14:36:19.391Z
8665783 8665783 20251201035740_X3dEK NL000P 2025-12-02T14:24:28.618Z 2025-12-05T14:36:19.118Z
8665431 8665431 20251201032044_6o8fi NL000P 2025-12-02T14:23:41.192Z 2025-12-05T14:36:04.429Z
8665177 8665177 20251201024142_ICPRs NL000P 2025-12-02T14:23:04.437Z 2025-12-05T14:35:44.805Z
8665051 8665051 20251201022123_PMEoT NL000P 2025-12-02T14:22:42.868Z 2025-12-05T14:35:40.874Z
8665029 8665029 20251201021826_PGghD NL000P 2025-12-02T14:22:38.394Z 2025-12-05T14:35:39.804Z
8664980 8664980 20251201021049_TMseA NL000P 2025-12-02T14:22:32.874Z 2025-12-05T14:35:37.981Z
8664962 8664962 20251201020824_E3tCc NL000P 2025-12-02T14:22:30.984Z 2025-12-05T14:35:37.531Z
8664959 8664959 20251201020809_L9dwS NL000P 2025-12-02T14:22:30.653Z 2025-12-05T14:35:37.374Z
8664807 8664807 20251201014259_TlG5x NL000P 2025-12-02T14:22:07.362Z 2025-12-05T14:35:18.873Z
8664764 8664764 20251201013437_GpbhW NL000P 2025-12-02T14:22:02.414Z 2025-12-05T14:35:17.173Z
8664606 8664606 20251201011047_B7b6B NL000P 2025-12-02T14:21:37.218Z 2025-12-05T14:35:10.133Z
8664491 8664491 20251201004219_S2yuh NL000P 2025-12-02T14:21:12.687Z 2025-12-05T14:35:06.264Z
8662763 8662763 20251130192831_hYp2C NL000P 2025-12-02T14:16:30.732Z 2025-12-05T14:33:47.203Z
8661686 8661686 20251130165335_Xw7QH NL000P 2025-12-02T14:12:36.529Z 2025-12-05T14:32:31.108Z
8656110 8656110 20251130043810_nEilS NL000P 2025-12-01T14:28:04.066Z 2025-12-01T14:28:04.066Z
8655137 8655137 20251130034519_mSxa4 NL000P 2025-12-01T14:26:25.200Z 2025-12-01T14:26:25.200Z
8655051 8655051 20251130034210_NHNlI NL000P 2025-12-01T14:26:19.485Z 2025-12-05T14:44:27.268Z
8654944 8654944 20251130033915_Y3omr NL000P 2025-12-01T14:26:12.457Z 2025-12-05T14:44:26.202Z
8654760 8654760 20251130033220_CEzEH NL000P 2025-12-01T14:25:59.043Z 2025-12-05T14:44:23.202Z
8596839 8596839 20251124221826_e9Wdc NL000P 2025-11-26T14:15:35.989Z 2025-12-02T15:07:15.172Z
8596519 8596519 20251124212238_jklae NL000P 2025-11-26T14:14:40.474Z 2025-12-02T15:07:01.477Z
8596360 8596360 20251124205324_T3w2a NL000P 2025-11-26T14:14:25.981Z 2025-12-02T15:06:53.646Z
8595794 8595794 20251124182902_7O413 NL000P 2025-11-26T14:12:30.390Z 2025-12-02T15:06:11.330Z
8595745 8595745 20251124181658_fyzSE NL000P 2025-11-26T14:12:21.810Z 2025-12-02T15:06:06.825Z
8595537 8595537 20251124164517_bV6Gh NL000P 2025-11-26T14:11:34.984Z 2025-12-02T15:06:01.151Z
8590632 8590632 20251124025947_DD53k NL000P 2025-11-25T14:22:19.794Z 2025-12-02T15:12:53.510Z
8590209 8590209 20251124022927_BGbLl NL000P 2025-11-25T14:21:33.190Z 2025-12-02T15:12:43.332Z
8589781 8589781 20251124015253_S83QM NL000P 2025-11-25T14:20:39.511Z 2025-12-02T15:12:35.737Z
8589730 8589730 20251124015032_SthtX NL000P 2025-11-25T14:20:26.640Z 2025-12-02T15:12:34.336Z
8589226 8589226 20251124011554_lFbW4 NL000P 2025-11-25T14:19:29.918Z 2025-12-02T15:12:11.811Z
8589192 8589192 20251124011305_75WoT NL000P 2025-11-25T14:19:25.238Z 2025-12-02T15:12:10.797Z
8579184 8579184 20251122223631_2kr2v NL000P 2025-11-24T14:13:45.825Z 2025-12-01T15:20:05.873Z
8579057 8579057 20251122221414_dtowk NL000P 2025-11-24T14:13:24.048Z 2025-12-01T15:20:00.414Z
8579028 8579028 20251122220901_h2hCx NL000P 2025-11-24T14:13:20.305Z 2025-12-01T15:19:58.756Z
8578758 8578758 20251122212336_18iLc NL000P 2025-11-24T14:12:38.029Z 2025-12-01T15:19:52.598Z
8578713 8578713 20251122211855_eITbk NL000P 2025-11-24T14:12:25.212Z 2025-12-01T15:19:50.581Z
8577998 8577998 20251122192618_3U1Jc NL000P 2025-11-24T14:10:28.904Z 2025-12-01T15:19:05.790Z
8577898 8577898 20251122190917_TnsVc NL000P 2025-11-24T14:10:08.060Z 2025-12-01T15:19:01.888Z
8577563 8577563 20251122183208_sJgNM NL000P 2025-11-24T14:09:03.914Z 2025-12-01T15:18:54.193Z
8577370 8577370 20251122175954_cZ9DV NL000P 2025-11-24T14:08:29.308Z 2025-12-01T15:18:48.445Z
8577350 8577350 20251122175835_xp3nN NL000P 2025-11-24T14:08:26.702Z 2025-12-01T15:18:47.953Z
8576907 8576907 20251122163826_2RdzH NL000P 2025-11-24T14:06:58.124Z 2025-12-01T15:18:41.197Z
8572485 8572485 20251122005545_IbHcF NL000P 2025-11-23T14:39:28.094Z 2025-11-30T15:05:50.878Z
8571650 8571650 20251121214114_1UToW NL000P 2025-11-23T14:37:24.183Z 2025-11-30T15:05:11.713Z
8569140 8569140 20251121054638_WZVlj NL000P 2025-11-23T14:31:55.459Z 2025-11-29T14:54:47.833Z
8568990 8568990 20251121054234_F6S8L NL000P 2025-11-23T14:31:50.527Z 2025-11-29T14:54:47.658Z
8568530 8568530 20251121052231_V2VIp NL000P 2025-11-23T14:31:11.272Z 2025-11-29T14:54:46.918Z
8567325 8567325 20251122053141_xbdiK NL000P 2025-11-23T14:19:30.950Z 2025-11-30T15:07:03.022Z
8567306 8567306 20251122052129_jg3Lg NL000P 2025-11-23T14:19:28.292Z 2025-11-30T15:07:01.231Z
8567201 8567201 20251122043650_k3aGu NL000P 2025-11-23T14:19:08.670Z 2025-11-30T15:06:49.376Z
8567144 8567144 20251122041959_jw6mV NL000P 2025-11-23T14:19:00.601Z 2025-11-30T15:06:41.695Z
8567106 8567106 20251122040909_XV0dq NL000P 2025-11-23T14:18:52.666Z 2025-11-30T15:06:37.598Z
8567098 8567098 20251122040650_b4LE8 NL000P 2025-11-23T14:18:51.214Z 2025-11-30T15:06:37.373Z
8567024 8567024 20251122034402_qDalj NL000P 2025-11-23T14:18:33.340Z 2025-11-30T15:06:32.854Z
8566664 8566664 20251122014252_ld0oX NL000P 2025-11-23T14:17:00.259Z 2025-11-30T15:06:00.878Z
8566597 8566597 20251122012426_ed9OH NL000P 2025-11-23T14:16:40.283Z 2025-11-30T15:05:54.690Z
8566546 8566546 20251122011003_of812 NL000P 2025-11-23T14:16:32.977Z 2025-11-30T15:05:51.719Z
8566298 8566298 20251122000329_hB01x NL000P 2025-11-23T14:15:42.862Z 2025-11-30T15:05:41.666Z
8566256 8566256 20251121234811_gsMuq NL000P 2025-11-23T14:15:36.458Z 2025-11-30T15:05:39.803Z
8566214 8566214 20251121233424_FMH70 NL000P 2025-11-23T14:15:29.955Z 2025-11-30T15:05:37.405Z
8566198 8566198 20251121233023_EqFLi NL000P 2025-11-23T14:15:27.546Z 2025-11-23T14:15:27.546Z
8566149 8566149 20251121230956_Ts2P2 NL000P 2025-11-23T14:15:10.869Z 2025-11-30T15:05:30.670Z
8565918 8565918 20251121220114_cTMyR NL000P 2025-11-23T14:14:31.672Z 2025-11-30T15:05:15.517Z
8565883 8565883 20251121215251_74RbO NL000P 2025-11-23T14:14:26.510Z 2025-11-30T15:05:14.628Z
8565779 8565779 20251121211333_7KD3Q NL000P 2025-11-23T14:14:03.065Z 2025-11-30T15:05:08.684Z
8565444 8565444 20251121203229_a608q NL000P 2025-11-23T14:13:20.618Z 2025-11-30T15:05:03.004Z
8565443 8565443 20251121203134_NhCqp NL000P 2025-11-23T14:13:20.169Z 2025-11-30T15:05:02.980Z
8565409 8565409 20251121202910_IdS9M NL000P 2025-11-23T14:13:16.061Z 2025-11-30T15:05:00.939Z
8565036 8565036 20251121193947_OziMD NL000P 2025-11-23T14:12:19.080Z 2025-11-30T15:04:39.509Z
8564293 8564293 20251121181711_auFqp NL000P 2025-11-23T14:10:31.900Z 2025-11-30T15:04:12.380Z
8564072 8564072 20251121175102_1zBWY NL000P 2025-11-23T14:09:59.394Z 2025-11-30T15:04:05.266Z
8563848 8563848 20251121173512_N1F1d NL000P 2025-11-23T14:09:30.147Z 2025-11-30T15:03:49.914Z
8560467 8560467 20251121045647_c38zJ NL000P 2025-11-22T14:42:52.989Z 2025-11-22T14:42:52.989Z
8560207 8560207 20251121044610_q2s2p NL000P 2025-11-22T14:42:35.652Z 2025-11-29T14:54:45.236Z
8559035 8559035 20251121035047_QELEI NL000P 2025-11-22T14:41:44.388Z 2025-11-29T14:54:37.004Z
8558768 8558768 20251121034107_akr8i NL000P 2025-11-22T14:41:14.165Z 2025-11-29T14:54:36.604Z
8557857 8557857 20251121030738_76U9U NL000P 2025-11-22T14:40:50.765Z 2025-11-29T14:54:34.793Z
8557730 8557730 20251121025704_rG4tz NL000P 2025-11-22T14:40:37.933Z 2025-11-29T14:54:34.512Z
8557293 8557293 20251121024339_dcNIp NL000P 2025-11-22T14:39:56.564Z 2025-11-29T14:54:33.763Z
8557290 8557290 20251121024338_TkQ9I NL000P 2025-11-22T14:39:56.466Z 2025-11-29T14:54:33.762Z
8556951 8556951 20251121022515_KKFXO NL000P 2025-11-22T14:39:48.217Z 2025-11-29T14:54:33.288Z
8556803 8556803 20251121021320_1Ajuc NL000P 2025-11-22T14:39:44.702Z 2025-11-29T14:54:33.031Z
8556312 8556312 20251121014709_aZUc0 NL000P 2025-11-22T14:39:21.657Z 2025-11-29T14:54:32.100Z
8554887 8554887 20251121004500_xgdJA NL000P 2025-11-22T14:37:34.627Z 2025-11-29T14:54:29.270Z
8551342 8551342 20251121003511_JWxPe NL000P 2025-11-22T14:22:25.570Z 2025-11-29T14:54:28.666Z
8551032 8551032 20251121001716_hXodo NL000P 2025-11-22T14:21:56.822Z 2025-11-29T14:54:28.098Z
8550950 8550950 20251121001318_3Xguh NL000P 2025-11-22T14:21:51.540Z 2025-11-22T14:21:51.540Z
8550761 8550761 20251121000343_3pJs2 NL000P 2025-11-22T14:21:26.802Z 2025-11-29T14:54:27.490Z

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