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

1,531 rows where station_code = "NL000G" 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
8665819 8665819 20251201040111_A0swZ NL000G 2025-12-02T14:24:32.109Z 2025-12-06T14:42:04.294Z
8665733 8665733 20251201035209_aImaY NL000G 2025-12-02T14:24:22.835Z 2025-12-06T14:41:47.537Z
8664936 8664936 20251201020606_9sZE2 NL000G 2025-12-02T14:22:28.885Z 2025-12-06T14:41:03.413Z
8664683 8664683 20251201012413_6L3bi NL000G 2025-12-02T14:21:47.341Z 2025-12-06T14:40:54.588Z
8664561 8664561 20251201005710_B5lVw NL000G 2025-12-02T14:21:22.199Z 2025-12-06T14:40:51.012Z
8664521 8664521 20251201004725_l82dC NL000G 2025-12-02T14:21:15.323Z 2025-12-06T14:40:49.371Z
8664270 8664270 20251130235443_oRchX NL000G 2025-12-02T14:20:37.130Z 2025-12-06T14:40:43.087Z
8664162 8664162 20251130232848_CGZzC NL000G 2025-12-02T14:20:13.351Z 2025-12-06T14:40:39.850Z
8664119 8664119 20251130231856_V2jb1 NL000G 2025-12-02T14:20:06.737Z 2025-12-06T14:40:35.793Z
8663975 8663975 20251130225156_Mfxji NL000G 2025-12-02T14:19:43.824Z 2025-12-06T14:40:18.458Z
8663968 8663968 20251130225111_23TAH NL000G 2025-12-02T14:19:42.877Z 2025-12-06T14:40:18.103Z
8653715 8653715 20251130023752_390z5 NL000G 2025-12-01T14:24:06.120Z 2025-12-06T14:48:30.828Z
8653346 8653346 20251130021146_7FcLo NL000G 2025-12-01T14:23:15.801Z 2025-12-06T14:47:56.377Z
8652389 8652389 20251130010553_fGSqU NL000G 2025-12-01T14:21:20.062Z 2025-12-06T14:47:36.584Z
8645359 8645359 20251128212637_FLRHN NL000G 2025-11-30T14:23:36.355Z 2025-12-06T14:54:54.345Z
8578915 8578915 20251122214937_3DrEE NL000G 2025-11-24T14:13:05.696Z 2025-12-01T15:19:55.852Z
8578781 8578781 20251122212431_gv6dx NL000G 2025-11-24T14:12:39.803Z 2025-12-01T15:19:52.774Z
8577795 8577795 20251122185529_ccibK NL000G 2025-11-24T14:09:40.991Z 2025-12-01T15:18:57.756Z
8577476 8577476 20251122181532_55JB3 NL000G 2025-11-24T14:08:44.998Z 2025-12-01T15:18:51.396Z
8577276 8577276 20251122175117_5s7gw NL000G 2025-11-24T14:08:11.161Z 2025-12-01T15:18:46.308Z
8573725 8573725 20251122035925_hwHIm NL000G 2025-11-23T14:41:56.400Z 2025-11-30T15:06:36.539Z
8573671 8573671 20251122035105_iG8TK NL000G 2025-11-23T14:41:49.420Z 2025-11-30T15:06:35.099Z
8571041 8571041 20251121184105_QK5F3 NL000G 2025-11-23T14:35:54.923Z 2025-11-30T15:04:24.697Z
8569064 8569064 20251121054449_k32do NL000G 2025-11-23T14:31:53.272Z 2025-11-29T14:54:47.732Z
8568608 8568608 20251121052728_7uwtS NL000G 2025-11-23T14:31:15.961Z 2025-11-29T14:54:47.098Z
8567946 8567946 20251121042735_28jk0 NL000G 2025-11-23T14:29:36.139Z 2025-11-29T14:54:44.338Z
8567241 8567241 20251122044645_2wS2k NL000G 2025-11-23T14:19:20.055Z 2025-11-23T14:19:20.055Z
8567190 8567190 20251122043347_xkMWX NL000G 2025-11-23T14:19:06.402Z 2025-11-30T15:06:48.569Z
8567153 8567153 20251122042152_upzz2 NL000G 2025-11-23T14:19:01.684Z 2025-11-30T15:06:44.446Z
8566988 8566988 20251122033139_fXM4r NL000G 2025-11-23T14:18:24.698Z 2025-11-30T15:06:30.691Z
8566962 8566962 20251122032139_93L24 NL000G 2025-11-23T14:18:19.174Z 2025-11-30T15:06:28.470Z
8566855 8566855 20251122024106_YeFBu NL000G 2025-11-23T14:17:46.292Z 2025-11-30T15:06:11.882Z
8565278 8565278 20251121201140_ApYBy NL000G 2025-11-23T14:12:54.468Z 2025-11-30T15:04:53.575Z
8565217 8565217 20251121200527_kx3a5 NL000G 2025-11-23T14:12:47.994Z 2025-11-30T15:04:52.819Z
8559757 8559757 20251121042524_XNhXT NL000G 2025-11-22T14:42:03.252Z 2025-11-29T14:54:43.817Z
8552775 8552775 20251120043017_caCZ1 NL000G 2025-11-22T14:33:03.351Z 2025-11-28T14:57:40.265Z
8536628 8536628 20251120044538_h3Ihq NL000G 2025-11-21T14:18:44.836Z 2025-11-28T14:57:47.125Z
8536554 8536554 20251120043401_XdMw2 NL000G 2025-11-21T14:18:37.261Z 2025-11-28T14:57:41.532Z
8536473 8536473 20251120042531_91vOA NL000G 2025-11-21T14:18:20.900Z 2025-11-28T14:57:38.041Z
8536280 8536280 20251120040130_o9Odc NL000G 2025-11-21T14:18:03.314Z 2025-11-28T14:57:30.538Z
8536149 8536149 20251120034259_KtVSz NL000G 2025-11-21T14:17:40.243Z 2025-11-28T14:57:26.021Z
8535696 8535696 20251120024033_ZlZK2 NL000G 2025-11-21T14:16:38.771Z 2025-11-28T14:56:57.886Z
8535622 8535622 20251120023123_cRx2w NL000G 2025-11-21T14:16:32.647Z 2025-11-28T14:56:52.105Z
8535552 8535552 20251120021640_yHfwL NL000G 2025-11-21T14:16:22.361Z 2025-11-28T14:56:46.517Z
8535481 8535481 20251120021141_3E2zQ NL000G 2025-11-21T14:16:07.404Z 2025-11-28T14:56:41.078Z
8535118 8535118 20251120011614_2526b NL000G 2025-11-21T14:15:19.673Z 2025-11-28T14:56:17.787Z
8535083 8535083 20251120011308_odTUU NL000G 2025-11-21T14:15:16.265Z 2025-11-28T14:56:15.475Z
8535043 8535043 20251120010650_bEKU9 NL000G 2025-11-21T14:15:12.328Z 2025-11-28T14:56:12.539Z
8535026 8535026 20251120010051_l52gw NL000G 2025-11-21T14:15:09.580Z 2025-11-28T14:56:11.617Z
8534987 8534987 20251120005559_wjqBG NL000G 2025-11-21T14:15:04.886Z 2025-11-28T14:56:11.027Z
8534926 8534926 20251120004525_y36d2 NL000G 2025-11-21T14:14:52.286Z 2025-11-28T14:56:08.634Z
8534892 8534892 20251120003753_umNvx NL000G 2025-11-21T14:14:48.098Z 2025-11-28T14:56:05.063Z
8534883 8534883 20251120003608_axgro NL000G 2025-11-21T14:14:47.190Z 2025-11-28T14:56:04.184Z
8534860 8534860 20251120003409_GhTr2 NL000G 2025-11-21T14:14:45.173Z 2025-11-28T14:56:03.968Z
8534386 8534386 20251119231317_vSe86 NL000G 2025-11-21T14:13:46.317Z 2025-11-28T14:55:45.388Z
8534296 8534296 20251119225626_V8mi3 NL000G 2025-11-21T14:13:27.947Z 2025-11-28T14:55:40.827Z
8534237 8534237 20251119224053_j5ro1 NL000G 2025-11-21T14:13:21.304Z 2025-11-28T14:55:39.602Z
8526330 8526330 20251118220831_MAAYb NL000G 2025-11-20T14:39:51.740Z 2025-11-27T15:11:43.320Z
8064463 8064463 20251004193730_DAdj3 NL000G 2025-10-07T12:28:44.746Z 2025-10-13T12:33:25.399Z
7994773 7994773 20250927234015_hCw6V NL000G 2025-09-29T12:22:11.272Z 2025-10-05T13:07:02.641Z
7994722 7994722 20250927233148_RlobL NL000G 2025-09-29T12:21:55.831Z 2025-10-05T13:07:01.592Z
7994393 7994393 20250927225017_CREmI NL000G 2025-09-29T12:21:08.111Z 2025-10-05T13:06:54.006Z
7994392 7994392 20250927224941_kq2L8 NL000G 2025-09-29T12:21:07.781Z 2025-10-05T13:06:53.983Z
7994372 7994372 20250927224756_ooGTp NL000G 2025-09-29T12:21:05.766Z 2025-10-05T13:06:53.807Z
7994031 7994031 20250927215742_Ipwgg NL000G 2025-09-29T12:20:02.869Z 2025-10-05T13:06:47.791Z
7994029 7994029 20250927215716_ZA2er NL000G 2025-09-29T12:20:02.654Z 2025-10-05T13:06:47.781Z
7993954 7993954 20250927214150_DjrOa NL000G 2025-09-29T12:19:53.568Z 2025-10-05T13:06:46.452Z
7993915 7993915 20250927213343_BJnbQ NL000G 2025-09-29T12:19:49.688Z 2025-10-05T13:06:46.030Z
7993776 7993776 20250927210954_CDQn3 NL000G 2025-09-29T12:19:20.136Z 2025-10-05T13:06:42.530Z
7982569 7982569 20250926192547_aVvsd NL000G 2025-09-28T12:20:02.112Z 2025-10-05T13:10:20.389Z
7982381 7982381 20250926185025_kcOtZ NL000G 2025-09-28T12:19:34.892Z 2025-10-05T13:10:16.851Z
7961166 7961166 20250925011302_fWkhT NL000G 2025-09-26T12:25:39.473Z 2025-10-03T13:04:15.252Z
7960890 7960890 20250925010034_opYyf NL000G 2025-09-26T12:25:11.741Z 2025-10-03T13:04:13.987Z
7960851 7960851 20250925005648_QEvMj NL000G 2025-09-26T12:25:08.115Z 2025-10-03T13:04:13.804Z
7960615 7960615 20250925004715_DCm4T NL000G 2025-09-26T12:24:56.180Z 2025-10-03T13:04:13.080Z
7960048 7960048 20250925001204_WyNi0 NL000G 2025-09-26T12:24:10.821Z 2025-10-03T13:04:06.964Z
7959701 7959701 20250924235103_NIlba NL000G 2025-09-26T12:23:30.366Z 2025-10-03T13:04:05.626Z
7951531 7951531 20250922193706_lOsSK NL000G 2025-09-25T12:43:31.661Z 2025-10-01T13:23:10.768Z
7946631 7946631 20250923231848_B0y2O NL000G 2025-09-25T12:29:12.957Z 2025-10-02T13:26:41.730Z
7945980 7945980 20250923224350_ccmdj NL000G 2025-09-25T12:28:13.732Z 2025-10-02T13:26:36.127Z
7944508 7944508 20250923205937_zRjVR NL000G 2025-09-25T12:25:24.071Z 2025-10-02T13:26:26.514Z
7943057 7943057 20250923192125_mFyHe NL000G 2025-09-25T12:21:52.431Z 2025-10-02T13:26:06.555Z
7931384 7931384 20250921223700_X3tMb NL000G 2025-09-24T12:48:41.413Z 2025-09-30T13:02:44.317Z
7931359 7931359 20250921223530_TO6vw NL000G 2025-09-24T12:48:39.752Z 2025-09-30T13:02:44.255Z
7931142 7931142 20250921222700_kLKNf NL000G 2025-09-24T12:48:27.893Z 2025-09-30T13:02:42.144Z
7931056 7931056 20250921222321_IbD2G NL000G 2025-09-24T12:48:20.776Z 2025-09-30T13:02:39.943Z
7931044 7931044 20250921222237_yiZbY NL000G 2025-09-24T12:48:20.503Z 2025-09-30T13:02:39.911Z
7930656 7930656 20250921220413_08Rnu NL000G 2025-09-24T12:47:49.794Z 2025-09-30T13:02:36.435Z
7930465 7930465 20250921215634_4bA0Z NL000G 2025-09-24T12:47:37.316Z 2025-09-30T13:02:34.842Z
7929898 7929898 20250921212424_i7w2j NL000G 2025-09-24T12:47:13.758Z 2025-09-30T13:02:29.232Z
7929627 7929627 20250921211008_L8dgs NL000G 2025-09-24T12:47:06.347Z 2025-09-30T13:02:24.688Z
7929393 7929393 20250921205628_Vyl20 NL000G 2025-09-24T12:47:00.027Z 2025-09-30T13:02:21.220Z
7929304 7929304 20250921205312_VU4Qe NL000G 2025-09-24T12:46:57.791Z 2025-09-30T13:02:20.953Z
7928925 7928925 20250921202555_jLls9 NL000G 2025-09-24T12:46:47.058Z 2025-09-30T13:02:16.992Z
7928307 7928307 20250921194509_V6jlz NL000G 2025-09-24T12:45:36.999Z 2025-09-30T13:02:10.556Z
7928231 7928231 20250921193941_Ubp4Y NL000G 2025-09-24T12:45:31.861Z 2025-09-30T13:02:10.229Z
7928016 7928016 20250921192239_zILkh NL000G 2025-09-24T12:45:26.204Z 2025-09-30T13:02:09.497Z
7892300 7892300 20250919194732_u3oMp NL000G 2025-09-21T12:33:36.531Z 2025-09-28T12:54:17.832Z
7863626 7863626 20250916221927_m9jwH NL000G 2025-09-18T12:35:05.582Z 2025-09-24T13:17:39.354Z
7855402 7855402 20250915213749_ZAfLJ NL000G 2025-09-17T12:36:22.981Z 2025-09-22T13:05:53.887Z

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