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,876 rows where station_code = "DE0015" 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
9243694 9243694 20260121050545_reVjo DE0015 2026-01-22T14:22:46.107Z 2026-01-29T15:05:23.705Z
9243237 9243237 20260121040444_8iZbe DE0015 2026-01-22T14:21:06.709Z 2026-01-29T15:04:52.310Z
9243232 9243232 20260121040246_GNhfk DE0015 2026-01-22T14:21:01.136Z 2026-01-29T15:04:51.872Z
9243188 9243188 20260121035648_Tv8zl DE0015 2026-01-22T14:20:52.812Z 2026-01-29T15:04:50.145Z
9243165 9243165 20260121035339_ipIWq DE0015 2026-01-22T14:20:49.503Z 2026-01-29T15:04:49.204Z
9243163 9243163 20260121035253_byMxh DE0015 2026-01-22T14:20:49.087Z 2026-01-29T15:04:49.066Z
9243105 9243105 20260121034322_j7HPy DE0015 2026-01-22T14:20:34.385Z 2026-01-29T15:04:46.666Z
9243019 9243019 20260121033238_xhYST DE0015 2026-01-22T14:20:19.747Z 2026-01-29T15:04:43.803Z
9242453 9242453 20260121015232_Q6jzr DE0015 2026-01-22T14:17:53.398Z 2026-01-29T15:03:59.269Z
9242202 9242202 20260121010020_4mspX DE0015 2026-01-22T14:16:52.907Z 2026-01-29T15:03:36.648Z
9213678 9213678 20260116042341_FXw7R DE0015 2026-01-17T14:18:07.445Z 2026-01-24T15:12:30.887Z
9212995 9212995 20260116014841_HRNVu DE0015 2026-01-17T14:14:53.007Z 2026-01-24T15:11:36.730Z
9212943 9212943 20260116014143_GGB3x DE0015 2026-01-17T14:14:42.104Z 2026-01-24T15:11:35.185Z
9212670 9212670 20260116001302_lfSUo DE0015 2026-01-17T14:13:12.192Z 2026-01-24T15:11:09.490Z
9212484 9212484 20260115221134_Ym3LJ DE0015 2026-01-17T14:12:09.990Z 2026-01-24T15:10:57.228Z
9212482 9212482 20260115221045_ANROw DE0015 2026-01-17T14:12:09.253Z 2026-01-24T15:10:57.141Z
9212447 9212447 20260115213059_9Epss DE0015 2026-01-17T14:11:52.640Z 2026-01-24T15:10:54.339Z
9207074 9207074 20260114212126_qT7pb DE0015 2026-01-16T14:06:59.108Z 2026-01-22T15:03:07.800Z
9201536 9201536 20260114022805_SMeB3 DE0015 2026-01-15T14:18:51.805Z 2026-01-22T15:09:05.427Z
9199842 9199842 20260113213008_NUZTh DE0015 2026-01-15T14:12:40.053Z 2026-01-22T15:08:03.744Z
9199661 9199661 20260113205150_QwLpn DE0015 2026-01-15T14:11:57.349Z 2026-01-22T15:07:59.187Z
9083160 9083160 20251227230743_vWVWF DE0015 2025-12-30T14:31:50.474Z 2026-01-05T15:07:39.426Z
9082768 9082768 20251227214127_jpWZN DE0015 2025-12-30T14:30:35.308Z 2026-01-05T15:07:18.088Z
9023867 9023867 20251220225354_WYYnt DE0015 2025-12-27T15:10:02.664Z 2025-12-29T15:26:23.814Z
9023826 9023826 20251220223038_dPQQM DE0015 2025-12-27T15:09:54.550Z 2025-12-29T15:26:23.340Z
9023801 9023801 20251220221821_I3Oet DE0015 2025-12-27T15:09:45.009Z 2025-12-29T15:26:22.961Z
9023777 9023777 20251220220553_TjkCb DE0015 2025-12-27T15:09:42.020Z 2025-12-29T15:26:22.639Z
9023760 9023760 20251220215205_6TsUH DE0015 2025-12-27T15:09:34.761Z 2025-12-29T15:26:22.396Z
9023754 9023754 20251220214708_OCK6T DE0015 2025-12-27T15:09:31.475Z 2025-12-29T15:26:22.296Z
9023741 9023741 20251220214506_hEu0e DE0015 2025-12-27T15:09:30.722Z 2025-12-27T15:09:30.722Z
9023566 9023566 20251220204359_2xQNK DE0015 2025-12-27T15:09:12.560Z 2025-12-29T15:26:20.832Z
9023530 9023530 20251220202949_3rn5i DE0015 2025-12-27T15:09:06.263Z 2025-12-29T15:26:20.548Z
9017551 9017551 20251220052931_wZBc5 DE0015 2025-12-27T15:01:25.009Z 2025-12-29T15:23:32.194Z
9017492 9017492 20251220052432_lnIWV DE0015 2025-12-27T15:01:23.343Z 2025-12-27T15:01:23.343Z
9017251 9017251 20251220050559_ZtyeI DE0015 2025-12-27T15:01:14.639Z 2025-12-27T15:01:14.639Z
9016932 9016932 20251220044120_eTza9 DE0015 2025-12-27T15:00:58.071Z 2025-12-29T15:23:27.124Z
8982885 8982885 20251219204719_IkeCX DE0015 2025-12-26T14:28:03.224Z 2025-12-28T15:22:23.717Z
8982765 8982765 20251219203204_ZdgJS DE0015 2025-12-26T14:27:43.573Z 2025-12-28T15:22:15.811Z
8981412 8981412 20251219173232_sG63w DE0015 2025-12-26T14:24:41.022Z 2025-12-28T15:21:51.935Z
8981364 8981364 20251219172612_ZZnRT DE0015 2025-12-26T14:24:32.950Z 2025-12-27T15:16:18.055Z
8826254 8826254 20251210224147_EbeBt DE0015 2025-12-17T15:19:36.578Z 2025-12-19T15:13:23.261Z
8756227 8756227 20251210040846_HVYKs DE0015 2025-12-13T15:45:04.881Z 2025-12-17T15:29:29.270Z
8755821 8755821 20251210034301_y2lvm DE0015 2025-12-13T15:44:26.276Z 2025-12-17T15:29:24.946Z
8742794 8742794 20251210224435_hh22a DE0015 2025-12-13T15:23:09.528Z 2025-12-19T15:13:23.789Z
8742787 8742787 20251210224414_7F0wP DE0015 2025-12-13T15:23:08.241Z 2025-12-19T15:13:23.705Z
8742766 8742766 20251210224214_qqdX3 DE0015 2025-12-13T15:23:07.578Z 2025-12-19T15:13:23.298Z
8742628 8742628 20251210223217_dYv3P DE0015 2025-12-13T15:23:00.951Z 2025-12-19T15:13:20.204Z
8742616 8742616 20251210223123_X5HuW DE0015 2025-12-13T15:23:00.302Z 2025-12-19T15:13:19.826Z
8742553 8742553 20251210222654_K3QKs DE0015 2025-12-13T15:22:52.037Z 2025-12-19T15:13:18.274Z
8740141 8740141 20251210183521_wz39R DE0015 2025-12-13T15:18:04.332Z 2025-12-19T15:11:14.696Z
8740074 8740074 20251210182653_2WnL2 DE0015 2025-12-13T15:17:59.617Z 2025-12-19T15:11:11.825Z
8713873 8713873 20251210043205_v3U38 DE0015 2025-12-11T14:00:33.050Z 2025-12-19T15:05:17.981Z
8683655 8683655 20251130005714_o9iwK DE0015 2025-12-04T14:40:19.109Z 2025-12-08T14:54:15.936Z
8656092 8656092 20251130043642_S414j DE0015 2025-12-01T14:28:02.795Z 2025-12-08T14:56:07.472Z
8656006 8656006 20251130042958_M4Amg DE0015 2025-12-01T14:27:55.924Z 2025-12-08T14:56:05.119Z
8655371 8655371 20251130035842_3f3mI DE0015 2025-12-01T14:26:51.513Z 2025-12-01T14:26:51.513Z
8655253 8655253 20251130035107_Usxkr DE0015 2025-12-01T14:26:41.714Z 2025-12-08T14:55:56.703Z
8655161 8655161 20251130034640_dPheK DE0015 2025-12-01T14:26:36.661Z 2025-12-08T14:55:54.413Z
8654753 8654753 20251130033149_3hBek DE0015 2025-12-01T14:25:58.309Z 2025-12-08T14:55:42.298Z
8654493 8654493 20251130031826_C2oQG DE0015 2025-12-01T14:25:29.745Z 2025-12-01T14:25:29.745Z
8654111 8654111 20251130025933_SVGtH DE0015 2025-12-01T14:24:52.500Z 2025-12-08T14:55:07.827Z
8653767 8653767 20251130023919_LBdQp DE0015 2025-12-01T14:24:12.864Z 2025-12-08T14:55:01.558Z
8653212 8653212 20251130020316_qm2bq DE0015 2025-12-01T14:23:05.160Z 2025-12-08T14:54:52.651Z
8652520 8652520 20251130011442_vsiUc DE0015 2025-12-01T14:21:37.896Z 2025-12-08T14:54:20.411Z
8652431 8652431 20251130010843_apht1 DE0015 2025-12-01T14:21:23.187Z 2025-12-08T14:54:18.952Z
8652422 8652422 20251130010829_tY1Y2 DE0015 2025-12-01T14:21:22.567Z 2025-12-08T14:54:18.872Z
8652322 8652322 20251130010256_XzzmV DE0015 2025-12-01T14:21:16.148Z 2025-12-08T14:54:17.753Z
8652295 8652295 20251130010231_Z0lE0 DE0015 2025-12-01T14:21:14.523Z 2025-12-08T14:54:17.406Z
8652238 8652238 20251130005743_5BHPi DE0015 2025-12-01T14:20:59.119Z 2025-12-08T14:54:16.055Z
8652234 8652234 20251130005714_euG3A DE0015 2025-12-01T14:20:58.068Z 2025-12-02T14:37:56.952Z
8652018 8652018 20251130004130_XzadC DE0015 2025-12-01T14:20:29.136Z 2025-12-08T14:54:12.503Z
8652003 8652003 20251130004041_Vi47g DE0015 2025-12-01T14:20:27.178Z 2025-12-08T14:54:12.249Z
8651978 8651978 20251130003910_KrMXx DE0015 2025-12-01T14:20:23.123Z 2025-12-08T14:54:11.964Z
8651956 8651956 20251130003727_iAQ62 DE0015 2025-12-01T14:20:19.669Z 2025-12-08T14:54:11.652Z
8651941 8651941 20251130003547_Ft3sV DE0015 2025-12-01T14:20:18.593Z 2025-12-08T14:54:11.462Z
8651735 8651735 20251130001517_SzNVj DE0015 2025-12-01T14:19:47.436Z 2025-12-08T14:54:01.478Z
8651689 8651689 20251130001050_VEWT1 DE0015 2025-12-01T14:19:41.545Z 2025-12-08T14:53:58.322Z
8651635 8651635 20251130000725_2s101 DE0015 2025-12-01T14:19:36.335Z 2025-12-08T14:53:50.720Z
8651619 8651619 20251130000249_YgZuh DE0015 2025-12-01T14:19:33.978Z 2025-12-08T14:53:48.105Z
8651448 8651448 20251129234404_IZ0Co DE0015 2025-12-01T14:19:08.454Z 2025-12-08T14:53:45.620Z
8651425 8651425 20251129234135_R74n2 DE0015 2025-12-01T14:19:02.310Z 2025-12-08T14:53:45.279Z
8651297 8651297 20251129232223_dSeBT DE0015 2025-12-01T14:18:42.130Z 2025-12-08T14:53:42.688Z
8651285 8651285 20251129232116_vYDai DE0015 2025-12-01T14:18:35.480Z 2025-12-08T14:53:42.548Z
8651274 8651274 20251129232030_bRNvU DE0015 2025-12-01T14:18:31.925Z 2025-12-08T14:53:42.364Z
8651214 8651214 20251129230731_Xul7y DE0015 2025-12-01T14:18:25.318Z 2025-12-08T14:53:41.248Z
8650750 8650750 20251129212124_RvGtz DE0015 2025-12-01T14:17:05.438Z 2025-12-08T14:53:04.744Z
8650679 8650679 20251129210620_l0Lp0 DE0015 2025-12-01T14:16:53.343Z 2025-12-08T14:53:03.498Z
8650651 8650651 20251129205927_wNiJ7 DE0015 2025-12-01T14:16:48.651Z 2025-12-08T14:53:02.864Z
8635828 8635828 20251128025241_sNzq2 DE0015 2025-11-29T14:24:13.028Z 2025-12-06T15:02:52.699Z
8635823 8635823 20251128025129_mFyEQ DE0015 2025-11-29T14:24:12.585Z 2025-12-06T15:02:52.624Z
8635365 8635365 20251128020726_dCYGz DE0015 2025-11-29T14:23:08.650Z 2025-12-06T15:02:43.673Z
8635339 8635339 20251128020452_Qks1r DE0015 2025-11-29T14:23:04.228Z 2025-12-06T15:02:43.502Z
8635059 8635059 20251128013822_Y2Hnx DE0015 2025-11-29T14:22:36.668Z 2025-12-06T15:02:40.210Z
8634669 8634669 20251128010848_pgndo DE0015 2025-11-29T14:21:54.284Z 2025-12-06T15:02:28.143Z
8634655 8634655 20251128010746_jJR3J DE0015 2025-11-29T14:21:52.049Z 2025-12-06T15:02:26.896Z
8634490 8634490 20251128005418_nswv6 DE0015 2025-11-29T14:21:24.747Z 2025-12-06T15:02:06.737Z
8634338 8634338 20251128004022_ohbF2 DE0015 2025-11-29T14:21:13.904Z 2025-12-06T15:02:00.672Z
8634044 8634044 20251128001721_6Vs3T DE0015 2025-11-29T14:20:39.741Z 2025-12-06T15:01:50.897Z
8633753 8633753 20251127235213_5PZeG DE0015 2025-11-29T14:20:15.808Z 2025-12-06T15:01:48.369Z
8633645 8633645 20251127234414_mLgHT DE0015 2025-11-29T14:20:01.982Z 2025-12-06T15:01:47.585Z

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