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

8,169 rows where station_code = "DE000S" 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
8666521 8666521 20251201060535_InbzF DE000S 2025-12-02T14:26:22.807Z 2025-12-05T14:37:01.199Z
8666482 8666482 20251201054728_N2fH2 DE000S 2025-12-02T14:26:18.440Z 2025-12-05T14:36:59.542Z
8666476 8666476 20251201054614_DQxWO DE000S 2025-12-02T14:26:18.021Z 2025-12-05T14:36:59.467Z
8666459 8666459 20251201054347_Sl92G DE000S 2025-12-02T14:26:15.878Z 2025-12-05T14:36:59.078Z
8666391 8666391 20251201053312_Iv9RT DE000S 2025-12-02T14:25:56.114Z 2025-12-05T14:36:56.992Z
8666264 8666264 20251201050506_7b4L3 DE000S 2025-12-02T14:25:41.177Z 2025-12-05T14:36:52.590Z
8666245 8666245 20251201050038_Qb0BD DE000S 2025-12-02T14:25:39.413Z 2025-12-05T14:36:50.814Z
8666208 8666208 20251201045246_st2Rc DE000S 2025-12-02T14:25:36.301Z 2025-12-05T14:36:36.073Z
8665980 8665980 20251201041621_NPNtR DE000S 2025-12-02T14:25:01.390Z 2025-12-05T14:36:25.763Z
8665549 8665549 20251201033424_CVyHM DE000S 2025-12-02T14:23:53.049Z 2025-12-05T14:36:11.428Z
8665543 8665543 20251201033406_3sI3O DE000S 2025-12-02T14:23:51.758Z 2025-12-05T14:36:11.216Z
8665451 8665451 20251201032120_k8MoS DE000S 2025-12-02T14:23:42.604Z 2025-12-05T14:36:07.864Z
8665254 8665254 20251201025225_J2f0v DE000S 2025-12-02T14:23:12.850Z 2025-12-05T14:35:47.549Z
8665117 8665117 20251201023234_1tQCc DE000S 2025-12-02T14:22:57.974Z 2025-12-05T14:35:43.041Z
8665083 8665083 20251201022710_D27tg DE000S 2025-12-02T14:22:54.356Z 2025-12-05T14:35:42.092Z
8665072 8665072 20251201022459_NVqDN DE000S 2025-12-02T14:22:46.292Z 2025-12-05T14:35:41.624Z
8665037 8665037 20251201022014_uorC0 DE000S 2025-12-02T14:22:39.276Z 2025-12-05T14:35:40.120Z
8664952 8664952 20251201020803_pXdMQ DE000S 2025-12-02T14:22:30.342Z 2025-12-05T14:35:37.282Z
8664875 8664875 20251201015523_Z3Awl DE000S 2025-12-02T14:22:15.774Z 2025-12-05T14:35:34.446Z
8664781 8664781 20251201013645_5wXjm DE000S 2025-12-02T14:22:03.697Z 2025-12-05T14:35:17.661Z
8664648 8664648 20251201011647_9F2hy DE000S 2025-12-02T14:21:43.267Z 2025-12-05T14:35:11.611Z
8664503 8664503 20251201004307_LtxzA DE000S 2025-12-02T14:21:13.782Z 2025-12-05T14:35:06.497Z
8664355 8664355 20251201000818_abLER DE000S 2025-12-02T14:20:47.174Z 2025-12-05T14:35:01.772Z
8664333 8664333 20251201000355_7lLmG DE000S 2025-12-02T14:20:43.930Z 2025-12-05T14:35:00.912Z
8664246 8664246 20251130235055_79Rfn DE000S 2025-12-02T14:20:34.393Z 2025-12-05T14:34:58.335Z
8664207 8664207 20251130234012_32Xwp DE000S 2025-12-02T14:20:29.378Z 2025-12-05T14:34:56.659Z
8663918 8663918 20251130223348_4u4Ml DE000S 2025-12-02T14:19:35.323Z 2025-12-05T14:34:36.684Z
8663870 8663870 20251130222158_bjCq7 DE000S 2025-12-02T14:19:28.884Z 2025-12-05T14:34:35.005Z
8663636 8663636 20251130211255_xcyKx DE000S 2025-12-02T14:18:38.160Z 2025-12-05T14:34:26.461Z
8663542 8663542 20251130205945_6XZUn DE000S 2025-12-02T14:18:25.880Z 2025-12-05T14:34:23.572Z
8645481 8645481 20251128222229_Yt262 DE000S 2025-11-30T14:23:47.937Z 2025-12-05T14:50:39.985Z
8623086 8623086 20251126224759_oeqae DE000S 2025-11-28T14:20:51.153Z 2025-12-05T15:03:28.204Z
8622971 8622971 20251126221943_2k5eu DE000S 2025-11-28T14:20:24.290Z 2025-12-05T15:03:21.129Z
8622925 8622925 20251126220655_rRJrr DE000S 2025-11-28T14:20:19.321Z 2025-12-05T15:03:20.040Z
8622850 8622850 20251126214919_5eOrq DE000S 2025-11-28T14:20:11.198Z 2025-12-05T15:03:16.604Z
8622840 8622840 20251126214451_f84Pn DE000S 2025-11-28T14:20:09.908Z 2025-12-05T15:03:16.248Z
8622838 8622838 20251126214444_Ci0gT DE000S 2025-11-28T14:20:09.628Z 2025-12-05T15:03:16.032Z
8622591 8622591 20251126201111_RwUQx DE000S 2025-11-28T14:19:26.889Z 2025-12-05T15:03:03.831Z
8608729 8608729 20251125223909_dIXr3 DE000S 2025-11-27T14:16:40.033Z 2025-12-04T15:07:48.126Z
8608621 8608621 20251125223154_Dtat4 DE000S 2025-11-27T14:16:23.876Z 2025-12-04T15:07:47.134Z
8608347 8608347 20251125220857_v02cL DE000S 2025-11-27T14:15:43.806Z 2025-12-04T15:07:43.912Z
8607804 8607804 20251125212250_ynfBS DE000S 2025-11-27T14:14:31.843Z 2025-12-04T15:07:30.529Z
8607623 8607623 20251125210802_AKERT DE000S 2025-11-27T14:14:04.506Z 2025-12-04T15:07:05.546Z
8607556 8607556 20251125210133_85xC2 DE000S 2025-11-27T14:13:56.830Z 2025-12-04T15:07:03.610Z
8607353 8607353 20251125204337_Eyjvr DE000S 2025-11-27T14:13:26.610Z 2025-12-04T15:07:01.080Z
8606971 8606971 20251125200047_se3ib DE000S 2025-11-27T14:11:54.047Z 2025-12-04T15:06:53.065Z
8599599 8599599 20251125021138_T3rlY DE000S 2025-11-26T14:21:17.986Z 2025-12-02T15:08:30.016Z
8598583 8598583 20251125010704_2QrlV DE000S 2025-11-26T14:19:17.429Z 2025-12-02T15:08:01.078Z
8597283 8597283 20251124232021_2vqmQ DE000S 2025-11-26T14:16:28.946Z 2025-12-02T15:07:27.924Z
8597124 8597124 20251124230056_GWJiP DE000S 2025-11-26T14:16:03.852Z 2025-12-02T15:07:23.362Z
8597039 8597039 20251124224846_2R6xx DE000S 2025-11-26T14:15:55.065Z 2025-12-02T15:07:22.621Z
8595580 8595580 20251124170622_drFPQ DE000S 2025-11-26T14:11:41.637Z 2025-12-02T15:06:01.982Z
8582277 8582277 20251123050942_ZBQKt DE000S 2025-11-24T14:33:27.048Z 2025-12-01T15:22:20.922Z
8582231 8582231 20251123045010_8BKLW DE000S 2025-11-24T14:33:24.154Z 2025-12-01T15:22:19.492Z
8582197 8582197 20251123044109_5YNdD DE000S 2025-11-24T14:33:22.251Z 2025-12-01T15:22:18.541Z
8582159 8582159 20251123042607_iA2CK DE000S 2025-11-24T14:33:20.120Z 2025-12-01T15:22:17.610Z
8582075 8582075 20251123040120_qAVbu DE000S 2025-11-24T14:33:15.359Z 2025-12-01T15:22:15.591Z
8582028 8582028 20251123034359_mufZM DE000S 2025-11-24T14:33:10.380Z 2025-12-01T15:22:14.344Z
8581984 8581984 20251123032951_INRZa DE000S 2025-11-24T14:32:57.017Z 2025-12-01T15:22:09.175Z
8581981 8581981 20251123032912_9PPDW DE000S 2025-11-24T14:32:56.396Z 2025-12-01T15:22:08.789Z
8581938 8581938 20251123031139_jLuh3 DE000S 2025-11-24T14:32:48.216Z 2025-12-01T15:22:01.841Z
8581932 8581932 20251123031008_DojJx DE000S 2025-11-24T14:32:47.888Z 2025-12-01T15:22:01.788Z
8581926 8581926 20251123030723_9wzd0 DE000S 2025-11-24T14:32:47.413Z 2025-12-01T15:21:59.852Z
8581888 8581888 20251123025618_NX8yS DE000S 2025-11-24T14:32:43.820Z 2025-12-01T15:21:55.202Z
8581860 8581860 20251123024916_yOzpM DE000S 2025-11-24T14:32:42.086Z 2025-12-01T15:21:49.803Z
8581830 8581830 20251123024338_AW2J6 DE000S 2025-11-24T14:32:40.673Z 2025-12-01T15:21:44.529Z
8581827 8581827 20251123024239_PYBU6 DE000S 2025-11-24T14:32:40.591Z 2025-12-01T15:21:44.186Z
8581792 8581792 20251123022358_yC8g8 DE000S 2025-11-24T14:32:38.372Z 2025-12-01T15:21:37.247Z
8581755 8581755 20251123020641_Xq6GS DE000S 2025-11-24T14:32:36.048Z 2025-12-01T15:21:28.298Z
8581753 8581753 20251123020636_mW22t DE000S 2025-11-24T14:32:35.921Z 2025-12-01T15:21:27.613Z
8581709 8581709 20251123014929_pRRNX DE000S 2025-11-24T14:32:33.450Z 2025-12-01T15:21:19.049Z
8581703 8581703 20251123014755_6Td3O DE000S 2025-11-24T14:32:32.908Z 2025-12-01T15:21:17.859Z
8581690 8581690 20251123014137_eonJ2 DE000S 2025-11-24T14:32:32.180Z 2025-12-01T15:21:14.992Z
8581628 8581628 20251123012123_vjnka DE000S 2025-11-24T14:32:14.321Z 2025-12-01T15:21:10.552Z
8581626 8581626 20251123012112_O2Ctc DE000S 2025-11-24T14:32:14.021Z 2025-12-01T15:21:10.325Z
8581622 8581622 20251123011938_0Ky0U DE000S 2025-11-24T14:32:13.003Z 2025-12-01T15:21:10.027Z
8581620 8581620 20251123011655_YRBqJ DE000S 2025-11-24T14:32:12.913Z 2025-12-01T15:21:08.469Z
8581589 8581589 20251123010610_I3Gsx DE000S 2025-11-24T14:32:09.299Z 2025-12-01T15:21:00.239Z
8581586 8581586 20251123010542_O2t2z DE000S 2025-11-24T14:32:09.253Z 2025-12-01T15:21:00.205Z
8581579 8581579 20251123005854_KJjVE DE000S 2025-11-24T14:32:04.368Z 2025-12-01T15:20:59.432Z
8581562 8581562 20251123005432_vmbRX DE000S 2025-11-24T14:31:54.531Z 2025-12-01T15:20:57.892Z
8581548 8581548 20251123005249_tdU2w DE000S 2025-11-24T14:31:47.461Z 2025-12-01T15:20:56.870Z
8581542 8581542 20251123005021_Bijox DE000S 2025-11-24T14:31:46.174Z 2025-12-01T15:20:55.943Z
8581517 8581517 20251123003546_Y5M6m DE000S 2025-11-24T14:31:42.986Z 2025-12-01T15:20:51.076Z
8581498 8581498 20251123001936_o5WRF DE000S 2025-11-24T14:31:41.218Z 2025-12-01T15:20:43.714Z
8581480 8581480 20251123000816_42Nlc DE000S 2025-11-24T14:31:40.154Z 2025-12-01T15:20:38.739Z
8581471 8581471 20251123000652_GZS33 DE000S 2025-11-24T14:31:39.650Z 2025-12-01T15:20:38.334Z
8581420 8581420 20251122234915_UsCLl DE000S 2025-11-24T14:31:33.662Z 2025-12-01T15:20:26.859Z
8581355 8581355 20251122231539_PTO70 DE000S 2025-11-24T14:31:28.154Z 2025-12-01T15:20:14.637Z
8581351 8581351 20251122231457_2xm3Y DE000S 2025-11-24T14:31:27.850Z 2025-12-01T15:20:14.505Z
8581289 8581289 20251122225454_n9u6b DE000S 2025-11-24T14:31:23.946Z 2025-12-01T15:20:11.468Z
8581254 8581254 20251122223212_HNF9E DE000S 2025-11-24T14:31:22.177Z 2025-12-01T15:20:05.243Z
8581244 8581244 20251122222842_7P3Nl DE000S 2025-11-24T14:31:21.661Z 2025-12-01T15:20:04.764Z
8581232 8581232 20251122222353_kCyo0 DE000S 2025-11-24T14:31:21.125Z 2025-12-01T15:20:03.542Z
8580730 8580730 20251122031258_n8ERI DE000S 2025-11-24T14:26:02.152Z 2025-11-30T15:06:25.095Z
8580719 8580719 20251122003948_7zN3R DE000S 2025-11-24T14:23:29.070Z 2025-11-30T15:05:49.237Z
8580715 8580715 20251122003321_M8NO2 DE000S 2025-11-24T14:23:25.729Z 2025-11-30T15:05:47.856Z
8579008 8579008 20251122220507_BONzL DE000S 2025-11-24T14:13:17.396Z 2025-12-01T15:19:58.181Z
8578762 8578762 20251122212402_0BRzJ DE000S 2025-11-24T14:12:38.880Z 2025-12-01T15:19:52.698Z
8578731 8578731 20251122212103_Uh1gI DE000S 2025-11-24T14:12:35.129Z 2025-12-01T15:19:51.012Z

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