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,604 rows where station_code = "BE000V" 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
8690746 8690746 20251205014052_2oucF BE000V 2025-12-06T14:15:21.414Z 2025-12-06T14:18:00.951Z
8690729 8690729 20251205013741_PGKaw BE000V 2025-12-06T14:15:17.203Z 2025-12-06T14:18:00.948Z
8690521 8690521 20251205001017_RErt9 BE000V 2025-12-06T14:14:36.600Z 2025-12-06T14:18:00.899Z
8690489 8690489 20251205000012_0IQkf BE000V 2025-12-06T14:14:31.687Z 2025-12-06T14:18:00.892Z
8690483 8690483 20251204235624_wE2FL BE000V 2025-12-06T14:14:30.382Z 2025-12-06T14:18:00.891Z
8687208 8687208 20251204054638_mszI4 BE000V 2025-12-05T14:14:24.098Z 2025-12-06T14:22:38.652Z
8687182 8687182 20251204053630_GXZut BE000V 2025-12-05T14:14:19.889Z 2025-12-06T14:22:36.057Z
8687172 8687172 20251204053023_gnZrt BE000V 2025-12-05T14:14:10.655Z 2025-12-06T14:22:35.108Z
8687158 8687158 20251204052827_wexfP BE000V 2025-12-05T14:14:05.590Z 2025-12-06T14:22:34.421Z
8687156 8687156 20251204052816_69g6x BE000V 2025-12-05T14:14:05.208Z 2025-12-06T14:22:34.300Z
8687148 8687148 20251204052223_oAcmX BE000V 2025-12-05T14:14:03.924Z 2025-12-06T14:22:33.820Z
8687140 8687140 20251204051758_z35xI BE000V 2025-12-05T14:14:02.938Z 2025-12-06T14:22:33.372Z
8666123 8666123 20251201043939_C8RsS BE000V 2025-12-02T14:25:17.081Z 2025-12-06T14:42:12.246Z
8666096 8666096 20251201043547_HQVaT BE000V 2025-12-02T14:25:13.965Z 2025-12-06T14:42:11.568Z
8665998 8665998 20251201042052_cWcJp BE000V 2025-12-02T14:25:04.353Z 2025-12-06T14:42:09.263Z
8665972 8665972 20251201041533_2kQDd BE000V 2025-12-02T14:25:00.263Z 2025-12-06T14:42:08.135Z
8665932 8665932 20251201041145_J12w3 BE000V 2025-12-02T14:24:56.223Z 2025-12-06T14:42:07.219Z
8665925 8665925 20251201041135_7sMrJ BE000V 2025-12-02T14:24:56.038Z 2025-12-06T14:42:07.154Z
8665916 8665916 20251201041111_nAqt9 BE000V 2025-12-02T14:24:55.422Z 2025-12-06T14:42:07.050Z
8665748 8665748 20251201035429_22Zh2 BE000V 2025-12-02T14:24:24.786Z 2025-12-06T14:41:48.173Z
8665742 8665742 20251201035358_wPTuF BE000V 2025-12-02T14:24:24.067Z 2025-12-06T14:41:47.847Z
8665658 8665658 20251201034809_O712O BE000V 2025-12-02T14:24:17.069Z 2025-12-06T14:41:44.976Z
8665634 8665634 20251201034528_z3aTW BE000V 2025-12-02T14:24:14.888Z 2025-12-06T14:41:43.745Z
8665628 8665628 20251201034444_3cYrH BE000V 2025-12-02T14:24:14.121Z 2025-12-06T14:41:43.633Z
8665618 8665618 20251201034355_f3LHb BE000V 2025-12-02T14:24:11.943Z 2025-12-06T14:41:41.991Z
8665561 8665561 20251201033508_bywLX BE000V 2025-12-02T14:23:54.649Z 2025-12-06T14:41:40.641Z
8665518 8665518 20251201033056_li156 BE000V 2025-12-02T14:23:49.035Z 2025-12-06T14:41:39.641Z
8665504 8665504 20251201032932_W2yoW BE000V 2025-12-02T14:23:47.938Z 2025-12-06T14:41:39.116Z
8665479 8665479 20251201032346_2Ffst BE000V 2025-12-02T14:23:45.332Z 2025-12-06T14:41:38.375Z
8665405 8665405 20251201031634_PlSs1 BE000V 2025-12-02T14:23:38.496Z 2025-12-06T14:41:36.954Z
8665370 8665370 20251201031247_QfgkW BE000V 2025-12-02T14:23:35.567Z 2025-12-06T14:41:36.174Z
8665351 8665351 20251201031046_dOL1G BE000V 2025-12-02T14:23:33.599Z 2025-12-06T14:41:35.457Z
8665219 8665219 20251201024838_iXjz7 BE000V 2025-12-02T14:23:09.356Z 2025-12-06T14:41:29.842Z
8665157 8665157 20251201023844_uFHvK BE000V 2025-12-02T14:23:02.331Z 2025-12-06T14:41:28.266Z
8665102 8665102 20251201022848_xmNy6 BE000V 2025-12-02T14:22:55.840Z 2025-12-06T14:41:26.645Z
8664928 8664928 20251201020529_pH2B4 BE000V 2025-12-02T14:22:28.566Z 2025-12-06T14:41:03.347Z
8664797 8664797 20251201014123_xbwG3 BE000V 2025-12-02T14:22:05.927Z 2025-12-06T14:40:57.942Z
8664742 8664742 20251201013341_KyyqR BE000V 2025-12-02T14:22:00.336Z 2025-12-06T14:40:56.158Z
8664646 8664646 20251201011625_A3AgM BE000V 2025-12-02T14:21:42.596Z 2025-12-06T14:40:53.773Z
8664590 8664590 20251201010424_y1iGl BE000V 2025-12-02T14:21:35.177Z 2025-12-06T14:40:52.054Z
8664481 8664481 20251201004011_R5sYk BE000V 2025-12-02T14:21:11.034Z 2025-12-06T14:40:48.130Z
8664458 8664458 20251201003417_Qg2Q2 BE000V 2025-12-02T14:21:07.345Z 2025-12-06T14:40:47.568Z
8664448 8664448 20251201003112_Qd35r BE000V 2025-12-02T14:21:05.948Z 2025-12-06T14:40:47.237Z
8664418 8664418 20251201002322_EfhUv BE000V 2025-12-02T14:21:02.168Z 2025-12-06T14:40:46.309Z
8664408 8664408 20251201001845_FoOuu BE000V 2025-12-02T14:21:01.197Z 2025-12-06T14:40:46.178Z
8664348 8664348 20251201000621_YoMp8 BE000V 2025-12-02T14:20:46.025Z 2025-12-06T14:40:44.927Z
8664251 8664251 20251130235131_G0yMU BE000V 2025-12-02T14:20:34.697Z 2025-12-06T14:40:42.573Z
8664244 8664244 20251130235040_FaNdk BE000V 2025-12-02T14:20:34.099Z 2025-12-06T14:40:42.306Z
8664239 8664239 20251130235028_Qm2Lv BE000V 2025-12-02T14:20:33.625Z 2025-12-06T14:40:42.153Z
8664212 8664212 20251130234421_8KOfs BE000V 2025-12-02T14:20:30.104Z 2025-12-06T14:40:41.575Z
8664193 8664193 20251130233824_jRXQN BE000V 2025-12-02T14:20:18.385Z 2025-12-06T14:40:41.257Z
8664182 8664182 20251130233627_K8IWq BE000V 2025-12-02T14:20:16.410Z 2025-12-06T14:40:40.978Z
8664134 8664134 20251130232113_8Pqd0 BE000V 2025-12-02T14:20:08.114Z 2025-12-06T14:40:37.012Z
8664055 8664055 20251130231234_WRVGr BE000V 2025-12-02T14:20:01.612Z 2025-12-06T14:40:24.906Z
8664050 8664050 20251130231019_3VXwo BE000V 2025-12-02T14:20:00.727Z 2025-12-06T14:40:21.799Z
8664045 8664045 20251130230954_2yllk BE000V 2025-12-02T14:20:00.292Z 2025-12-06T14:40:21.707Z
8664030 8664030 20251130230503_V07Rq BE000V 2025-12-02T14:19:58.046Z 2025-12-06T14:40:20.174Z
8663959 8663959 20251130225017_eq46e BE000V 2025-12-02T14:19:41.584Z 2025-12-06T14:40:17.692Z
8663952 8663952 20251130224920_0PAs1 BE000V 2025-12-02T14:19:40.680Z 2025-12-06T14:40:17.248Z
8663931 8663931 20251130224027_GXGJn BE000V 2025-12-02T14:19:37.279Z 2025-12-06T14:40:16.654Z
8663924 8663924 20251130223815_bynwW BE000V 2025-12-02T14:19:36.558Z 2025-12-06T14:40:16.506Z
8663908 8663908 20251130223129_Gwytc BE000V 2025-12-02T14:19:34.183Z 2025-12-06T14:40:15.976Z
8663866 8663866 20251130222155_t3nRB BE000V 2025-12-02T14:19:28.654Z 2025-12-06T14:40:13.538Z
8663818 8663818 20251130220951_Dd73n BE000V 2025-12-02T14:19:21.792Z 2025-12-06T14:40:12.406Z
8663701 8663701 20251130212644_D0zyf BE000V 2025-12-02T14:18:54.889Z 2025-12-06T14:40:08.026Z
8663576 8663576 20251130210559_o1Gb4 BE000V 2025-12-02T14:18:31.221Z 2025-12-06T14:40:04.186Z
8663436 8663436 20251130204706_jxMIz BE000V 2025-12-02T14:18:17.610Z 2025-12-06T14:40:00.630Z
8663433 8663433 20251130204516_cKW7T BE000V 2025-12-02T14:18:17.122Z 2025-12-06T14:40:00.517Z
8663277 8663277 20251130202605_32kFz BE000V 2025-12-02T14:17:55.402Z 2025-12-06T14:39:57.363Z
8663235 8663235 20251130202403_1Di2K BE000V 2025-12-02T14:17:52.609Z 2025-12-06T14:39:56.704Z
8663176 8663176 20251130201811_iWZRj BE000V 2025-12-02T14:17:34.998Z 2025-12-06T14:39:55.123Z
8662376 8662376 20251130184100_N3hM4 BE000V 2025-12-02T14:15:17.649Z 2025-12-06T14:39:14.161Z
8645577 8645577 20251128225918_cgK3P BE000V 2025-11-30T14:24:13.503Z 2025-12-06T14:55:00.426Z
8645545 8645545 20251128224341_kKPRd BE000V 2025-11-30T14:23:57.133Z 2025-12-06T14:54:59.919Z
8645415 8645415 20251128220157_H3DUw BE000V 2025-11-30T14:23:41.596Z 2025-12-06T14:54:56.923Z
8623900 8623900 20251127022331_NdImQ BE000V 2025-11-28T14:23:04.571Z 2025-12-05T15:04:25.640Z
8623898 8623898 20251127022306_r1flb BE000V 2025-11-28T14:23:04.176Z 2025-12-05T15:04:25.593Z
8623894 8623894 20251127022249_c7GVn BE000V 2025-11-28T14:23:03.955Z 2025-12-05T15:04:25.486Z
8623822 8623822 20251127021303_3uyRh BE000V 2025-11-28T14:22:57.216Z 2025-12-05T15:04:18.462Z
8623771 8623771 20251127015829_dVmuo BE000V 2025-11-28T14:22:51.005Z 2025-12-05T15:04:15.578Z
8623769 8623769 20251127015813_50oLE BE000V 2025-11-28T14:22:50.627Z 2025-12-05T15:04:15.537Z
8623708 8623708 20251127014904_3RuJk BE000V 2025-11-28T14:22:27.387Z 2025-12-05T15:04:10.531Z
8623695 8623695 20251127014607_dOh9l BE000V 2025-11-28T14:22:26.230Z 2025-12-05T15:04:09.839Z
8623675 8623675 20251127014200_FsmKf BE000V 2025-11-28T14:22:23.679Z 2025-12-05T15:04:07.757Z
8623662 8623662 20251127014039_zo99g BE000V 2025-11-28T14:22:21.423Z 2025-12-05T15:04:06.736Z
8623661 8623661 20251127013839_7cq2r BE000V 2025-11-28T14:22:21.096Z 2025-12-05T15:04:06.696Z
8623649 8623649 20251127013645_fBZUy BE000V 2025-11-28T14:22:19.787Z 2025-12-05T15:04:06.016Z
8623144 8623144 20251126230426_GesOY BE000V 2025-11-28T14:20:57.323Z 2025-12-05T15:03:32.542Z
8622679 8622679 20251126204143_8X7Zn BE000V 2025-11-28T14:19:40.878Z 2025-12-05T15:03:04.894Z
8622571 8622571 20251126200059_HMyY0 BE000V 2025-11-28T14:19:24.354Z 2025-12-05T15:03:03.643Z
8622341 8622341 20251126185107_bFClJ BE000V 2025-11-28T14:18:27.744Z 2025-12-05T15:02:55.499Z
8622305 8622305 20251126183929_GE1Zz BE000V 2025-11-28T14:18:21.421Z 2025-12-05T15:02:55.212Z
8622263 8622263 20251126182926_j4j3b BE000V 2025-11-28T14:18:16.257Z 2025-12-05T15:02:54.564Z
8622196 8622196 20251126181133_gK6Yy BE000V 2025-11-28T14:18:06.844Z 2025-12-05T15:02:53.454Z
8622173 8622173 20251126180653_3j3Xk BE000V 2025-11-28T14:18:01.909Z 2025-12-05T15:02:53.143Z
8581510 8581510 20251123002548_o4wTY BE000V 2025-11-24T14:31:42.228Z 2025-12-01T15:20:48.164Z
8581456 8581456 20251122235902_2UhTY BE000V 2025-11-24T14:31:35.903Z 2025-12-01T15:20:32.179Z
8581298 8581298 20251122225816_OrVt3 BE000V 2025-11-24T14:31:24.327Z 2025-12-01T15:20:11.708Z
8579507 8579507 20251123000041_1JCrO BE000V 2025-11-24T14:14:29.606Z 2025-12-01T15:20:34.624Z
8579090 8579090 20251122222155_xZYIL BE000V 2025-11-24T14:13:29.980Z 2025-12-01T15:20:02.835Z

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