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,681 rows where station_code = "DE0014" 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
9217553 9217553 20260116174344_1vjNB DE0014 2026-01-18T14:07:51.904Z 2026-01-25T14:57:25.749Z
9214089 9214089 20260116053307_icHNC DE0014 2026-01-17T14:20:00.201Z 2026-01-24T15:13:05.029Z
9213915 9213915 20260116045834_uAFYS DE0014 2026-01-17T14:19:08.558Z 2026-01-24T15:12:51.222Z
9212769 9212769 20260116005533_R3ip3 DE0014 2026-01-17T14:13:45.500Z 2026-01-24T15:11:25.779Z
9212554 9212554 20260115231022_8Dgey DE0014 2026-01-17T14:12:40.794Z 2026-01-24T15:11:02.784Z
9212507 9212507 20260115222349_1fgoT DE0014 2026-01-17T14:12:19.249Z 2026-01-24T15:10:59.026Z
9212505 9212505 20260115222347_YaVva DE0014 2026-01-17T14:12:18.602Z 2026-01-24T15:10:58.865Z
9212126 9212126 20260115191943_rjyGK DE0014 2026-01-17T14:10:05.131Z 2026-01-24T15:10:25.076Z
9211803 9211803 20260115175341_fX1fJ DE0014 2026-01-17T14:08:34.362Z 2026-01-24T15:09:56.294Z
9207233 9207233 20260115000419_vybvm DE0014 2026-01-16T14:07:50.011Z 2026-01-22T15:03:15.419Z
9201736 9201736 20260114024654_4btMk DE0014 2026-01-15T14:19:36.229Z 2026-01-22T15:09:08.552Z
9201408 9201408 20260114021513_1zZhl DE0014 2026-01-15T14:18:34.764Z 2026-01-22T15:09:03.166Z
9023791 9023791 20251220221501_b2ICW DE0014 2025-12-27T15:09:42.962Z 2025-12-29T15:26:22.780Z
9023679 9023679 20251220211659_AAgJP DE0014 2025-12-27T15:09:23.828Z 2025-12-29T15:26:21.681Z
9023582 9023582 20251220205034_Otmyv DE0014 2025-12-27T15:09:14.188Z 2025-12-29T15:26:20.968Z
9023551 9023551 20251220203748_nE2PI DE0014 2025-12-27T15:09:09.669Z 2025-12-29T15:26:20.676Z
9023262 9023262 20251220193908_MvNRI DE0014 2025-12-27T15:08:50.329Z 2025-12-27T15:08:50.329Z
9022806 9022806 20251220184226_vBPcQ DE0014 2025-12-27T15:08:39.386Z 2025-12-29T15:26:13.986Z
9017069 9017069 20251220045123_8y3lm DE0014 2025-12-27T15:01:07.067Z 2025-12-29T15:23:28.358Z
8982667 8982667 20251219201409_h0Mz3 DE0014 2025-12-26T14:27:31.850Z 2025-12-28T15:22:14.086Z
8756387 8756387 20251210042334_gFMZI DE0014 2025-12-13T15:45:08.977Z 2025-12-17T15:29:31.201Z
8756381 8756381 20251210042319_AxzbI DE0014 2025-12-13T15:45:08.836Z 2025-12-17T15:29:31.149Z
8756304 8756304 20251210041318_C5M74 DE0014 2025-12-13T15:45:06.634Z 2025-12-17T15:29:30.010Z
8756159 8756159 20251210040342_Z3LCy DE0014 2025-12-13T15:45:02.588Z 2025-12-17T15:29:28.481Z
8756132 8756132 20251210040216_06HoW DE0014 2025-12-13T15:45:02.194Z 2025-12-17T15:29:28.246Z
8756044 8756044 20251210035556_TkdPI DE0014 2025-12-13T15:44:59.142Z 2025-12-17T15:29:27.221Z
8756022 8756022 20251210035513_JzeHf DE0014 2025-12-13T15:44:58.475Z 2025-12-17T15:29:26.974Z
8755856 8755856 20251210034456_hiFFB DE0014 2025-12-13T15:44:33.823Z 2025-12-17T15:29:25.274Z
8742088 8742088 20251210220217_WFJNV DE0014 2025-12-13T15:22:05.415Z 2025-12-19T15:13:07.675Z
8740941 8740941 20251210202829_1Xry2 DE0014 2025-12-13T15:19:49.038Z 2025-12-19T15:11:58.332Z
8740911 8740911 20251210202535_4jYh3 DE0014 2025-12-13T15:19:46.821Z 2025-12-19T15:11:57.334Z
8740684 8740684 20251210195203_NR68y DE0014 2025-12-13T15:19:09.201Z 2025-12-19T15:11:50.175Z
8740368 8740368 20251210190837_CZcva DE0014 2025-12-13T15:18:30.926Z 2025-12-19T15:11:22.426Z
8740314 8740314 20251210190356_vt6hI DE0014 2025-12-13T15:18:18.053Z 2025-12-19T15:11:20.169Z
8714399 8714399 20251210051236_lHN2G DE0014 2025-12-11T14:02:28.366Z 2025-12-19T15:05:32.301Z
8714311 8714311 20251210050621_T5dlq DE0014 2025-12-11T14:02:16.349Z 2025-12-19T15:05:30.347Z
8713881 8713881 20251210043245_v5t2S DE0014 2025-12-11T14:00:34.981Z 2025-12-19T15:05:18.273Z
8713827 8713827 20251210042837_3UyEh DE0014 2025-12-11T14:00:16.791Z 2025-12-19T15:05:14.306Z
8656105 8656105 20251130043725_3Fgyx DE0014 2025-12-01T14:28:03.618Z 2025-12-08T14:56:07.828Z
8655574 8655574 20251130040801_mLycB DE0014 2025-12-01T14:27:10.562Z 2025-12-08T14:56:00.681Z
8654139 8654139 20251130030101_g7Rza DE0014 2025-12-01T14:24:54.589Z 2025-12-08T14:55:08.121Z
8654096 8654096 20251130025759_UX8dU DE0014 2025-12-01T14:24:51.096Z 2025-12-08T14:55:07.560Z
8653812 8653812 20251130024214_om6n5 DE0014 2025-12-01T14:24:17.958Z 2025-12-08T14:55:02.220Z
8653294 8653294 20251130020817_1I5fy DE0014 2025-12-01T14:23:11.577Z 2025-12-08T14:54:54.241Z
8652419 8652419 20251130010730_tgcDw DE0014 2025-12-01T14:21:22.109Z 2025-12-08T14:54:18.799Z
8652156 8652156 20251130005055_aFk1S DE0014 2025-12-01T14:20:49.564Z 2025-12-08T14:54:14.715Z
8652117 8652117 20251130004903_OKRkf DE0014 2025-12-01T14:20:45.580Z 2025-12-08T14:54:14.191Z
8651876 8651876 20251130003022_3ZW9w DE0014 2025-12-01T14:20:10.594Z 2025-12-08T14:54:04.030Z
8651478 8651478 20251129234557_CW5c3 DE0014 2025-12-01T14:19:10.616Z 2025-12-08T14:53:46.062Z
8456190 8456190 20251113181356_6dTYL DE0014 2025-11-15T14:10:40.241Z 2025-11-22T15:20:41.154Z
8449606 8449606 20251113022955_FM5i3 DE0014 2025-11-14T14:20:58.539Z 2025-11-21T15:12:10.269Z
8439473 8439473 20251112035427_uC3Ye DE0014 2025-11-13T14:26:36.985Z 2025-11-20T15:25:25.207Z
8439370 8439370 20251112034343_3UMcP DE0014 2025-11-13T14:26:17.750Z 2025-11-20T15:25:18.025Z
8439321 8439321 20251112033753_t8nRO DE0014 2025-11-13T14:26:08.006Z 2025-11-20T15:25:16.844Z
8438963 8438963 20251112025753_wPYdS DE0014 2025-11-13T14:25:14.595Z 2025-11-20T15:24:54.959Z
8438673 8438673 20251112022601_g3BJN DE0014 2025-11-13T14:24:28.892Z 2025-11-20T15:24:45.150Z
8438443 8438443 20251112015939_4ilTI DE0014 2025-11-13T14:23:47.714Z 2025-11-20T15:24:35.224Z
8438112 8438112 20251112012505_FPnxO DE0014 2025-11-13T14:22:53.831Z 2025-11-20T15:24:14.796Z
8437962 8437962 20251112010333_MJago DE0014 2025-11-13T14:22:22.487Z 2025-11-20T15:24:02.205Z
8437942 8437942 20251112010031_9Lje1 DE0014 2025-11-13T14:22:20.479Z 2025-11-20T15:24:01.505Z
8437780 8437780 20251112004433_V6cO3 DE0014 2025-11-13T14:22:05.311Z 2025-11-20T15:23:53.592Z
8437471 8437471 20251112000828_0jOBz DE0014 2025-11-13T14:21:09.542Z 2025-11-20T15:23:37.016Z
8437412 8437412 20251112000121_wFwkg DE0014 2025-11-13T14:21:03.000Z 2025-11-20T15:23:30.046Z
8437271 8437271 20251111234707_w7H5w DE0014 2025-11-13T14:20:34.172Z 2025-11-20T15:23:24.960Z
8437227 8437227 20251111234302_ZpbdB DE0014 2025-11-13T14:20:27.835Z 2025-11-20T15:23:20.932Z
8437218 8437218 20251111234058_KqtVs DE0014 2025-11-13T14:20:26.996Z 2025-11-20T15:23:20.576Z
8437071 8437071 20251111231357_Alx4y DE0014 2025-11-13T14:19:59.037Z 2025-11-20T15:23:13.445Z
8436951 8436951 20251111225554_ESzwL DE0014 2025-11-13T14:19:43.953Z 2025-11-20T15:23:05.612Z
8436674 8436674 20251111221916_926Uu DE0014 2025-11-13T14:18:52.170Z 2025-11-20T15:22:58.566Z
8436651 8436651 20251111221534_EgzWq DE0014 2025-11-13T14:18:49.641Z 2025-11-20T15:22:58.215Z
8436645 8436645 20251111221309_8R3xx DE0014 2025-11-13T14:18:48.979Z 2025-11-20T15:22:58.061Z
8436607 8436607 20251111220631_W1y3W DE0014 2025-11-13T14:18:44.909Z 2025-11-20T15:22:57.183Z
8436373 8436373 20251111212810_VxZDA DE0014 2025-11-13T14:18:06.086Z 2025-11-20T15:22:49.453Z
8434004 8434004 20251111174402_HSq1D DE0014 2025-11-13T14:11:42.653Z 2025-11-20T15:21:17.873Z
8433915 8433915 20251111173233_ecUiY DE0014 2025-11-13T14:11:31.444Z 2025-11-20T15:21:12.982Z
8425973 8425973 20251111022419_lrh1N DE0014 2025-11-12T14:24:13.824Z 2025-11-19T15:16:54.644Z
8425916 8425916 20251111022037_Pp1i2 DE0014 2025-11-12T14:23:52.093Z 2025-11-19T15:16:53.729Z
8422715 8422715 20251110222442_yup1t DE0014 2025-11-12T14:16:57.837Z 2025-11-19T15:15:31.061Z
8420827 8420827 20251110193922_06Rzx DE0014 2025-11-12T14:12:13.955Z 2025-11-19T15:14:16.193Z
8420572 8420572 20251110192040_lgBEe DE0014 2025-11-12T14:11:14.348Z 2025-11-19T15:14:11.370Z
8385354 8385354 20251105231610_tda5l DE0014 2025-11-07T14:06:26.433Z 2025-11-14T15:08:07.993Z
8385187 8385187 20251105221443_e5q8R DE0014 2025-11-07T14:05:47.417Z 2025-11-14T15:08:04.668Z
8385171 8385171 20251105220728_PAruy DE0014 2025-11-07T14:05:40.593Z 2025-11-14T15:08:04.428Z
8384797 8384797 20251105175518_B1ftY DE0014 2025-11-07T14:03:40.661Z 2025-11-14T15:07:44.307Z
8380956 8380956 20251105034153_bVjM1 DE0014 2025-11-06T14:13:31.799Z 2025-11-13T15:15:13.879Z
8379345 8379345 20251104214526_V5eWo DE0014 2025-11-06T14:07:28.052Z 2025-11-13T15:14:09.756Z
8378578 8378578 20251104174547_cIptx DE0014 2025-11-06T14:04:25.271Z 2025-11-13T15:13:30.589Z
8374544 8374544 20251103040354_C37i0 DE0014 2025-11-05T14:32:22.451Z 2025-11-11T15:07:42.892Z
8371489 8371489 20251104042558_rOd1M DE0014 2025-11-05T14:15:11.371Z 2025-11-12T15:11:02.218Z
8371454 8371454 20251104042310_0KmRQ DE0014 2025-11-05T14:15:00.283Z 2025-11-12T15:11:01.770Z
8371388 8371388 20251104041720_B9hg2 DE0014 2025-11-05T14:14:46.925Z 2025-11-12T15:11:00.828Z
8371337 8371337 20251104041236_VW56B DE0014 2025-11-05T14:14:37.535Z 2025-11-12T15:11:00.051Z
8371322 8371322 20251104041017_tuiDa DE0014 2025-11-05T14:14:34.516Z 2025-11-12T15:10:59.891Z
8371230 8371230 20251104040203_XW8hS DE0014 2025-11-05T14:14:09.009Z 2025-11-12T15:10:58.420Z
8371066 8371066 20251104033731_srJvG DE0014 2025-11-05T14:13:34.156Z 2025-11-12T15:10:55.671Z
8370992 8370992 20251104032730_mkxri DE0014 2025-11-05T14:13:14.643Z 2025-11-12T15:10:54.304Z
8370901 8370901 20251104031601_Fmi2K DE0014 2025-11-05T14:12:57.322Z 2025-11-12T15:10:53.103Z
8370881 8370881 20251104031512_mPCmt DE0014 2025-11-05T14:12:54.820Z 2025-11-12T15:10:52.840Z
8370842 8370842 20251104030910_qcKre DE0014 2025-11-05T14:12:40.807Z 2025-11-12T15:10:52.085Z
8369846 8369846 20251103230849_v5xnS DE0014 2025-11-05T14:08:38.876Z 2025-11-12T15:09:49.546Z

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