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,417 rows where station_code = "DE0003" 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
7789625 7789625 20250907221011_K2xab DE0003 2025-09-09T12:04:16.528Z 2025-09-16T12:50:51.973Z
7789562 7789562 20250907214547_d8BRf DE0003 2025-09-09T12:04:01.607Z 2025-09-16T12:50:51.434Z
7487534 7487534 20250812015257_KpewB DE0003 2025-08-15T12:41:08.952Z 2025-08-20T13:06:06.145Z
7475981 7475981 20250813023502_jto3Y DE0003 2025-08-14T12:36:18.428Z 2025-08-21T12:47:45.777Z
7473995 7473995 20250813014055_B2TQy DE0003 2025-08-14T12:35:08.649Z 2025-08-21T12:47:38.997Z
7463818 7463818 20250813005040_i2Sq1 DE0003 2025-08-14T12:14:28.594Z 2025-08-21T12:47:32.281Z
7449873 7449873 20250812014857_wv6YG DE0003 2025-08-13T12:16:16.109Z 2025-08-20T13:06:05.797Z
7434496 7434496 20250811013038_6aaNg DE0003 2025-08-12T12:14:46.656Z 2025-08-18T13:40:02.356Z
7422239 7422239 20250810003355_F6vKk DE0003 2025-08-11T12:10:33.080Z 2025-08-18T13:46:05.201Z
7421748 7421748 20250810001139_gLJBm DE0003 2025-08-11T12:09:37.152Z 2025-08-18T13:45:48.120Z
7176809 7176809 20250725023025_qx3zV DE0003 2025-07-26T12:03:47.699Z 2025-08-03T13:03:54.491Z
6824193 6824193 20250529000019_Ku3vT DE0003 2025-05-30T12:16:49.190Z 2025-06-06T13:01:51.161Z
6824003 6824003 20250528224334_Tekfa DE0003 2025-05-30T12:16:08.492Z 2025-06-06T13:01:29.293Z
6823934 6823934 20250528221626_wuUNC DE0003 2025-05-30T12:15:56.891Z 2025-06-06T13:01:26.567Z
6823909 6823909 20250528220741_zTk3n DE0003 2025-05-30T12:15:54.073Z 2025-06-06T13:01:25.333Z
6796646 6796646 20250524003824_gn58I DE0003 2025-05-25T12:22:24.308Z 2025-06-01T12:36:59.914Z
6796570 6796570 20250524001251_B0M33 DE0003 2025-05-25T12:22:15.962Z 2025-06-01T12:36:58.815Z
6795808 6795808 20250523205348_ds6LL DE0003 2025-05-25T12:20:38.187Z 2025-06-01T12:36:46.940Z
6787141 6787141 20250522234910_fqI82 DE0003 2025-05-24T12:20:10.044Z 2025-05-31T13:14:06.208Z
6762820 6762820 20250520021652_cbuaz DE0003 2025-05-21T12:23:30.378Z 2025-05-28T13:14:10.591Z
6761433 6761433 20250519233404_H32XX DE0003 2025-05-21T12:21:33.188Z 2025-05-28T13:13:14.334Z
6754088 6754088 20250519010854_HUzJm DE0003 2025-05-20T12:20:08.151Z 2025-05-27T13:21:41.489Z
6753860 6753860 20250519003555_XhO3y DE0003 2025-05-20T12:19:54.543Z 2025-05-27T13:21:34.345Z
6723174 6723174 20250513201139_dbbuy DE0003 2025-05-15T12:14:59.146Z 2025-05-21T12:32:24.606Z
6722275 6722275 20250514003542_WtPsb DE0003 2025-05-15T12:11:15.280Z 2025-05-22T12:36:12.075Z
6722228 6722228 20250513235252_U1y2i DE0003 2025-05-15T12:10:55.320Z 2025-05-22T12:36:08.523Z
6718329 6718329 20250513021106_EnnaF DE0003 2025-05-14T12:04:50.310Z 2025-05-21T12:32:10.420Z
6718151 6718151 20250513013856_WrsJL DE0003 2025-05-14T12:04:19.514Z 2025-05-21T12:32:09.170Z
6717949 6717949 20250513010420_8r8Tt DE0003 2025-05-14T12:03:40.829Z 2025-05-21T12:32:07.775Z
6717662 6717662 20250513000221_w2TSa DE0003 2025-05-14T12:02:51.233Z 2025-05-21T12:32:05.445Z
6717650 6717650 20250512235743_uDH2Q DE0003 2025-05-14T12:02:49.073Z 2025-05-21T12:32:05.351Z
6717624 6717624 20250512234946_ai0Wn DE0003 2025-05-14T12:02:37.308Z 2025-05-21T12:32:05.126Z
6714702 6714702 20250512023700_HszVk DE0003 2025-05-13T12:05:36.042Z 2025-05-20T12:33:36.551Z
6699477 6699477 20250510010405_cuc9L DE0003 2025-05-11T12:07:54.390Z 2025-05-18T12:33:53.616Z
6699244 6699244 20250510004459_pyIbA DE0003 2025-05-11T12:07:29.449Z 2025-05-18T12:33:50.205Z
6699187 6699187 20250510003508_6IBf3 DE0003 2025-05-11T12:07:17.296Z 2025-05-18T12:33:48.604Z
6692332 6692332 20250509021320_0Zm3U DE0003 2025-05-10T12:11:23.557Z 2025-05-17T12:35:59.489Z
6636141 6636141 20250502202538_5IeZC DE0003 2025-05-04T12:11:14.989Z 2025-05-11T12:36:38.962Z
6603166 6603166 20250429001838_vFfOs DE0003 2025-04-30T12:18:10.719Z 2025-05-07T12:34:57.155Z
6602843 6602843 20250428235430_t3X0S DE0003 2025-04-30T12:17:29.085Z 2025-05-07T12:34:55.785Z
6595949 6595949 20250428024348_3vgrj DE0003 2025-04-29T12:22:15.928Z 2025-05-06T12:36:53.182Z
6584532 6584532 20250427000703_4srOm DE0003 2025-04-28T12:20:18.021Z 2025-05-05T12:31:26.174Z
6578635 6578635 20250426004649_G3IDF DE0003 2025-04-27T12:21:38.024Z 2025-05-04T12:36:44.004Z
6578527 6578527 20250426002049_YDs7z DE0003 2025-04-27T12:21:13.247Z 2025-05-04T12:36:43.611Z
6550722 6550722 20250422201411_dxHcR DE0003 2025-04-24T12:17:12.603Z 2025-05-01T12:38:33.994Z
6542317 6542317 20250421211715_BuuMh DE0003 2025-04-23T12:17:24.318Z 2025-04-30T12:41:18.626Z
6535371 6535371 20250420213447_1MiEv DE0003 2025-04-22T12:17:27.567Z 2025-04-29T12:36:23.188Z
6535191 6535191 20250420205705_4uY3N DE0003 2025-04-22T12:16:57.829Z 2025-04-29T12:36:21.941Z
6534946 6534946 20250420193458_5dVGi DE0003 2025-04-22T12:16:01.927Z 2025-04-29T12:36:19.146Z
6530747 6530747 20250420024054_wtqLT DE0003 2025-04-21T12:16:32.144Z 2025-04-28T12:41:21.123Z
6529683 6529683 20250420001349_XX35V DE0003 2025-04-21T12:14:05.683Z 2025-04-28T12:41:10.526Z
6529325 6529325 20250419232625_sr3JV DE0003 2025-04-21T12:13:08.582Z 2025-04-28T12:41:06.424Z
6528684 6528684 20250419213003_vPm5B DE0003 2025-04-21T12:11:21.884Z 2025-04-28T12:40:59.476Z
6511476 6511476 20250414024731_5FeA2 DE0003 2025-04-15T12:00:56.033Z 2025-04-23T12:32:54.693Z
6490597 6490597 20250409025453_lj4Ms DE0003 2025-04-10T12:03:54.610Z 2025-04-17T12:22:27.737Z
6489889 6489889 20250409012158_yQ12m DE0003 2025-04-10T12:02:06.036Z 2025-04-17T12:22:13.437Z
6483106 6483106 20250408014219_LryYW DE0003 2025-04-09T12:03:06.491Z 2025-04-16T12:25:03.272Z
6476561 6476561 20250406031256_VwtyZ DE0003 2025-04-08T12:19:21.440Z 2025-04-14T12:30:19.452Z
6473783 6473783 20250405215253_536iK DE0003 2025-04-08T12:14:13.592Z 2025-04-14T12:29:26.672Z
6469600 6469600 20250407010937_P2JUn DE0003 2025-04-08T12:03:36.742Z 2025-04-15T12:25:36.977Z
6469102 6469102 20250407000447_SXsfe DE0003 2025-04-08T12:02:15.899Z 2025-04-15T12:25:19.452Z
6457009 6457009 20250404002351_GLhtL DE0003 2025-04-05T12:05:48.461Z 2025-04-12T12:38:59.702Z
6441797 6441797 20250330193731_RF42v DE0003 2025-04-02T12:58:13.961Z 2025-04-06T12:55:29.466Z
6429730 6429730 20250330195935_SCiVX DE0003 2025-04-02T12:22:15.570Z 2025-04-08T13:00:16.437Z
6421461 6421461 20250330012842_R2lPs DE0003 2025-03-31T12:04:57.496Z 2025-04-06T12:51:31.589Z
6407475 6407475 20250328002531_rq0ui DE0003 2025-03-29T12:08:03.443Z 2025-04-05T13:03:14.887Z
6406658 6406658 20250327210141_thlTw DE0003 2025-03-29T12:04:01.415Z 2025-04-05T13:02:27.530Z
6406615 6406615 20250327205240_cR5Nr DE0003 2025-03-29T12:03:51.587Z 2025-04-05T13:02:25.479Z
6359442 6359442 20250321000842_JHCDp DE0003 2025-03-22T12:09:54.480Z 2025-03-29T13:14:38.166Z
6359274 6359274 20250320234436_SeNU9 DE0003 2025-03-22T12:09:19.817Z 2025-03-29T13:14:28.383Z
6359038 6359038 20250320230707_NJuy2 DE0003 2025-03-22T12:08:25.975Z 2025-03-29T13:14:05.274Z
6358354 6358354 20250320210141_ZxCuR DE0003 2025-03-22T12:05:50.816Z 2025-03-29T13:13:22.095Z
6352069 6352069 20250320012108_FQwED DE0003 2025-03-21T12:12:11.375Z 2025-03-28T12:57:59.170Z
6349834 6349834 20250319201951_LI8Hp DE0003 2025-03-21T12:04:41.737Z 2025-03-28T12:56:04.744Z
6349585 6349585 20250319193733_02qUC DE0003 2025-03-21T12:03:42.311Z 2025-03-28T12:55:56.845Z
6343660 6343660 20250319023717_APdXE DE0003 2025-03-20T12:14:26.086Z 2025-03-27T13:09:08.467Z
6336236 6336236 20250318030108_PbGTL DE0003 2025-03-19T12:10:19.232Z 2025-03-26T12:57:20.482Z
6335032 6335032 20250318004414_V51mv DE0003 2025-03-19T12:07:16.569Z 2025-03-26T12:56:41.599Z
6334908 6334908 20250318002341_8hl6k DE0003 2025-03-19T12:06:57.351Z 2025-03-26T12:56:39.465Z
6333931 6333931 20250317221645_xOtnY DE0003 2025-03-19T12:04:24.533Z 2025-03-26T12:55:52.932Z
6333437 6333437 20250317210048_7GtgW DE0003 2025-03-19T12:02:54.108Z 2025-03-26T12:55:41.781Z
6333087 6333087 20250317192131_sm4aF DE0003 2025-03-19T12:01:27.891Z 2025-03-26T12:55:32.630Z
6329687 6329687 20250316232125_3VReW DE0003 2025-03-18T12:04:35.501Z 2025-03-25T12:54:05.314Z
6329598 6329598 20250316223719_74GHP DE0003 2025-03-18T12:04:13.897Z 2025-03-25T12:54:02.651Z
6329433 6329433 20250316212742_SDJoJ DE0003 2025-03-18T12:03:41.515Z 2025-03-25T12:53:47.184Z
6265832 6265832 20250303213154_VSFRF DE0003 2025-03-07T15:03:41.566Z 2025-03-11T13:19:44.846Z
6221949 6221949 20250302193820_MPzZW DE0003 2025-03-04T14:05:03.470Z 2025-03-11T13:28:29.441Z
6216351 6216351 20250302050042_IRdtl DE0003 2025-03-03T14:16:44.212Z 2025-03-10T13:47:03.597Z
6214931 6214931 20250302024615_IBmiz DE0003 2025-03-03T14:13:12.867Z 2025-03-10T13:45:45.425Z
6156594 6156594 20250223193612_1vnUa DE0003 2025-02-25T14:03:36.494Z 2025-03-04T15:22:37.088Z
6115516 6115516 20250218223024_Fr3i9 DE0003 2025-02-20T14:05:03.343Z 2025-02-27T15:26:57.442Z
6093048 6093048 20250209022459_RP2FE DE0003 2025-02-10T14:02:12.079Z 2025-02-17T14:24:06.744Z
6053655 6053655 20250202213623_bfnOv DE0003 2025-02-04T14:24:07.051Z 2025-02-10T14:59:04.954Z
6046430 6046430 20250203000849_1qgeD DE0003 2025-02-04T14:02:14.761Z 2025-02-11T14:37:03.657Z
6045363 6045363 20250201203414_3X635 DE0003 2025-02-03T14:21:47.599Z 2025-02-09T15:03:07.102Z
6038121 6038121 20250202003235_rOmSI DE0003 2025-02-03T14:02:20.280Z 2025-02-10T14:52:50.199Z
6010720 6010720 20250127235118_bBn0K DE0003 2025-01-29T14:19:06.820Z 2025-02-05T14:39:47.219Z
5966396 5966396 20250119012532_UMFYL DE0003 2025-01-22T14:24:12.493Z 2025-01-27T14:46:44.220Z
5966304 5966304 20250119003120_1G5az DE0003 2025-01-22T14:24:02.201Z 2025-01-27T14:46:39.250Z
5966212 5966212 20250118233859_Mn9ON DE0003 2025-01-22T14:23:51.482Z 2025-01-27T14:46:36.950Z

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