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 = "BE000G" 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
9262831 9262831 20260126033641_Ak3X8 BE000G 2026-01-27T14:15:37.384Z 2026-01-29T14:38:51.568Z
9262809 9262809 20260126031730_wFREN BE000G 2026-01-27T14:15:30.271Z 2026-01-29T14:38:49.446Z
9262802 9262802 20260126031625_So5gJ BE000G 2026-01-27T14:15:28.409Z 2026-01-29T14:38:48.895Z
9262789 9262789 20260126025616_NIdGo BE000G 2026-01-27T14:15:24.393Z 2026-01-29T14:38:47.649Z
9262775 9262775 20260126024130_ORupY BE000G 2026-01-27T14:15:15.526Z 2026-01-29T14:38:46.819Z
9262768 9262768 20260126022533_o5ErN BE000G 2026-01-27T14:15:11.399Z 2026-01-29T14:38:44.011Z
9262766 9262766 20260126022511_ZDkhW BE000G 2026-01-27T14:15:10.786Z 2026-01-29T14:38:43.447Z
9262764 9262764 20260126022322_EVcAv BE000G 2026-01-27T14:15:10.068Z 2026-01-29T14:38:41.873Z
9262760 9262760 20260126022142_RGo3x BE000G 2026-01-27T14:15:09.484Z 2026-01-29T14:38:41.708Z
9262755 9262755 20260126020958_sIqRU BE000G 2026-01-27T14:15:08.212Z 2026-01-29T14:38:41.383Z
9262691 9262691 20260126010607_yhGxy BE000G 2026-01-27T14:14:48.695Z 2026-01-29T14:38:34.872Z
9262619 9262619 20260125214452_eh7Jd BE000G 2026-01-27T14:14:20.830Z 2026-01-29T14:38:28.646Z
9262610 9262610 20260125212501_JnP5G BE000G 2026-01-27T14:14:10.565Z 2026-01-29T14:38:27.199Z
9260643 9260643 20260125061342_wfjx6 BE000G 2026-01-26T14:22:42.888Z 2026-01-29T14:44:33.081Z
9260588 9260588 20260125053849_b4E9b BE000G 2026-01-26T14:22:28.810Z 2026-01-29T14:44:28.992Z
9260508 9260508 20260125045815_HmESw BE000G 2026-01-26T14:22:01.756Z 2026-01-29T14:44:18.995Z
9260487 9260487 20260125044850_FAS2G BE000G 2026-01-26T14:21:57.589Z 2026-01-29T14:44:17.729Z
9260346 9260346 20260125035237_wfX2Y BE000G 2026-01-26T14:21:21.477Z 2026-01-29T14:44:07.124Z
9260315 9260315 20260125033637_nLk5v BE000G 2026-01-26T14:21:15.980Z 2026-01-29T14:44:05.315Z
9260308 9260308 20260125033412_Q2qm3 BE000G 2026-01-26T14:21:07.965Z 2026-01-29T14:44:04.898Z
9260304 9260304 20260125033051_MRYXq BE000G 2026-01-26T14:21:07.353Z 2026-01-29T14:44:04.740Z
9260280 9260280 20260125032416_yYuPi BE000G 2026-01-26T14:21:02.262Z 2026-01-29T14:44:03.639Z
9260270 9260270 20260125031843_h72Wl BE000G 2026-01-26T14:20:59.193Z 2026-01-29T14:44:03.005Z
9260228 9260228 20260125031129_xmxhZ BE000G 2026-01-26T14:20:52.421Z 2026-01-29T14:44:01.022Z
9260166 9260166 20260125025206_72FWW BE000G 2026-01-26T14:20:33.006Z 2026-01-29T14:43:52.345Z
9260162 9260162 20260125025111_VsmWx BE000G 2026-01-26T14:20:29.130Z 2026-01-29T14:43:52.010Z
9260158 9260158 20260125024815_3gIof BE000G 2026-01-26T14:20:27.668Z 2026-01-29T14:43:51.671Z
9260144 9260144 20260125024423_oqN52 BE000G 2026-01-26T14:20:25.483Z 2026-01-29T14:43:51.113Z
9259918 9259918 20260125011016_S2uaz BE000G 2026-01-26T14:19:17.095Z 2026-01-29T14:43:35.136Z
9259848 9259848 20260125004500_yJ3lz BE000G 2026-01-26T14:18:53.913Z 2026-01-29T14:43:25.405Z
9259799 9259799 20260125002335_nlUv4 BE000G 2026-01-26T14:18:38.083Z 2026-01-29T14:43:22.103Z
9259771 9259771 20260125000208_hm6O6 BE000G 2026-01-26T14:18:32.274Z 2026-01-29T14:43:18.294Z
9259769 9259769 20260125000202_0Omg0 BE000G 2026-01-26T14:18:31.579Z 2026-01-29T14:43:18.101Z
9259740 9259740 20260124234909_LiRZ2 BE000G 2026-01-26T14:18:20.673Z 2026-01-29T14:43:16.547Z
9259726 9259726 20260124234256_dC3BV BE000G 2026-01-26T14:18:17.393Z 2026-01-29T14:43:15.561Z
9259697 9259697 20260124232157_N7MeJ BE000G 2026-01-26T14:18:07.984Z 2026-01-29T14:43:13.633Z
9259657 9259657 20260124225935_3z7rr BE000G 2026-01-26T14:17:59.779Z 2026-01-29T14:43:11.526Z
9259620 9259620 20260124221850_01sFe BE000G 2026-01-26T14:17:43.957Z 2026-01-29T14:43:09.510Z
9259055 9259055 20260124183450_CuTy7 BE000G 2026-01-26T14:15:32.712Z 2026-01-29T14:42:28.302Z
9259033 9259033 20260124182713_UriIK BE000G 2026-01-26T14:15:29.252Z 2026-01-29T14:42:27.195Z
9259021 9259021 20260124182351_doipk BE000G 2026-01-26T14:15:27.263Z 2026-01-29T14:42:26.513Z
9255952 9255952 20260124053039_2Czfa BE000G 2026-01-25T14:15:18.984Z 2026-01-29T14:48:09.659Z
9255930 9255930 20260124052322_MzTuD BE000G 2026-01-25T14:15:10.819Z 2026-01-29T14:48:08.585Z
9255830 9255830 20260124050503_0ffm2 BE000G 2026-01-25T14:14:55.565Z 2026-01-29T14:48:00.248Z
9255679 9255679 20260124042944_NsbL4 BE000G 2026-01-25T14:14:16.956Z 2026-01-29T14:47:50.851Z
9252068 9252068 20260123005139_BLlhe BE000G 2026-01-24T14:14:16.813Z 2026-01-29T14:52:27.156Z
9252062 9252062 20260123005107_6Ep92 BE000G 2026-01-24T14:14:15.161Z 2026-01-29T14:52:26.877Z
9252046 9252046 20260123004507_y23G5 BE000G 2026-01-24T14:14:11.852Z 2026-01-29T14:52:25.806Z
9249671 9249671 20260122061538_dJwYk BE000G 2026-01-23T14:15:52.291Z 2026-01-29T14:58:48.748Z
9249652 9249652 20260122061057_fVcWr BE000G 2026-01-23T14:15:50.642Z 2026-01-29T14:58:48.000Z
9249641 9249641 20260122060922_RqUNx BE000G 2026-01-23T14:15:49.750Z 2026-01-29T14:58:47.615Z
9249256 9249256 20260122042534_L34Qj BE000G 2026-01-23T14:15:03.717Z 2026-01-29T14:58:19.954Z
9249219 9249219 20260122041441_rNjUg BE000G 2026-01-23T14:14:53.401Z 2026-01-29T14:58:17.674Z
9249092 9249092 20260122033349_wTULI BE000G 2026-01-23T14:14:34.142Z 2026-01-29T14:58:12.353Z
9249074 9249074 20260122032913_D5KLQ BE000G 2026-01-23T14:14:32.531Z 2026-01-29T14:58:11.553Z
9249001 9249001 20260122030512_ocNxU BE000G 2026-01-23T14:14:17.415Z 2026-01-29T14:58:07.995Z
9248992 9248992 20260122030511_e2oVd BE000G 2026-01-23T14:14:16.664Z 2026-01-29T14:58:07.586Z
9248921 9248921 20260122024422_mOeM2 BE000G 2026-01-23T14:14:06.867Z 2026-01-29T14:57:54.791Z
9248781 9248781 20260122020940_GWMNA BE000G 2026-01-23T14:13:51.121Z 2026-01-29T14:57:46.442Z
9248766 9248766 20260122020257_XToTr BE000G 2026-01-23T14:13:40.532Z 2026-01-29T14:57:45.664Z
9248738 9248738 20260122015837_gSELZ BE000G 2026-01-23T14:13:36.245Z 2026-01-29T14:57:44.164Z
9248733 9248733 20260122015649_Scbq0 BE000G 2026-01-23T14:13:35.499Z 2026-01-29T14:57:43.786Z
9248729 9248729 20260122015639_ck9D9 BE000G 2026-01-23T14:13:35.036Z 2026-01-29T14:57:43.642Z
9248615 9248615 20260122011029_GR1CH BE000G 2026-01-23T14:13:16.346Z 2026-01-29T14:57:36.842Z
9248531 9248531 20260122003025_2RnoW BE000G 2026-01-23T14:13:01.621Z 2026-01-29T14:57:25.264Z
9248399 9248399 20260121233304_Vi2fl BE000G 2026-01-23T14:12:43.470Z 2026-01-29T14:57:17.237Z
9248378 9248378 20260121232156_MOv1a BE000G 2026-01-23T14:12:40.173Z 2026-01-29T14:57:16.067Z
9248374 9248374 20260121231610_WyehW BE000G 2026-01-23T14:12:39.786Z 2026-01-29T14:57:15.975Z
9248330 9248330 20260121225618_fNAG8 BE000G 2026-01-23T14:12:31.290Z 2026-01-29T14:57:13.981Z
9248314 9248314 20260121225152_oakVe BE000G 2026-01-23T14:12:29.367Z 2026-01-29T14:57:13.407Z
9248304 9248304 20260121225035_P2ZXE BE000G 2026-01-23T14:12:27.897Z 2026-01-29T14:57:13.134Z
9248247 9248247 20260121222955_qUeP2 BE000G 2026-01-23T14:12:19.228Z 2026-01-29T14:57:09.892Z
9248213 9248213 20260121221555_rz6MC BE000G 2026-01-23T14:12:14.708Z 2026-01-29T14:57:08.637Z
9248103 9248103 20260121213423_9Obno BE000G 2026-01-23T14:11:56.511Z 2026-01-29T14:56:54.571Z
9247721 9247721 20260121193513_tuDRG BE000G 2026-01-23T14:10:58.602Z 2026-01-29T14:56:32.014Z
9247643 9247643 20260121192212_NtkMD BE000G 2026-01-23T14:10:39.542Z 2026-01-29T14:56:21.341Z
9243741 9243741 20260121051150_5MIys BE000G 2026-01-22T14:22:53.436Z 2026-01-29T15:05:25.679Z
9243603 9243603 20260121045104_F4ojU BE000G 2026-01-22T14:22:19.080Z 2026-01-29T15:05:19.574Z
9243579 9243579 20260121044847_fOwDj BE000G 2026-01-22T14:22:14.701Z 2026-01-29T15:05:18.479Z
9237199 9237199 20260120044841_XYQ4Q BE000G 2026-01-21T14:25:31.474Z 2026-01-28T15:01:02.311Z
9236918 9236918 20260120041900_I0LS8 BE000G 2026-01-21T14:24:30.010Z 2026-01-28T15:00:48.910Z
9235360 9235360 20260120010145_A0WNn BE000G 2026-01-21T14:18:41.684Z 2026-01-28T14:58:50.996Z
9235133 9235133 20260120003321_2Y436 BE000G 2026-01-21T14:17:41.767Z 2026-01-28T14:58:32.158Z
9234800 9234800 20260119232457_U8xZo BE000G 2026-01-21T14:16:10.782Z 2026-01-28T14:58:13.928Z
9234756 9234756 20260119231602_OXxa4 BE000G 2026-01-21T14:15:59.897Z 2026-01-28T14:58:04.676Z
9234462 9234462 20260119213427_xxJNc BE000G 2026-01-21T14:14:34.046Z 2026-01-28T14:57:47.898Z
9234313 9234313 20260119204349_N5Wj5 BE000G 2026-01-21T14:13:35.958Z 2026-01-28T14:57:28.460Z
9231034 9231034 20260119054758_M922i BE000G 2026-01-20T14:30:59.076Z 2026-01-27T15:05:54.142Z
9228616 9228616 20260118231037_v5mHK BE000G 2026-01-20T14:18:38.273Z 2026-01-27T15:02:10.975Z
9228507 9228507 20260118223826_qzgFJ BE000G 2026-01-20T14:18:04.814Z 2026-01-27T15:02:04.740Z
9228270 9228270 20260118210622_rB1hI BE000G 2026-01-20T14:16:59.145Z 2026-01-27T15:01:40.387Z
9228265 9228265 20260118210525_TvJav BE000G 2026-01-20T14:16:57.732Z 2026-01-27T15:01:39.721Z
9228243 9228243 20260118205559_mVhmW BE000G 2026-01-20T14:16:51.280Z 2026-01-27T15:01:35.918Z
9228114 9228114 20260118195720_ebYoU BE000G 2026-01-20T14:16:06.326Z 2026-01-27T15:01:27.232Z
9228043 9228043 20260118192653_eG26N BE000G 2026-01-20T14:15:42.493Z 2026-01-27T15:01:22.494Z
9227994 9227994 20260118190455_8ZYPx BE000G 2026-01-20T14:15:22.054Z 2026-01-27T15:01:10.180Z
9227907 9227907 20260118183223_kozgd BE000G 2026-01-20T14:14:49.773Z 2026-01-27T15:01:02.430Z
9227849 9227849 20260118181542_nMNNZ BE000G 2026-01-20T14:14:26.660Z 2026-01-27T15:00:58.399Z
9224784 9224784 20260118060338_9V6CM BE000G 2026-01-19T14:26:02.449Z 2026-01-26T15:03:49.069Z
9224520 9224520 20260118050623_34aQe BE000G 2026-01-19T14:24:43.348Z 2026-01-26T15:03:22.242Z

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