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

6,171 rows where station_code = "DE000W" 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
8690303 8690303 20251204224314_OCooD DE000W 2025-12-06T14:13:59.325Z 2025-12-06T14:18:00.857Z
8666522 8666522 20251201060535_InbzF DE000W 2025-12-02T14:26:22.807Z 2025-12-06T14:42:24.693Z
8666492 8666492 20251201055318_I3moa DE000W 2025-12-02T14:26:19.715Z 2025-12-06T14:42:23.868Z
8666477 8666477 20251201054614_DQxWO DE000W 2025-12-02T14:26:18.021Z 2025-12-06T14:42:23.337Z
8666469 8666469 20251201054456_edZYH DE000W 2025-12-02T14:26:16.864Z 2025-12-06T14:42:23.133Z
8666417 8666417 20251201053646_uyosC DE000W 2025-12-02T14:26:00.150Z 2025-12-06T14:42:21.709Z
8666404 8666404 20251201053546_3PbEd DE000W 2025-12-02T14:25:58.702Z 2025-12-06T14:42:21.225Z
8665968 8665968 20251201041528_xcqua DE000W 2025-12-02T14:24:59.817Z 2025-12-06T14:42:08.095Z
8665407 8665407 20251201031723_bjXtK DE000W 2025-12-02T14:23:38.972Z 2025-12-06T14:41:37.073Z
8665128 8665128 20251201023458_7mYLK DE000W 2025-12-02T14:22:59.206Z 2025-12-06T14:41:27.689Z
8665111 8665111 20251201023200_KZGof DE000W 2025-12-02T14:22:56.979Z 2025-12-06T14:41:27.261Z
8665084 8665084 20251201022710_D27tg DE000W 2025-12-02T14:22:54.356Z 2025-12-06T14:41:25.202Z
8665073 8665073 20251201022459_NVqDN DE000W 2025-12-02T14:22:46.292Z 2025-12-06T14:41:24.840Z
8664953 8664953 20251201020803_pXdMQ DE000W 2025-12-02T14:22:30.342Z 2025-12-06T14:41:03.743Z
8664891 8664891 20251201015921_0Kt03 DE000W 2025-12-02T14:22:18.071Z 2025-12-06T14:41:02.139Z
8664876 8664876 20251201015523_Z3Awl DE000W 2025-12-02T14:22:15.774Z 2025-12-06T14:41:01.665Z
8664628 8664628 20251201011508_PpvTf DE000W 2025-12-02T14:21:40.375Z 2025-12-06T14:40:53.374Z
8664504 8664504 20251201004307_LtxzA DE000W 2025-12-02T14:21:13.782Z 2025-12-06T14:40:48.927Z
8664365 8664365 20251201000953_J6msT DE000W 2025-12-02T14:20:48.375Z 2025-12-06T14:40:45.415Z
8664356 8664356 20251201000818_abLER DE000W 2025-12-02T14:20:47.174Z 2025-12-06T14:40:45.144Z
8664247 8664247 20251130235055_79Rfn DE000W 2025-12-02T14:20:34.393Z 2025-12-06T14:40:42.410Z
8664107 8664107 20251130231831_2jiyZ DE000W 2025-12-02T14:20:05.798Z 2025-12-06T14:40:35.332Z
8663678 8663678 20251130212418_RjYVk DE000W 2025-12-02T14:18:51.356Z 2025-12-06T14:40:06.939Z
8663637 8663637 20251130211255_xcyKx DE000W 2025-12-02T14:18:38.160Z 2025-12-06T14:40:05.336Z
8663323 8663323 20251130203025_5fncD DE000W 2025-12-02T14:17:58.314Z 2025-12-06T14:39:57.834Z
8662847 8662847 20251130193915_lRvdl DE000W 2025-12-02T14:16:51.075Z 2025-12-06T14:39:33.184Z
8662598 8662598 20251130191251_SKHxw DE000W 2025-12-02T14:15:57.750Z 2025-12-06T14:39:23.183Z
8662013 8662013 20251130174156_iCgz1 DE000W 2025-12-02T14:13:58.357Z 2025-12-06T14:38:46.628Z
8647368 8647368 20251129042817_3KzQV DE000W 2025-11-30T14:28:03.742Z 2025-12-06T14:56:37.623Z
8647091 8647091 20251129034243_L2zSD DE000W 2025-11-30T14:27:31.452Z 2025-12-06T14:56:31.734Z
8645757 8645757 20251128234414_kNF1m DE000W 2025-11-30T14:24:29.820Z 2025-12-06T14:55:05.656Z
8623317 8623317 20251126235518_zgDxm DE000W 2025-11-28T14:21:30.114Z 2025-12-05T15:03:42.168Z
8623087 8623087 20251126224759_oeqae DE000W 2025-11-28T14:20:51.153Z 2025-12-05T15:03:28.204Z
8623040 8623040 20251126223345_wBkj0 DE000W 2025-11-28T14:20:32.225Z 2025-12-05T15:03:26.103Z
8622972 8622972 20251126221943_2k5eu DE000W 2025-11-28T14:20:24.290Z 2025-12-05T15:03:21.129Z
8622851 8622851 20251126214919_5eOrq DE000W 2025-11-28T14:20:11.198Z 2025-12-05T15:03:16.604Z
8622841 8622841 20251126214451_f84Pn DE000W 2025-11-28T14:20:09.908Z 2025-12-05T15:03:16.248Z
8622839 8622839 20251126214444_Ci0gT DE000W 2025-11-28T14:20:09.628Z 2025-12-05T15:03:16.032Z
8622647 8622647 20251126203058_3iDI1 DE000W 2025-11-28T14:19:37.669Z 2025-12-05T15:03:04.578Z
8622407 8622407 20251126190445_r8Hli DE000W 2025-11-28T14:18:48.269Z 2025-12-05T15:02:56.532Z
8622142 8622142 20251126175928_GeLv8 DE000W 2025-11-28T14:17:49.049Z 2025-12-05T15:02:52.767Z
8602293 8602293 20251125044622_Iypzp DE000W 2025-11-26T14:25:30.349Z 2025-12-02T15:09:30.265Z
8582198 8582198 20251123044109_5YNdD DE000W 2025-11-24T14:33:22.251Z 2025-12-01T15:22:18.541Z
8582076 8582076 20251123040120_qAVbu DE000W 2025-11-24T14:33:15.359Z 2025-12-01T15:22:15.591Z
8582029 8582029 20251123034359_mufZM DE000W 2025-11-24T14:33:10.380Z 2025-12-01T15:22:14.344Z
8581982 8581982 20251123032912_9PPDW DE000W 2025-11-24T14:32:56.396Z 2025-12-01T15:22:08.789Z
8581939 8581939 20251123031139_jLuh3 DE000W 2025-11-24T14:32:48.216Z 2025-12-01T15:22:01.841Z
8581927 8581927 20251123030723_9wzd0 DE000W 2025-11-24T14:32:47.413Z 2025-12-01T15:21:59.852Z
8581889 8581889 20251123025618_NX8yS DE000W 2025-11-24T14:32:43.820Z 2025-12-01T15:21:55.202Z
8581831 8581831 20251123024338_AW2J6 DE000W 2025-11-24T14:32:40.673Z 2025-12-01T15:21:44.529Z
8581788 8581788 20251123022255_3jyjz DE000W 2025-11-24T14:32:38.094Z 2025-12-01T15:21:36.867Z
8581756 8581756 20251123020641_Xq6GS DE000W 2025-11-24T14:32:36.048Z 2025-12-01T15:21:28.298Z
8581754 8581754 20251123020636_mW22t DE000W 2025-11-24T14:32:35.921Z 2025-12-01T15:21:27.613Z
8581712 8581712 20251123015140_MNmJZ DE000W 2025-11-24T14:32:33.716Z 2025-12-01T15:21:19.543Z
8581710 8581710 20251123014929_pRRNX DE000W 2025-11-24T14:32:33.450Z 2025-12-01T15:21:19.049Z
8581704 8581704 20251123014755_6Td3O DE000W 2025-11-24T14:32:32.908Z 2025-12-01T15:21:17.859Z
8581691 8581691 20251123014137_eonJ2 DE000W 2025-11-24T14:32:32.180Z 2025-12-01T15:21:14.992Z
8581687 8581687 20251123014059_XCknD DE000W 2025-11-24T14:32:32.088Z 2025-12-01T15:21:14.668Z
8581671 8581671 20251123013728_N9ezv DE000W 2025-11-24T14:32:30.993Z 2025-12-01T15:21:12.018Z
8581662 8581662 20251123013413_nEwA1 DE000W 2025-11-24T14:32:30.583Z 2025-12-01T15:21:11.851Z
8581627 8581627 20251123012112_O2Ctc DE000W 2025-11-24T14:32:14.021Z 2025-12-01T15:21:10.325Z
8581623 8581623 20251123011938_0Ky0U DE000W 2025-11-24T14:32:13.003Z 2025-12-01T15:21:10.028Z
8581621 8581621 20251123011655_YRBqJ DE000W 2025-11-24T14:32:12.913Z 2025-12-01T15:21:08.469Z
8581590 8581590 20251123010610_I3Gsx DE000W 2025-11-24T14:32:09.299Z 2025-12-01T15:21:00.240Z
8581587 8581587 20251123010542_O2t2z DE000W 2025-11-24T14:32:09.254Z 2025-12-01T15:21:00.205Z
8581563 8581563 20251123005437_EaN5O DE000W 2025-11-24T14:31:58.154Z 2025-12-01T15:20:57.921Z
8581518 8581518 20251123003546_Y5M6m DE000W 2025-11-24T14:31:42.986Z 2025-12-01T15:20:51.077Z
8581499 8581499 20251123001936_o5WRF DE000W 2025-11-24T14:31:41.218Z 2025-12-01T15:20:43.714Z
8581481 8581481 20251123000816_42Nlc DE000W 2025-11-24T14:31:40.154Z 2025-12-01T15:20:38.739Z
8581431 8581431 20251122235257_Xed5f DE000W 2025-11-24T14:31:34.228Z 2025-12-01T15:20:28.903Z
8581421 8581421 20251122234915_UsCLl DE000W 2025-11-24T14:31:33.662Z 2025-12-01T15:20:26.859Z
8581403 8581403 20251122234350_FPRi0 DE000W 2025-11-24T14:31:32.011Z 2025-12-01T15:20:21.813Z
8581392 8581392 20251122234025_utMqq DE000W 2025-11-24T14:31:31.229Z 2025-12-01T15:20:19.002Z
8581356 8581356 20251122231539_PTO70 DE000W 2025-11-24T14:31:28.154Z 2025-12-01T15:20:14.637Z
8581352 8581352 20251122231457_2xm3Y DE000W 2025-11-24T14:31:27.850Z 2025-12-01T15:20:14.505Z
8581335 8581335 20251122231055_lH1r3 DE000W 2025-11-24T14:31:27.114Z 2025-12-01T15:20:14.095Z
8581255 8581255 20251122223212_HNF9E DE000W 2025-11-24T14:31:22.177Z 2025-12-01T15:20:05.243Z
8580716 8580716 20251122003321_M8NO2 DE000W 2025-11-24T14:23:25.729Z 2025-11-30T15:05:47.856Z
8579048 8579048 20251122221150_sH8p2 DE000W 2025-11-24T14:13:22.966Z 2025-11-24T14:13:22.966Z
8579009 8579009 20251122220507_BONzL DE000W 2025-11-24T14:13:17.396Z 2025-12-01T15:19:58.181Z
8578787 8578787 20251122212653_tl8jC DE000W 2025-11-24T14:12:41.163Z 2025-12-01T15:19:52.882Z
8578763 8578763 20251122212402_0BRzJ DE000W 2025-11-24T14:12:38.880Z 2025-12-01T15:19:52.698Z
8578677 8578677 20251122211324_l2EzS DE000W 2025-11-24T14:12:18.750Z 2025-12-01T15:19:49.645Z
8578624 8578624 20251122210345_oaJa4 DE000W 2025-11-24T14:12:13.756Z 2025-12-01T15:19:49.072Z
8578613 8578613 20251122210311_FhPnf DE000W 2025-11-24T14:12:12.688Z 2025-12-01T15:19:48.960Z
8578531 8578531 20251122204924_cyITd DE000W 2025-11-24T14:12:02.834Z 2025-12-01T15:19:46.507Z
8578457 8578457 20251122203805_mLKPG DE000W 2025-11-24T14:11:47.075Z 2025-12-01T15:19:38.271Z
8577971 8577971 20251122191945_7BnWf DE000W 2025-11-24T14:10:20.368Z 2025-11-24T14:10:20.368Z
8577716 8577716 20251122185020_2T122 DE000W 2025-11-24T14:09:30.658Z 2025-12-01T15:18:56.845Z
8577472 8577472 20251122181459_Qihgn DE000W 2025-11-24T14:08:43.752Z 2025-12-01T15:18:51.298Z
8577391 8577391 20251122180147_BUudF DE000W 2025-11-24T14:08:30.745Z 2025-12-01T15:18:48.705Z
8577240 8577240 20251122174015_Cb1lV DE000W 2025-11-24T14:08:04.090Z 2025-12-01T15:18:45.319Z
8577033 8577033 20251122170911_cq0ht DE000W 2025-11-24T14:07:23.578Z 2025-12-01T15:18:42.668Z
8574131 8574131 20251122051502_aujnD DE000W 2025-11-23T14:42:21.302Z 2025-11-30T15:06:59.614Z
8574121 8574121 20251122051436_Bc22S DE000W 2025-11-23T14:42:20.137Z 2025-11-30T15:06:59.180Z
8574056 8574056 20251122050435_IkWFM DE000W 2025-11-23T14:42:13.857Z 2025-11-30T15:06:56.458Z
8574008 8574008 20251122045757_JNh1T DE000W 2025-11-23T14:42:11.596Z 2025-11-30T15:06:55.580Z
8574006 8574006 20251122045750_kuF2y DE000W 2025-11-23T14:42:11.502Z 2025-11-30T15:06:55.514Z
8573969 8573969 20251122045119_vL1O4 DE000W 2025-11-23T14:42:09.661Z 2025-11-30T15:06:54.219Z
8573963 8573963 20251122045028_UlbZ3 DE000W 2025-11-23T14:42:09.248Z 2025-11-30T15:06:53.751Z

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