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 = "HU0003" 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
8647668 8647668 20251129050524_dT3hn HU0003 2025-11-30T14:28:43.268Z 2025-12-06T14:56:42.845Z
8647514 8647514 20251129044638_rn4b6 HU0003 2025-11-30T14:28:31.880Z 2025-12-06T14:56:40.329Z
8647492 8647492 20251129044404_2O9i9 HU0003 2025-11-30T14:28:29.783Z 2025-12-06T14:56:39.877Z
8647441 8647441 20251129043640_lCBx5 HU0003 2025-11-30T14:28:26.235Z 2025-12-06T14:56:39.182Z
8647406 8647406 20251129043207_LkTYv HU0003 2025-11-30T14:28:06.869Z 2025-12-06T14:56:38.219Z
8647229 8647229 20251129040824_BN0h6 HU0003 2025-11-30T14:27:52.348Z 2025-12-06T14:56:34.205Z
8647160 8647160 20251129035356_BZAGY HU0003 2025-11-30T14:27:46.188Z 2025-12-06T14:56:33.058Z
8647016 8647016 20251129032723_EWXO0 HU0003 2025-11-30T14:27:17.897Z 2025-12-06T14:56:29.855Z
8646998 8646998 20251129032510_P1TDs HU0003 2025-11-30T14:27:14.910Z 2025-12-06T14:56:29.471Z
8646653 8646653 20251129023536_wrYjL HU0003 2025-11-30T14:26:36.917Z 2025-12-06T14:56:22.651Z
8646373 8646373 20251129015514_hzNRu HU0003 2025-11-30T14:25:55.009Z 2025-12-06T14:56:03.047Z
8637158 8637158 20251128051030_pkbHl HU0003 2025-11-29T14:26:55.122Z 2025-12-06T15:03:57.169Z
8637047 8637047 20251128045440_ULkvR HU0003 2025-11-29T14:26:47.690Z 2025-12-06T15:03:56.026Z
8636974 8636974 20251128044454_SFWPu HU0003 2025-11-29T14:26:28.891Z 2025-12-06T15:03:53.429Z
8636868 8636868 20251128043128_mLr03 HU0003 2025-11-29T14:26:16.678Z 2025-12-06T15:03:46.857Z
8636821 8636821 20251128042950_mqNPQ HU0003 2025-11-29T14:26:14.486Z 2025-12-06T15:03:45.731Z
8636769 8636769 20251128042545_vNoLb HU0003 2025-11-29T14:26:11.007Z 2025-12-06T15:03:41.876Z
8636767 8636767 20251128042503_EYssv HU0003 2025-11-29T14:26:10.508Z 2025-12-06T15:03:41.303Z
8636759 8636759 20251128042334_IGDU6 HU0003 2025-11-29T14:26:09.737Z 2025-12-06T15:03:40.636Z
8636655 8636655 20251128041534_OXOYo HU0003 2025-11-29T14:25:57.799Z 2025-12-06T15:03:34.778Z
8636542 8636542 20251128035728_LlSgB HU0003 2025-11-29T14:25:38.516Z 2025-12-06T15:03:26.016Z
8636285 8636285 20251128033207_B0xEw HU0003 2025-11-29T14:25:20.545Z 2025-12-06T15:03:03.577Z
8636282 8636282 20251128033125_kZkVa HU0003 2025-11-29T14:25:20.310Z 2025-12-06T15:03:03.257Z
8636190 8636190 20251128032728_03ihZ HU0003 2025-11-29T14:25:03.561Z 2025-12-06T15:02:58.049Z
8636038 8636038 20251128030912_1nQaz HU0003 2025-11-29T14:24:49.475Z 2025-12-06T15:02:55.491Z
8635952 8635952 20251128030211_DYm2e HU0003 2025-11-29T14:24:41.849Z 2025-12-06T15:02:54.570Z
8635950 8635950 20251128030155_Coee0 HU0003 2025-11-29T14:24:41.571Z 2025-12-06T15:02:54.539Z
8635927 8635927 20251128025913_ufOlZ HU0003 2025-11-29T14:24:28.588Z 2025-12-06T15:02:54.138Z
8635774 8635774 20251128024645_l0nJk HU0003 2025-11-29T14:24:08.889Z 2025-12-06T15:02:50.716Z
8635651 8635651 20251128023527_15lLP HU0003 2025-11-29T14:23:58.800Z 2025-12-06T15:02:47.823Z
8635577 8635577 20251128022751_eF7oh HU0003 2025-11-29T14:23:45.325Z 2025-12-06T15:02:46.827Z
8635538 8635538 20251128022343_H3E92 HU0003 2025-11-29T14:23:38.639Z 2025-12-06T15:02:46.155Z
8635381 8635381 20251128020831_c85Fc HU0003 2025-11-29T14:23:18.864Z 2025-12-06T15:02:43.843Z
8635299 8635299 20251128020204_V6ZNm HU0003 2025-11-29T14:23:02.242Z 2025-12-06T15:02:43.165Z
8635133 8635133 20251128014506_MeLnh HU0003 2025-11-29T14:22:42.831Z 2025-12-06T15:02:40.949Z
8635131 8635131 20251128014452_3F732 HU0003 2025-11-29T14:22:42.710Z 2025-12-06T15:02:40.888Z
8635101 8635101 20251128014126_NeQp8 HU0003 2025-11-29T14:22:40.574Z 2025-12-06T15:02:40.674Z
8635056 8635056 20251128013752_7h5CR HU0003 2025-11-29T14:22:36.332Z 2025-12-06T15:02:40.199Z
8635035 8635035 20251128013540_yPzxD HU0003 2025-11-29T14:22:27.087Z 2025-12-06T15:02:39.989Z
8634830 8634830 20251128012058_rf9Ld HU0003 2025-11-29T14:22:05.939Z 2025-12-06T15:02:36.312Z
8634664 8634664 20251128010801_2I93V HU0003 2025-11-29T14:21:53.708Z 2025-12-06T15:02:27.283Z
8634652 8634652 20251128010732_Y3naq HU0003 2025-11-29T14:21:48.179Z 2025-12-06T15:02:26.737Z
8634616 8634616 20251128010502_a0USZ HU0003 2025-11-29T14:21:40.401Z 2025-12-06T15:02:25.757Z
8634377 8634377 20251128004403_ydmdY HU0003 2025-11-29T14:21:16.075Z 2025-12-06T15:02:02.076Z
8633904 8633904 20251128000249_lW7gF HU0003 2025-11-29T14:20:29.788Z 2025-12-06T15:01:49.365Z
8633385 8633385 20251127231007_iHRsc HU0003 2025-11-29T14:19:38.718Z 2025-12-06T15:01:43.390Z
8633239 8633239 20251127225630_aKccC HU0003 2025-11-29T14:19:17.997Z 2025-12-06T15:01:41.500Z
8633185 8633185 20251127224940_GOdkh HU0003 2025-11-29T14:19:12.688Z 2025-12-06T15:01:40.898Z
8632998 8632998 20251127222837_hHpkm HU0003 2025-11-29T14:18:48.325Z 2025-12-06T15:01:37.052Z
8632979 8632979 20251127222516_CpIrA HU0003 2025-11-29T14:18:39.793Z 2025-12-06T15:01:36.773Z
8632793 8632793 20251127215634_2IHT7 HU0003 2025-11-29T14:18:23.538Z 2025-12-06T15:01:33.489Z
8632230 8632230 20251127204336_w0BJn HU0003 2025-11-29T14:17:10.306Z 2025-12-06T15:01:04.303Z
8631925 8631925 20251127201502_UZp5c HU0003 2025-11-29T14:16:34.455Z 2025-12-06T15:00:46.858Z
8631712 8631712 20251127195312_GJK39 HU0003 2025-11-29T14:16:07.596Z 2025-12-06T15:00:38.441Z
8631706 8631706 20251127194921_UEdbV HU0003 2025-11-29T14:16:05.065Z 2025-12-06T15:00:37.857Z
8631684 8631684 20251127194429_YkBlw HU0003 2025-11-29T14:16:02.047Z 2025-12-06T15:00:35.665Z
8631412 8631412 20251127190352_uQrkx HU0003 2025-11-29T14:15:18.254Z 2025-12-06T15:00:10.696Z
8631262 8631262 20251127184208_7RIpj HU0003 2025-11-29T14:15:01.624Z 2025-12-06T15:00:01.110Z
8630827 8630827 20251127173307_vRC36 HU0003 2025-11-29T14:13:50.413Z 2025-12-06T14:59:34.733Z
8630746 8630746 20251127171238_3Okq8 HU0003 2025-11-29T14:13:39.222Z 2025-12-06T14:59:23.840Z
8630708 8630708 20251127170847_GFM5f HU0003 2025-11-29T14:13:30.694Z 2025-12-06T14:59:20.644Z
8630525 8630525 20251127163743_frRjq HU0003 2025-11-29T14:12:51.717Z 2025-12-06T14:59:09.044Z
8624226 8624226 20251127034506_aVS39 HU0003 2025-11-28T14:24:17.576Z 2025-12-05T15:04:55.392Z
8624201 8624201 20251127033922_CfZjN HU0003 2025-11-28T14:23:59.290Z 2025-12-05T15:04:54.781Z
8624072 8624072 20251127030115_0vnoH HU0003 2025-11-28T14:23:43.728Z 2025-12-05T15:04:43.555Z
8624041 8624041 20251127025456_qzWjI HU0003 2025-11-28T14:23:40.035Z 2025-12-05T15:04:39.973Z
8624003 8624003 20251127024414_NhKZB HU0003 2025-11-28T14:23:36.040Z 2025-12-05T15:04:33.855Z
8623429 8623429 20251127003238_YMJma HU0003 2025-11-28T14:21:44.063Z 2025-12-05T15:03:52.423Z
8623353 8623353 20251127000732_RtMqI HU0003 2025-11-28T14:21:34.043Z 2025-12-05T15:03:44.282Z
8623324 8623324 20251126235922_X2qnH HU0003 2025-11-28T14:21:31.177Z 2025-12-05T15:03:43.161Z
8623273 8623273 20251126233950_eFkPv HU0003 2025-11-28T14:21:26.063Z 2025-12-05T15:03:41.457Z
8623246 8623246 20251126233231_Zxx9e HU0003 2025-11-28T14:21:23.243Z 2025-12-05T15:03:40.495Z
8623219 8623219 20251126232241_EUjHX HU0003 2025-11-28T14:21:07.112Z 2025-12-05T15:03:38.625Z
8623179 8623179 20251126231314_z2gHk HU0003 2025-11-28T14:21:01.894Z 2025-12-05T15:03:36.517Z
8623173 8623173 20251126231234_OgRLW HU0003 2025-11-28T14:21:01.108Z 2025-12-05T15:03:36.303Z
8623152 8623152 20251126230554_WggwN HU0003 2025-11-28T14:20:58.609Z 2025-12-05T15:03:32.928Z
8623139 8623139 20251126230018_YS9Em HU0003 2025-11-28T14:20:56.764Z 2025-12-05T15:03:31.264Z
8623125 8623125 20251126225703_Xm2e1 HU0003 2025-11-28T14:20:55.365Z 2025-12-05T15:03:30.512Z
8623112 8623112 20251126225518_1nE1x HU0003 2025-11-28T14:20:54.164Z 2025-12-05T15:03:30.269Z
8623108 8623108 20251126225403_1992z HU0003 2025-11-28T14:20:53.586Z 2025-12-05T15:03:30.042Z
8623099 8623099 20251126225322_sPtR0 HU0003 2025-11-28T14:20:52.676Z 2025-12-05T15:03:29.883Z
8623062 8623062 20251126224352_TRlZn HU0003 2025-11-28T14:20:40.529Z 2025-12-05T15:03:27.229Z
8623057 8623057 20251126224228_z9hfS HU0003 2025-11-28T14:20:38.857Z 2025-12-05T15:03:27.161Z
8623027 8623027 20251126223144_GmsDT HU0003 2025-11-28T14:20:30.904Z 2025-12-05T15:03:25.980Z
8622991 8622991 20251126222330_xFrbN HU0003 2025-11-28T14:20:26.207Z 2025-12-05T15:03:24.618Z
8622977 8622977 20251126222103_i2HKd HU0003 2025-11-28T14:20:24.829Z 2025-12-05T15:03:21.234Z
8622805 8622805 20251126213352_5B0Qj HU0003 2025-11-28T14:19:55.069Z 2025-12-05T15:03:11.660Z
8622667 8622667 20251126203403_60Bc2 HU0003 2025-11-28T14:19:39.914Z 2025-12-05T15:03:04.784Z
8622413 8622413 20251126190743_yeTSB HU0003 2025-11-28T14:18:49.103Z 2025-12-05T15:02:56.681Z
8591402 8591402 20251124041221_Cb1zY HU0003 2025-11-25T14:24:19.150Z 2025-12-02T15:12:58.581Z
8591334 8591334 20251124040527_PvwCO HU0003 2025-11-25T14:23:56.697Z 2025-12-02T15:12:58.062Z
8591234 8591234 20251124035359_2bWPe HU0003 2025-11-25T14:23:46.291Z 2025-12-02T15:12:57.513Z
8526100 8526100 20251118205105_LyzAD HU0003 2025-11-20T14:39:14.073Z 2025-11-27T15:11:38.315Z
8524957 8524957 20251119044339_TENUK HU0003 2025-11-20T14:21:50.073Z 2025-11-27T15:13:09.298Z
8524934 8524934 20251119044039_z2PKp HU0003 2025-11-20T14:21:47.724Z 2025-11-27T15:13:08.016Z
8524915 8524915 20251119043711_xhTtK HU0003 2025-11-20T14:21:46.319Z 2025-11-27T15:13:07.718Z
8524870 8524870 20251119043109_cBays HU0003 2025-11-20T14:21:42.058Z 2025-11-27T15:13:06.790Z
8524816 8524816 20251119042506_u3ADF HU0003 2025-11-20T14:21:37.845Z 2025-11-27T15:13:06.357Z
8524793 8524793 20251119042159_8ODje HU0003 2025-11-20T14:21:36.036Z 2025-11-27T15:13:04.016Z
8524662 8524662 20251119041003_jKjJE HU0003 2025-11-20T14:21:11.763Z 2025-11-27T15:13:02.934Z

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