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

>10,000 rows count all where station_code = "BE000L" 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
8744807 8744807 20251211011000_I2SBk BE000L 2025-12-13T15:26:43.162Z 2025-12-14T15:34:14.659Z
8744743 8744743 20251211010610_heth9 BE000L 2025-12-13T15:26:40.335Z 2025-12-14T15:34:03.586Z
8744546 8744546 20251211005239_LxC3Q BE000L 2025-12-13T15:26:16.750Z 2025-12-14T15:33:54.331Z
8744429 8744429 20251211003759_2IEIc BE000L 2025-12-13T15:25:50.610Z 2025-12-14T15:33:48.869Z
8744066 8744066 20251211001309_pybr5 BE000L 2025-12-13T15:25:29.399Z 2025-12-14T15:33:39.835Z
8744009 8744009 20251211000827_fGGD3 BE000L 2025-12-13T15:25:27.607Z 2025-12-14T15:33:38.859Z
8743969 8743969 20251211000214_E3FQo BE000L 2025-12-13T15:25:25.408Z 2025-12-14T15:33:37.656Z
8743869 8743869 20251210235445_yJBje BE000L 2025-12-13T15:25:10.519Z 2025-12-14T15:33:30.508Z
8743832 8743832 20251210235223_jB6Hj BE000L 2025-12-13T15:25:09.127Z 2025-12-14T15:33:27.488Z
8743631 8743631 20251210234041_uto2c BE000L 2025-12-13T15:24:23.443Z 2025-12-14T15:33:11.769Z
8743533 8743533 20251210233506_8b6VQ BE000L 2025-12-13T15:24:17.880Z 2025-12-14T15:33:09.838Z
8743247 8743247 20251210231456_tMaDf BE000L 2025-12-13T15:24:02.274Z 2025-12-14T15:32:42.886Z
8743135 8743135 20251210230824_Jb913 BE000L 2025-12-13T15:23:58.557Z 2025-12-14T15:32:39.197Z
8743085 8743085 20251210230517_3Mkg6 BE000L 2025-12-13T15:23:56.475Z 2025-12-14T15:32:37.229Z
8743014 8743014 20251210230110_8ShZA BE000L 2025-12-13T15:23:37.390Z 2025-12-14T15:32:34.925Z
8742966 8742966 20251210225525_MaULP BE000L 2025-12-13T15:23:27.918Z 2025-12-14T15:32:33.911Z
8742923 8742923 20251210225128_t2q3r BE000L 2025-12-13T15:23:19.479Z 2025-12-14T15:32:32.920Z
8742760 8742760 20251210224159_v3Icd BE000L 2025-12-13T15:23:07.521Z 2025-12-14T15:32:22.602Z
8742714 8742714 20251210223956_hajm6 BE000L 2025-12-13T15:23:05.003Z 2025-12-14T15:32:13.339Z
8742700 8742700 20251210223816_Y7z1v BE000L 2025-12-13T15:23:04.698Z 2025-12-14T15:32:11.688Z
8742697 8742697 20251210223814_EYBIL BE000L 2025-12-13T15:23:04.630Z 2025-12-14T15:32:11.551Z
8742691 8742691 20251210223733_d8b6x BE000L 2025-12-13T15:23:04.226Z 2025-12-14T15:32:09.745Z
8742688 8742688 20251210223731_qhBUE BE000L 2025-12-13T15:23:03.940Z 2025-12-14T15:32:09.263Z
8742626 8742626 20251210223201_U1IDs BE000L 2025-12-13T15:23:00.782Z 2025-12-14T15:32:06.004Z
8742546 8742546 20251210222555_FKCZl BE000L 2025-12-13T15:22:51.471Z 2025-12-14T15:32:00.820Z
8742347 8742347 20251210221501_hIUTb BE000L 2025-12-13T15:22:17.299Z 2025-12-14T15:31:54.916Z
8742263 8742263 20251210221216_rtsZu BE000L 2025-12-13T15:22:14.519Z 2025-12-14T15:31:52.950Z
8742243 8742243 20251210221142_VVSvg BE000L 2025-12-13T15:22:13.952Z 2025-12-14T15:31:52.533Z
8742205 8742205 20251210221029_giEjW BE000L 2025-12-13T15:22:12.062Z 2025-12-14T15:31:51.565Z
8741868 8741868 20251210214457_u5uwR BE000L 2025-12-13T15:21:30.098Z 2025-12-14T15:31:28.958Z
8741681 8741681 20251210213244_ivwMF BE000L 2025-12-13T15:21:17.368Z 2025-12-14T15:30:59.856Z
8741640 8741640 20251210212824_WBXNf BE000L 2025-12-13T15:21:14.435Z 2025-12-14T15:30:57.091Z
8741474 8741474 20251210211757_3Orsg BE000L 2025-12-13T15:20:44.764Z 2025-12-14T15:30:48.856Z
8741461 8741461 20251210211722_35ked BE000L 2025-12-13T15:20:43.479Z 2025-12-14T15:30:48.465Z
8741346 8741346 20251210211036_XQ0eK BE000L 2025-12-13T15:20:36.070Z 2025-12-14T15:30:44.939Z
8741129 8741129 20251210204941_9Zzdq BE000L 2025-12-13T15:20:13.370Z 2025-12-14T15:30:35.519Z
8741112 8741112 20251210204746_e5VD0 BE000L 2025-12-13T15:20:03.389Z 2025-12-14T15:30:34.799Z
8740338 8740338 20251210190705_u6mgC BE000L 2025-12-13T15:18:21.149Z 2025-12-14T15:29:27.003Z
8740304 8740304 20251210190237_OM320 BE000L 2025-12-13T15:18:17.342Z 2025-12-14T15:29:25.479Z
8726130 8726130 20251212040751_72rvX BE000L 2025-12-13T14:02:02.089Z 2025-12-14T15:15:59.303Z
8713448 8713448 20251209035759_1j3hD BE000L 2025-12-10T14:16:25.056Z 2025-12-14T15:55:08.160Z
8713010 8713010 20251209021600_lSCUF BE000L 2025-12-10T14:15:22.238Z 2025-12-14T15:54:54.721Z
8712588 8712588 20251209001608_8F6Wp BE000L 2025-12-10T14:14:24.684Z 2025-12-14T15:54:03.315Z
8690341 8690341 20251204231050_4awbD BE000L 2025-12-06T14:14:03.981Z 2025-12-13T16:03:59.965Z
8687194 8687194 20251204054241_2Nvsg BE000L 2025-12-05T14:14:22.136Z 2025-12-11T14:42:04.603Z
8687191 8687191 20251204054121_9qyTS BE000L 2025-12-05T14:14:21.674Z 2025-12-11T14:42:04.564Z
8687168 8687168 20251204052941_SdaHK BE000L 2025-12-05T14:14:08.793Z 2025-12-11T14:42:03.823Z
8687103 8687103 20251204040101_RDyve BE000L 2025-12-05T14:13:53.889Z 2025-12-11T14:42:01.507Z
8666217 8666217 20251201045345_kppVY BE000L 2025-12-02T14:25:37.045Z 2025-12-09T14:59:39.880Z
8666003 8666003 20251201042239_2sDi9 BE000L 2025-12-02T14:25:05.029Z 2025-12-09T14:59:35.505Z
8665995 8665995 20251201042049_YukWX BE000L 2025-12-02T14:25:04.069Z 2025-12-09T14:59:35.349Z
8665974 8665974 20251201041534_7uhTE BE000L 2025-12-02T14:25:00.520Z 2025-12-09T14:59:34.575Z
8665844 8665844 20251201040240_NsN4z BE000L 2025-12-02T14:24:34.763Z 2025-12-09T14:59:03.157Z
8665839 8665839 20251201040239_3D9tP BE000L 2025-12-02T14:24:34.458Z 2025-12-09T14:59:03.131Z
8665777 8665777 20251201035710_k51QT BE000L 2025-12-02T14:24:28.275Z 2025-12-09T14:59:01.837Z
8665754 8665754 20251201035457_NG8V2 BE000L 2025-12-02T14:24:25.719Z 2025-12-09T14:59:01.389Z
8665657 8665657 20251201034809_O712O BE000L 2025-12-02T14:24:17.069Z 2025-12-09T14:58:59.487Z
8665631 8665631 20251201034450_mFbFf BE000L 2025-12-02T14:24:14.400Z 2025-12-09T14:58:58.860Z
8665604 8665604 20251201034318_t8XIO BE000L 2025-12-02T14:24:02.931Z 2025-12-09T14:58:57.930Z
8665601 8665601 20251201034252_2jVZP BE000L 2025-12-02T14:24:01.515Z 2025-12-09T14:58:56.584Z
8665579 8665579 20251201033748_1PZDZ BE000L 2025-12-02T14:23:56.233Z 2025-12-09T14:58:55.582Z
8665573 8665573 20251201033708_yyUZz BE000L 2025-12-02T14:23:55.906Z 2025-12-09T14:58:55.519Z
8665533 8665533 20251201033252_0N6UU BE000L 2025-12-02T14:23:50.669Z 2025-12-09T14:58:54.729Z
8665475 8665475 20251201032341_MVTpD BE000L 2025-12-02T14:23:45.000Z 2025-12-09T14:58:53.537Z
8665446 8665446 20251201032120_k8MoS BE000L 2025-12-02T14:23:42.604Z 2025-12-09T14:58:53.039Z
8665395 8665395 20251201031528_ZnteE BE000L 2025-12-02T14:23:37.451Z 2025-12-09T14:58:52.073Z
8664777 8664777 20251201013645_5wXjm BE000L 2025-12-02T14:22:03.697Z 2025-12-09T14:58:37.504Z
8664714 8664714 20251201013025_wj6pG BE000L 2025-12-02T14:21:57.545Z 2025-12-09T14:58:36.191Z
8664689 8664689 20251201012522_KoCGR BE000L 2025-12-02T14:21:48.370Z 2025-12-09T14:58:35.320Z
8664676 8664676 20251201012155_op9Z8 BE000L 2025-12-02T14:21:47.043Z 2025-12-09T14:58:33.294Z
8664618 8664618 20251201011244_LyPVA BE000L 2025-12-02T14:21:38.566Z 2025-12-09T14:58:16.784Z
8664594 8664594 20251201010803_l07c4 BE000L 2025-12-02T14:21:35.812Z 2025-12-09T14:58:14.888Z
8664587 8664587 20251201010239_XoY3K BE000L 2025-12-02T14:21:34.832Z 2025-12-09T14:58:14.774Z
8664577 8664577 20251201005932_4lY2y BE000L 2025-12-02T14:21:32.658Z 2025-12-09T14:58:14.333Z
8664566 8664566 20251201005748_SOPKM BE000L 2025-12-02T14:21:22.663Z 2025-12-09T14:58:14.173Z
8664509 8664509 20251201004325_ICtsY BE000L 2025-12-02T14:21:14.117Z 2025-12-09T14:58:12.724Z
8664475 8664475 20251201003919_9B8C3 BE000L 2025-12-02T14:21:10.231Z 2025-12-09T14:58:12.144Z
8664436 8664436 20251201002706_bhFcx BE000L 2025-12-02T14:21:04.523Z 2025-12-09T14:58:11.138Z
8664421 8664421 20251201002505_aNUPT BE000L 2025-12-02T14:21:02.693Z 2025-12-09T14:58:10.804Z
8664374 8664374 20251201001239_S9AdZ BE000L 2025-12-02T14:20:49.108Z 2025-12-09T14:58:07.663Z
8664346 8664346 20251201000603_ZN92a BE000L 2025-12-02T14:20:45.599Z 2025-12-09T14:58:06.531Z
8664328 8664328 20251201000344_G5UER BE000L 2025-12-02T14:20:43.508Z 2025-12-09T14:58:06.234Z
8664271 8664271 20251130235513_9OdPo BE000L 2025-12-02T14:20:37.501Z 2025-12-09T14:58:05.252Z
8664250 8664250 20251130235131_G0yMU BE000L 2025-12-02T14:20:34.697Z 2025-12-09T14:58:04.812Z
8664085 8664085 20251130231456_G3hsV BE000L 2025-12-02T14:20:04.066Z 2025-12-09T14:58:01.233Z
8664066 8664066 20251130231357_LekrV BE000L 2025-12-02T14:20:03.074Z 2025-12-09T14:58:01.073Z
8664043 8664043 20251130230954_2yllk BE000L 2025-12-02T14:20:00.292Z 2025-12-09T14:58:00.660Z
8664033 8664033 20251130230853_p3ixJ BE000L 2025-12-02T14:19:58.968Z 2025-12-09T14:58:00.301Z
8664007 8664007 20251130230108_LYVWt BE000L 2025-12-02T14:19:48.685Z 2025-12-09T14:57:59.665Z
8663943 8663943 20251130224321_Jsn4Z BE000L 2025-12-02T14:19:39.388Z 2025-12-09T14:57:58.267Z
8663920 8663920 20251130223412_xDDcP BE000L 2025-12-02T14:19:35.891Z 2025-12-09T14:57:57.782Z
8663886 8663886 20251130222723_GUhrt BE000L 2025-12-02T14:19:31.682Z 2025-12-09T14:57:57.039Z
8663873 8663873 20251130222159_3wOAA BE000L 2025-12-02T14:19:29.174Z 2025-12-09T14:57:56.729Z
8663860 8663860 20251130222056_c86jz BE000L 2025-12-02T14:19:27.366Z 2025-12-09T14:57:56.539Z
8663829 8663829 20251130221533_1zlAr BE000L 2025-12-02T14:19:22.850Z 2025-12-09T14:57:55.872Z
8663774 8663774 20251130215735_OUGhC BE000L 2025-12-02T14:19:05.278Z 2025-12-09T14:57:54.479Z
8663759 8663759 20251130215033_8PVwM BE000L 2025-12-02T14:19:02.982Z 2025-12-09T14:57:54.178Z
8663754 8663754 20251130214818_GKzQj BE000L 2025-12-02T14:19:02.451Z 2025-12-09T14:57:54.114Z
8663742 8663742 20251130214620_5lTbX BE000L 2025-12-02T14:19:01.516Z 2025-12-09T14:57:53.970Z
8663729 8663729 20251130214228_HL9Z4 BE000L 2025-12-02T14:18:58.765Z 2025-12-09T14:57:53.481Z

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