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,721 rows where station_code = "NL0011" 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
9610525 9610525 20260404201007_vl2cZ NL0011 2026-04-06T12:09:55.378Z 2026-04-06T12:16:14.589Z
9608970 9608970 20260404025347_eRTaC NL0011 2026-04-05T12:12:25.969Z 2026-04-06T12:20:54.236Z
9608838 9608838 20260404015526_Wza9K NL0011 2026-04-05T12:11:55.059Z 2026-04-06T12:20:42.494Z
9607112 9607112 20260404033801_YVfnv NL0011 2026-04-05T12:00:28.011Z 2026-04-06T12:16:14.364Z
9607035 9607035 20260404031701_sYlh2 NL0011 2026-04-05T12:00:11.932Z 2026-04-06T12:16:14.347Z
9606963 9606963 20260403011606_2ret2 NL0011 2026-04-04T12:12:34.021Z 2026-04-06T12:23:59.537Z
9606902 9606902 20260402232610_HFsQe NL0011 2026-04-04T12:12:12.668Z 2026-04-06T12:23:55.018Z
9606865 9606865 20260402223325_2Gxhi NL0011 2026-04-04T12:12:01.426Z 2026-04-06T12:23:52.731Z
9606761 9606761 20260402204225_9TE42 NL0011 2026-04-04T12:11:31.451Z 2026-04-06T12:23:39.872Z
9606746 9606746 20260402200327_W4lqa NL0011 2026-04-04T12:11:23.291Z 2026-04-06T12:23:36.702Z
9594969 9594969 20260329010951_3eoM6 NL0011 2026-03-30T12:10:41.898Z 2026-04-06T12:40:21.801Z
9594694 9594694 20260329000212_xAdLc NL0011 2026-03-30T12:10:10.884Z 2026-04-06T12:40:04.282Z
9594560 9594560 20260328225949_OFNYm NL0011 2026-03-30T12:09:49.696Z 2026-04-06T12:39:57.104Z
9594313 9594313 20260328212340_cn3Uy NL0011 2026-03-30T12:09:17.570Z 2026-04-06T12:39:47.746Z
9592816 9592816 20260329032827_S2Ws6 NL0011 2026-03-30T12:01:59.677Z 2026-04-06T12:34:29.454Z
9592249 9592249 20260329013057_qnvgD NL0011 2026-03-30T12:00:28.585Z 2026-04-06T12:33:55.260Z
9588713 9588713 20260327003856_QNjg8 NL0011 2026-03-28T12:11:42.145Z 2026-04-04T12:42:28.726Z
9588642 9588642 20260327001518_4WhTd NL0011 2026-03-28T12:11:30.379Z 2026-04-04T12:42:23.505Z
9588510 9588510 20260326233120_vAKvo NL0011 2026-03-28T12:11:17.909Z 2026-04-04T12:42:17.224Z
9588416 9588416 20260326223743_hNcX5 NL0011 2026-03-28T12:11:07.575Z 2026-04-04T12:42:07.088Z
9586044 9586044 20260327034047_0SxvO NL0011 2026-03-28T12:02:02.573Z 2026-04-05T12:32:58.063Z
9585934 9585934 20260327031251_WacC3 NL0011 2026-03-28T12:01:46.783Z 2026-04-05T12:32:53.534Z
9585809 9585809 20260327024005_GtiMR NL0011 2026-03-28T12:01:25.062Z 2026-04-05T12:32:46.759Z
9585641 9585641 20260327020038_UY0F5 NL0011 2026-03-28T12:00:52.583Z 2026-04-05T12:32:31.410Z
9585633 9585633 20260327015907_izhST NL0011 2026-03-28T12:00:51.464Z 2026-04-05T12:32:31.103Z
9585459 9585459 20260327010511_whLpo NL0011 2026-03-28T12:00:24.248Z 2026-04-05T12:32:22.292Z
9585329 9585329 20260326001623_XBdfJ NL0011 2026-03-27T12:17:08.134Z 2026-04-03T12:39:56.745Z
9585007 9585007 20260325230442_SOTaf NL0011 2026-03-27T12:16:31.667Z 2026-04-03T12:39:46.422Z
9581392 9581392 20260326030633_35KhE NL0011 2026-03-27T12:02:58.049Z 2026-04-04T12:38:59.426Z
9581185 9581185 20260326023406_ARyiT NL0011 2026-03-27T12:02:19.300Z 2026-04-04T12:38:44.980Z
9581130 9581130 20260326022752_oeob8 NL0011 2026-03-27T12:02:12.280Z 2026-04-04T12:38:43.554Z
9580439 9580439 20260326004903_ad8O8 NL0011 2026-03-27T12:00:29.743Z 2026-04-04T12:38:10.479Z
9580434 9580434 20260326004832_GtcCp NL0011 2026-03-27T12:00:29.226Z 2026-04-04T12:38:10.307Z
9575497 9575497 20260323224923_rsav4 NL0011 2026-03-25T12:21:16.356Z 2026-03-31T12:29:00.208Z
9571002 9571002 20260322233158_JujT6 NL0011 2026-03-24T12:24:08.384Z 2026-03-30T12:30:53.486Z
9570923 9570923 20260322231244_Uxn7f NL0011 2026-03-24T12:24:01.990Z 2026-03-30T12:30:52.100Z
9570771 9570771 20260322224431_rnptg NL0011 2026-03-24T12:23:48.087Z 2026-03-30T12:30:49.200Z
9570606 9570606 20260322221453_3o1mf NL0011 2026-03-24T12:23:31.994Z 2026-03-30T12:30:46.499Z
9570027 9570027 20260322185633_z5TLd NL0011 2026-03-24T12:22:29.116Z 2026-03-30T12:30:26.592Z
9570001 9570001 20260322184945_EgZgT NL0011 2026-03-24T12:22:27.099Z 2026-03-30T12:30:26.153Z
9563013 9563013 20260323043655_3IF8K NL0011 2026-03-24T12:04:45.042Z 2026-03-31T12:26:32.351Z
9560930 9560930 20260321223642_dXnNm NL0011 2026-03-23T12:12:07.807Z 2026-03-29T12:21:04.000Z
9560834 9560834 20260321222304_2QR88 NL0011 2026-03-23T12:12:05.011Z 2026-03-29T12:21:03.277Z
9560353 9560353 20260321210438_JJSij NL0011 2026-03-23T12:11:43.548Z 2026-03-29T12:20:59.399Z
9559997 9559997 20260321201955_rxOhN NL0011 2026-03-23T12:11:35.972Z 2026-03-29T12:20:57.307Z
9559970 9559970 20260321201412_MEcwd NL0011 2026-03-23T12:11:34.858Z 2026-03-29T12:20:56.948Z
9559965 9559965 20260321201412_gHMEB NL0011 2026-03-23T12:11:34.739Z 2026-03-29T12:20:56.926Z
9559887 9559887 20260321200509_N6VhR NL0011 2026-03-23T12:11:33.127Z 2026-03-29T12:20:56.323Z
9555073 9555073 20260322040214_jv35f NL0011 2026-03-23T12:03:09.060Z 2026-03-30T12:28:14.155Z
9554977 9554977 20260322035044_PdnVZ NL0011 2026-03-23T12:02:59.926Z 2026-03-30T12:28:12.541Z
9554699 9554699 20260322032634_Pam1q NL0011 2026-03-23T12:02:46.629Z 2026-03-30T12:28:07.396Z
9554662 9554662 20260322032353_ZM9ma NL0011 2026-03-23T12:02:44.854Z 2026-03-30T12:28:06.915Z
9554591 9554591 20260322031916_0Udx6 NL0011 2026-03-23T12:02:42.143Z 2026-03-30T12:28:06.044Z
9554447 9554447 20260322030910_I2SDS NL0011 2026-03-23T12:02:32.243Z 2026-03-30T12:28:03.920Z
9554429 9554429 20260322030704_052Av NL0011 2026-03-23T12:02:31.581Z 2026-03-30T12:28:03.686Z
9553953 9553953 20260322022843_vfHOv NL0011 2026-03-23T12:02:03.112Z 2026-03-30T12:27:55.867Z
9553640 9553640 20260322020313_y4SAZ NL0011 2026-03-23T12:01:44.108Z 2026-03-30T12:27:50.455Z
9553466 9553466 20260322014425_Q27EY NL0011 2026-03-23T12:01:31.924Z 2026-03-30T12:27:41.631Z
9553427 9553427 20260322014117_GVgdj NL0011 2026-03-23T12:01:29.152Z 2026-03-30T12:27:40.795Z
9553249 9553249 20260322012655_ReWmP NL0011 2026-03-23T12:01:21.026Z 2026-03-30T12:27:38.460Z
9552958 9552958 20260322010017_GFoUW NL0011 2026-03-23T12:01:03.770Z 2026-03-30T12:27:32.969Z
9552510 9552510 20260322001524_8iNoc NL0011 2026-03-23T12:00:29.532Z 2026-03-30T12:27:25.343Z
9551792 9551792 20260320213533_UPiCe NL0011 2026-03-22T12:27:03.087Z 2026-03-28T12:37:02.197Z
9551718 9551718 20260320211045_3l4pi NL0011 2026-03-22T12:26:58.394Z 2026-03-28T12:37:00.912Z
9551686 9551686 20260320205759_mO1kZ NL0011 2026-03-22T12:26:56.114Z 2026-03-28T12:37:00.233Z
9551175 9551175 20260320184424_EhxNH NL0011 2026-03-22T12:26:15.415Z 2026-03-28T12:36:40.687Z
9534225 9534225 20260320033745_aVwmk NL0011 2026-03-21T12:07:29.519Z 2026-03-28T12:34:16.350Z
9531260 9531260 20260318225014_Wv086 NL0011 2026-03-20T12:25:03.541Z 2026-03-26T12:39:18.398Z
9531118 9531118 20260318223046_q4jOY NL0011 2026-03-20T12:24:58.188Z 2026-03-26T12:39:17.521Z
9530786 9530786 20260318214319_5RifD NL0011 2026-03-20T12:24:46.542Z 2026-03-26T12:39:15.527Z
9530347 9530347 20260318204026_8UqXH NL0011 2026-03-20T12:24:19.013Z 2026-03-26T12:39:11.399Z
9529595 9529595 20260318185757_cFbOQ NL0011 2026-03-20T12:23:20.391Z 2026-03-26T12:39:04.698Z
9521121 9521121 20260319035420_P0a93 NL0011 2026-03-20T12:07:32.749Z 2026-03-27T12:40:51.803Z
9520946 9520946 20260319034520_NjuYH NL0011 2026-03-20T12:07:16.555Z 2026-03-27T12:40:49.231Z
9520625 9520625 20260319032916_gs330 NL0011 2026-03-20T12:06:42.726Z 2026-03-27T12:40:45.619Z
9520012 9520012 20260319024751_4FwtH NL0011 2026-03-20T12:05:32.335Z 2026-03-27T12:40:38.007Z
9520003 9520003 20260319024731_toRC2 NL0011 2026-03-20T12:05:31.453Z 2026-03-27T12:40:37.885Z
9519409 9519409 20260319020835_Nau6y NL0011 2026-03-20T12:04:26.368Z 2026-03-27T12:40:30.903Z
9518741 9518741 20260319012142_o0TIi NL0011 2026-03-20T12:03:12.510Z 2026-03-27T12:40:13.096Z
9518560 9518560 20260319010815_TrHM3 NL0011 2026-03-20T12:02:49.112Z 2026-03-27T12:40:11.302Z
9518442 9518442 20260319010132_7j2dh NL0011 2026-03-20T12:02:34.373Z 2026-03-27T12:40:09.737Z
9517179 9517179 20260317225008_gVabX NL0011 2026-03-19T12:27:16.826Z 2026-03-25T12:43:09.101Z
9516737 9516737 20260317214637_iuexb NL0011 2026-03-19T12:26:43.192Z 2026-03-25T12:43:06.497Z
9515847 9515847 20260317190435_l9lKm NL0011 2026-03-19T12:25:07.489Z 2026-03-25T12:42:40.165Z
9511366 9511366 20260318034751_Lf314 NL0011 2026-03-19T12:10:02.084Z 2026-03-26T12:37:36.354Z
9511261 9511261 20260318034230_lBv9B NL0011 2026-03-19T12:09:49.050Z 2026-03-26T12:37:32.414Z
9510620 9510620 20260318030422_qX2p6 NL0011 2026-03-19T12:08:08.265Z 2026-03-26T12:37:14.997Z
9510215 9510215 20260318023842_YTR2Q NL0011 2026-03-19T12:07:08.521Z 2026-03-26T12:37:10.854Z
9510205 9510205 20260318023840_L3SvW NL0011 2026-03-19T12:07:07.876Z 2026-03-26T12:37:10.845Z
9510007 9510007 20260318022745_0HB3a NL0011 2026-03-19T12:06:41.965Z 2026-03-26T12:37:09.279Z
9509960 9509960 20260318022326_2W527 NL0011 2026-03-19T12:06:32.533Z 2026-03-26T12:37:08.815Z
9509682 9509682 20260318020653_w0e0A NL0011 2026-03-19T12:05:57.660Z 2026-03-26T12:37:07.022Z
9509677 9509677 20260318020652_fpcnw NL0011 2026-03-19T12:05:57.358Z 2026-03-26T12:37:07.020Z
9509588 9509588 20260318015831_dQFWR NL0011 2026-03-19T12:05:42.577Z 2026-03-26T12:37:06.522Z
9509543 9509543 20260318015720_WkUMn NL0011 2026-03-19T12:05:37.658Z 2026-03-26T12:37:06.322Z
9509269 9509269 20260318013804_SdR6Q NL0011 2026-03-19T12:04:55.634Z 2026-03-26T12:37:04.311Z
9508023 9508023 20260318000722_ST48d NL0011 2026-03-19T12:01:55.981Z 2026-03-26T12:36:55.077Z
9492978 9492978 20260314222708_VFmkv NL0011 2026-03-16T12:29:14.872Z 2026-03-22T12:42:56.121Z
9492863 9492863 20260314220548_V9129 NL0011 2026-03-16T12:29:06.608Z 2026-03-22T12:42:55.463Z
9492739 9492739 20260314215108_VZUFS NL0011 2026-03-16T12:29:00.319Z 2026-03-22T12:42:54.189Z

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