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

2,390 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
8686985 8686985 20251204000041_awSFF NL0014 2025-12-05T14:13:19.296Z 2025-12-05T14:14:35.540Z
8686976 8686976 20251203232625_LKurw NL0014 2025-12-05T14:13:18.073Z 2025-12-05T14:14:35.537Z
8666409 8666409 20251201053546_3PbEd NL0014 2025-12-02T14:25:58.702Z 2025-12-05T14:36:57.505Z
8666383 8666383 20251201052646_h2AeI NL0014 2025-12-02T14:25:55.106Z 2025-12-05T14:36:56.205Z
8666319 8666319 20251201051118_WqMHv NL0014 2025-12-02T14:25:46.237Z 2025-12-05T14:36:54.140Z
8666291 8666291 20251201050855_jM1Z2 NL0014 2025-12-02T14:25:43.190Z 2025-12-05T14:36:53.261Z
8666235 8666235 20251201045507_NNFC0 NL0014 2025-12-02T14:25:38.462Z 2025-12-05T14:36:45.891Z
8666076 8666076 20251201043026_PwirV NL0014 2025-12-02T14:25:11.805Z 2025-12-05T14:36:31.491Z
8665992 8665992 20251201041758_hmoEL NL0014 2025-12-02T14:25:03.287Z 2025-12-05T14:36:26.400Z
8665960 8665960 20251201041351_vPr25 NL0014 2025-12-02T14:24:59.230Z 2025-12-05T14:36:25.134Z
8665714 8665714 20251201035140_35qGK NL0014 2025-12-02T14:24:21.700Z 2025-12-05T14:36:16.609Z
8665490 8665490 20251201032526_APX1a NL0014 2025-12-02T14:23:46.480Z 2025-12-05T14:36:09.190Z
8665347 8665347 20251201030910_S2ENd NL0014 2025-12-02T14:23:33.001Z 2025-12-05T14:35:52.884Z
8665335 8665335 20251201030824_P42by NL0014 2025-12-02T14:23:32.469Z 2025-12-05T14:35:52.605Z
8665302 8665302 20251201030327_CAg26 NL0014 2025-12-02T14:23:18.866Z 2025-12-05T14:35:51.330Z
8665135 8665135 20251201023458_7mYLK NL0014 2025-12-02T14:22:59.206Z 2025-12-05T14:35:43.327Z
8665100 8665100 20251201022813_6lfr4 NL0014 2025-12-02T14:22:55.489Z 2025-12-05T14:35:42.380Z
8665089 8665089 20251201022710_D27tg NL0014 2025-12-02T14:22:54.356Z 2025-12-05T14:35:42.092Z
8665026 8665026 20251201021803_b0CYn NL0014 2025-12-02T14:22:38.019Z 2025-12-05T14:35:39.647Z
8664759 8664759 20251201013428_J0kd5 NL0014 2025-12-02T14:22:01.687Z 2025-12-05T14:35:16.955Z
8664368 8664368 20251201000953_J6msT NL0014 2025-12-02T14:20:48.375Z 2025-12-05T14:35:02.189Z
8664264 8664264 20251130235326_MZ7ei NL0014 2025-12-02T14:20:36.472Z 2025-12-05T14:34:58.898Z
8652459 8652459 20251130011056_lwG6K NL0014 2025-12-01T14:21:26.750Z 2025-12-05T14:42:45.128Z
8646502 8646502 20251129021147_nnrBw NL0014 2025-11-30T14:26:05.548Z 2025-12-05T14:51:43.431Z
8646115 8646115 20251129010757_wQkqu NL0014 2025-11-30T14:25:13.582Z 2025-12-05T14:51:33.450Z
8645873 8645873 20251129000735_Aklxa NL0014 2025-11-30T14:24:38.567Z 2025-12-05T14:51:26.857Z
8645511 8645511 20251128223240_iaaq7 NL0014 2025-11-30T14:23:53.617Z 2025-12-05T14:50:45.304Z
8645424 8645424 20251128220717_EtjXk NL0014 2025-11-30T14:23:42.716Z 2025-12-05T14:50:38.618Z
8645132 8645132 20251128204145_p1I0B NL0014 2025-11-30T14:23:08.364Z 2025-12-05T14:50:32.177Z
8644850 8644850 20251128200534_Pdt56 NL0014 2025-11-30T14:22:47.464Z 2025-12-05T14:50:28.141Z
8644141 8644141 20251128190217_v7i2A NL0014 2025-11-30T14:21:23.844Z 2025-12-05T14:50:16.987Z
8642815 8642815 20251128165317_m5AQZ NL0014 2025-11-30T14:18:41.466Z 2025-12-05T14:49:05.392Z
8612994 8612994 20251126025821_KS2Vi NL0014 2025-11-27T14:25:05.795Z 2025-12-04T15:09:36.402Z
8612809 8612809 20251126024814_dSqrH NL0014 2025-11-27T14:24:48.394Z 2025-12-04T15:09:34.299Z
8612733 8612733 20251126024327_0qCWt NL0014 2025-11-27T14:24:32.801Z 2025-12-04T15:09:33.416Z
8612551 8612551 20251126023737_oVX8D NL0014 2025-11-27T14:24:21.304Z 2025-12-04T15:09:31.861Z
8611412 8611412 20251126014152_dggCj NL0014 2025-11-27T14:22:06.580Z 2025-12-04T15:09:12.006Z
8611188 8611188 20251126013013_hm59F NL0014 2025-11-27T14:21:37.272Z 2025-12-04T15:08:56.841Z
8608731 8608731 20251125223909_dIXr3 NL0014 2025-11-27T14:16:40.033Z 2025-12-04T15:07:48.126Z
8608462 8608462 20251125221855_qmoTS NL0014 2025-11-27T14:16:09.390Z 2025-12-04T15:07:45.443Z
8606191 8606191 20251125181658_lST9E NL0014 2025-11-27T14:09:24.386Z 2025-12-04T15:06:31.541Z
8605829 8605829 20251125172230_ibchB NL0014 2025-11-27T14:08:04.669Z 2025-12-04T15:05:46.462Z
8605748 8605748 20251125164445_2Qqkv NL0014 2025-11-27T14:07:37.110Z 2025-12-04T15:05:38.270Z
8601543 8601543 20251125035422_TKH8X NL0014 2025-11-26T14:24:25.213Z 2025-12-02T15:09:12.018Z
8601521 8601521 20251125035245_pbVcl NL0014 2025-11-26T14:24:23.571Z 2025-12-02T15:09:09.592Z
8601127 8601127 20251125033538_V86il NL0014 2025-11-26T14:23:43.452Z 2025-12-02T15:09:00.294Z
8601066 8601066 20251125033130_XDmS3 NL0014 2025-11-26T14:23:39.098Z 2025-12-02T15:08:56.738Z
8600924 8600924 20251125032245_kbpCK NL0014 2025-11-26T14:23:08.351Z 2025-12-02T15:08:52.123Z
8599512 8599512 20251125020920_rX3rW NL0014 2025-11-26T14:21:11.786Z 2025-12-02T15:08:27.071Z
8599347 8599347 20251125015936_SypEF NL0014 2025-11-26T14:20:48.379Z 2025-12-02T15:08:22.714Z
8598641 8598641 20251125011250_J5xBf NL0014 2025-11-26T14:19:23.126Z 2025-12-02T15:08:01.498Z
8598413 8598413 20251125005532_6UMGD NL0014 2025-11-26T14:18:46.708Z 2025-12-02T15:07:53.805Z
8598151 8598151 20251125003910_334ky NL0014 2025-11-26T14:18:22.711Z 2025-12-02T15:07:47.004Z
8597653 8597653 20251124235757_uiXE0 NL0014 2025-11-26T14:17:17.513Z 2025-12-02T15:07:39.103Z
8597126 8597126 20251124230056_GWJiP NL0014 2025-11-26T14:16:03.852Z 2025-12-02T15:07:23.362Z
8596838 8596838 20251124221554_iJOxm NL0014 2025-11-26T14:15:34.078Z 2025-12-02T15:07:15.170Z
8596746 8596746 20251124220151_4SDgc NL0014 2025-11-26T14:15:14.193Z 2025-12-02T15:07:09.156Z
8596719 8596719 20251124220042_F31jn NL0014 2025-11-26T14:15:12.255Z 2025-12-02T15:07:07.473Z
8596650 8596650 20251124214645_EPEFk NL0014 2025-11-26T14:15:03.102Z 2025-12-02T15:07:04.108Z
8596376 8596376 20251124210010_KToUc NL0014 2025-11-26T14:14:28.270Z 2025-12-02T15:06:54.390Z
8596248 8596248 20251124203126_eZ5v2 NL0014 2025-11-26T14:14:03.609Z 2025-12-02T15:06:51.450Z
8596181 8596181 20251124201710_0vvlo NL0014 2025-11-26T14:13:54.810Z 2025-12-02T15:06:48.970Z
8596009 8596009 20251124192634_rIAGt NL0014 2025-11-26T14:13:20.097Z 2025-12-02T15:06:28.468Z
8595702 8595702 20251124180200_OpD3p NL0014 2025-11-26T14:12:14.530Z 2025-12-02T15:06:05.689Z
8591845 8591845 20251124050605_6EZFk NL0014 2025-11-25T14:25:14.171Z 2025-12-02T15:13:00.747Z
8591143 8591143 20251124034955_0265O NL0014 2025-11-25T14:23:40.524Z 2025-12-02T15:12:57.229Z
8591119 8591119 20251124034747_PP3n1 NL0014 2025-11-25T14:23:38.313Z 2025-12-02T15:12:57.143Z
8591100 8591100 20251124034635_AiV1o NL0014 2025-11-25T14:23:36.489Z 2025-12-02T15:12:57.095Z
8590991 8590991 20251124033241_FJZC9 NL0014 2025-11-25T14:23:12.283Z 2025-12-02T15:12:56.481Z
8590969 8590969 20251124033053_BqsMZ NL0014 2025-11-25T14:23:08.034Z 2025-12-02T15:12:56.430Z
8590935 8590935 20251124032834_5DSNn NL0014 2025-11-25T14:23:04.887Z 2025-12-02T15:12:56.307Z
8590887 8590887 20251124032429_Zre8T NL0014 2025-11-25T14:23:00.019Z 2025-12-02T15:12:56.004Z
8590717 8590717 20251124030604_rHWYU NL0014 2025-11-25T14:22:27.717Z 2025-12-02T15:12:55.084Z
8588732 8588732 20251124002801_l7Ffw NL0014 2025-11-25T14:18:12.738Z 2025-12-02T15:11:51.110Z
8588380 8588380 20251123235138_GWw5x NL0014 2025-11-25T14:17:29.312Z 2025-12-02T15:11:41.174Z
8587841 8587841 20251123225144_W1Ybx NL0014 2025-11-25T14:16:10.638Z 2025-12-02T15:11:20.747Z
8587527 8587527 20251123221318_657hi NL0014 2025-11-25T14:15:27.630Z 2025-12-02T15:11:16.726Z
8578369 8578369 20251122203037_orEun NL0014 2025-11-24T14:11:37.258Z 2025-12-01T15:19:33.450Z
8578332 8578332 20251122202910_jEgPN NL0014 2025-11-24T14:11:25.224Z 2025-12-01T15:19:32.289Z
8577319 8577319 20251122175429_GXKQO NL0014 2025-11-24T14:08:21.821Z 2025-12-01T15:18:47.346Z
8576910 8576910 20251122163826_2RdzH NL0014 2025-11-24T14:06:58.174Z 2025-12-01T15:18:41.198Z
8568745 8568745 20251121053254_UpZiR NL0014 2025-11-23T14:31:22.053Z 2025-11-29T14:54:47.287Z
8568477 8568477 20251121052117_J5Rp2 NL0014 2025-11-23T14:31:09.692Z 2025-11-29T14:54:46.837Z
8568455 8568455 20251121051952_9Lo6v NL0014 2025-11-23T14:31:08.905Z 2025-11-29T14:54:46.820Z
8568442 8568442 20251121051942_qUi7K NL0014 2025-11-23T14:31:08.204Z 2025-11-29T14:54:46.782Z
8568407 8568407 20251121051544_NTa5t NL0014 2025-11-23T14:31:06.368Z 2025-11-29T14:54:46.674Z
8568188 8568188 20251121050427_LbAu2 NL0014 2025-11-23T14:30:56.677Z 2025-11-29T14:54:46.259Z
8567338 8567338 20251122053832_2aiTr NL0014 2025-11-23T14:19:32.685Z 2025-11-30T15:07:03.769Z
8566928 8566928 20251122030050_WK47j NL0014 2025-11-23T14:18:06.893Z 2025-11-30T15:06:16.955Z
8566830 8566830 20251122023459_nttwi NL0014 2025-11-23T14:17:40.361Z 2025-11-30T15:06:11.173Z
8565816 8565816 20251121213201_vctwi NL0014 2025-11-23T14:14:18.586Z 2025-11-30T15:05:11.067Z
8565422 8565422 20251121202916_EHmvv NL0014 2025-11-23T14:13:17.065Z 2025-11-30T15:05:02.697Z
8565357 8565357 20251121202154_eLEj3 NL0014 2025-11-23T14:13:11.615Z 2025-11-30T15:04:55.691Z
8564654 8564654 20251121185303_Re26r NL0014 2025-11-23T14:11:19.378Z 2025-11-30T15:04:25.607Z
8564617 8564617 20251121184727_TB8B1 NL0014 2025-11-23T14:11:15.792Z 2025-11-30T15:04:25.397Z
8564603 8564603 20251121184559_YwUqx NL0014 2025-11-23T14:11:13.059Z 2025-11-30T15:04:25.108Z
8564481 8564481 20251121183351_lWtO4 NL0014 2025-11-23T14:10:57.167Z 2025-11-30T15:04:20.816Z
8564404 8564404 20251121182441_5uqjl NL0014 2025-11-23T14:10:41.067Z 2025-11-30T15:04:17.799Z
8563963 8563963 20251121174218_M72xH NL0014 2025-11-23T14:09:40.962Z 2025-11-30T15:03:56.966Z
8563789 8563789 20251121172200_YRGun NL0014 2025-11-23T14:09:20.208Z 2025-11-30T15:03:46.550Z

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