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,062 rows where station_code = "NL0019" 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
9267367 9267367 20260127000317_1aYjW NL0019 2026-01-28T14:21:21.041Z 2026-01-29T14:34:54.902Z
9267365 9267365 20260127000310_5cGlc NL0019 2026-01-28T14:21:19.781Z 2026-01-29T14:34:54.744Z
9260374 9260374 20260125040305_4QT2r NL0019 2026-01-26T14:21:26.642Z 2026-01-29T14:44:08.849Z
9260337 9260337 20260125034936_Fvohr NL0019 2026-01-26T14:21:19.894Z 2026-01-29T14:44:06.642Z
9260297 9260297 20260125032902_8p28N NL0019 2026-01-26T14:21:05.783Z 2026-01-29T14:44:04.343Z
9260293 9260293 20260125032707_zQEx4 NL0019 2026-01-26T14:21:05.171Z 2026-01-29T14:44:04.134Z
9260062 9260062 20260125021856_rck57 NL0019 2026-01-26T14:20:00.032Z 2026-01-29T14:43:44.266Z
9259465 9259465 20260124205550_Z3E2K NL0019 2026-01-26T14:17:06.709Z 2026-01-29T14:42:56.030Z
9256446 9256446 20260121231146_pj92n NL0019 2026-01-25T14:26:30.891Z 2026-01-29T14:57:15.435Z
9249668 9249668 20260122061529_LOu0I NL0019 2026-01-23T14:15:51.995Z 2026-01-29T14:58:48.550Z
9249600 9249600 20260122060309_2jPgp NL0019 2026-01-23T14:15:46.140Z 2026-01-29T14:58:46.280Z
9249473 9249473 20260122052653_vgaDn NL0019 2026-01-23T14:15:28.212Z 2026-01-29T14:58:40.883Z
9249454 9249454 20260122052324_Ue3Ne NL0019 2026-01-23T14:15:26.963Z 2026-01-29T14:58:40.019Z
9249289 9249289 20260122043817_SrQn0 NL0019 2026-01-23T14:15:06.966Z 2026-01-29T14:58:21.738Z
9249196 9249196 20260122040457_GSqms NL0019 2026-01-23T14:14:49.666Z 2026-01-29T14:58:16.344Z
9249190 9249190 20260122040200_336lu NL0019 2026-01-23T14:14:44.910Z 2026-01-29T14:58:15.989Z
9249177 9249177 20260122035608_08vcw NL0019 2026-01-23T14:14:43.324Z 2026-01-29T14:58:15.357Z
9249070 9249070 20260122032654_sfAUB NL0019 2026-01-23T14:14:31.930Z 2026-01-29T14:58:11.347Z
9249046 9249046 20260122032015_23ZHg NL0019 2026-01-23T14:14:29.792Z 2026-01-29T14:58:10.607Z
9249019 9249019 20260122030828_Ph4NP NL0019 2026-01-23T14:14:25.776Z 2026-01-29T14:58:09.065Z
9248850 9248850 20260122022633_nKehQ NL0019 2026-01-23T14:13:58.526Z 2026-01-29T14:57:49.457Z
9248607 9248607 20260122010719_N2lG3 NL0019 2026-01-23T14:13:15.119Z 2026-01-29T14:57:36.437Z
9248124 9248124 20260121213828_Pi732 NL0019 2026-01-23T14:11:59.085Z 2026-01-29T14:56:55.640Z
9247665 9247665 20260121192439_YaF89 NL0019 2026-01-23T14:10:41.951Z 2026-01-29T14:56:22.104Z
9237791 9237791 20260120060503_XfFBZ NL0019 2026-01-21T14:27:38.987Z 2026-01-28T15:01:42.363Z
9237685 9237685 20260120054944_tugK1 NL0019 2026-01-21T14:27:17.800Z 2026-01-28T15:01:35.981Z
9237295 9237295 20260120045900_ZTV2q NL0019 2026-01-21T14:25:51.948Z 2026-01-28T15:01:08.257Z
9236614 9236614 20260120034023_TpHgw NL0019 2026-01-21T14:23:31.890Z 2026-01-28T15:00:24.757Z
9236016 9236016 20260120022747_IaJSp NL0019 2026-01-21T14:21:15.063Z 2026-01-28T14:59:34.174Z
9235964 9235964 20260120022053_76oJi NL0019 2026-01-21T14:20:53.328Z 2026-01-28T14:59:30.488Z
9235309 9235309 20260120005254_qQGsG NL0019 2026-01-21T14:18:26.039Z 2026-01-28T14:58:48.577Z
9235184 9235184 20260120004131_sbZfD NL0019 2026-01-21T14:17:50.932Z 2026-01-28T14:58:41.976Z
9235178 9235178 20260120004050_AP24L NL0019 2026-01-21T14:17:50.080Z 2026-01-28T14:58:37.023Z
9235118 9235118 20260120003124_HqSrD NL0019 2026-01-21T14:17:39.256Z 2026-01-28T14:58:31.378Z
9234947 9234947 20260119235355_tGYgu NL0019 2026-01-21T14:16:47.695Z 2026-01-28T14:58:21.658Z
9231174 9231174 20260119061817_p3XKx NL0019 2026-01-20T14:31:40.553Z 2026-01-27T15:06:03.478Z
9230946 9230946 20260119053156_KNhx1 NL0019 2026-01-20T14:30:33.568Z 2026-01-27T15:05:45.778Z
9230633 9230633 20260119044221_3r82M NL0019 2026-01-20T14:28:59.748Z 2026-01-27T15:05:17.661Z
9224431 9224431 20260118044229_eFHaL NL0019 2026-01-19T14:24:21.320Z 2026-01-26T15:03:18.570Z
9224142 9224142 20260118033348_w9FY1 NL0019 2026-01-19T14:23:03.797Z 2026-01-26T15:03:06.434Z
9223730 9223730 20260118021317_5ceD4 NL0019 2026-01-19T14:20:46.836Z 2026-01-26T15:02:33.939Z
9223474 9223474 20260118005057_qzOuY NL0019 2026-01-19T14:19:29.246Z 2026-01-26T15:02:08.238Z
9223401 9223401 20260118003334_cT7dL NL0019 2026-01-19T14:19:03.835Z 2026-01-26T15:02:05.461Z
9223346 9223346 20260118001908_3IJcH NL0019 2026-01-19T14:18:51.087Z 2026-01-26T15:02:03.259Z
9223315 9223315 20260118001046_Io4aE NL0019 2026-01-19T14:18:38.692Z 2026-01-26T15:02:01.857Z
9222778 9222778 20260117204837_QBbHD NL0019 2026-01-19T14:16:11.470Z 2026-01-26T15:01:20.459Z
9222046 9222046 20260117174959_SimTz NL0019 2026-01-19T14:13:00.078Z 2026-01-26T15:00:35.588Z
9207822 9207822 20260115031351_s87Vi NL0019 2026-01-16T14:10:15.721Z 2026-01-22T15:03:53.945Z
9182743 9182743 20260111062843_X4GeR NL0019 2026-01-12T14:15:37.463Z 2026-01-19T15:18:57.812Z
9182657 9182657 20260111060110_dmmLA NL0019 2026-01-12T14:15:19.884Z 2026-01-19T15:18:53.894Z
9182589 9182589 20260111055018_tVJeb NL0019 2026-01-12T14:15:04.641Z 2026-01-19T15:18:50.413Z
9182561 9182561 20260111054226_LRaJT NL0019 2026-01-12T14:14:59.740Z 2026-01-19T15:18:49.335Z
9182541 9182541 20260111053912_EvLMP NL0019 2026-01-12T14:14:56.333Z 2026-01-19T15:18:48.690Z
9182500 9182500 20260111053238_RWfQ7 NL0019 2026-01-12T14:14:45.930Z 2026-01-19T15:18:44.612Z
9181622 9181622 20260111022740_RYJfs NL0019 2026-01-12T14:11:30.414Z 2026-01-19T15:17:40.741Z
9181481 9181481 20260111015543_ThavK NL0019 2026-01-12T14:10:55.497Z 2026-01-19T15:17:21.046Z
9181428 9181428 20260111014315_ZbP0f NL0019 2026-01-12T14:10:46.150Z 2026-01-19T15:17:17.464Z
9181399 9181399 20260111013757_pTT3s NL0019 2026-01-12T14:10:39.591Z 2026-01-19T15:17:16.332Z
9181061 9181061 20260111000714_jSpLZ NL0019 2026-01-12T14:09:27.085Z 2026-01-19T15:16:46.304Z
9180978 9180978 20260110233759_amw8g NL0019 2026-01-12T14:09:06.954Z 2026-01-19T15:16:42.631Z
9180932 9180932 20260110232900_KFmSh NL0019 2026-01-12T14:08:57.641Z 2026-01-19T15:16:39.330Z
9180917 9180917 20260110232338_gEDQT NL0019 2026-01-12T14:08:52.804Z 2026-01-19T15:16:38.765Z
9162117 9162117 20260106214143_r7DID NL0019 2026-01-08T14:03:01.761Z 2026-01-13T15:01:37.092Z
9162084 9162084 20260106203953_dYDBz NL0019 2026-01-08T14:02:41.903Z 2026-01-13T15:01:34.128Z
9162021 9162021 20260106182821_DXK2o NL0019 2026-01-08T14:01:52.212Z 2026-01-13T15:01:22.794Z
9161994 9161994 20260106181310_BQmtR NL0019 2026-01-08T14:01:35.796Z 2026-01-13T15:01:14.827Z
9160623 9160623 20260106063455_0DsNH NL0019 2026-01-07T14:13:13.608Z 2026-01-13T15:09:42.386Z
9160292 9160292 20260106052405_MCFYD NL0019 2026-01-07T14:12:08.252Z 2026-01-13T15:09:18.652Z
9160109 9160109 20260106044751_3JTvH NL0019 2026-01-07T14:11:25.599Z 2026-01-13T15:09:01.006Z
9159642 9159642 20260106031841_bmfg8 NL0019 2026-01-07T14:10:00.372Z 2026-01-13T15:08:35.720Z
9153615 9153615 20260104040359_T38nw NL0019 2026-01-06T14:33:43.500Z 2026-01-12T15:08:58.137Z
9146910 9146910 20260104044236_dTPrs NL0019 2026-01-05T14:23:14.997Z 2026-01-12T15:09:40.182Z
9143687 9143687 20260104022027_62cmX NL0019 2026-01-05T14:17:57.809Z 2026-01-12T15:06:29.667Z
9143560 9143560 20260104021549_QUpcr NL0019 2026-01-05T14:17:50.851Z 2026-01-12T15:06:27.000Z
9143320 9143320 20260104020541_xgArB NL0019 2026-01-05T14:17:23.047Z 2026-01-12T15:06:19.911Z
9143285 9143285 20260104020454_efIT2 NL0019 2026-01-05T14:17:21.378Z 2026-01-12T15:06:19.227Z
9140758 9140758 20260104002752_n1N2q NL0019 2026-01-05T14:13:34.032Z 2026-01-12T15:04:29.184Z
9140610 9140610 20260104002308_PNGTb NL0019 2026-01-05T14:13:27.547Z 2026-01-12T15:04:26.085Z
9127099 9127099 20260102023034_zFlu4 NL0019 2026-01-03T14:08:28.129Z 2026-01-09T14:49:27.793Z
9123648 9123648 20251231024055_F8cJp NL0019 2026-01-02T14:32:56.720Z 2026-01-08T15:07:52.735Z
9119698 9119698 20251230184241_16TLL NL0019 2026-01-01T14:56:50.971Z 2026-01-07T15:13:10.003Z
9118717 9118717 20251230044625_gcNaV NL0019 2026-01-01T14:47:56.855Z 2026-01-07T15:09:00.377Z
9118715 9118715 20251230043509_DpQOa NL0019 2026-01-01T14:47:40.302Z 2026-01-07T15:08:47.655Z
9118681 9118681 20251230031553_rb3dl NL0019 2026-01-01T14:44:35.028Z 2026-01-07T15:07:45.376Z
9118667 9118667 20251230025129_TjTI2 NL0019 2026-01-01T14:43:46.388Z 2026-01-07T15:07:34.459Z
9118663 9118663 20251230023512_Tb6tf NL0019 2026-01-01T14:43:11.425Z 2026-01-07T15:07:18.179Z
9116201 9116201 20251231055714_T9RbE NL0019 2026-01-01T14:27:28.863Z 2026-01-08T15:11:38.449Z
9115552 9115552 20251231051454_0eLDM NL0019 2026-01-01T14:25:44.908Z 2026-01-08T15:10:54.767Z
9113888 9113888 20251231035316_TaNzE NL0019 2026-01-01T14:20:42.494Z 2026-01-08T15:09:13.968Z
9113536 9113536 20251231033452_34bbo NL0019 2026-01-01T14:19:25.190Z 2026-01-08T15:08:48.405Z
9113379 9113379 20251231032557_tNiSv NL0019 2026-01-01T14:18:40.623Z 2026-01-08T15:08:41.885Z
9113283 9113283 20251231032026_3dpgL NL0019 2026-01-01T14:18:17.700Z 2026-01-08T15:08:38.013Z
9112989 9112989 20251231030432_PBWkt NL0019 2026-01-01T14:17:01.593Z 2026-01-08T15:08:16.605Z
9112787 9112787 20251231025150_LuQPS NL0019 2026-01-01T14:16:18.385Z 2026-01-08T15:08:07.103Z
9112598 9112598 20251231024055_vEEyB NL0019 2026-01-01T14:15:41.056Z 2026-01-01T14:57:52.220Z
9112416 9112416 20251231022544_HScgO NL0019 2026-01-01T14:15:00.813Z 2026-01-08T15:07:42.387Z
9112228 9112228 20251231021307_mMfps NL0019 2026-01-01T14:14:26.845Z 2026-01-08T15:07:34.078Z
9111302 9111302 20251231010031_xlUcS NL0019 2026-01-01T14:10:54.816Z 2026-01-08T15:06:27.981Z
9110986 9110986 20251231002605_wXGvq NL0019 2026-01-01T14:09:39.773Z 2026-01-08T15:06:09.916Z
9110978 9110978 20251231002457_cU1Td NL0019 2026-01-01T14:09:37.963Z 2026-01-08T15:06:09.516Z

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