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

3,999 rows where station_code = "BE000U" 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
8687150 8687150 20251204052310_5OgDc BE000U 2025-12-05T14:14:04.324Z 2025-12-06T14:22:34.017Z
8666151 8666151 20251201044315_KJMMR BE000U 2025-12-02T14:25:30.657Z 2025-12-06T14:42:13.536Z
8666147 8666147 20251201044233_9Rhwc BE000U 2025-12-02T14:25:26.515Z 2025-12-06T14:42:13.408Z
8666050 8666050 20251201042740_rDAV2 BE000U 2025-12-02T14:25:09.028Z 2025-12-06T14:42:10.519Z
8666045 8666045 20251201042704_KG6f9 BE000U 2025-12-02T14:25:08.334Z 2025-12-06T14:42:10.377Z
8665940 8665940 20251201041157_xcoiA BE000U 2025-12-02T14:24:56.758Z 2025-12-06T14:42:07.334Z
8665897 8665897 20251201040751_Mg1zb BE000U 2025-12-02T14:24:51.853Z 2025-12-06T14:42:06.364Z
8665794 8665794 20251201035833_8CBcE BE000U 2025-12-02T14:24:29.841Z 2025-12-06T14:42:03.657Z
8665764 8665764 20251201035620_3nDdx BE000U 2025-12-02T14:24:26.769Z 2025-12-06T14:42:01.970Z
8665759 8665759 20251201035511_b32A4 BE000U 2025-12-02T14:24:26.256Z 2025-12-06T14:41:56.737Z
8665737 8665737 20251201035232_1Rk0D BE000U 2025-12-02T14:24:23.378Z 2025-12-06T14:41:47.650Z
8665707 8665707 20251201035139_pINsb BE000U 2025-12-02T14:24:21.231Z 2025-12-06T14:41:46.665Z
8665699 8665699 20251201035108_fNAWU BE000U 2025-12-02T14:24:20.757Z 2025-12-06T14:41:46.573Z
8665592 8665592 20251201034025_N3Ute BE000U 2025-12-02T14:23:57.763Z 2025-12-06T14:41:41.232Z
8665484 8665484 20251201032437_buyMJ BE000U 2025-12-02T14:23:45.850Z 2025-12-06T14:41:38.484Z
8665461 8665461 20251201032206_5JwyP BE000U 2025-12-02T14:23:43.562Z 2025-12-06T14:41:38.016Z
8665296 8665296 20251201030313_LnBgi BE000U 2025-12-02T14:23:18.396Z 2025-12-06T14:41:33.095Z
8665293 8665293 20251201030222_ZtZnd BE000U 2025-12-02T14:23:18.236Z 2025-12-06T14:41:33.020Z
8665282 8665282 20251201030118_vzJ8u BE000U 2025-12-02T14:23:17.441Z 2025-12-06T14:41:32.694Z
8663889 8663889 20251130223031_A5rrI BE000U 2025-12-02T14:19:32.002Z 2025-12-06T14:40:14.113Z
8663847 8663847 20251130221829_Vonvm BE000U 2025-12-02T14:19:24.879Z 2025-12-06T14:40:12.947Z
8663687 8663687 20251130212539_263n9 BE000U 2025-12-02T14:18:52.805Z 2025-12-06T14:40:07.362Z
8662555 8662555 20251130190956_bMbLG BE000U 2025-12-02T14:15:52.797Z 2025-12-06T14:39:22.290Z
8662481 8662481 20251130185615_yUcoQ BE000U 2025-12-02T14:15:42.276Z 2025-12-06T14:39:19.852Z
8662282 8662282 20251130182552_DXUN6 BE000U 2025-12-02T14:14:53.907Z 2025-12-06T14:38:57.822Z
8655036 8655036 20251130034117_2fZcZ BE000U 2025-12-01T14:26:17.158Z 2025-12-01T14:26:17.158Z
8624202 8624202 20251127033958_HGXxB BE000U 2025-11-28T14:23:59.675Z 2025-12-05T15:04:54.805Z
8624059 8624059 20251127025857_D3aHk BE000U 2025-11-28T14:23:42.280Z 2025-12-05T15:04:40.456Z
8624031 8624031 20251127025332_W4NoB BE000U 2025-11-28T14:23:39.245Z 2025-12-05T15:04:39.790Z
8623996 8623996 20251127024356_1bwJm BE000U 2025-11-28T14:23:35.111Z 2025-12-05T15:04:32.421Z
8623918 8623918 20251127022444_Emyn5 BE000U 2025-11-28T14:23:06.170Z 2025-12-05T15:04:26.086Z
8623883 8623883 20251127022044_bFgjj BE000U 2025-11-28T14:23:03.144Z 2025-12-05T15:04:24.063Z
8623830 8623830 20251127021418_yE9tt BE000U 2025-11-28T14:22:58.288Z 2025-12-05T15:04:18.681Z
8623824 8623824 20251127021306_Tarue BE000U 2025-11-28T14:22:57.438Z 2025-12-05T15:04:18.546Z
8623761 8623761 20251127015507_eJI6y BE000U 2025-11-28T14:22:49.786Z 2025-12-05T15:04:15.131Z
8623655 8623655 20251127013724_TNatz BE000U 2025-11-28T14:22:20.402Z 2025-12-05T15:04:06.105Z
8623623 8623623 20251127012822_HcZSF BE000U 2025-11-28T14:22:16.953Z 2025-12-05T15:04:05.281Z
8623283 8623283 20251126234546_ox0R3 BE000U 2025-11-28T14:21:27.366Z 2025-12-05T15:03:41.742Z
8623101 8623101 20251126225357_QaN6R BE000U 2025-11-28T14:20:53.002Z 2025-12-05T15:03:29.905Z
8622176 8622176 20251126180713_rFdaU BE000U 2025-11-28T14:18:03.866Z 2025-12-05T15:02:53.225Z
8609273 8609273 20251125232820_BmGFE BE000U 2025-11-27T14:18:00.146Z 2025-12-04T15:07:53.048Z
8595755 8595755 20251124181916_PrTnj BE000U 2025-11-26T14:12:23.479Z 2025-12-02T15:06:08.891Z
8595712 8595712 20251124180457_qAusb BE000U 2025-11-26T14:12:16.654Z 2025-12-02T15:06:05.983Z
8579470 8579470 20251122235037_7MW1I BE000U 2025-11-24T14:14:25.529Z 2025-12-01T15:20:28.486Z
8579352 8579352 20251122231636_2t2Dv BE000U 2025-11-24T14:14:03.289Z 2025-12-01T15:20:14.752Z
8579252 8579252 20251122225523_ChIZ6 BE000U 2025-11-24T14:13:52.174Z 2025-12-01T15:20:11.605Z
8579083 8579083 20251122222023_RPtIB BE000U 2025-11-24T14:13:29.027Z 2025-12-01T15:20:02.177Z
8579006 8579006 20251122220454_FVPWt BE000U 2025-11-24T14:13:17.191Z 2025-12-01T15:19:58.173Z
8578849 8578849 20251122213735_JTF1h BE000U 2025-11-24T14:12:50.337Z 2025-12-01T15:19:53.884Z
8578812 8578812 20251122212911_C7cfr BE000U 2025-11-24T14:12:45.467Z 2025-12-01T15:19:53.202Z
8578401 8578401 20251122203338_hn37E BE000U 2025-11-24T14:11:40.546Z 2025-12-01T15:19:34.132Z
8578312 8578312 20251122202708_2bDf3 BE000U 2025-11-24T14:11:23.446Z 2025-12-01T15:19:31.655Z
8578280 8578280 20251122202158_LY6hT BE000U 2025-11-24T14:11:17.996Z 2025-12-01T15:19:29.881Z
8578238 8578238 20251122201004_GZ6Hb BE000U 2025-11-24T14:11:11.050Z 2025-12-01T15:19:25.644Z
8578167 8578167 20251122195215_Nvuu2 BE000U 2025-11-24T14:11:00.226Z 2025-12-01T15:19:18.263Z
8578074 8578074 20251122193603_1pABI BE000U 2025-11-24T14:10:40.623Z 2025-12-01T15:19:08.067Z
8577646 8577646 20251122184309_IIMMS BE000U 2025-11-24T14:09:16.927Z 2025-12-01T15:18:55.685Z
8577527 8577527 20251122182109_AUQWe BE000U 2025-11-24T14:08:56.912Z 2025-12-01T15:18:52.476Z
8577070 8577070 20251122171604_azKtq BE000U 2025-11-24T14:07:27.495Z 2025-12-01T15:18:43.028Z
8576954 8576954 20251122165255_6X9Wr BE000U 2025-11-24T14:07:05.808Z 2025-12-01T15:18:41.766Z
8571372 8571372 20251121202448_9UFSw BE000U 2025-11-23T14:36:13.736Z 2025-11-30T15:04:58.461Z
8571227 8571227 20251121194613_xH2LD BE000U 2025-11-23T14:36:04.948Z 2025-11-30T15:04:41.151Z
8571108 8571108 20251121191454_XUsIW BE000U 2025-11-23T14:35:58.861Z 2025-11-30T15:04:28.997Z
8571025 8571025 20251121183508_tWk3B BE000U 2025-11-23T14:35:53.839Z 2025-11-30T15:04:20.871Z
8571010 8571010 20251121183137_6o2j1 BE000U 2025-11-23T14:35:53.087Z 2025-11-30T15:04:20.355Z
8570844 8570844 20251121173453_RTHHg BE000U 2025-11-23T14:34:54.509Z 2025-11-30T15:03:49.886Z
8512480 8512480 20251117222541_CpFxc BE000U 2025-11-19T14:34:41.643Z 2025-11-26T15:07:43.978Z
8511640 8511640 20251117194947_1PeHi BE000U 2025-11-19T14:33:39.471Z 2025-11-26T15:07:37.076Z
8510959 8510959 20251117172538_P1PWD BE000U 2025-11-19T14:32:10.226Z 2025-11-26T15:06:28.229Z
8510772 8510772 20251118054656_fXdqj BE000U 2025-11-19T14:22:36.481Z 2025-11-26T15:08:06.101Z
8510706 8510706 20251118053309_SORNI BE000U 2025-11-19T14:22:23.445Z 2025-11-26T15:08:05.304Z
8510680 8510680 20251118052452_qiLpN BE000U 2025-11-19T14:22:21.547Z 2025-11-26T15:08:05.075Z
8510661 8510661 20251118052224_CeE6k BE000U 2025-11-19T14:22:19.660Z 2025-11-26T15:08:04.918Z
8510657 8510657 20251118052223_EIpo2 BE000U 2025-11-19T14:22:19.619Z 2025-11-26T15:08:04.908Z
8510648 8510648 20251118052028_NDJOr BE000U 2025-11-19T14:22:18.804Z 2025-11-26T15:08:04.853Z
8510636 8510636 20251118051851_qcA1h BE000U 2025-11-19T14:22:17.906Z 2025-11-26T15:08:04.735Z
8510604 8510604 20251118051230_ZMucD BE000U 2025-11-19T14:22:15.823Z 2025-11-26T15:08:04.476Z
8510423 8510423 20251118044209_BVTBk BE000U 2025-11-19T14:21:49.929Z 2025-11-26T15:08:01.804Z
8510346 8510346 20251118043103_pVnQg BE000U 2025-11-19T14:21:39.510Z 2025-11-26T15:08:01.329Z
8510145 8510145 20251118040833_xZADw BE000U 2025-11-19T14:21:20.881Z 2025-11-26T15:08:00.020Z
8509922 8509922 20251118034147_QoQPn BE000U 2025-11-19T14:20:48.750Z 2025-11-26T15:07:58.803Z
8509739 8509739 20251118032401_ZycLU BE000U 2025-11-19T14:20:17.055Z 2025-11-26T15:07:57.823Z
8509689 8509689 20251118031936_AKUwv BE000U 2025-11-19T14:20:10.213Z 2025-11-26T15:07:57.622Z
8509677 8509677 20251118031814_nkGxT BE000U 2025-11-19T14:20:09.007Z 2025-11-26T15:07:57.570Z
8509628 8509628 20251118031146_or0Fm BE000U 2025-11-19T14:20:03.327Z 2025-11-26T15:07:57.218Z
8509622 8509622 20251118031108_uNETX BE000U 2025-11-19T14:20:02.743Z 2025-11-26T15:07:57.184Z
8509603 8509603 20251118030829_PUIAW BE000U 2025-11-19T14:20:00.886Z 2025-11-26T15:07:57.097Z
8509551 8509551 20251118030034_7cIcu BE000U 2025-11-19T14:19:54.916Z 2025-11-26T15:07:56.704Z
8509364 8509364 20251118023759_kgwtD BE000U 2025-11-19T14:19:24.280Z 2025-11-26T15:07:55.333Z
8509241 8509241 20251118022152_jkinM BE000U 2025-11-19T14:19:13.642Z 2025-11-26T15:07:54.598Z
8509210 8509210 20251118021717_tcWYB BE000U 2025-11-19T14:19:09.136Z 2025-11-26T15:07:54.361Z
8508778 8508778 20251118013259_yRtXV BE000U 2025-11-19T14:18:12.041Z 2025-11-26T15:07:52.161Z
8508477 8508477 20251118010607_Sj1TN BE000U 2025-11-19T14:17:49.596Z 2025-11-26T15:07:50.991Z
8508445 8508445 20251118010322_MhA2X BE000U 2025-11-19T14:17:36.439Z 2025-11-26T15:07:50.859Z
8508309 8508309 20251118005032_KhnTs BE000U 2025-11-19T14:17:21.848Z 2025-11-26T15:07:50.277Z
8508294 8508294 20251118004909_NtWMC BE000U 2025-11-19T14:17:19.864Z 2025-11-26T15:07:50.208Z
8508283 8508283 20251118004835_Tgz2G BE000U 2025-11-19T14:17:18.888Z 2025-11-26T15:07:50.185Z
8508216 8508216 20251118004314_6cUaP BE000U 2025-11-19T14:17:12.311Z 2025-11-26T15:07:49.865Z
8508168 8508168 20251118003543_NPwhF BE000U 2025-11-19T14:16:53.538Z 2025-11-26T15:07:49.562Z
8508037 8508037 20251118002154_2RFjz BE000U 2025-11-19T14:16:41.809Z 2025-11-26T15:07:49.025Z

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