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,860 rows where station_code = "BR001M" 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
8106093 8106093 20251015073126_BNgN3 BR001M 2025-10-16T12:21:24.746Z 2025-10-23T13:09:08.998Z
8105996 8105996 20251015071259_rnNCM BR001M 2025-10-16T12:21:12.755Z 2025-10-23T13:09:08.549Z
8105964 8105964 20251015070425_K2oKr BR001M 2025-10-16T12:21:08.848Z 2025-10-23T13:09:08.450Z
8105807 8105807 20251015063556_VdEBO BR001M 2025-10-16T12:20:33.756Z 2025-10-23T13:09:07.151Z
8105795 8105795 20251015063317_kcvlA BR001M 2025-10-16T12:20:32.363Z 2025-10-23T13:09:06.996Z
8105748 8105748 20251015062101_JESeU BR001M 2025-10-16T12:20:27.274Z 2025-10-23T13:09:06.486Z
8105599 8105599 20251015054613_v6Osc BR001M 2025-10-16T12:19:56.635Z 2025-10-23T13:09:05.260Z
8088206 8088206 20251012054128_S4qjI BR001M 2025-10-13T12:13:03.121Z 2025-10-20T13:03:56.329Z
8087813 8087813 20251012035122_LPZ4H BR001M 2025-10-13T12:12:05.431Z 2025-10-20T13:03:47.519Z
8087654 8087654 20251012032054_vvXJH BR001M 2025-10-13T12:11:33.482Z 2025-10-20T13:03:43.442Z
8087401 8087401 20251012023640_ahm4L BR001M 2025-10-13T12:10:52.157Z 2025-10-20T13:03:35.283Z
8086641 8086641 20251012000125_qd55k BR001M 2025-10-13T12:08:50.763Z 2025-10-20T13:03:28.299Z
8086208 8086208 20251011223113_raEbh BR001M 2025-10-13T12:07:51.575Z 2025-10-20T13:03:22.220Z
8067879 8067879 20251005073108_3Ki1E BR001M 2025-10-07T12:35:19.867Z 2025-10-13T12:34:20.926Z
8067825 8067825 20251005071323_RR8gy BR001M 2025-10-07T12:35:14.729Z 2025-10-13T12:34:18.905Z
8052177 8052177 20251001041524_Xb2eS BR001M 2025-10-04T12:52:46.696Z 2025-10-09T12:39:41.926Z
8049753 8049753 20251001073232_Bgwyl BR001M 2025-10-04T12:22:22.961Z 2025-10-10T12:35:47.451Z
8022088 8022088 20250930075906_iBW3s BR001M 2025-10-02T12:02:26.240Z 2025-10-09T12:34:27.849Z
8022056 8022056 20250930075229_B369t BR001M 2025-10-02T12:02:20.366Z 2025-10-09T12:34:25.106Z
8021783 8021783 20250930071411_PHrx2 BR001M 2025-10-02T12:00:50.997Z 2025-10-09T12:34:11.206Z
8021361 8021361 20250930052619_ocglI BR001M 2025-10-01T12:48:31.866Z 2025-10-08T12:44:13.420Z
8021281 8021281 20250930050700_UkzOS BR001M 2025-10-01T12:48:04.804Z 2025-10-08T12:44:11.475Z
8021220 8021220 20250930045521_KLvhd BR001M 2025-10-01T12:47:59.791Z 2025-10-08T12:44:09.578Z
8021210 8021210 20250930045339_CFqZm BR001M 2025-10-01T12:47:59.488Z 2025-10-08T12:44:09.532Z
8020679 8020679 20250930040245_6JkBy BR001M 2025-10-01T12:47:28.598Z 2025-10-08T12:43:59.322Z
7997644 7997644 20250928045143_TBNWx BR001M 2025-09-29T12:28:47.830Z 2025-10-05T13:07:57.143Z
7997523 7997523 20250928042034_Sflne BR001M 2025-09-29T12:28:37.691Z 2025-10-05T13:07:54.368Z
7990330 7990330 20250928075222_J3wju BR001M 2025-09-29T12:01:20.401Z 2025-10-07T12:59:21.616Z
7990315 7990315 20250928074156_tF25s BR001M 2025-09-29T12:01:16.931Z 2025-10-07T12:59:21.402Z
7990234 7990234 20250928070825_F3AN4 BR001M 2025-09-29T12:00:54.585Z 2025-10-07T12:59:18.858Z
7986052 7986052 20250927045458_TF3u7 BR001M 2025-09-28T12:27:34.595Z 2025-10-05T13:11:23.895Z
7985645 7985645 20250927034134_83tqk BR001M 2025-09-28T12:26:42.455Z 2025-10-05T13:11:18.146Z
7975996 7975996 20250927080026_9aKLy BR001M 2025-09-28T12:03:19.389Z 2025-10-05T13:04:26.076Z
7975925 7975925 20250927075106_bXA0o BR001M 2025-09-28T12:02:58.587Z 2025-10-05T13:04:23.427Z
7975852 7975852 20250927073740_jiayl BR001M 2025-09-28T12:02:43.942Z 2025-10-05T13:04:22.333Z
7975664 7975664 20250927064922_W2pc7 BR001M 2025-09-28T12:01:47.681Z 2025-10-05T13:04:12.141Z
7975575 7975575 20250927062941_6ZKeR BR001M 2025-09-28T12:01:19.987Z 2025-10-05T13:04:10.197Z
7975546 7975546 20250927062544_WECxK BR001M 2025-09-28T12:01:13.306Z 2025-10-05T13:04:09.494Z
7975485 7975485 20250927060331_yDhL1 BR001M 2025-09-28T12:00:59.093Z 2025-10-05T13:04:08.438Z
7975466 7975466 20250927055629_8MdmK BR001M 2025-09-28T12:00:52.490Z 2025-10-05T13:04:08.221Z
7975378 7975378 20250927052808_mrnDF BR001M 2025-09-28T12:00:33.727Z 2025-10-05T13:04:05.602Z
7975265 7975265 20250927050038_nJOU4 BR001M 2025-09-28T12:00:07.560Z 2025-10-05T13:03:57.558Z
7949102 7949102 20250924013355_3XeRp BR001M 2025-09-25T12:33:14.577Z 2025-10-02T13:27:19.719Z
7948531 7948531 20250924010727_2bLlm BR001M 2025-09-25T12:32:23.651Z 2025-10-02T13:27:09.871Z
7882559 7882559 20250919000920_FhoMP BR001M 2025-09-20T12:36:42.125Z 2025-09-27T12:47:53.470Z
7875057 7875057 20250919055134_sBSnK BR001M 2025-09-20T12:13:15.325Z 2025-09-28T12:53:24.323Z
7875041 7875041 20250919054806_fo777 BR001M 2025-09-20T12:13:12.518Z 2025-09-28T12:53:24.237Z
7874861 7874861 20250919043411_21NZC BR001M 2025-09-20T12:12:29.493Z 2025-09-28T12:53:21.900Z
7874369 7874369 20250919034032_QFo25 BR001M 2025-09-20T12:10:31.955Z 2025-09-28T12:53:18.261Z
7866703 7866703 20250918045427_bIZ2t BR001M 2025-09-19T12:11:31.563Z 2025-09-27T12:46:35.534Z
7866619 7866619 20250918042241_D30mV BR001M 2025-09-19T12:11:02.114Z 2025-09-27T12:46:33.790Z
7866491 7866491 20250918040140_SG1Ym BR001M 2025-09-19T12:10:35.185Z 2025-09-27T12:46:32.121Z
7866446 7866446 20250918035324_oVxde BR001M 2025-09-19T12:10:12.298Z 2025-09-27T12:46:31.790Z
7866311 7866311 20250918033700_dwaHv BR001M 2025-09-19T12:09:46.406Z 2025-09-27T12:46:29.102Z
7858663 7858663 20250917065624_ajB7f BR001M 2025-09-18T12:11:58.141Z 2025-09-25T13:11:09.334Z
7858634 7858634 20250917064555_1FUID BR001M 2025-09-18T12:11:46.324Z 2025-09-25T13:11:09.101Z
7858387 7858387 20250917055751_hWPRA BR001M 2025-09-18T12:10:38.392Z 2025-09-25T13:11:05.071Z
7858361 7858361 20250917055227_8PBGY BR001M 2025-09-18T12:10:28.689Z 2025-09-25T13:11:04.857Z
7858323 7858323 20250917054744_kDdfn BR001M 2025-09-18T12:10:21.884Z 2025-09-25T13:11:04.000Z
7858171 7858171 20250917050944_2K8Jk BR001M 2025-09-18T12:09:39.427Z 2025-09-25T13:10:58.523Z
7858156 7858156 20250917050647_l7LwI BR001M 2025-09-18T12:09:35.400Z 2025-09-25T13:10:58.208Z
7858121 7858121 20250917045600_Ryxlq BR001M 2025-09-18T12:09:19.323Z 2025-09-25T13:10:57.440Z
7857806 7857806 20250917032719_MxT5m BR001M 2025-09-18T12:07:43.442Z 2025-09-25T13:10:49.016Z
7836551 7836551 20250914065740_EFTQM BR001M 2025-09-16T12:24:16.926Z 2025-09-22T13:07:37.684Z
7836395 7836395 20250914055413_14SVa BR001M 2025-09-16T12:23:50.305Z 2025-09-22T13:07:35.824Z
7836236 7836236 20250914050826_HLEmF BR001M 2025-09-16T12:23:34.813Z 2025-09-22T13:07:34.370Z
7836167 7836167 20250914044219_GJ27Z BR001M 2025-09-16T12:23:28.314Z 2025-09-22T13:07:33.818Z
7835942 7835942 20250914033859_JNwRW BR001M 2025-09-16T12:22:43.326Z 2025-09-22T13:07:22.512Z
7835625 7835625 20250914014237_LCsB8 BR001M 2025-09-16T12:21:03.344Z 2025-09-22T13:06:57.355Z
7835609 7835609 20250914013548_khf2A BR001M 2025-09-16T12:20:50.327Z 2025-09-22T13:06:54.919Z
7835489 7835489 20250914004612_E9YN1 BR001M 2025-09-16T12:20:10.519Z 2025-09-22T13:06:43.198Z
7833999 7833999 20250915080228_JOdww BR001M 2025-09-16T12:14:31.558Z 2025-09-22T13:03:18.963Z
7833922 7833922 20250915074649_3Cc1k BR001M 2025-09-16T12:14:19.208Z 2025-09-22T13:03:16.113Z
7833896 7833896 20250915074007_UPycD BR001M 2025-09-16T12:14:14.362Z 2025-09-22T13:03:14.999Z
7830473 7830473 20250914231459_xvckm BR001M 2025-09-16T12:01:21.509Z 2025-09-22T13:01:51.722Z
7811835 7811835 20250912015438_POckM BR001M 2025-09-13T12:11:01.999Z 2025-09-20T13:01:47.275Z
7800833 7800833 20250910065523_HgPbe BR001M 2025-09-11T12:10:14.600Z 2025-09-18T12:59:41.095Z
7800798 7800798 20250910062945_ff8Kk BR001M 2025-09-11T12:10:07.646Z 2025-09-18T12:59:40.405Z
7800783 7800783 20250910061838_Ws9c9 BR001M 2025-09-11T12:10:04.629Z 2025-09-18T12:59:40.318Z
7800734 7800734 20250910053610_lhWEc BR001M 2025-09-11T12:09:57.054Z 2025-09-18T12:59:40.064Z
7800647 7800647 20250910043432_HWxUQ BR001M 2025-09-11T12:09:29.189Z 2025-09-18T12:59:38.415Z
7800516 7800516 20250910035127_XghZP BR001M 2025-09-11T12:09:02.809Z 2025-09-18T12:59:35.009Z
7800280 7800280 20250910023936_1CT09 BR001M 2025-09-11T12:08:00.943Z 2025-09-18T12:59:32.299Z
7799690 7799690 20250910003118_AM4jb BR001M 2025-09-11T12:05:41.652Z 2025-09-18T12:59:20.809Z
7799562 7799562 20250910000726_E3PmG BR001M 2025-09-11T12:05:09.544Z 2025-09-18T12:59:18.295Z
7799458 7799458 20250909233936_aB1wI BR001M 2025-09-11T12:04:42.987Z 2025-09-18T12:59:17.259Z
7799216 7799216 20250909223208_rtwNi BR001M 2025-09-11T12:03:39.757Z 2025-09-18T12:59:12.912Z
7774909 7774909 20250905074127_xyWNC BR001M 2025-09-06T13:20:55.466Z 2025-09-06T13:36:14.479Z
7768624 7768624 20250904222612_4U43v BR001M 2025-09-06T12:39:39.807Z 2025-09-13T12:55:40.803Z
7754752 7754752 20250902081959_vafnT BR001M 2025-09-04T12:30:06.264Z 2025-09-10T12:47:45.506Z
7754516 7754516 20250902072607_4tCX2 BR001M 2025-09-04T12:29:53.257Z 2025-09-10T12:47:42.716Z
7754448 7754448 20250902071312_WqfTt BR001M 2025-09-04T12:29:29.465Z 2025-09-10T12:47:41.855Z
7754353 7754353 20250902062512_0a2Nf BR001M 2025-09-04T12:29:13.629Z 2025-09-10T12:47:40.546Z
7754314 7754314 20250902060348_ZG431 BR001M 2025-09-04T12:29:11.684Z 2025-09-10T12:47:40.172Z
7754239 7754239 20250902051131_UTOJ2 BR001M 2025-09-04T12:29:05.438Z 2025-09-10T12:47:39.401Z
7745504 7745504 20250831073645_joLDK BR001M 2025-09-03T12:42:12.268Z 2025-09-08T12:53:39.905Z
7745500 7745500 20250831065234_GtUoa BR001M 2025-09-03T12:42:07.284Z 2025-09-08T12:53:32.633Z
7745495 7745495 20250831063651_nz2C5 BR001M 2025-09-03T12:42:06.079Z 2025-09-08T12:53:28.038Z
7745489 7745489 20250831055534_2qckr BR001M 2025-09-03T12:41:57.592Z 2025-09-08T12:53:23.973Z
7745485 7745485 20250831045259_jA4AO BR001M 2025-09-03T12:41:50.968Z 2025-09-08T12:53:18.165Z

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