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,201 rows where station_code = "DE000R" 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
9217709 9217709 20260116191704_ii2UC DE000R 2026-01-18T14:08:37.921Z 2026-01-25T14:57:45.064Z
9123557 9123557 20251231020423_4vlJr DE000R 2026-01-02T14:30:59.197Z 2026-01-08T15:07:18.149Z
9112351 9112351 20251231022036_w8G6F DE000R 2026-01-01T14:14:47.710Z 2026-01-08T15:07:38.594Z
9112080 9112080 20251231020421_E9XWt DE000R 2026-01-01T14:13:55.435Z 2026-01-08T15:07:17.944Z
9111881 9111881 20251231015029_YrEKy DE000R 2026-01-01T14:13:10.634Z 2026-01-08T15:07:08.179Z
9111512 9111512 20251231011518_vCh6T DE000R 2026-01-01T14:11:47.009Z 2026-01-08T15:06:43.230Z
9111163 9111163 20251231004340_eird1 DE000R 2026-01-01T14:10:20.324Z 2026-01-08T15:06:18.670Z
9110816 9110816 20251231000401_vTU4m DE000R 2026-01-01T14:08:53.438Z 2026-01-08T15:05:52.641Z
9110700 9110700 20251230235129_SxFYs DE000R 2026-01-01T14:08:27.031Z 2026-01-08T15:05:45.907Z
9099290 9099290 20251226200535_sjpJ4 DE000R 2025-12-30T15:23:17.322Z 2026-01-03T15:43:37.474Z
9091067 9091067 20251228174745_MYSDk DE000R 2025-12-30T14:51:41.956Z 2026-01-05T15:14:00.829Z
9086885 9086885 20251228055756_6l7p8 DE000R 2025-12-30T14:42:24.339Z 2026-01-05T15:10:35.140Z
9083143 9083143 20251227230349_DDuzU DE000R 2025-12-30T14:31:46.524Z 2026-01-05T15:07:38.503Z
9082702 9082702 20251227213044_RopPF DE000R 2025-12-30T14:30:17.608Z 2026-01-05T15:07:13.905Z
9080020 9080020 20251229040705_mZn2F DE000R 2025-12-30T14:19:26.112Z 2026-01-06T15:17:48.542Z
9078927 9078927 20251229024035_QEzCK DE000R 2025-12-30T14:15:00.819Z 2026-01-06T15:16:45.788Z
9078797 9078797 20251229023003_l0pgC DE000R 2025-12-30T14:14:31.615Z 2026-01-06T15:16:41.936Z
9076816 9076816 20251228231425_RlbLR DE000R 2025-12-30T14:05:10.141Z 2026-01-06T15:14:55.682Z
9076430 9076430 20251228221141_tgswM DE000R 2025-12-30T14:03:32.217Z 2026-01-06T15:14:36.222Z
9076363 9076363 20251228215736_iSjnD DE000R 2025-12-30T14:03:12.909Z 2026-01-06T15:14:25.663Z
9075966 9075966 20251228204046_CIUta DE000R 2025-12-30T14:00:44.610Z 2026-01-06T15:14:08.355Z
9075134 9075134 20251225210842_lhXfp DE000R 2025-12-29T15:01:30.264Z 2026-01-02T15:48:44.860Z
9072013 9072013 20251226200535_YQpRW DE000R 2025-12-29T14:50:18.832Z 2025-12-29T14:51:19.160Z
9071477 9071477 20251226184346_Y1bj0 DE000R 2025-12-29T14:49:31.331Z 2026-01-03T15:42:56.533Z
9063503 9063503 20251226031758_irGWO DE000R 2025-12-29T14:35:27.352Z 2026-01-03T15:35:21.574Z
9063138 9063138 20251226025620_Co5cx DE000R 2025-12-29T14:34:44.433Z 2026-01-03T15:35:05.661Z
9061592 9061592 20251226011216_9IAok DE000R 2025-12-29T14:31:37.870Z 2026-01-03T15:33:43.410Z
9061182 9061182 20251226004123_ik2Uf DE000R 2025-12-29T14:30:50.939Z 2026-01-03T15:33:29.255Z
9061104 9061104 20251226003311_hCDXV DE000R 2025-12-29T14:30:38.911Z 2026-01-03T15:33:26.640Z
9058085 9058085 20251227053341_OszfM DE000R 2025-12-29T14:24:13.780Z 2026-01-04T15:30:14.044Z
9057384 9057384 20251227045922_RYOWJ DE000R 2025-12-29T14:22:55.849Z 2026-01-04T15:29:44.812Z
9055732 9055732 20251227033606_vFbjM DE000R 2025-12-29T14:18:53.694Z 2026-01-04T15:28:15.749Z
9055086 9055086 20251227030545_uS5Q2 DE000R 2025-12-29T14:17:05.642Z 2026-01-04T15:27:41.462Z
9054397 9054397 20251227023258_kV1Im DE000R 2025-12-29T14:15:25.040Z 2026-01-04T15:27:05.498Z
9053806 9053806 20251227020258_hnZAl DE000R 2025-12-29T14:13:38.202Z 2026-01-04T15:26:31.605Z
9053371 9053371 20251227014102_8e2Dm DE000R 2025-12-29T14:12:28.685Z 2026-01-04T15:26:16.763Z
9053150 9053150 20251227012954_bqReA DE000R 2025-12-29T14:11:54.530Z 2026-01-04T15:25:58.036Z
9053001 9053001 20251227012249_cM5QW DE000R 2025-12-29T14:11:33.856Z 2026-01-04T15:25:53.576Z
9052775 9052775 20251227011206_W7Aua DE000R 2025-12-29T14:11:02.286Z 2026-01-04T15:25:45.231Z
9051569 9051569 20251226235518_fqevH DE000R 2025-12-29T14:07:12.304Z 2026-01-04T15:24:42.286Z
9051157 9051157 20251226232533_bBkJc DE000R 2025-12-29T14:05:52.038Z 2026-01-04T15:24:19.784Z
9051129 9051129 20251226232314_Q6cAQ DE000R 2025-12-29T14:05:46.728Z 2026-01-04T15:24:17.096Z
9050943 9050943 20251226230706_OOxKU DE000R 2025-12-29T14:05:05.912Z 2026-01-04T15:24:09.805Z
9024050 9024050 20251218012700_annlR DE000R 2025-12-27T15:18:54.901Z 2025-12-27T15:18:54.901Z
9015692 9015692 20251221230227_XWkcU DE000R 2025-12-27T14:54:33.511Z 2025-12-27T14:54:33.511Z
9015026 9015026 20251221205453_osL3z DE000R 2025-12-27T14:53:39.313Z 2025-12-27T14:53:39.313Z
9014984 9014984 20251221204925_EwjgD DE000R 2025-12-27T14:53:32.679Z 2025-12-27T14:53:32.679Z
8997353 8997353 20251222040623_xB15C DE000R 2025-12-27T14:09:22.876Z 2025-12-30T15:46:35.463Z
8996552 8996552 20251222023003_hT7yG DE000R 2025-12-27T14:05:21.627Z 2025-12-30T15:45:49.051Z
8996139 8996139 20251222013227_0EfM2 DE000R 2025-12-27T14:03:07.786Z 2025-12-30T15:45:43.931Z
8995757 8995757 20251222001909_4sYPS DE000R 2025-12-27T14:01:20.489Z 2025-12-30T15:45:38.661Z
8985822 8985822 20251218032556_NlHCx DE000R 2025-12-26T14:36:05.290Z 2025-12-27T15:19:06.283Z
8985206 8985206 20251218013410_O4pBw DE000R 2025-12-26T14:33:39.021Z 2025-12-27T15:18:55.615Z
8985165 8985165 20251218012700_g934z DE000R 2025-12-26T14:33:04.621Z 2025-12-27T15:18:54.851Z
8971321 8971321 20251217000024_lGs1A DE000R 2025-12-25T14:53:44.012Z 2025-12-25T14:53:44.012Z
8971299 8971299 20251216235724_4bpsH DE000R 2025-12-25T14:53:43.248Z 2025-12-25T14:53:43.248Z
8753996 8753996 20251210011848_HWAt0 DE000R 2025-12-13T15:42:27.610Z 2025-12-17T15:28:20.871Z
8753624 8753624 20251210004859_c4UPr DE000R 2025-12-13T15:41:48.701Z 2025-12-17T15:27:58.710Z
8713412 8713412 20251209034342_j8cr7 DE000R 2025-12-10T14:16:21.582Z 2025-12-17T15:34:30.477Z
8666448 8666448 20251201054241_23cdK DE000R 2025-12-02T14:26:14.518Z 2025-12-09T14:59:44.914Z
8666440 8666440 20251201054037_RmJF7 DE000R 2025-12-02T14:26:12.527Z 2025-12-09T14:59:44.758Z
8666396 8666396 20251201053317_5IxxD DE000R 2025-12-02T14:25:56.561Z 2025-12-09T14:59:43.943Z
8666367 8666367 20251201052250_BUGIL DE000R 2025-12-02T14:25:53.452Z 2025-12-09T14:59:43.055Z
8666359 8666359 20251201052148_liFHQ DE000R 2025-12-02T14:25:52.561Z 2025-12-09T14:59:42.787Z
8666334 8666334 20251201051611_tMZ7z DE000R 2025-12-02T14:25:48.025Z 2025-12-09T14:59:42.121Z
8666237 8666237 20251201045518_fy047 DE000R 2025-12-02T14:25:38.701Z 2025-12-09T14:59:40.216Z
8665955 8665955 20251201041333_f9qkJ DE000R 2025-12-02T14:24:58.686Z 2025-12-09T14:59:33.902Z
8665927 8665927 20251201041135_7sMrJ DE000R 2025-12-02T14:24:56.038Z 2025-12-09T14:59:28.319Z
8665919 8665919 20251201041111_nAqt9 DE000R 2025-12-02T14:24:55.422Z 2025-12-09T14:59:26.482Z
8665744 8665744 20251201035358_wPTuF DE000R 2025-12-02T14:24:24.067Z 2025-12-09T14:59:01.092Z
8665731 8665731 20251201035154_PaoJ2 DE000R 2025-12-02T14:24:22.490Z 2025-12-09T14:59:00.870Z
8665692 8665692 20251201035042_2FHf4 DE000R 2025-12-02T14:24:20.125Z 2025-12-09T14:59:00.111Z
8665540 8665540 20251201033403_UQHCG DE000R 2025-12-02T14:23:51.362Z 2025-12-09T14:58:54.864Z
8665520 8665520 20251201033056_li156 DE000R 2025-12-02T14:23:49.035Z 2025-12-09T14:58:54.327Z
8665481 8665481 20251201032346_2Ffst DE000R 2025-12-02T14:23:45.332Z 2025-12-09T14:58:53.581Z
8665279 8665279 20251201025929_3xewr DE000R 2025-12-02T14:23:16.728Z 2025-12-09T14:58:49.718Z
8665103 8665103 20251201022848_xmNy6 DE000R 2025-12-02T14:22:55.840Z 2025-12-09T14:58:45.370Z
8664929 8664929 20251201020529_pH2B4 DE000R 2025-12-02T14:22:28.566Z 2025-12-09T14:58:41.625Z
8664885 8664885 20251201015708_Q2q0x DE000R 2025-12-02T14:22:16.762Z 2025-12-09T14:58:40.278Z
8664721 8664721 20251201013054_VOGBv DE000R 2025-12-02T14:21:58.448Z 2025-12-09T14:58:36.339Z
8664241 8664241 20251130235028_Qm2Lv DE000R 2025-12-02T14:20:33.625Z 2025-12-09T14:58:04.451Z
8574039 8574039 20251122050113_Ndba3 DE000R 2025-11-23T14:42:12.937Z 2025-11-30T15:06:56.038Z
8574034 8574034 20251122050101_02RIc DE000R 2025-11-23T14:42:12.580Z 2025-11-30T15:06:55.869Z
8573780 8573780 20251122040905_8c6YU DE000R 2025-11-23T14:41:59.250Z 2025-11-30T15:06:37.555Z
8573408 8573408 20251122030819_u5zI3 DE000R 2025-11-23T14:41:10.467Z 2025-11-30T15:06:22.507Z
8573388 8573388 20251122030349_lYoIA DE000R 2025-11-23T14:41:09.254Z 2025-11-30T15:06:19.903Z
8573139 8573139 20251122023315_4ciJb DE000R 2025-11-23T14:40:45.861Z 2025-11-30T15:06:10.620Z
8572495 8572495 20251122010049_eIBjI DE000R 2025-11-23T14:39:28.882Z 2025-11-30T15:05:51.273Z
8572493 8572493 20251122010010_xoJSs DE000R 2025-11-23T14:39:28.714Z 2025-11-30T15:05:51.237Z
8572424 8572424 20251122004209_JtX07 DE000R 2025-11-23T14:39:12.922Z 2025-11-30T15:05:49.500Z
8572288 8572288 20251122001813_d7fo4 DE000R 2025-11-23T14:38:36.473Z 2025-11-30T15:05:43.068Z
8572068 8572068 20251121233049_ugzN2 DE000R 2025-11-23T14:37:57.536Z 2025-11-30T15:05:36.500Z
8571702 8571702 20251121215111_fO3KU DE000R 2025-11-23T14:37:40.457Z 2025-11-30T15:05:14.552Z
8571315 8571315 20251121201314_dl3ef DE000R 2025-11-23T14:36:09.733Z 2025-11-30T15:04:53.737Z
8526546 8526546 20251118231938_tDMZ3 DE000R 2025-11-20T14:39:58.685Z 2025-11-27T15:11:54.400Z
8522831 8522831 20251119010149_cGwuM DE000R 2025-11-20T14:16:47.500Z 2025-11-27T15:12:07.256Z
8521985 8521985 20251118230055_ICzjL DE000R 2025-11-20T14:14:05.651Z 2025-11-27T15:11:52.186Z
8520460 8520460 20251118192756_Iivb0 DE000R 2025-11-20T14:09:59.494Z 2025-11-27T15:11:33.418Z
8514043 8514043 20251118013346_do4rq DE000R 2025-11-19T14:36:53.027Z 2025-11-26T15:07:52.172Z
8513360 8513360 20251118002030_oPOgH DE000R 2025-11-19T14:36:15.662Z 2025-11-26T15:07:48.938Z

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