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

7,532 rows where station_code = "NL000C" 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
8666814 8666814 20251201035145_J4RVT NL000C 2025-12-02T14:28:02.532Z 2025-12-05T14:36:17.235Z
8666199 8666199 20251201045039_X48kY NL000C 2025-12-02T14:25:35.356Z 2025-12-05T14:36:35.811Z
8666114 8666114 20251201043917_PMePB NL000C 2025-12-02T14:25:15.738Z 2025-12-05T14:36:32.729Z
8666094 8666094 20251201043527_3Y05f NL000C 2025-12-02T14:25:13.084Z 2025-12-05T14:36:32.100Z
8666023 8666023 20251201042503_w4YPY NL000C 2025-12-02T14:25:06.723Z 2025-12-05T14:36:27.556Z
8665829 8665829 20251201040221_M4g9U NL000C 2025-12-02T14:24:33.158Z 2025-12-05T14:36:21.039Z
8665809 8665809 20251201040044_mk0l4 NL000C 2025-12-02T14:24:30.734Z 2025-12-05T14:36:20.037Z
8665788 8665788 20251201035819_LaVH4 NL000C 2025-12-02T14:24:29.386Z 2025-12-05T14:36:19.391Z
8665710 8665710 20251201035140_35qGK NL000C 2025-12-02T14:24:21.700Z 2025-12-05T14:36:16.609Z
8665654 8665654 20251201034713_Oo1gK NL000C 2025-12-02T14:24:16.445Z 2025-12-05T14:36:15.054Z
8665439 8665439 20251201032056_sln2G NL000C 2025-12-02T14:23:41.662Z 2025-12-05T14:36:04.849Z
8665332 8665332 20251201030824_P42by NL000C 2025-12-02T14:23:32.469Z 2025-12-05T14:35:52.605Z
8665325 8665325 20251201030739_IZ4CH NL000C 2025-12-02T14:23:31.301Z 2025-12-05T14:35:52.397Z
8665246 8665246 20251201025050_d358y NL000C 2025-12-02T14:23:11.702Z 2025-12-05T14:35:47.166Z
8665176 8665176 20251201024142_ICPRs NL000C 2025-12-02T14:23:04.437Z 2025-12-05T14:35:44.805Z
8665156 8665156 20251201023719_G3DDr NL000C 2025-12-02T14:23:02.132Z 2025-12-05T14:35:44.142Z
8665131 8665131 20251201023458_7mYLK NL000C 2025-12-02T14:22:59.206Z 2025-12-05T14:35:43.327Z
8665099 8665099 20251201022813_6lfr4 NL000C 2025-12-02T14:22:55.489Z 2025-12-05T14:35:42.380Z
8665087 8665087 20251201022710_D27tg NL000C 2025-12-02T14:22:54.356Z 2025-12-05T14:35:42.092Z
8664979 8664979 20251201021049_TMseA NL000C 2025-12-02T14:22:32.874Z 2025-12-05T14:35:37.981Z
8664958 8664958 20251201020809_L9dwS NL000C 2025-12-02T14:22:30.653Z 2025-12-05T14:35:37.374Z
8664699 8664699 20251201012700_ZadQw NL000C 2025-12-02T14:21:50.495Z 2025-12-05T14:35:14.996Z
8664671 8664671 20251201012040_aRbRe NL000C 2025-12-02T14:21:46.396Z 2025-12-05T14:35:12.210Z
8664260 8664260 20251130235326_MZ7ei NL000C 2025-12-02T14:20:36.437Z 2025-12-05T14:34:58.897Z
8653032 8653032 20251130015149_6ORFP NL000C 2025-12-01T14:22:40.551Z 2025-12-05T14:42:59.644Z
8645872 8645872 20251129000735_Aklxa NL000C 2025-11-30T14:24:38.567Z 2025-12-05T14:51:26.857Z
8645671 8645671 20251128232409_ninfn NL000C 2025-11-30T14:24:22.921Z 2025-12-05T14:51:06.356Z
8645660 8645660 20251128231915_HNhLT NL000C 2025-11-30T14:24:21.781Z 2025-12-05T14:51:05.575Z
8645520 8645520 20251128223733_k7GeQ NL000C 2025-11-30T14:23:54.682Z 2025-12-05T14:50:49.099Z
8645510 8645510 20251128223240_iaaq7 NL000C 2025-11-30T14:23:53.617Z 2025-12-05T14:50:45.304Z
8645064 8645064 20251128203329_NfVXQ NL000C 2025-11-30T14:23:01.709Z 2025-12-05T14:50:31.459Z
8591787 8591787 20251124045636_oLwep NL000C 2025-11-25T14:25:08.320Z 2025-12-02T15:13:00.522Z
8591687 8591687 20251124044515_3zZpA NL000C 2025-11-25T14:24:44.999Z 2025-12-02T15:12:59.935Z
8591650 8591650 20251124044125_pkKEH NL000C 2025-11-25T14:24:42.426Z 2025-12-02T15:12:59.807Z
8591539 8591539 20251124042323_UpX03 NL000C 2025-11-25T14:24:31.543Z 2025-12-02T15:12:59.301Z
8591507 8591507 20251124042108_X7qIx NL000C 2025-11-25T14:24:27.205Z 2025-12-02T15:12:59.019Z
8591351 8591351 20251124040704_HmhMb NL000C 2025-11-25T14:23:58.283Z 2025-12-02T15:12:58.138Z
8591281 8591281 20251124040052_IglUR NL000C 2025-11-25T14:23:50.291Z 2025-12-02T15:12:57.761Z
8591115 8591115 20251124034745_e56ix NL000C 2025-11-25T14:23:37.987Z 2025-12-02T15:12:57.139Z
8591109 8591109 20251124034659_HkgD2 NL000C 2025-11-25T14:23:37.217Z 2025-12-02T15:12:57.108Z
8591098 8591098 20251124034635_AiV1o NL000C 2025-11-25T14:23:36.489Z 2025-12-02T15:12:57.095Z
8590713 8590713 20251124030604_rHWYU NL000C 2025-11-25T14:22:27.716Z 2025-12-02T15:12:55.084Z
8590697 8590697 20251124030347_ncy9A NL000C 2025-11-25T14:22:23.552Z 2025-12-02T15:12:54.555Z
8590423 8590423 20251124024004_VasYv NL000C 2025-11-25T14:21:54.979Z 2025-12-02T15:12:47.574Z
8590208 8590208 20251124022927_BGbLl NL000C 2025-11-25T14:21:33.190Z 2025-12-02T15:12:43.332Z
8590122 8590122 20251124022426_cAdLJ NL000C 2025-11-25T14:21:26.367Z 2025-12-02T15:12:42.488Z
8590060 8590060 20251124021813_mUgmy NL000C 2025-11-25T14:21:19.550Z 2025-12-02T15:12:41.642Z
8589978 8589978 20251124021418_DRezV NL000C 2025-11-25T14:21:04.334Z 2025-12-02T15:12:40.930Z
8588825 8588825 20251124003412_AOGuM NL000C 2025-11-25T14:18:22.255Z 2025-12-02T15:11:56.604Z
8587525 8587525 20251123221318_657hi NL000C 2025-11-25T14:15:27.599Z 2025-12-02T15:11:16.726Z
8581565 8581565 20251123005437_EaN5O NL000C 2025-11-24T14:31:58.154Z 2025-12-01T15:20:57.921Z
8579869 8579869 20251123013735_tF3ji NL000C 2025-11-24T14:15:28.008Z 2025-12-01T15:21:12.034Z
8579802 8579802 20251123011942_gbt2K NL000C 2025-11-24T14:15:11.673Z 2025-12-01T15:21:10.039Z
8579661 8579661 20251123004007_3tlEc NL000C 2025-11-24T14:14:56.255Z 2025-12-01T15:20:52.576Z
8579487 8579487 20251122235431_ieP2S NL000C 2025-11-24T14:14:27.133Z 2025-12-01T15:20:29.173Z
8579454 8579454 20251122234757_2BHO7 NL000C 2025-11-24T14:14:23.941Z 2025-12-01T15:20:26.549Z
8579027 8579027 20251122220901_h2hCx NL000C 2025-11-24T14:13:20.305Z 2025-12-01T15:19:58.756Z
8578852 8578852 20251122213906_tltKF NL000C 2025-11-24T14:12:50.843Z 2025-12-01T15:19:53.901Z
8578754 8578754 20251122212331_kKPxl NL000C 2025-11-24T14:12:37.738Z 2025-12-01T15:19:51.565Z
8578721 8578721 20251122211957_KaGE1 NL000C 2025-11-24T14:12:32.451Z 2025-12-01T15:19:50.695Z
8578437 8578437 20251122203702_KWsiI NL000C 2025-11-24T14:11:44.493Z 2025-12-01T15:19:37.330Z
8578422 8578422 20251122203540_pqJLn NL000C 2025-11-24T14:11:42.906Z 2025-12-01T15:19:35.407Z
8578367 8578367 20251122203037_orEun NL000C 2025-11-24T14:11:37.258Z 2025-12-01T15:19:33.450Z
8578329 8578329 20251122202910_jEgPN NL000C 2025-11-24T14:11:25.209Z 2025-12-01T15:19:32.289Z
8578277 8578277 20251122202013_2GLEn NL000C 2025-11-24T14:11:17.149Z 2025-12-01T15:19:29.513Z
8577997 8577997 20251122192618_3U1Jc NL000C 2025-11-24T14:10:28.904Z 2025-12-01T15:19:05.790Z
8577369 8577369 20251122175954_cZ9DV NL000C 2025-11-24T14:08:29.308Z 2025-12-01T15:18:48.445Z
8577349 8577349 20251122175835_xp3nN NL000C 2025-11-24T14:08:26.702Z 2025-12-01T15:18:47.953Z
8577316 8577316 20251122175429_GXKQO NL000C 2025-11-24T14:08:21.821Z 2025-12-01T15:18:47.346Z
8577222 8577222 20251122173611_lM0ds NL000C 2025-11-24T14:08:00.663Z 2025-12-01T15:18:44.996Z
8577118 8577118 20251122172255_MXijY NL000C 2025-11-24T14:07:37.580Z 2025-12-01T15:18:43.743Z
8576976 8576976 20251122165554_eMEZD NL000C 2025-11-24T14:07:14.650Z 2025-12-01T15:18:42.065Z
8568473 8568473 20251121052117_J5Rp2 NL000C 2025-11-23T14:31:09.692Z 2025-11-29T14:54:46.837Z
8568450 8568450 20251121051952_9Lo6v NL000C 2025-11-23T14:31:08.905Z 2025-11-29T14:54:46.820Z
8567945 8567945 20251121042735_28jk0 NL000C 2025-11-23T14:29:36.138Z 2025-11-29T14:54:44.338Z
8567324 8567324 20251122053141_xbdiK NL000C 2025-11-23T14:19:30.950Z 2025-11-30T15:07:03.022Z
8567288 8567288 20251122051150_4HDoL NL000C 2025-11-23T14:19:24.970Z 2025-11-30T15:06:58.770Z
8567273 8567273 20251122050406_g6hUy NL000C 2025-11-23T14:19:23.785Z 2025-11-30T15:06:56.442Z
8567170 8567170 20251122042656_3s7D2 NL000C 2025-11-23T14:19:03.169Z 2025-11-30T15:06:44.727Z
8567164 8567164 20251122042626_dq8LJ NL000C 2025-11-23T14:19:02.971Z 2025-11-30T15:06:44.716Z
8567140 8567140 20251122041918_XhRxh NL000C 2025-11-23T14:19:00.282Z 2025-11-30T15:06:41.592Z
8563596 8563596 20251121165132_kkpF2 NL000C 2025-11-23T14:08:48.579Z 2025-11-30T15:03:41.827Z
8560309 8560309 20251121044929_fBRuv NL000C 2025-11-22T14:42:50.060Z 2025-11-29T14:54:45.568Z
8560305 8560305 20251121044929_5BBad NL000C 2025-11-22T14:42:49.955Z 2025-11-29T14:54:45.542Z
8560247 8560247 20251121044748_iTqfj NL000C 2025-11-22T14:42:40.407Z 2025-11-29T14:54:45.361Z
8560218 8560218 20251121044626_Wua3O NL000C 2025-11-22T14:42:37.256Z 2025-11-29T14:54:45.242Z
8560206 8560206 20251121044610_q2s2p NL000C 2025-11-22T14:42:35.652Z 2025-11-29T14:54:45.236Z
8559671 8559671 20251121042210_cWjsd NL000C 2025-11-22T14:42:01.109Z 2025-11-29T14:54:43.203Z
8558900 8558900 20251121034443_4YGAo NL000C 2025-11-22T14:41:24.511Z 2025-11-29T14:54:36.818Z
8547919 8547919 20251120202326_t8o4T NL000C 2025-11-22T14:15:55.639Z 2025-11-29T14:54:21.365Z
8540727 8540727 20251120012613_OzUW0 NL000C 2025-11-21T14:36:42.653Z 2025-11-28T14:56:20.033Z
8540709 8540709 20251120012231_slgl2 NL000C 2025-11-21T14:36:38.443Z 2025-11-28T14:56:18.858Z
8536259 8536259 20251120035940_BsRhM NL000C 2025-11-21T14:18:01.927Z 2025-11-28T14:57:30.375Z
8536166 8536166 20251120034334_VQa8a NL000C 2025-11-21T14:17:41.434Z 2025-11-28T14:57:26.114Z
8536087 8536087 20251120032948_WuBc0 NL000C 2025-11-21T14:17:33.972Z 2025-11-28T14:57:24.147Z
8535902 8535902 20251120031206_PuNrX NL000C 2025-11-21T14:17:07.803Z 2025-11-28T14:57:13.013Z
8535819 8535819 20251120030454_bYGpp NL000C 2025-11-21T14:17:02.278Z 2025-11-28T14:57:07.911Z
8535693 8535693 20251120023937_2KWs8 NL000C 2025-11-21T14:16:38.308Z 2025-11-28T14:56:57.877Z
8535616 8535616 20251120022946_KVRvu NL000C 2025-11-21T14:16:31.507Z 2025-11-28T14:56:51.808Z
8535599 8535599 20251120022802_odfvm NL000C 2025-11-21T14:16:30.210Z 2025-11-28T14:56:51.697Z

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