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,416 rows where station_code = "DE000C" 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
9243457 9243457 20260121043445_JBVOE DE000C 2026-01-22T14:22:00.624Z 2026-01-29T15:05:03.432Z
9243428 9243428 20260121043059_12OIN DE000C 2026-01-22T14:21:45.763Z 2026-01-29T15:05:01.980Z
9243424 9243424 20260121043059_UiX7C DE000C 2026-01-22T14:21:45.450Z 2026-01-29T15:05:01.897Z
9241771 9241771 20260120222258_7kbiW DE000C 2026-01-22T14:14:27.295Z 2026-01-29T15:03:01.627Z
9241728 9241728 20260120215523_FzBLm DE000C 2026-01-22T14:14:18.515Z 2026-01-29T15:02:59.210Z
9241632 9241632 20260120212040_vQLZZ DE000C 2026-01-22T14:13:57.660Z 2026-01-29T15:02:55.671Z
9241102 9241102 20260120190753_jjTla DE000C 2026-01-22T14:11:40.729Z 2026-01-29T15:02:22.754Z
9241093 9241093 20260120190536_y9JXK DE000C 2026-01-22T14:11:39.081Z 2026-01-29T15:02:22.337Z
9240935 9240935 20260120183130_McY4h DE000C 2026-01-22T14:10:57.740Z 2026-01-29T15:02:03.446Z
9237112 9237112 20260120043907_q35CX DE000C 2026-01-21T14:25:18.284Z 2026-01-28T15:00:58.512Z
9236752 9236752 20260120035604_p35jE DE000C 2026-01-21T14:23:54.587Z 2026-01-28T15:00:33.543Z
9236177 9236177 20260120024430_NLPdn DE000C 2026-01-21T14:21:53.711Z 2026-01-28T14:59:48.772Z
9235935 9235935 20260120021941_MRQ3D DE000C 2026-01-21T14:20:50.465Z 2026-01-28T14:59:29.492Z
9234695 9234695 20260119225957_2Q28D DE000C 2026-01-21T14:15:43.972Z 2026-01-28T14:58:01.576Z
9234245 9234245 20260119202202_KYvfT DE000C 2026-01-21T14:13:15.006Z 2026-01-28T14:57:24.644Z
9233840 9233840 20260119181237_Ihb2M DE000C 2026-01-21T14:10:49.818Z 2026-01-28T14:56:45.843Z
9231044 9231044 20260119054858_vL86b DE000C 2026-01-20T14:31:00.718Z 2026-01-27T15:05:54.507Z
9230252 9230252 20260119034624_17qsx DE000C 2026-01-20T14:26:50.612Z 2026-01-27T15:04:44.674Z
9229487 9229487 20260119015233_IiWC9 DE000C 2026-01-20T14:22:47.790Z 2026-01-27T15:03:28.477Z
9208088 9208088 20260115041134_fTliU DE000C 2026-01-16T14:11:17.055Z 2026-01-22T15:04:00.919Z
9207502 9207502 20260115015750_FSe3Z DE000C 2026-01-16T14:08:59.836Z 2026-01-22T15:03:23.410Z
9182603 9182603 20260111055428_3jE4t DE000C 2026-01-12T14:15:07.779Z 2026-01-19T15:18:51.172Z
9182503 9182503 20260111053327_F02nm DE000C 2026-01-12T14:14:46.898Z 2026-01-19T15:18:46.493Z
9182414 9182414 20260111052113_yjY3s DE000C 2026-01-12T14:14:29.491Z 2026-01-19T15:18:31.356Z
9182299 9182299 20260111045758_wzCBY DE000C 2026-01-12T14:14:04.451Z 2026-01-19T15:18:24.755Z
9181794 9181794 20260111030817_b9JMp DE000C 2026-01-12T14:12:09.671Z 2026-01-19T15:17:48.981Z
9181707 9181707 20260111025324_TBdzx DE000C 2026-01-12T14:11:49.256Z 2026-01-19T15:17:45.399Z
9181409 9181409 20260111014038_f7UYG DE000C 2026-01-12T14:10:42.838Z 2026-01-19T15:17:16.739Z
9181305 9181305 20260111011825_UEfHM DE000C 2026-01-12T14:10:19.127Z 2026-01-19T15:17:12.086Z
9181141 9181141 20260111003305_VnQdI DE000C 2026-01-12T14:09:42.594Z 2026-01-19T15:17:05.156Z
9180214 9180214 20260110193840_mVBYm DE000C 2026-01-12T14:06:15.937Z 2026-01-19T15:15:51.987Z
9111215 9111215 20251231004956_nNnhf DE000C 2026-01-01T14:10:32.909Z 2026-01-08T15:06:21.249Z
9104365 9104365 20251230054626_aLazY DE000C 2025-12-31T14:21:01.808Z 2025-12-31T14:29:54.295Z
9103352 9103352 20251230042240_2Im2S DE000C 2025-12-31T14:17:30.186Z 2026-01-07T15:08:39.500Z
9103211 9103211 20251230040733_ClAVm DE000C 2025-12-31T14:16:55.816Z 2026-01-07T15:08:32.298Z
9102768 9102768 20251230033306_i1iKo DE000C 2025-12-31T14:15:15.301Z 2026-01-07T15:08:05.181Z
9102667 9102667 20251230032441_Z3Pnb DE000C 2025-12-31T14:14:50.328Z 2026-01-07T15:07:51.239Z
9102634 9102634 20251230032051_KX94E DE000C 2025-12-31T14:14:43.565Z 2026-01-07T15:07:48.943Z
9102564 9102564 20251230031333_X4i1Y DE000C 2025-12-31T14:14:29.006Z 2026-01-07T15:07:44.774Z
9102126 9102126 20251230022740_z2idq DE000C 2025-12-31T14:12:16.106Z 2026-01-07T15:07:13.068Z
9101861 9101861 20251230014933_q3APF DE000C 2025-12-31T14:10:52.505Z 2026-01-07T15:06:52.060Z
9101797 9101797 20251230013918_vzSdw DE000C 2025-12-31T14:10:36.223Z 2026-01-07T15:06:48.998Z
9101692 9101692 20251230011901_ltxRK DE000C 2025-12-31T14:10:00.199Z 2026-01-07T15:06:41.977Z
9101641 9101641 20251230010953_HUYo0 DE000C 2025-12-31T14:09:45.357Z 2025-12-31T14:29:52.645Z
9101561 9101561 20251230005454_30itW DE000C 2025-12-31T14:09:21.832Z 2026-01-07T15:06:35.050Z
9101487 9101487 20251230003740_lzsNm DE000C 2025-12-31T14:08:55.511Z 2026-01-07T15:06:23.490Z
9101246 9101246 20251229233611_v3zZX DE000C 2025-12-31T14:07:26.694Z 2026-01-07T15:06:09.162Z
9086675 9086675 20251228052538_FCJH9 DE000C 2025-12-30T14:41:50.676Z 2025-12-31T14:52:29.923Z
9086667 9086667 20251228052447_qtYcN DE000C 2025-12-30T14:41:49.819Z 2026-01-05T15:10:26.385Z
9085933 9085933 20251228041428_Rk0I5 DE000C 2025-12-30T14:39:49.706Z 2026-01-05T15:09:50.171Z
9085562 9085562 20251228033742_1hsA3 DE000C 2025-12-30T14:38:48.917Z 2026-01-05T15:09:37.573Z
9085393 9085393 20251228032112_INEKL DE000C 2025-12-30T14:38:28.065Z 2026-01-05T15:09:22.301Z
9084791 9084791 20251228021853_KLVwP DE000C 2025-12-30T14:36:48.273Z 2026-01-05T15:09:03.654Z
9084436 9084436 20251228014147_hl6N8 DE000C 2025-12-30T14:35:40.984Z 2026-01-05T15:08:42.536Z
9083146 9083146 20251227230442_VvY34 DE000C 2025-12-30T14:31:47.270Z 2026-01-05T15:07:38.688Z
9076521 9076521 20251228222709_qT85q DE000C 2025-12-30T14:04:01.455Z 2026-01-06T15:14:39.846Z
9074610 9074610 20251225201558_LIFSQ DE000C 2025-12-29T15:01:11.835Z 2026-01-02T15:48:34.537Z
9059377 9059377 20251225220922_gcIyf DE000C 2025-12-29T14:26:57.943Z 2026-01-03T15:31:53.985Z
9044838 9044838 20251223061130_83XTD DE000C 2025-12-28T14:52:33.969Z 2025-12-31T15:42:41.079Z
9044803 9044803 20251223060032_Hdr5o DE000C 2025-12-28T14:52:30.994Z 2025-12-31T15:42:40.603Z
9036676 9036676 20251224050247_vC28P DE000C 2025-12-28T14:35:34.069Z 2026-01-01T15:54:38.584Z
9036504 9036504 20251224043734_i8NGZ DE000C 2025-12-28T14:35:18.167Z 2025-12-28T14:48:35.017Z
9035723 9035723 20251224001131_XWc3T DE000C 2025-12-28T14:33:04.794Z 2026-01-01T15:53:56.480Z
9035696 9035696 20251223234835_XtGiJ DE000C 2025-12-28T14:33:01.630Z 2026-01-01T15:53:56.180Z
9035648 9035648 20251223232311_EU17d DE000C 2025-12-28T14:32:49.712Z 2026-01-01T15:53:55.259Z
8986569 8986569 20251218055757_h7NlV DE000C 2025-12-26T14:38:17.897Z 2025-12-27T15:19:22.729Z
8963493 8963493 20251216054319_nP2ew DE000C 2025-12-25T14:39:14.045Z 2025-12-25T14:39:14.045Z
8828232 8828232 20251213184543_Bxktp DE000C 2025-12-18T14:29:41.252Z 2025-12-23T14:23:26.184Z
8744263 8744263 20251211002957_7UJKq DE000C 2025-12-13T15:25:36.988Z 2025-12-19T15:14:29.745Z
8743467 8743467 20251210232916_VllIH DE000C 2025-12-13T15:24:13.018Z 2025-12-19T15:14:12.012Z
8664538 8664538 20251201005444_vADkC DE000C 2025-12-02T14:21:18.379Z 2025-12-09T14:58:13.450Z
8664224 8664224 20251130234443_oKF9R DE000C 2025-12-02T14:20:31.510Z 2025-12-09T14:58:04.099Z
8581974 8581974 20251123032644_9Y8lM DE000C 2025-11-24T14:32:53.304Z 2025-12-01T15:22:07.945Z
8581965 8581965 20251123032453_SVGHB DE000C 2025-11-24T14:32:50.493Z 2025-12-01T15:22:05.286Z
8581934 8581934 20251123031113_TC3bC DE000C 2025-11-24T14:32:48.157Z 2025-12-01T15:22:01.820Z
8581856 8581856 20251123024903_VWugM DE000C 2025-11-24T14:32:41.881Z 2025-12-01T15:21:49.334Z
8581771 8581771 20251123021722_V4rFO DE000C 2025-11-24T14:32:37.169Z 2025-12-01T15:21:33.888Z
8581760 8581760 20251123021150_xz8cF DE000C 2025-11-24T14:32:36.624Z 2025-12-01T15:21:30.356Z
8578139 8578139 20251122194843_bpmPQ DE000C 2025-11-24T14:10:51.792Z 2025-12-01T15:19:17.165Z
8578117 8578117 20251122194506_PPCg5 DE000C 2025-11-24T14:10:48.347Z 2025-12-01T15:19:11.490Z
8577180 8577180 20251122172746_p3Sd6 DE000C 2025-11-24T14:07:53.208Z 2025-12-01T15:18:44.529Z
8573877 8573877 20251122043126_ciL1Z DE000C 2025-11-23T14:42:04.926Z 2025-11-30T15:06:47.971Z
8573154 8573154 20251122023607_9ig0J DE000C 2025-11-23T14:40:54.829Z 2025-11-30T15:06:11.358Z
8572860 8572860 20251122015151_oqCi8 DE000C 2025-11-23T14:39:47.587Z 2025-11-30T15:06:04.605Z
8571607 8571607 20251121213240_1p7zT DE000C 2025-11-23T14:37:08.517Z 2025-11-30T15:05:11.085Z
8571525 8571525 20251121210916_iSWhH DE000C 2025-11-23T14:36:46.872Z 2025-11-30T15:05:08.370Z
8571282 8571282 20251121200533_i2fB0 DE000C 2025-11-23T14:36:08.694Z 2025-11-30T15:04:53.085Z
8571157 8571157 20251121192604_sVsXD DE000C 2025-11-23T14:36:00.693Z 2025-11-30T15:04:30.358Z
8571104 8571104 20251121191211_NjL6H DE000C 2025-11-23T14:35:58.555Z 2025-11-30T15:04:28.605Z
8549157 8549157 20251120215908_yph3g DE000C 2025-11-22T14:18:24.970Z 2025-11-29T14:54:24.095Z
8549082 8549082 20251120215028_9RuRM DE000C 2025-11-22T14:18:20.501Z 2025-11-29T14:54:23.942Z
8549061 8549061 20251120214720_weGZx DE000C 2025-11-22T14:18:11.908Z 2025-11-29T14:54:23.896Z
8548886 8548886 20251120212719_Hvy89 DE000C 2025-11-22T14:17:54.526Z 2025-11-29T14:54:23.575Z
8548300 8548300 20251120204808_nXvel DE000C 2025-11-22T14:16:43.316Z 2025-11-29T14:54:22.337Z
8548142 8548142 20251120203904_UhHCM DE000C 2025-11-22T14:16:21.804Z 2025-11-29T14:54:22.051Z
8545195 8545195 20251120162513_sEVj1 DE000C 2025-11-22T14:09:56.845Z 2025-11-29T14:54:01.768Z
8523694 8523694 20251119023656_n3l4Z DE000C 2025-11-20T14:19:02.932Z 2025-11-27T15:12:26.219Z
8522386 8522386 20251119000344_aEPWp DE000C 2025-11-20T14:15:19.476Z 2025-11-27T15:12:01.138Z
8522314 8522314 20251118235512_nC3qP DE000C 2025-11-20T14:15:12.390Z 2025-11-27T15:12:00.098Z
8508500 8508500 20251118010957_skUWv DE000C 2025-11-19T14:17:52.020Z 2025-11-26T15:07:51.079Z

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