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,346 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
8664538 8664538 20251201005444_vADkC DE000C 2025-12-02T14:21:18.379Z 2025-12-06T14:40:49.971Z
8664224 8664224 20251130234443_oKF9R DE000C 2025-12-02T14:20:31.510Z 2025-12-06T14:40:41.813Z
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
8508463 8508463 20251118010429_qJVUh DE000C 2025-11-19T14:17:45.832Z 2025-11-26T15:07:50.935Z
8508351 8508351 20251118005252_iTCxc DE000C 2025-11-19T14:17:25.200Z 2025-11-26T15:07:50.430Z
8508104 8508104 20251118003017_c6Lb8 DE000C 2025-11-19T14:16:48.751Z 2025-11-26T15:07:49.304Z
8507099 8507099 20251117224527_vTahk DE000C 2025-11-19T14:14:25.706Z 2025-11-26T15:07:44.902Z
8506844 8506844 20251117222116_gDjYk DE000C 2025-11-19T14:13:46.872Z 2025-11-26T15:07:43.616Z
8503143 8503143 20251117164259_0Jldx DE000C 2025-11-19T14:04:37.416Z 2025-11-26T15:06:21.421Z
8498819 8498819 20251117011646_elTSl DE000C 2025-11-18T14:31:46.927Z 2025-11-25T15:09:01.776Z
8492626 8492626 20251117004233_e7hM0 DE000C 2025-11-18T14:20:19.845Z 2025-11-25T15:08:54.885Z
8492329 8492329 20251117002014_jphCZ DE000C 2025-11-18T14:19:35.255Z 2025-11-25T15:08:50.755Z
8492285 8492285 20251117001634_wZ3AX DE000C 2025-11-18T14:19:30.736Z 2025-11-25T15:08:48.439Z
8491965 8491965 20251116233529_QIlSF DE000C 2025-11-18T14:18:47.758Z 2025-11-25T15:08:43.463Z
8490148 8490148 20251116184348_ahE32 DE000C 2025-11-18T14:12:55.131Z 2025-11-25T15:08:03.173Z
8489954 8489954 20251116180905_fLjXC DE000C 2025-11-18T14:12:09.513Z 2025-11-25T15:07:54.351Z
8481999 8481999 20251116045332_698uh DE000C 2025-11-17T14:22:16.632Z 2025-11-24T15:05:16.566Z
8481997 8481997 20251116045332_S5FsU DE000C 2025-11-17T14:22:16.409Z 2025-11-24T15:05:16.537Z
8478364 8478364 20251115170816_6glrf DE000C 2025-11-17T14:13:21.505Z 2025-11-24T15:04:10.526Z
8450417 8450417 20251113042735_0r6tQ DE000C 2025-11-14T14:23:23.444Z 2025-11-21T15:12:38.234Z
8450009 8450009 20251113033441_K6zkA DE000C 2025-11-14T14:22:23.229Z 2025-11-21T15:12:26.644Z
8449626 8449626 20251113023516_vQJAj DE000C 2025-11-14T14:21:01.796Z 2025-11-21T15:12:10.885Z
8434857 8434857 20251111185007_pa3HF DE000C 2025-11-13T14:13:49.482Z 2025-11-20T15:21:52.818Z
8359200 8359200 20251101044647_SZqs5 DE000C 2025-11-03T14:47:07.029Z 2025-11-09T15:03:31.073Z
8359194 8359194 20251101021140_J9t5U DE000C 2025-11-03T14:47:01.611Z 2025-11-09T15:02:15.363Z
8359192 8359192 20251101020050_X6pO8 DE000C 2025-11-03T14:47:01.355Z 2025-11-09T15:02:08.747Z
8359190 8359190 20251101013844_NBAPQ DE000C 2025-11-03T14:47:00.971Z 2025-11-09T15:01:34.519Z
8359175 8359175 20251101002833_uDT7Z DE000C 2025-11-03T14:46:59.263Z 2025-11-09T15:00:43.879Z
8359173 8359173 20251101002323_i9zzL DE000C 2025-11-03T14:46:59.169Z 2025-11-09T15:00:43.032Z
8359167 8359167 20251031235222_vEYn3 DE000C 2025-11-03T14:46:58.573Z 2025-11-09T15:00:36.961Z
8343765 8343765 20251101030700_xL6wu DE000C 2025-11-02T14:41:39.098Z 2025-11-09T15:03:14.751Z
8336434 8336434 20251031044049_Z0PcU DE000C 2025-11-02T14:29:20.595Z 2025-11-08T15:15:49.899Z
8336100 8336100 20251031041620_XUPyM DE000C 2025-11-02T14:28:53.810Z 2025-11-08T15:15:37.590Z
8335834 8335834 20251031035151_aa6Sa DE000C 2025-11-02T14:28:10.885Z 2025-11-08T15:15:12.642Z
8335821 8335821 20251031035104_uv8m6 DE000C 2025-11-02T14:28:09.723Z 2025-11-08T15:15:11.908Z
8335654 8335654 20251031034008_85g1h DE000C 2025-11-02T14:27:59.767Z 2025-11-08T15:14:58.174Z
8333266 8333266 20251030235426_QMSeS DE000C 2025-11-02T14:22:09.816Z 2025-11-08T15:12:51.339Z
8299041 8299041 20251029023534_xjS7N DE000C 2025-10-30T12:51:46.223Z 2025-11-06T15:13:33.631Z
8298694 8298694 20251029015322_440KS DE000C 2025-10-30T12:51:33.676Z 2025-11-06T15:13:13.160Z
8297567 8297567 20251028233828_BcdhF DE000C 2025-10-30T12:49:26.359Z 2025-11-06T15:12:30.053Z
8296728 8296728 20251028213839_zSr01 DE000C 2025-10-30T12:47:43.664Z 2025-11-06T15:12:16.207Z
8283098 8283098 20251028031328_Aam0S DE000C 2025-10-29T12:43:43.151Z 2025-11-05T15:22:01.970Z
8235151 8235151 20251026002008_fIOoR DE000C 2025-10-27T12:17:10.328Z 2025-11-03T15:16:07.458Z
8234992 8234992 20251026001126_W3SQU DE000C 2025-10-27T12:16:44.736Z 2025-11-03T15:16:06.986Z
8234811 8234811 20251026000638_9A0yF DE000C 2025-10-27T12:16:25.871Z 2025-11-03T15:16:04.466Z
8232319 8232319 20251025205242_LXEhn DE000C 2025-10-27T12:10:21.216Z 2025-11-03T15:15:52.229Z
8199984 8199984 20251022222358_ekGlH DE000C 2025-10-25T12:10:04.473Z 2025-10-31T13:08:23.997Z
8199930 8199930 20251022215339_3jcYY DE000C 2025-10-25T12:09:49.642Z 2025-10-31T13:08:21.550Z
8199919 8199919 20251022214913_nyHeV DE000C 2025-10-25T12:09:48.029Z 2025-10-31T13:08:21.443Z
8199915 8199915 20251022214729_8tk4f DE000C 2025-10-25T12:09:42.879Z 2025-10-31T13:08:21.415Z
8199831 8199831 20251022210222_IwzVO DE000C 2025-10-25T12:09:23.611Z 2025-10-25T12:32:07.884Z
8199778 8199778 20251022201540_k9El1 DE000C 2025-10-25T12:08:55.194Z 2025-10-31T13:08:14.740Z
8168512 8168512 20251020035942_7cuOW DE000C 2025-10-22T12:35:48.200Z 2025-10-28T13:08:56.171Z
8164476 8164476 20251019204121_4XfEN DE000C 2025-10-22T12:25:42.091Z 2025-10-28T13:07:55.248Z
8143904 8143904 20251019001817_qKGxf DE000C 2025-10-20T12:15:44.391Z 2025-10-27T13:10:09.418Z
8141862 8141862 20251018195923_X5wQu DE000C 2025-10-20T12:08:56.112Z 2025-10-27T13:09:45.691Z
8141822 8141822 20251018195049_sQbJc DE000C 2025-10-20T12:08:48.835Z 2025-10-27T13:09:45.389Z
8141583 8141583 20251018191009_BmnL2 DE000C 2025-10-20T12:07:42.864Z 2025-10-27T13:09:41.931Z
8134533 8134533 20251018044822_jS6K8 DE000C 2025-10-19T12:15:50.131Z 2025-10-26T13:15:57.641Z
8134355 8134355 20251018042636_Lip8W DE000C 2025-10-19T12:15:34.533Z 2025-10-26T13:15:55.398Z
8133967 8133967 20251018035124_mvHd2 DE000C 2025-10-19T12:14:40.138Z 2025-10-26T13:15:48.908Z
8133963 8133963 20251018035123_fcAvK DE000C 2025-10-19T12:14:39.923Z 2025-10-26T13:15:48.897Z
8133700 8133700 20251018032505_5Lvw5 DE000C 2025-10-19T12:13:52.958Z 2025-10-26T13:15:45.594Z
8133579 8133579 20251018031404_oCsY1 DE000C 2025-10-19T12:13:43.575Z 2025-10-26T13:15:44.346Z
8133561 8133561 20251018031210_3ENt6 DE000C 2025-10-19T12:13:41.918Z 2025-10-26T13:15:44.065Z
8133044 8133044 20251018022416_bvWNi DE000C 2025-10-19T12:12:10.037Z 2025-10-26T13:15:38.584Z
8132973 8132973 20251018021739_xwjGf DE000C 2025-10-19T12:12:03.300Z 2025-10-26T13:15:38.105Z
8132962 8132962 20251018021636_xtOXY DE000C 2025-10-19T12:12:01.330Z 2025-10-26T13:15:38.089Z
8132754 8132754 20251018015340_bvr0C DE000C 2025-10-19T12:11:21.464Z 2025-10-26T13:15:33.904Z
8132498 8132498 20251018012107_AOF48 DE000C 2025-10-19T12:10:39.234Z 2025-10-26T13:15:21.414Z
8132048 8132048 20251018001843_2hxJN DE000C 2025-10-19T12:09:19.541Z 2025-10-26T13:15:15.689Z
8131802 8131802 20251017234226_flRy3 DE000C 2025-10-19T12:08:39.987Z 2025-10-26T13:15:13.362Z
8131786 8131786 20251017233917_sPnZL DE000C 2025-10-19T12:08:36.717Z 2025-10-26T13:15:13.296Z

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