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

5,609 rows where station_code = "DE000Q" 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
8666287 8666287 20251201050855_jM1Z2 DE000Q 2025-12-02T14:25:43.189Z 2025-12-05T14:36:53.261Z
8666244 8666244 20251201050038_Qb0BD DE000Q 2025-12-02T14:25:39.413Z 2025-12-05T14:36:50.814Z
8666232 8666232 20251201045507_NNFC0 DE000Q 2025-12-02T14:25:38.462Z 2025-12-05T14:36:45.891Z
8666207 8666207 20251201045246_st2Rc DE000Q 2025-12-02T14:25:36.301Z 2025-12-05T14:36:36.073Z
8665548 8665548 20251201033424_CVyHM DE000Q 2025-12-02T14:23:53.048Z 2025-12-05T14:36:11.428Z
8665542 8665542 20251201033406_3sI3O DE000Q 2025-12-02T14:23:51.757Z 2025-12-05T14:36:11.216Z
8665343 8665343 20251201030910_S2ENd DE000Q 2025-12-02T14:23:32.986Z 2025-12-05T14:35:52.884Z
8624258 8624258 20251127034934_n52d6 DE000Q 2025-11-28T14:24:22.210Z 2025-12-05T15:04:56.780Z
8624144 8624144 20251127031915_LiADI DE000Q 2025-11-28T14:23:52.297Z 2025-12-05T15:04:48.291Z
8624132 8624132 20251127031507_MPz7y DE000Q 2025-11-28T14:23:50.859Z 2025-12-05T15:04:46.455Z
8623965 8623965 20251127023424_fgMIi DE000Q 2025-11-28T14:23:12.715Z 2025-12-05T15:04:31.138Z
8623906 8623906 20251127022353_a1MT5 DE000Q 2025-11-28T14:23:05.276Z 2025-12-05T15:04:25.790Z
8623891 8623891 20251127022239_JOayL DE000Q 2025-11-28T14:23:03.578Z 2025-12-05T15:04:24.315Z
8623777 8623777 20251127015949_FQR2B DE000Q 2025-11-28T14:22:51.664Z 2025-12-05T15:04:15.748Z
8623727 8623727 20251127015055_HwYgF DE000Q 2025-11-28T14:22:32.356Z 2025-12-05T15:04:12.038Z
8623464 8623464 20251127004616_26dum DE000Q 2025-11-28T14:21:47.298Z 2025-12-05T15:03:54.780Z
8623421 8623421 20251127002745_2qvfQ DE000Q 2025-11-28T14:21:42.219Z 2025-12-05T15:03:49.885Z
8623316 8623316 20251126235518_zgDxm DE000Q 2025-11-28T14:21:30.114Z 2025-12-05T15:03:42.168Z
8623085 8623085 20251126224759_oeqae DE000Q 2025-11-28T14:20:51.153Z 2025-12-05T15:03:28.204Z
8622898 8622898 20251126220214_iMHvE DE000Q 2025-11-28T14:20:16.874Z 2025-12-05T15:03:19.158Z
8622837 8622837 20251126214444_Ci0gT DE000Q 2025-11-28T14:20:09.607Z 2025-12-05T15:03:16.032Z
8611437 8611437 20251126014252_8W0H5 DE000Q 2025-11-27T14:22:08.704Z 2025-12-04T15:09:18.648Z
8611413 8611413 20251126014153_zhQMk DE000Q 2025-11-27T14:22:06.860Z 2025-12-04T15:09:12.129Z
8581983 8581983 20251123032951_INRZa DE000Q 2025-11-24T14:32:57.017Z 2025-12-01T15:22:09.175Z
8581887 8581887 20251123025618_NX8yS DE000Q 2025-11-24T14:32:43.820Z 2025-12-01T15:21:55.202Z
8581829 8581829 20251123024338_AW2J6 DE000Q 2025-11-24T14:32:40.673Z 2025-12-01T15:21:44.529Z
8581787 8581787 20251123022255_3jyjz DE000Q 2025-11-24T14:32:38.094Z 2025-12-01T15:21:36.867Z
8581711 8581711 20251123015140_MNmJZ DE000Q 2025-11-24T14:32:33.716Z 2025-12-01T15:21:19.543Z
8581689 8581689 20251123014137_eonJ2 DE000Q 2025-11-24T14:32:32.180Z 2025-12-01T15:21:14.992Z
8581661 8581661 20251123013413_nEwA1 DE000Q 2025-11-24T14:32:30.583Z 2025-12-01T15:21:11.851Z
8581625 8581625 20251123012112_O2Ctc DE000Q 2025-11-24T14:32:14.021Z 2025-12-01T15:21:10.325Z
8581561 8581561 20251123005432_vmbRX DE000Q 2025-11-24T14:31:54.530Z 2025-12-01T15:20:57.892Z
8581419 8581419 20251122234915_UsCLl DE000Q 2025-11-24T14:31:33.662Z 2025-12-01T15:20:26.859Z
8581391 8581391 20251122234025_utMqq DE000Q 2025-11-24T14:31:31.229Z 2025-12-01T15:20:19.002Z
8581350 8581350 20251122231457_2xm3Y DE000Q 2025-11-24T14:31:27.850Z 2025-12-01T15:20:14.505Z
8581334 8581334 20251122231055_lH1r3 DE000Q 2025-11-24T14:31:27.113Z 2025-12-01T15:20:14.095Z
8579790 8579790 20251123011654_AORSs DE000Q 2025-11-24T14:15:09.975Z 2025-12-01T15:21:08.250Z
8579753 8579753 20251123010611_S9CPW DE000Q 2025-11-24T14:15:05.596Z 2025-12-01T15:21:00.359Z
8579348 8579348 20251122231539_jYJiR DE000Q 2025-11-24T14:14:02.506Z 2025-12-01T15:20:14.638Z
8578800 8578800 20251122212808_v2A66 DE000Q 2025-11-24T14:12:42.764Z 2025-12-01T15:19:53.110Z
8578751 8578751 20251122212331_kKPxl DE000Q 2025-11-24T14:12:37.738Z 2025-12-01T15:19:51.565Z
8578679 8578679 20251122211324_0elWP DE000Q 2025-11-24T14:12:19.174Z 2025-12-01T15:19:49.685Z
8578622 8578622 20251122210345_oaJa4 DE000Q 2025-11-24T14:12:13.756Z 2025-12-01T15:19:49.072Z
8578617 8578617 20251122210345_N2iWs DE000Q 2025-11-24T14:12:13.507Z 2025-12-01T15:19:49.002Z
8578442 8578442 20251122203721_SwL2P DE000Q 2025-11-24T14:11:45.224Z 2025-12-01T15:19:37.925Z
8577473 8577473 20251122181459_89X99 DE000Q 2025-11-24T14:08:44.469Z 2025-12-01T15:18:51.392Z
8577387 8577387 20251122180147_6Ve0X DE000Q 2025-11-24T14:08:30.420Z 2025-12-01T15:18:48.673Z
8573576 8573576 20251122033547_gX20y DE000Q 2025-11-23T14:41:19.456Z 2025-11-30T15:06:31.747Z
8573545 8573545 20251122033015_fhpO6 DE000Q 2025-11-23T14:41:16.492Z 2025-11-30T15:06:30.590Z
8572895 8572895 20251122015524_piuVe DE000Q 2025-11-23T14:40:01.511Z 2025-11-30T15:06:05.584Z
8572292 8572292 20251122002004_Wm214 DE000Q 2025-11-23T14:38:39.133Z 2025-11-30T15:05:43.106Z
8572219 8572219 20251122000457_FVGJV DE000Q 2025-11-23T14:38:07.276Z 2025-11-30T15:05:41.696Z
8572153 8572153 20251121235032_wNDZt DE000Q 2025-11-23T14:38:03.432Z 2025-11-30T15:05:40.288Z
8572084 8572084 20251121233343_A2ANb DE000Q 2025-11-23T14:37:58.170Z 2025-11-30T15:05:37.065Z
8571904 8571904 20251121224650_poMe9 DE000Q 2025-11-23T14:37:49.695Z 2025-11-30T15:05:25.508Z
8571848 8571848 20251121222818_o6Fgg DE000Q 2025-11-23T14:37:46.440Z 2025-11-30T15:05:20.304Z
8571833 8571833 20251121221708_PSACQ DE000Q 2025-11-23T14:37:45.721Z 2025-11-30T15:05:19.812Z
8571795 8571795 20251121220912_WPpSy DE000Q 2025-11-23T14:37:44.203Z 2025-11-30T15:05:19.057Z
8571695 8571695 20251121215103_pmJcP DE000Q 2025-11-23T14:37:40.289Z 2025-11-30T15:05:14.524Z
8571580 8571580 20251121212401_iIx8a DE000Q 2025-11-23T14:37:03.021Z 2025-11-30T15:05:10.504Z
8571522 8571522 20251121210823_CQ3Dz DE000Q 2025-11-23T14:36:46.380Z 2025-11-30T15:05:08.170Z
8571442 8571442 20251121204838_NW2tU DE000Q 2025-11-23T14:36:28.532Z 2025-11-30T15:05:06.048Z
8571355 8571355 20251121202154_vzwvn DE000Q 2025-11-23T14:36:12.763Z 2025-11-30T15:04:55.241Z
8571322 8571322 20251121201511_U33mM DE000Q 2025-11-23T14:36:10.371Z 2025-11-30T15:04:53.774Z
8571263 8571263 20251121200046_ks3P6 DE000Q 2025-11-23T14:36:07.319Z 2025-11-30T15:04:44.541Z
8570814 8570814 20251121171541_aG6fH DE000Q 2025-11-23T14:34:44.405Z 2025-11-30T15:03:43.874Z
8569389 8569389 20251121055527_lUNL9 DE000Q 2025-11-23T14:32:13.607Z 2025-11-29T14:54:48.248Z
8550139 8550139 20251120232500_Gh97t DE000Q 2025-11-22T14:20:20.559Z 2025-11-29T14:54:26.332Z
8550060 8550060 20251120231639_K2f38 DE000Q 2025-11-22T14:20:12.241Z 2025-11-29T14:54:26.177Z
8550006 8550006 20251120230901_t2DE3 DE000Q 2025-11-22T14:19:55.861Z 2025-11-29T14:54:25.959Z
8549920 8549920 20251120230306_IPD4j DE000Q 2025-11-22T14:19:45.808Z 2025-11-29T14:54:25.852Z
8549682 8549682 20251120224927_cjVXT DE000Q 2025-11-22T14:19:17.603Z 2025-11-29T14:54:25.290Z
8549624 8549624 20251120224404_cHq3m DE000Q 2025-11-22T14:19:11.797Z 2025-11-29T14:54:25.170Z
8549552 8549552 20251120223840_LTA8q DE000Q 2025-11-22T14:19:06.262Z 2025-11-29T14:54:24.997Z
8545617 8545617 20251120171527_IF8v2 DE000Q 2025-11-22T14:10:56.269Z 2025-11-29T14:54:05.069Z
8508137 8508137 20251118003200_0SGRd DE000Q 2025-11-19T14:16:51.267Z 2025-11-26T15:07:49.396Z
8507991 8507991 20251118001641_0rpGe DE000Q 2025-11-19T14:16:37.070Z 2025-11-26T15:07:48.811Z
8507795 8507795 20251117235812_BK1SD DE000Q 2025-11-19T14:16:06.529Z 2025-11-26T15:07:47.872Z
8507541 8507541 20251117233305_IjyR3 DE000Q 2025-11-19T14:15:27.793Z 2025-11-26T15:07:46.881Z
8507279 8507279 20251117230423_mVUB5 DE000Q 2025-11-19T14:14:52.345Z 2025-11-26T15:07:45.593Z
8506726 8506726 20251117220633_dAVXd DE000Q 2025-11-19T14:13:34.168Z 2025-11-26T15:07:43.032Z
8506402 8506402 20251117212809_rHdlf DE000Q 2025-11-19T14:12:46.921Z 2025-11-26T15:07:41.708Z
8506325 8506325 20251117212150_OdD9X DE000Q 2025-11-19T14:12:38.220Z 2025-11-26T15:07:41.429Z
8506314 8506314 20251117212039_W97vS DE000Q 2025-11-19T14:12:36.752Z 2025-11-26T15:07:41.395Z
8506305 8506305 20251117212035_XkaXn DE000Q 2025-11-19T14:12:36.466Z 2025-11-26T15:07:41.391Z
8506048 8506048 20251117210137_f3PdA DE000Q 2025-11-19T14:11:59.246Z 2025-11-26T15:07:40.598Z
8505927 8505927 20251117205340_t7Dsz DE000Q 2025-11-19T14:11:35.604Z 2025-11-26T15:07:40.173Z
8505277 8505277 20251117200154_Etvos DE000Q 2025-11-19T14:09:55.320Z 2025-11-26T15:07:37.877Z
8505086 8505086 20251117194605_wutgl DE000Q 2025-11-19T14:09:29.668Z 2025-11-26T15:07:36.873Z
8505074 8505074 20251117194503_Ew932 DE000Q 2025-11-19T14:09:29.036Z 2025-11-26T15:07:36.810Z
8505055 8505055 20251117194207_tG7CU DE000Q 2025-11-19T14:09:26.388Z 2025-11-26T15:07:36.757Z
8504691 8504691 20251117191608_h2O7j DE000Q 2025-11-19T14:08:30.365Z 2025-11-26T15:07:30.131Z
8504300 8504300 20251117184645_xo2ZF DE000Q 2025-11-19T14:07:42.888Z 2025-11-26T15:07:15.945Z
8504275 8504275 20251117184431_jRlQC DE000Q 2025-11-19T14:07:40.275Z 2025-11-26T15:07:15.820Z
8503525 8503525 20251117173420_CPJHQ DE000Q 2025-11-19T14:05:38.202Z 2025-11-26T15:06:34.420Z
8503456 8503456 20251117172632_WEeRN DE000Q 2025-11-19T14:05:30.527Z 2025-11-26T15:06:28.638Z
8494382 8494382 20251117024206_12gqH DE000Q 2025-11-18T14:24:09.141Z 2025-11-25T15:09:35.732Z
8494322 8494322 20251117023950_xAwSS DE000Q 2025-11-18T14:24:05.276Z 2025-11-25T15:09:34.947Z
8494261 8494261 20251117023635_OL4at DE000Q 2025-11-18T14:24:00.208Z 2025-11-25T15:09:33.839Z
8493395 8493395 20251117014045_I70PW DE000Q 2025-11-18T14:22:07.573Z 2025-11-25T15:09:12.528Z

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