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

4,601 rows where station_code = "DE0013" 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
8666812 8666812 20251201035145_J4RVT DE0013 2025-12-02T14:28:02.532Z 2025-12-06T14:41:47.162Z
8666493 8666493 20251201055318_I3moa DE0013 2025-12-02T14:26:19.715Z 2025-12-06T14:42:23.868Z
8666478 8666478 20251201054614_DQxWO DE0013 2025-12-02T14:26:18.021Z 2025-12-06T14:42:23.337Z
8666470 8666470 20251201054456_edZYH DE0013 2025-12-02T14:26:16.864Z 2025-12-06T14:42:23.133Z
8666418 8666418 20251201053646_uyosC DE0013 2025-12-02T14:26:00.150Z 2025-12-06T14:42:21.709Z
8666405 8666405 20251201053546_3PbEd DE0013 2025-12-02T14:25:58.702Z 2025-12-06T14:42:21.225Z
8666379 8666379 20251201052646_h2AeI DE0013 2025-12-02T14:25:55.106Z 2025-12-06T14:42:20.193Z
8666288 8666288 20251201050855_jM1Z2 DE0013 2025-12-02T14:25:43.190Z 2025-12-06T14:42:16.569Z
8666246 8666246 20251201050038_Qb0BD DE0013 2025-12-02T14:25:39.413Z 2025-12-06T14:42:15.378Z
8666233 8666233 20251201045507_NNFC0 DE0013 2025-12-02T14:25:38.462Z 2025-12-06T14:42:15.103Z
8666198 8666198 20251201045039_X48kY DE0013 2025-12-02T14:25:35.356Z 2025-12-06T14:42:14.485Z
8666187 8666187 20251201044957_3G723 DE0013 2025-12-02T14:25:34.523Z 2025-12-06T14:42:14.379Z
8666113 8666113 20251201043917_PMePB DE0013 2025-12-02T14:25:15.738Z 2025-12-06T14:42:12.046Z
8666021 8666021 20251201042503_w4YPY DE0013 2025-12-02T14:25:06.723Z 2025-12-06T14:42:09.840Z
8665991 8665991 20251201041758_hmoEL DE0013 2025-12-02T14:25:03.287Z 2025-12-06T14:42:09.065Z
8665969 8665969 20251201041528_xcqua DE0013 2025-12-02T14:24:59.817Z 2025-12-06T14:42:08.095Z
8665908 8665908 20251201040925_uQ3du DE0013 2025-12-02T14:24:54.351Z 2025-12-06T14:42:06.758Z
8665782 8665782 20251201035740_X3dEK DE0013 2025-12-02T14:24:28.618Z 2025-12-06T14:42:03.297Z
8665408 8665408 20251201031723_bjXtK DE0013 2025-12-02T14:23:38.972Z 2025-12-06T14:41:37.073Z
8665344 8665344 20251201030910_S2ENd DE0013 2025-12-02T14:23:33.001Z 2025-12-06T14:41:35.202Z
8665330 8665330 20251201030824_P42by DE0013 2025-12-02T14:23:32.469Z 2025-12-06T14:41:35.002Z
8665300 8665300 20251201030327_CAg26 DE0013 2025-12-02T14:23:18.866Z 2025-12-06T14:41:33.335Z
8665173 8665173 20251201024142_ICPRs DE0013 2025-12-02T14:23:04.437Z 2025-12-06T14:41:28.707Z
8665160 8665160 20251201023918_g5m9A DE0013 2025-12-02T14:23:02.735Z 2025-12-06T14:41:28.330Z
8665129 8665129 20251201023458_7mYLK DE0013 2025-12-02T14:22:59.206Z 2025-12-06T14:41:27.689Z
8665097 8665097 20251201022813_6lfr4 DE0013 2025-12-02T14:22:55.489Z 2025-12-06T14:41:26.284Z
8665085 8665085 20251201022710_D27tg DE0013 2025-12-02T14:22:54.356Z 2025-12-06T14:41:25.202Z
8665074 8665074 20251201022459_NVqDN DE0013 2025-12-02T14:22:46.292Z 2025-12-06T14:41:24.840Z
8665023 8665023 20251201021803_b0CYn DE0013 2025-12-02T14:22:38.018Z 2025-12-06T14:41:07.015Z
8664961 8664961 20251201020824_E3tCc DE0013 2025-12-02T14:22:30.984Z 2025-12-06T14:41:03.939Z
8664954 8664954 20251201020803_pXdMQ DE0013 2025-12-02T14:22:30.342Z 2025-12-06T14:41:03.743Z
8664864 8664864 20251201015229_wEUWa DE0013 2025-12-02T14:22:14.252Z 2025-12-06T14:41:01.353Z
8664754 8664754 20251201013428_J0kd5 DE0013 2025-12-02T14:22:01.687Z 2025-12-06T14:40:56.578Z
8664664 8664664 20251201012027_yuktk DE0013 2025-12-02T14:21:46.044Z 2025-12-06T14:40:54.298Z
8664629 8664629 20251201011508_PpvTf DE0013 2025-12-02T14:21:40.375Z 2025-12-06T14:40:53.374Z
8664604 8664604 20251201011047_B7b6B DE0013 2025-12-02T14:21:37.218Z 2025-12-06T14:40:52.523Z
8664535 8664535 20251201005349_ESwkw DE0013 2025-12-02T14:21:17.099Z 2025-12-06T14:40:49.877Z
8664505 8664505 20251201004307_LtxzA DE0013 2025-12-02T14:21:13.782Z 2025-12-06T14:40:48.927Z
8664489 8664489 20251201004219_S2yuh DE0013 2025-12-02T14:21:12.687Z 2025-12-06T14:40:48.546Z
8664453 8664453 20251201003316_ixYsj DE0013 2025-12-02T14:21:06.676Z 2025-12-06T14:40:47.414Z
8664366 8664366 20251201000953_J6msT DE0013 2025-12-02T14:20:48.375Z 2025-12-06T14:40:45.415Z
8664339 8664339 20251201000600_Lyp1T DE0013 2025-12-02T14:20:44.685Z 2025-12-06T14:40:44.593Z
8664323 8664323 20251201000338_BC30C DE0013 2025-12-02T14:20:42.763Z 2025-12-06T14:40:44.287Z
8646077 8646077 20251129005955_96pgc DE0013 2025-11-30T14:25:09.431Z 2025-12-06T14:55:30.912Z
8646018 8646018 20251129004757_fvF6v DE0013 2025-11-30T14:25:04.482Z 2025-12-06T14:55:26.158Z
8646009 8646009 20251129004644_deP2e DE0013 2025-11-30T14:25:03.843Z 2025-12-06T14:55:25.584Z
8645987 8645987 20251129004149_wSrvt DE0013 2025-11-30T14:25:02.028Z 2025-12-06T14:55:24.271Z
8645870 8645870 20251129000735_Aklxa DE0013 2025-11-30T14:24:38.567Z 2025-12-06T14:55:12.280Z
8645758 8645758 20251128234414_kNF1m DE0013 2025-11-30T14:24:29.835Z 2025-12-06T14:55:05.656Z
8645670 8645670 20251128232409_ninfn DE0013 2025-11-30T14:24:22.921Z 2025-12-06T14:55:01.995Z
8645659 8645659 20251128231915_HNhLT DE0013 2025-11-30T14:24:21.781Z 2025-12-06T14:55:01.800Z
8645556 8645556 20251128224537_spfUL DE0013 2025-11-30T14:24:01.940Z 2025-12-06T14:55:00.177Z
8645421 8645421 20251128220717_EtjXk DE0013 2025-11-30T14:23:42.696Z 2025-12-06T14:54:57.493Z
8624313 8624313 20251127040717_srfl0 DE0013 2025-11-28T14:24:26.621Z 2025-12-05T15:04:58.468Z
8624259 8624259 20251127034934_n52d6 DE0013 2025-11-28T14:24:22.210Z 2025-12-05T15:04:56.780Z
8624179 8624179 20251127032825_1d5Ua DE0013 2025-11-28T14:23:56.726Z 2025-12-05T15:04:51.773Z
8624145 8624145 20251127031915_LiADI DE0013 2025-11-28T14:23:52.297Z 2025-12-05T15:04:48.291Z
8624133 8624133 20251127031507_MPz7y DE0013 2025-11-28T14:23:50.859Z 2025-12-05T15:04:46.455Z
8624067 8624067 20251127030041_QCjXw DE0013 2025-11-28T14:23:42.922Z 2025-12-05T15:04:43.068Z
8623907 8623907 20251127022353_a1MT5 DE0013 2025-11-28T14:23:05.276Z 2025-12-05T15:04:25.790Z
8623892 8623892 20251127022239_JOayL DE0013 2025-11-28T14:23:03.578Z 2025-12-05T15:04:24.315Z
8623778 8623778 20251127015949_FQR2B DE0013 2025-11-28T14:22:51.664Z 2025-12-05T15:04:15.748Z
8623728 8623728 20251127015055_HwYgF DE0013 2025-11-28T14:22:32.356Z 2025-12-05T15:04:12.038Z
8623723 8623723 20251127015031_dY0Vb DE0013 2025-11-28T14:22:30.115Z 2025-12-05T15:04:11.892Z
8623716 8623716 20251127014940_RJhg1 DE0013 2025-11-28T14:22:28.068Z 2025-12-05T15:04:11.343Z
8623586 8623586 20251127011534_tGBtI DE0013 2025-11-28T14:22:13.066Z 2025-12-05T15:04:03.909Z
8623481 8623481 20251127005042_YvVSn DE0013 2025-11-28T14:21:50.126Z 2025-12-05T15:03:55.997Z
8623465 8623465 20251127004616_26dum DE0013 2025-11-28T14:21:47.298Z 2025-12-05T15:03:54.780Z
8623440 8623440 20251127003723_5cDcP DE0013 2025-11-28T14:21:45.220Z 2025-12-05T15:03:53.781Z
8623422 8623422 20251127002745_2qvfQ DE0013 2025-11-28T14:21:42.219Z 2025-12-05T15:03:49.885Z
8623369 8623369 20251127001419_eQ24A DE0013 2025-11-28T14:21:35.767Z 2025-12-05T15:03:45.133Z
8623318 8623318 20251126235518_zgDxm DE0013 2025-11-28T14:21:30.114Z 2025-12-05T15:03:42.168Z
8623149 8623149 20251126230452_PXn6e DE0013 2025-11-28T14:20:58.028Z 2025-12-05T15:03:32.915Z
8623088 8623088 20251126224759_oeqae DE0013 2025-11-28T14:20:51.153Z 2025-12-05T15:03:28.204Z
8623041 8623041 20251126223345_wBkj0 DE0013 2025-11-28T14:20:32.226Z 2025-12-05T15:03:26.103Z
8622899 8622899 20251126220214_iMHvE DE0013 2025-11-28T14:20:16.874Z 2025-12-05T15:03:19.158Z
8622857 8622857 20251126215142_KnjKK DE0013 2025-11-28T14:20:12.042Z 2025-12-05T15:03:16.835Z
8622843 8622843 20251126214451_f84Pn DE0013 2025-11-28T14:20:09.908Z 2025-12-05T15:03:16.248Z
8622505 8622505 20251126194005_c53y4 DE0013 2025-11-28T14:19:01.217Z 2025-12-05T15:03:02.619Z
8622144 8622144 20251126175928_GeLv8 DE0013 2025-11-28T14:17:49.094Z 2025-12-05T15:02:52.767Z
8622097 8622097 20251126175002_X2MAC DE0013 2025-11-28T14:17:41.509Z 2025-12-05T15:02:52.159Z
8591977 8591977 20251124052706_iywmo DE0013 2025-11-25T14:25:28.470Z 2025-12-02T15:13:01.313Z
8591785 8591785 20251124045636_oLwep DE0013 2025-11-25T14:25:08.320Z 2025-12-02T15:13:00.522Z
8591648 8591648 20251124044125_pkKEH DE0013 2025-11-25T14:24:42.393Z 2025-12-02T15:12:59.807Z
8581672 8581672 20251123013728_N9ezv DE0013 2025-11-24T14:32:30.993Z 2025-12-01T15:21:12.018Z
8581564 8581564 20251123005437_EaN5O DE0013 2025-11-24T14:31:58.154Z 2025-12-01T15:20:57.921Z
8579890 8579890 20251123014228_n4yHo DE0013 2025-11-24T14:15:32.806Z 2025-12-01T15:21:15.196Z
8579801 8579801 20251123011942_gbt2K DE0013 2025-11-24T14:15:11.673Z 2025-12-01T15:21:10.039Z
8579791 8579791 20251123011654_AORSs DE0013 2025-11-24T14:15:09.976Z 2025-12-01T15:21:08.250Z
8579677 8579677 20251123004424_HKa1i DE0013 2025-11-24T14:14:57.485Z 2025-12-01T15:20:53.329Z
8579659 8579659 20251123004007_3tlEc DE0013 2025-11-24T14:14:56.255Z 2025-12-01T15:20:52.576Z
8579518 8579518 20251123000517_he32O DE0013 2025-11-24T14:14:31.381Z 2025-12-01T15:20:35.306Z
8579486 8579486 20251122235431_ieP2S DE0013 2025-11-24T14:14:27.133Z 2025-12-01T15:20:29.173Z
8579480 8579480 20251122235313_p84HE DE0013 2025-11-24T14:14:26.397Z 2025-12-01T15:20:28.992Z
8579349 8579349 20251122231539_jYJiR DE0013 2025-11-24T14:14:02.506Z 2025-12-01T15:20:14.638Z
8579247 8579247 20251122225454_njvni DE0013 2025-11-24T14:13:51.773Z 2025-12-01T15:20:11.440Z
8579066 8579066 20251122221656_9gQte DE0013 2025-11-24T14:13:27.330Z 2025-12-01T15:20:01.073Z
8578982 8578982 20251122220253_iGwvL DE0013 2025-11-24T14:13:14.117Z 2025-12-01T15:19:57.755Z
8578752 8578752 20251122212331_kKPxl DE0013 2025-11-24T14:12:37.738Z 2025-12-01T15:19:51.565Z
8578708 8578708 20251122211843_OigkL DE0013 2025-11-24T14:12:24.405Z 2025-12-01T15:19:50.465Z

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