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

8,023 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
9249468 9249468 20260122052653_vgaDn NL000C 2026-01-23T14:15:28.211Z 2026-01-29T14:58:40.882Z
9249460 9249460 20260122052642_Ua8l0 NL000C 2026-01-23T14:15:27.752Z 2026-01-29T14:58:40.657Z
9249386 9249386 20260122050545_58si0 NL000C 2026-01-23T14:15:16.309Z 2026-01-29T14:58:28.267Z
9248805 9248805 20260122021518_tJE7l NL000C 2026-01-23T14:13:53.375Z 2026-01-29T14:57:47.324Z
9248794 9248794 20260122021053_BY27r NL000C 2026-01-23T14:13:52.005Z 2026-01-29T14:57:46.825Z
9248510 9248510 20260122002430_t5tML NL000C 2026-01-23T14:12:57.596Z 2026-01-29T14:57:24.404Z
9248218 9248218 20260121222134_6NOow NL000C 2026-01-23T14:12:15.438Z 2026-01-29T14:57:08.997Z
9248119 9248119 20260121213828_Pi732 NL000C 2026-01-23T14:11:59.085Z 2026-01-29T14:56:55.640Z
9247661 9247661 20260121192439_YaF89 NL000C 2026-01-23T14:10:41.951Z 2026-01-29T14:56:22.104Z
9230059 9230059 20260119031850_TnGqa NL000C 2026-01-20T14:25:43.204Z 2026-01-27T15:04:22.788Z
9230038 9230038 20260119031453_RI6BP NL000C 2026-01-20T14:25:34.538Z 2026-01-27T15:04:21.700Z
9229389 9229389 20260119013912_OLx0J NL000C 2026-01-20T14:22:19.170Z 2026-01-27T15:03:21.334Z
9224637 9224637 20260118052545_p41h8 NL000C 2026-01-19T14:25:15.952Z 2026-01-26T15:03:43.301Z
9224598 9224598 20260118051710_DJH7F NL000C 2026-01-19T14:25:08.779Z 2026-01-26T15:03:30.352Z
9224539 9224539 20260118050958_1Acd6 NL000C 2026-01-19T14:24:48.549Z 2026-01-26T15:03:23.092Z
9224178 9224178 20260118034333_e5V6m NL000C 2026-01-19T14:23:10.989Z 2026-01-26T15:03:07.783Z
9223880 9223880 20260118024146_sUapK NL000C 2026-01-19T14:21:41.293Z 2026-01-26T15:02:39.974Z
9223813 9223813 20260118022544_g7SQw NL000C 2026-01-19T14:21:15.667Z 2026-01-26T15:02:36.964Z
9223665 9223665 20260118015924_inFHS NL000C 2026-01-19T14:20:34.265Z 2026-01-26T15:02:31.490Z
9223553 9223553 20260118011951_iCRcG NL000C 2026-01-19T14:19:56.077Z 2026-01-26T15:02:14.139Z
9223433 9223433 20260118003951_3PhQT NL000C 2026-01-19T14:19:19.671Z 2026-01-26T15:02:06.674Z
9223387 9223387 20260118002945_QxbkH NL000C 2026-01-19T14:19:00.207Z 2026-01-26T15:02:04.848Z
9223344 9223344 20260118001908_3IJcH NL000C 2026-01-19T14:18:51.087Z 2026-01-26T15:02:03.259Z
9223311 9223311 20260118001046_Io4aE NL000C 2026-01-19T14:18:38.692Z 2026-01-26T15:02:01.857Z
9222980 9222980 20260117215829_yGbcw NL000C 2026-01-19T14:17:11.508Z 2026-01-26T15:01:30.917Z
9222834 9222834 20260117210114_2i4gX NL000C 2026-01-19T14:16:26.879Z 2026-01-26T15:01:22.659Z
9222774 9222774 20260117204837_QBbHD NL000C 2026-01-19T14:16:11.469Z 2026-01-26T15:01:20.459Z
9222630 9222630 20260117201156_Tf5JR NL000C 2026-01-19T14:15:38.914Z 2026-01-26T15:01:15.679Z
9222560 9222560 20260117195600_4PSI1 NL000C 2026-01-19T14:15:16.866Z 2026-01-26T15:01:13.573Z
9222421 9222421 20260117193016_8ag73 NL000C 2026-01-19T14:14:42.308Z 2026-01-26T15:00:53.128Z
9222168 9222168 20260117183601_R2Ow8 NL000C 2026-01-19T14:13:34.580Z 2026-01-26T15:00:42.645Z
9195048 9195048 20260113000725_O1xzo NL000C 2026-01-14T14:11:50.135Z 2026-01-21T15:04:35.551Z
9182706 9182706 20260111061631_xSgyW NL000C 2026-01-12T14:15:28.268Z 2026-01-19T15:18:56.108Z
9182701 9182701 20260111061514_ZTdys NL000C 2026-01-12T14:15:27.448Z 2026-01-19T15:18:55.812Z
9182646 9182646 20260111060020_rnTwg NL000C 2026-01-12T14:15:16.912Z 2026-01-19T15:18:53.357Z
9182578 9182578 20260111054611_QbQn3 NL000C 2026-01-12T14:15:02.407Z 2026-01-19T15:18:49.831Z
9182574 9182574 20260111054422_5RSrF NL000C 2026-01-12T14:15:01.537Z 2026-01-19T15:18:49.629Z
9182558 9182558 20260111054226_wD5WX NL000C 2026-01-12T14:14:59.268Z 2026-01-19T15:18:49.215Z
9182531 9182531 20260111053727_enKcG NL000C 2026-01-12T14:14:52.380Z 2026-01-19T15:18:48.405Z
9182406 9182406 20260111052108_5P62T NL000C 2026-01-12T14:14:28.532Z 2026-01-19T15:18:31.160Z
9182141 9182141 20260111042913_tg7eq NL000C 2026-01-12T14:13:27.057Z 2026-01-19T15:18:17.258Z
9182123 9182123 20260111042507_ibrAD NL000C 2026-01-12T14:13:21.133Z 2026-01-19T15:18:16.507Z
9181764 9181764 20260111030418_XPnXP NL000C 2026-01-12T14:12:04.600Z 2026-01-19T15:17:47.724Z
9181734 9181734 20260111030028_oecea NL000C 2026-01-12T14:11:54.960Z 2026-01-19T15:17:46.323Z
9181487 9181487 20260111015612_SxVfi NL000C 2026-01-12T14:10:56.973Z 2026-01-19T15:17:21.243Z
9181476 9181476 20260111015543_hXrfg NL000C 2026-01-12T14:10:54.974Z 2026-01-19T15:17:20.924Z
9180848 9180848 20260110225718_5Pk5d NL000C 2026-01-12T14:08:35.420Z 2026-01-19T15:16:35.096Z
9180797 9180797 20260110223506_UPhAU NL000C 2026-01-12T14:08:23.654Z 2026-01-19T15:16:32.933Z
9180790 9180790 20260110223037_pzANr NL000C 2026-01-12T14:08:21.781Z 2026-01-19T15:16:32.558Z
9162055 9162055 20260106192231_bRLWa NL000C 2026-01-08T14:02:21.850Z 2026-01-13T15:01:29.027Z
9162017 9162017 20260106182821_DXK2o NL000C 2026-01-08T14:01:52.176Z 2026-01-13T15:01:22.794Z
9161990 9161990 20260106181310_BQmtR NL000C 2026-01-08T14:01:35.779Z 2026-01-13T15:01:14.827Z
9138184 9138184 20260103220854_OmeN8 NL000C 2026-01-05T14:09:30.156Z 2026-01-12T15:02:42.513Z
9125975 9125975 20251230173253_psECw NL000C 2026-01-02T15:06:40.918Z 2026-01-07T15:12:24.834Z
9124399 9124399 20251231061856_tNGX6 NL000C 2026-01-02T14:45:25.027Z 2026-01-08T15:11:53.675Z
9124350 9124350 20251231060330_gEVoo NL000C 2026-01-02T14:44:46.921Z 2026-01-08T15:11:43.439Z
9124316 9124316 20251231055715_GRug7 NL000C 2026-01-02T14:44:31.812Z 2026-01-08T15:11:38.567Z
9124230 9124230 20251231053006_g0Lz2 NL000C 2026-01-02T14:43:19.104Z 2026-01-08T15:11:13.145Z
9124155 9124155 20251231050129_sIPla NL000C 2026-01-02T14:41:59.441Z 2026-01-08T15:10:43.849Z
9124122 9124122 20251231045128_4V8M8 NL000C 2026-01-02T14:41:20.163Z 2026-01-08T15:10:28.734Z
9124118 9124118 20251231045126_2fYrA NL000C 2026-01-02T14:41:19.248Z 2026-01-08T15:10:28.495Z
9123845 9123845 20251231034813_YEqgk NL000C 2026-01-02T14:36:55.967Z 2026-01-08T15:09:08.617Z
9123816 9123816 20251231033452_yL8uo NL000C 2026-01-02T14:36:08.969Z 2026-01-08T15:08:48.540Z
9123811 9123811 20251231033136_bWIGb NL000C 2026-01-02T14:35:57.250Z 2026-01-08T15:08:46.458Z
9123759 9123759 20251231031242_3Ofj4 NL000C 2026-01-02T14:34:49.799Z 2026-01-08T15:08:31.852Z
9123681 9123681 20251231025633_U2CzP NL000C 2026-01-02T14:33:52.086Z 2026-01-08T15:08:11.254Z
9123548 9123548 20251231015756_ZUvzy NL000C 2026-01-02T14:30:40.459Z 2026-01-08T15:07:14.485Z
9123435 9123435 20251231005031_MsyFN NL000C 2026-01-02T14:27:41.280Z 2026-01-08T15:06:21.493Z
9123226 9123226 20251230215234_YLVOq NL000C 2026-01-02T14:21:51.893Z 2026-01-08T15:04:51.848Z
9123212 9123212 20251230213638_VjmTZ NL000C 2026-01-02T14:21:38.492Z 2026-01-08T15:04:49.030Z
9119316 9119316 20251230173254_o6HE8 NL000C 2026-01-01T14:55:42.025Z 2026-01-07T15:12:24.755Z
9118750 9118750 20251230053757_tjdYx NL000C 2026-01-01T14:49:52.885Z 2026-01-07T15:09:35.758Z
9118709 9118709 20251230043248_FUcaM NL000C 2026-01-01T14:47:29.217Z 2026-01-07T15:08:46.495Z
9118698 9118698 20251230035420_SNszy NL000C 2026-01-01T14:46:14.703Z 2026-01-07T15:08:18.073Z
9116345 9116345 20251231060516_NmuDI NL000C 2026-01-01T14:27:49.814Z 2026-01-08T15:11:44.571Z
9116324 9116324 20251231060330_QHkQT NL000C 2026-01-01T14:27:46.922Z 2026-01-08T15:11:43.281Z
9116286 9116286 20251231060032_EYsgr NL000C 2026-01-01T14:27:42.274Z 2026-01-08T15:11:41.496Z
9116250 9116250 20251231055834_kga0c NL000C 2026-01-01T14:27:34.956Z 2026-01-01T14:57:54.707Z
9116198 9116198 20251231055714_T9RbE NL000C 2026-01-01T14:27:28.863Z 2026-01-08T15:11:38.449Z
9116055 9116055 20251231054737_dzDSK NL000C 2026-01-01T14:27:14.258Z 2026-01-01T14:57:54.633Z
9115949 9115949 20251231053507_ZNbnC NL000C 2026-01-01T14:26:48.455Z 2026-01-08T15:11:17.815Z
9115812 9115812 20251231053006_GgFOf NL000C 2026-01-01T14:26:35.428Z 2026-01-08T15:11:13.066Z
9115520 9115520 20251231051233_uWf5C NL000C 2026-01-01T14:25:39.048Z 2026-01-08T15:10:51.135Z
9115353 9115353 20251231050129_xtGFF NL000C 2026-01-01T14:25:08.455Z 2026-01-08T15:10:43.731Z
9115168 9115168 20251231045128_wfzlQ NL000C 2026-01-01T14:24:38.130Z 2026-01-08T15:10:28.615Z
9114448 9114448 20251231041751_D0wcF NL000C 2026-01-01T14:22:33.443Z 2026-01-08T15:09:48.840Z
9113767 9113767 20251231034813_hj7WR NL000C 2026-01-01T14:20:22.560Z 2026-01-08T15:09:08.767Z
9113619 9113619 20251231033941_KoYYC NL000C 2026-01-01T14:19:45.873Z 2026-01-08T15:08:54.217Z
9113533 9113533 20251231033452_34bbo NL000C 2026-01-01T14:19:25.190Z 2026-01-08T15:08:48.405Z
9113469 9113469 20251231033136_ztoCc NL000C 2026-01-01T14:19:06.034Z 2026-01-01T14:57:53.067Z
9113376 9113376 20251231032557_tNiSv NL000C 2026-01-01T14:18:40.623Z 2026-01-08T15:08:41.885Z
9113158 9113158 20251231031316_pU1k3 NL000C 2026-01-01T14:17:45.432Z 2026-01-08T15:08:32.685Z
9112928 9112928 20251231030010_4P32Y NL000C 2026-01-01T14:16:49.291Z 2026-01-08T15:08:14.184Z
9112852 9112852 20251231025635_Wz8t1 NL000C 2026-01-01T14:16:32.984Z 2026-01-08T15:08:11.391Z
9112029 9112029 20251231015756_c4syt NL000C 2026-01-01T14:13:37.017Z 2026-01-08T15:07:14.299Z
9111218 9111218 20251231005031_AWaFd NL000C 2026-01-01T14:10:33.745Z 2026-01-08T15:06:21.673Z
9110668 9110668 20251230235020_rd53G NL000C 2026-01-01T14:08:21.211Z 2026-01-08T15:05:44.985Z
9110442 9110442 20251230231002_3TP7B NL000C 2026-01-01T14:07:13.736Z 2026-01-01T14:57:49.691Z
9110211 9110211 20251230223550_rQ2wH NL000C 2026-01-01T14:06:21.399Z 2026-01-01T14:57:49.338Z
9110001 9110001 20251230215831_Idnbr NL000C 2026-01-01T14:05:18.173Z 2026-01-01T14:57:49.127Z

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