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

1,561 rows where station_code = "BE0010" 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
8687115 8687115 20251204044100_60g9B BE0010 2025-12-05T14:13:55.161Z 2025-12-05T14:14:35.623Z
8687092 8687092 20251204033839_3ycFm BE0010 2025-12-05T14:13:52.078Z 2025-12-05T14:14:35.615Z
8687060 8687060 20251204024955_yySHK BE0010 2025-12-05T14:13:46.237Z 2025-12-05T14:14:35.596Z
8687041 8687041 20251204020659_OcvuP BE0010 2025-12-05T14:13:41.439Z 2025-12-05T14:14:35.581Z
8687031 8687031 20251204015116_IAIlW BE0010 2025-12-05T14:13:31.193Z 2025-12-05T14:14:35.575Z
8680996 8680996 20251203021022_QPvj2 BE0010 2025-12-04T14:13:31.638Z 2025-12-05T14:21:10.373Z
8666772 8666772 20251201020444_9lluj BE0010 2025-12-02T14:27:45.480Z 2025-12-05T14:35:36.426Z
8665017 8665017 20251201021732_TfMqP BE0010 2025-12-02T14:22:37.274Z 2025-12-05T14:35:39.430Z
8664917 8664917 20251201020440_tsACM BE0010 2025-12-02T14:22:26.938Z 2025-12-05T14:35:36.336Z
8664880 8664880 20251201015559_ckGUE BE0010 2025-12-02T14:22:15.944Z 2025-12-05T14:35:34.548Z
8664853 8664853 20251201015116_P2AVF BE0010 2025-12-02T14:22:12.163Z 2025-12-05T14:35:33.759Z
8664773 8664773 20251201013634_4nXAD BE0010 2025-12-02T14:22:03.309Z 2025-12-05T14:35:17.502Z
8664616 8664616 20251201011223_VvIA2 BE0010 2025-12-02T14:21:38.262Z 2025-12-05T14:35:10.531Z
8664306 8664306 20251201000059_8BptF BE0010 2025-12-02T14:20:40.898Z 2025-12-05T14:35:00.138Z
8664295 8664295 20251130235913_xSmNt BE0010 2025-12-02T14:20:39.875Z 2025-12-05T14:34:59.868Z
8664129 8664129 20251130231905_2EW6V BE0010 2025-12-02T14:20:07.381Z 2025-12-05T14:34:53.477Z
8664093 8664093 20251130231621_j3xwo BE0010 2025-12-02T14:20:04.438Z 2025-12-05T14:34:51.930Z
8663767 8663767 20251130215353_seR7Q BE0010 2025-12-02T14:19:04.005Z 2025-12-05T14:34:31.243Z
8663763 8663763 20251130215138_Ve0aQ BE0010 2025-12-02T14:19:03.470Z 2025-12-05T14:34:31.128Z
8663660 8663660 20251130211934_4Vvtb BE0010 2025-12-02T14:18:48.752Z 2025-12-05T14:34:27.418Z
8663657 8663657 20251130211848_pfAhL BE0010 2025-12-02T14:18:48.202Z 2025-12-05T14:34:27.273Z
8663618 8663618 20251130211021_TY0Re BE0010 2025-12-02T14:18:36.181Z 2025-12-05T14:34:25.986Z
8663341 8663341 20251130203356_XX86s BE0010 2025-12-02T14:18:00.700Z 2025-12-05T14:34:05.183Z
8663116 8663116 20251130201149_xJgjI BE0010 2025-12-02T14:17:29.165Z 2025-12-05T14:33:57.696Z
8662918 8662918 20251130194657_ZZ9CI BE0010 2025-12-02T14:17:01.524Z 2025-12-05T14:33:52.384Z
8662691 8662691 20251130192034_D6rRe BE0010 2025-12-02T14:16:18.550Z 2025-12-05T14:33:43.468Z
8662043 8662043 20251130174738_RmJuK BE0010 2025-12-02T14:14:04.696Z 2025-12-05T14:32:50.063Z
8662030 8662030 20251130174548_wUSn2 BE0010 2025-12-02T14:14:02.209Z 2025-12-05T14:32:49.468Z
8656835 8656835 20251130051327_cvi8X BE0010 2025-12-01T14:29:11.960Z 2025-12-05T14:45:22.200Z
8656401 8656401 20251130045328_cAUlM BE0010 2025-12-01T14:28:36.187Z 2025-12-05T14:45:15.393Z
8654542 8654542 20251130031952_9P8FM BE0010 2025-12-01T14:25:34.181Z 2025-12-05T14:44:10.637Z
8650867 8650867 20251129214644_20U8Z BE0010 2025-12-01T14:17:23.862Z 2025-12-05T14:41:21.419Z
8646161 8646161 20251129011605_S322e BE0010 2025-11-30T14:25:17.771Z 2025-12-05T14:51:34.501Z
8646067 8646067 20251129005740_dzhge BE0010 2025-11-30T14:25:08.098Z 2025-12-05T14:51:32.232Z
8645999 8645999 20251129004624_t0GRy BE0010 2025-11-30T14:25:03.000Z 2025-12-05T14:51:30.762Z
8645935 8645935 20251129003105_DRwRN BE0010 2025-11-30T14:24:56.817Z 2025-12-05T14:51:28.856Z
8645930 8645930 20251129003000_wAZoJ BE0010 2025-11-30T14:24:56.338Z 2025-12-05T14:51:28.732Z
8645684 8645684 20251128232702_oVcjp BE0010 2025-11-30T14:24:23.646Z 2025-12-05T14:51:06.690Z
8645609 8645609 20251128230446_8l5Af BE0010 2025-11-30T14:24:16.459Z 2025-12-05T14:50:57.285Z
8645197 8645197 20251128204911_5Y3hL BE0010 2025-11-30T14:23:11.918Z 2025-12-05T14:50:32.846Z
8625394 8625394 20251125231645_WcwMR BE0010 2025-11-28T14:32:40.322Z 2025-12-04T15:07:52.120Z
8622831 8622831 20251126214311_LhOEB BE0010 2025-11-28T14:20:08.686Z 2025-12-05T15:03:15.650Z
8622797 8622797 20251126212602_jQiNe BE0010 2025-11-28T14:19:53.980Z 2025-12-05T15:03:11.357Z
8622663 8622663 20251126203309_WQUjF BE0010 2025-11-28T14:19:39.529Z 2025-12-05T15:03:04.749Z
8622072 8622072 20251126174346_w8gHA BE0010 2025-11-28T14:17:37.019Z 2025-12-05T15:02:51.557Z
8616095 8616095 20251126053848_gqnkK BE0010 2025-11-27T14:30:30.610Z 2025-12-04T15:11:35.699Z
8615431 8615431 20251126050318_hE9IB BE0010 2025-11-27T14:29:32.066Z 2025-12-04T15:11:28.826Z
8612820 8612820 20251126024918_94aaf BE0010 2025-11-27T14:24:52.438Z 2025-12-04T15:09:34.526Z
8612246 8612246 20251126022254_B2pct BE0010 2025-11-27T14:23:39.490Z 2025-12-04T15:09:28.535Z
8612159 8612159 20251126022006_59HBU BE0010 2025-11-27T14:23:34.177Z 2025-12-04T15:09:28.029Z
8611848 8611848 20251126020219_kVm5O BE0010 2025-11-27T14:22:58.513Z 2025-12-04T15:09:24.781Z
8611755 8611755 20251126015804_UsLSs BE0010 2025-11-27T14:22:35.904Z 2025-12-04T15:09:23.875Z
8611327 8611327 20251126013722_gbzZ3 BE0010 2025-11-27T14:21:52.015Z 2025-12-04T15:09:10.123Z
8609592 8609592 20251125234848_FpFPg BE0010 2025-11-27T14:18:27.877Z 2025-12-04T15:07:55.473Z
8609457 8609457 20251125234215_IEaLw BE0010 2025-11-27T14:18:13.143Z 2025-12-04T15:07:54.405Z
8609160 8609160 20251125231644_mKGZ7 BE0010 2025-11-27T14:17:37.749Z 2025-12-04T15:07:51.994Z
8608344 8608344 20251125220852_EgQvO BE0010 2025-11-27T14:15:43.281Z 2025-12-04T15:07:43.821Z
8608244 8608244 20251125220324_BfYOH BE0010 2025-11-27T14:15:36.792Z 2025-12-04T15:07:43.000Z
8608092 8608092 20251125214921_6qti3 BE0010 2025-11-27T14:15:17.575Z 2025-12-04T15:07:41.152Z
8608079 8608079 20251125214812_g5Rj5 BE0010 2025-11-27T14:15:16.035Z 2025-12-04T15:07:40.947Z
8606382 8606382 20251125184042_r6DHw BE0010 2025-11-27T14:09:59.261Z 2025-12-04T15:06:44.447Z
8599867 8599867 20251125022908_CggJq BE0010 2025-11-26T14:21:33.891Z 2025-12-02T15:08:32.505Z
8599496 8599496 20251125020833_XNvjI BE0010 2025-11-26T14:21:10.876Z 2025-12-02T15:08:27.058Z
8599463 8599463 20251125020651_O82Vy BE0010 2025-11-26T14:20:57.249Z 2025-12-02T15:08:24.486Z
8598630 8598630 20251125011101_3Fw9j BE0010 2025-11-26T14:19:22.139Z 2025-12-02T15:08:01.444Z
8598438 8598438 20251125005720_qkn9O BE0010 2025-11-26T14:19:06.029Z 2025-12-02T15:07:54.518Z
8597644 8597644 20251124235610_wKVhZ BE0010 2025-11-26T14:17:15.773Z 2025-12-02T15:07:38.649Z
8597207 8597207 20251124231405_v6eyY BE0010 2025-11-26T14:16:21.815Z 2025-12-02T15:07:24.308Z
8597133 8597133 20251124230436_qn3Oh BE0010 2025-11-26T14:16:14.546Z 2025-12-02T15:07:23.409Z
8597078 8597078 20251124225243_2HF16 BE0010 2025-11-26T14:15:56.896Z 2025-12-02T15:07:22.808Z
8596622 8596622 20251124214325_322Yz BE0010 2025-11-26T14:15:01.225Z 2025-12-02T15:07:03.538Z
8589829 8589829 20251124015818_PBpZK BE0010 2025-11-25T14:20:47.134Z 2025-12-02T15:12:37.091Z
8589134 8589134 20251124010629_glM4S BE0010 2025-11-25T14:19:07.792Z 2025-12-02T15:12:09.622Z
8589122 8589122 20251124010354_2R3LZ BE0010 2025-11-25T14:19:06.310Z 2025-12-02T15:12:09.075Z
8589040 8589040 20251124005553_ZUkRX BE0010 2025-11-25T14:18:54.842Z 2025-12-02T15:12:03.862Z
8588823 8588823 20251124003412_G03CU BE0010 2025-11-25T14:18:21.402Z 2025-12-02T15:11:56.538Z
8588503 8588503 20251124000258_VeMXs BE0010 2025-11-25T14:17:40.090Z 2025-12-02T15:11:47.751Z
8587503 8587503 20251123221033_UeGME BE0010 2025-11-25T14:15:24.521Z 2025-12-02T15:11:16.461Z
8586681 8586681 20251123203026_YPEKX BE0010 2025-11-25T14:13:35.890Z 2025-12-02T15:10:58.768Z
8585784 8585784 20251123174321_DZPTk BE0010 2025-11-25T14:10:50.342Z 2025-12-02T15:10:20.402Z
8573742 8573742 20251122040127_GvY5v BE0010 2025-11-23T14:41:57.069Z 2025-11-30T15:06:36.630Z
8573606 8573606 20251122034230_5tLv6 BE0010 2025-11-23T14:41:25.864Z 2025-11-30T15:06:32.658Z
8573441 8573441 20251122031212_WX3Zg BE0010 2025-11-23T14:41:11.706Z 2025-11-30T15:06:24.533Z
8573404 8573404 20251122030754_IZUxO BE0010 2025-11-23T14:41:10.436Z 2025-11-30T15:06:22.500Z
8573373 8573373 20251122030135_fYmEv BE0010 2025-11-23T14:41:08.487Z 2025-11-30T15:06:19.540Z
8573346 8573346 20251122025908_2uGTT BE0010 2025-11-23T14:41:06.971Z 2025-11-30T15:06:16.457Z
8573336 8573336 20251122025806_aM118 BE0010 2025-11-23T14:41:06.606Z 2025-11-30T15:06:16.282Z
8573233 8573233 20251122024404_zHhge BE0010 2025-11-23T14:41:01.607Z 2025-11-30T15:06:12.613Z
8572989 8572989 20251122021424_Byc8A BE0010 2025-11-23T14:40:31.548Z 2025-11-30T15:06:08.083Z
8572987 8572987 20251122021350_cHiHf BE0010 2025-11-23T14:40:31.215Z 2025-11-30T15:06:07.974Z
8572956 8572956 20251122020904_lWipi BE0010 2025-11-23T14:40:21.038Z 2025-11-30T15:06:07.168Z
8572949 8572949 20251122020836_WeQHh BE0010 2025-11-23T14:40:14.858Z 2025-11-30T15:06:07.139Z
8572919 8572919 20251122020023_LpkmH BE0010 2025-11-23T14:40:07.086Z 2025-11-30T15:06:06.211Z
8572783 8572783 20251122014138_nGYPU BE0010 2025-11-23T14:39:43.509Z 2025-11-30T15:06:00.734Z
8572775 8572775 20251122014045_50kuJ BE0010 2025-11-23T14:39:43.261Z 2025-11-30T15:05:58.290Z
8572715 8572715 20251122013332_97xND BE0010 2025-11-23T14:39:39.844Z 2025-11-30T15:05:56.834Z
8572619 8572619 20251122012020_vbaT2 BE0010 2025-11-23T14:39:34.884Z 2025-11-30T15:05:53.087Z
8572533 8572533 20251122010653_DV7Mb BE0010 2025-11-23T14:39:30.307Z 2025-11-30T15:05:51.560Z
8572518 8572518 20251122010421_30PW4 BE0010 2025-11-23T14:39:29.904Z 2025-11-30T15:05:51.504Z
8572385 8572385 20251122003418_lZe3X BE0010 2025-11-23T14:39:04.374Z 2025-11-30T15:05:47.875Z

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