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 = "BE0005" 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
8665893 8665893 20251201040629_Eprmf BE0005 2025-12-02T14:24:50.430Z 2025-12-06T14:42:06.205Z
8665875 8665875 20251201040430_araib BE0005 2025-12-02T14:24:37.985Z 2025-12-06T14:42:05.864Z
8663987 8663987 20251130225429_B253Y BE0005 2025-12-02T14:19:45.643Z 2025-12-06T14:40:19.000Z
8663423 8663423 20251130204442_2d7Lb BE0005 2025-12-02T14:18:16.273Z 2025-12-06T14:40:00.430Z
8662917 8662917 20251130194657_ZZ9CI BE0005 2025-12-02T14:17:01.524Z 2025-12-06T14:39:35.462Z
8662686 8662686 20251130192034_D6rRe BE0005 2025-12-02T14:16:18.519Z 2025-12-06T14:39:26.137Z
8662127 8662127 20251130180255_qcHqX BE0005 2025-12-02T14:14:27.263Z 2025-12-06T14:38:51.086Z
8646197 8646197 20251129012250_Ca3X8 BE0005 2025-11-30T14:25:24.222Z 2025-12-06T14:55:43.626Z
8646159 8646159 20251129011605_S322e BE0005 2025-11-30T14:25:17.748Z 2025-12-06T14:55:39.975Z
8623945 8623945 20251127023153_YN9ZH BE0005 2025-11-28T14:23:10.935Z 2025-12-05T15:04:28.084Z
8623916 8623916 20251127022439_2Coqt BE0005 2025-11-28T14:23:05.932Z 2025-12-05T15:04:25.955Z
8623885 8623885 20251127022156_JeGzO BE0005 2025-11-28T14:23:03.415Z 2025-12-05T15:04:24.193Z
8623772 8623772 20251127015911_kOSy9 BE0005 2025-11-28T14:22:51.391Z 2025-12-05T15:04:15.714Z
8623588 8623588 20251127011635_T9vS4 BE0005 2025-11-28T14:22:13.373Z 2025-12-05T15:04:03.951Z
8623231 8623231 20251126232638_tZl92 BE0005 2025-11-28T14:21:08.611Z 2025-12-05T15:03:39.315Z
8623221 8623221 20251126232313_G0KIT BE0005 2025-11-28T14:21:07.536Z 2025-12-05T15:03:38.659Z
8623214 8623214 20251126232204_6h0JG BE0005 2025-11-28T14:21:06.241Z 2025-12-05T15:03:38.371Z
8623006 8623006 20251126222736_aMz3Y BE0005 2025-11-28T14:20:28.535Z 2025-12-05T15:03:25.080Z
8622959 8622959 20251126221347_OTO3a BE0005 2025-11-28T14:20:23.279Z 2025-12-05T15:03:20.767Z
8581468 8581468 20251123000421_UccO7 BE0005 2025-11-24T14:31:39.560Z 2025-12-01T15:20:35.203Z
8581457 8581457 20251122235945_qIdqD BE0005 2025-11-24T14:31:35.996Z 2025-12-01T15:20:34.528Z
8581338 8581338 20251122231314_TmOge BE0005 2025-11-24T14:31:27.520Z 2025-12-01T15:20:14.313Z
8581305 8581305 20251122230133_WXA5j BE0005 2025-11-24T14:31:24.922Z 2025-12-01T15:20:12.243Z
8581236 8581236 20251122222614_M8Mhj BE0005 2025-11-24T14:31:21.458Z 2025-12-01T15:20:03.911Z
8579102 8579102 20251122222215_EhL6V BE0005 2025-11-24T14:13:30.844Z 2025-12-01T15:20:02.984Z
8578820 8578820 20251122213042_gYfOR BE0005 2025-11-24T14:12:46.701Z 2025-12-01T15:19:53.383Z
8578777 8578777 20251122212431_gv6dx BE0005 2025-11-24T14:12:39.803Z 2025-12-01T15:19:52.774Z
8578745 8578745 20251122212205_fK4jO BE0005 2025-11-24T14:12:37.273Z 2025-12-01T15:19:51.255Z
8578649 8578649 20251122210614_zwbzX BE0005 2025-11-24T14:12:16.088Z 2025-12-01T15:19:49.360Z
8578450 8578450 20251122203746_eCqjO BE0005 2025-11-24T14:11:46.096Z 2025-12-01T15:19:37.951Z
8578180 8578180 20251122195613_6UxAA BE0005 2025-11-24T14:11:02.508Z 2025-12-01T15:19:20.047Z
8578075 8578075 20251122193616_FSAS7 BE0005 2025-11-24T14:10:40.966Z 2025-12-01T15:19:08.169Z
8577987 8577987 20251122192112_C58Ko BE0005 2025-11-24T14:10:27.018Z 2025-12-01T15:19:05.529Z
8577819 8577819 20251122185927_y0NuD BE0005 2025-11-24T14:09:48.662Z 2025-12-01T15:18:59.205Z
8577490 8577490 20251122181719_Gf0ZS BE0005 2025-11-24T14:08:47.547Z 2025-12-01T15:18:52.065Z
8577453 8577453 20251122181042_qBgll BE0005 2025-11-24T14:08:39.308Z 2025-12-01T15:18:50.696Z
8577277 8577277 20251122175118_tT4wX BE0005 2025-11-24T14:08:11.421Z 2025-12-01T15:18:46.333Z
8577167 8577167 20251122172659_WAU42 BE0005 2025-11-24T14:07:52.055Z 2025-12-01T15:18:44.420Z
8574232 8574232 20251122053401_L8uV6 BE0005 2025-11-23T14:42:58.762Z 2025-11-30T15:07:03.290Z
8574141 8574141 20251122051537_NeHwH BE0005 2025-11-23T14:42:22.686Z 2025-11-30T15:06:59.659Z
8574062 8574062 20251122050446_n5PC0 BE0005 2025-11-23T14:42:14.239Z 2025-11-30T15:06:56.504Z
8573915 8573915 20251122043754_1fq2C BE0005 2025-11-23T14:42:06.785Z 2025-11-30T15:06:49.457Z
8573913 8573913 20251122043734_sKoWa BE0005 2025-11-23T14:42:06.649Z 2025-11-30T15:06:49.424Z
8573903 8573903 20251122043626_m2EDw BE0005 2025-11-23T14:42:06.294Z 2025-11-30T15:06:49.003Z
8573815 8573815 20251122041629_305hf BE0005 2025-11-23T14:42:01.654Z 2025-11-30T15:06:41.341Z
8573739 8573739 20251122040127_GvY5v BE0005 2025-11-23T14:41:57.068Z 2025-11-30T15:06:36.629Z
8573713 8573713 20251122035808_m115U BE0005 2025-11-23T14:41:55.804Z 2025-11-30T15:06:36.217Z
8573695 8573695 20251122035544_9XRd2 BE0005 2025-11-23T14:41:55.171Z 2025-11-30T15:06:35.885Z
8573523 8573523 20251122032607_gPKiG BE0005 2025-11-23T14:41:15.586Z 2025-11-30T15:06:30.081Z
8573516 8573516 20251122032405_eKL2r BE0005 2025-11-23T14:41:15.125Z 2025-11-30T15:06:29.354Z
8573370 8573370 20251122030135_fYmEv BE0005 2025-11-23T14:41:08.487Z 2025-11-30T15:06:19.540Z
8573341 8573341 20251122025808_ZOAjr BE0005 2025-11-23T14:41:06.786Z 2025-11-30T15:06:16.334Z
8573229 8573229 20251122024404_zHhge BE0005 2025-11-23T14:41:01.607Z 2025-11-30T15:06:12.613Z
8573130 8573130 20251122023310_wR2wI BE0005 2025-11-23T14:40:45.759Z 2025-11-30T15:06:10.617Z
8572849 8572849 20251122014950_Sx6zo BE0005 2025-11-23T14:39:46.750Z 2025-11-30T15:06:04.546Z
8572795 8572795 20251122014311_N5wAz BE0005 2025-11-23T14:39:44.572Z 2025-11-30T15:06:01.088Z
8572780 8572780 20251122014138_nGYPU BE0005 2025-11-23T14:39:43.509Z 2025-11-30T15:06:00.734Z
8572683 8572683 20251122012858_MFfvW BE0005 2025-11-23T14:39:38.385Z 2025-11-30T15:05:55.128Z
8572609 8572609 20251122011709_yghQt BE0005 2025-11-23T14:39:34.237Z 2025-11-30T15:05:52.934Z
8572530 8572530 20251122010653_DV7Mb BE0005 2025-11-23T14:39:30.307Z 2025-11-30T15:05:51.560Z
8572463 8572463 20251122005053_GqL7a BE0005 2025-11-23T14:39:26.407Z 2025-11-30T15:05:50.485Z
8572389 8572389 20251122003455_Pp6Tx BE0005 2025-11-23T14:39:07.437Z 2025-11-30T15:05:48.870Z
8572386 8572386 20251122003446_hjPYl BE0005 2025-11-23T14:39:07.263Z 2025-11-30T15:05:48.790Z
8572358 8572358 20251122003148_Gcp4A BE0005 2025-11-23T14:39:00.867Z 2025-11-23T14:39:00.867Z
8572326 8572326 20251122002732_5xqWM BE0005 2025-11-23T14:38:49.369Z 2025-11-30T15:05:44.874Z
8572268 8572268 20251122001521_HQcIB BE0005 2025-11-23T14:38:29.043Z 2025-11-30T15:05:42.405Z
8572077 8572077 20251121233304_yYrtv BE0005 2025-11-23T14:37:58.034Z 2025-11-30T15:05:37.051Z
8572057 8572057 20251121232819_o4F23 BE0005 2025-11-23T14:37:57.049Z 2025-11-30T15:05:36.306Z
8571986 8571986 20251121230736_0xIq4 BE0005 2025-11-23T14:37:53.879Z 2025-11-30T15:05:29.757Z
8571871 8571871 20251121223500_rYXI5 BE0005 2025-11-23T14:37:48.027Z 2025-11-30T15:05:23.579Z
8571815 8571815 20251121221340_aGShe BE0005 2025-11-23T14:37:45.258Z 2025-11-30T15:05:19.570Z
8571786 8571786 20251121220834_UuMQg BE0005 2025-11-23T14:37:43.998Z 2025-11-30T15:05:18.940Z
8571733 8571733 20251121215951_mbJOv BE0005 2025-11-23T14:37:41.920Z 2025-11-30T15:05:15.466Z
8571718 8571718 20251121215738_t22tB BE0005 2025-11-23T14:37:41.364Z 2025-11-30T15:05:15.257Z
8571684 8571684 20251121214956_2s3IW BE0005 2025-11-23T14:37:38.796Z 2025-11-30T15:05:14.301Z
8571681 8571681 20251121214848_ChAXU BE0005 2025-11-23T14:37:37.981Z 2025-11-30T15:05:14.219Z
8571658 8571658 20251121214354_LyyIb BE0005 2025-11-23T14:37:29.717Z 2025-11-30T15:05:11.887Z
8571534 8571534 20251121211310_l7VR1 BE0005 2025-11-23T14:36:51.249Z 2025-11-30T15:05:08.673Z
8571487 8571487 20251121205514_hVGmj BE0005 2025-11-23T14:36:36.135Z 2025-11-30T15:05:06.759Z
8571360 8571360 20251121202344_Gm6nk BE0005 2025-11-23T14:36:13.083Z 2025-11-30T15:04:58.391Z
8571325 8571325 20251121201531_OEhB3 BE0005 2025-11-23T14:36:10.571Z 2025-11-30T15:04:53.846Z
8571248 8571248 20251121195920_DnTRZ BE0005 2025-11-23T14:36:07.002Z 2025-11-30T15:04:43.926Z
8571239 8571239 20251121195114_bDbHc BE0005 2025-11-23T14:36:06.086Z 2025-11-30T15:04:43.022Z
8571018 8571018 20251121183437_pnP31 BE0005 2025-11-23T14:35:53.664Z 2025-11-30T15:04:20.849Z
8515957 8515957 20251118052605_ghkD3 BE0005 2025-11-19T14:40:04.572Z 2025-11-26T15:08:05.079Z
8515816 8515816 20251118051012_OKfy8 BE0005 2025-11-19T14:39:58.999Z 2025-11-26T15:08:04.393Z
8515806 8515806 20251118050915_hmR6Q BE0005 2025-11-19T14:39:58.534Z 2025-11-26T15:08:04.264Z
8515701 8515701 20251118045637_Bripf BE0005 2025-11-19T14:39:54.576Z 2025-11-26T15:08:03.552Z
8515635 8515635 20251118044900_NS8Le BE0005 2025-11-19T14:39:52.343Z 2025-11-26T15:08:02.202Z
8515608 8515608 20251118044532_cbUVO BE0005 2025-11-19T14:39:51.178Z 2025-11-26T15:08:02.049Z
8515585 8515585 20251118044218_Y2gJk BE0005 2025-11-19T14:39:50.737Z 2025-11-26T15:08:01.807Z
8515522 8515522 20251118043516_OI1cc BE0005 2025-11-19T14:39:48.518Z 2025-11-26T15:08:01.490Z
8515414 8515414 20251118042403_S2v8U BE0005 2025-11-19T14:39:44.509Z 2025-11-26T15:08:00.867Z
8515352 8515352 20251118041652_s3Su7 BE0005 2025-11-19T14:39:42.074Z 2025-11-26T15:08:00.512Z
8515180 8515180 20251118035456_5jIoI BE0005 2025-11-19T14:39:00.216Z 2025-11-26T15:07:59.516Z
8515147 8515147 20251118034842_2ygrP BE0005 2025-11-19T14:38:54.933Z 2025-11-26T15:07:59.187Z
8515105 8515105 20251118034517_OhiJR BE0005 2025-11-19T14:38:44.454Z 2025-11-26T15:07:58.881Z
8515095 8515095 20251118034433_Dthap BE0005 2025-11-19T14:38:43.837Z 2025-11-26T15:07:58.873Z
8515061 8515061 20251118033905_dARbD BE0005 2025-11-19T14:38:38.255Z 2025-11-26T15:07:58.578Z
8514971 8514971 20251118033037_KPWrx BE0005 2025-11-19T14:38:35.907Z 2025-11-26T15:07:58.132Z

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