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

315 rows where station_code = "BR001Q" 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
9085780 9085780 20251228040136_Ez5bu BR001Q 2025-12-30T14:39:22.479Z 2026-01-05T15:09:45.184Z
9051760 9051760 20251227001035_xJvWX BR001Q 2025-12-29T14:07:55.596Z 2026-01-04T15:24:51.569Z
9044977 9044977 20251223070709_WOYSt BR001Q 2025-12-28T14:53:00.767Z 2025-12-31T15:42:43.274Z
9044876 9044876 20251223062536_Vo7Tg BR001Q 2025-12-28T14:52:36.498Z 2025-12-31T15:42:41.654Z
9044713 9044713 20251223051411_qp41m BR001Q 2025-12-28T14:52:25.480Z 2025-12-31T15:42:38.792Z
9044574 9044574 20251223041619_9sZoa BR001Q 2025-12-28T14:51:51.449Z 2025-12-31T15:42:13.229Z
9044301 9044301 20251223005504_y2qiZ BR001Q 2025-12-28T14:49:26.900Z 2025-12-31T15:42:08.687Z
9037392 9037392 20251224065558_nsYPy BR001Q 2025-12-28T14:37:00.100Z 2025-12-28T14:48:35.551Z
9037380 9037380 20251224065212_Q4Xuw BR001Q 2025-12-28T14:36:58.584Z 2026-01-01T15:54:47.219Z
9037360 9037360 20251224064829_8emlD BR001Q 2025-12-28T14:36:57.150Z 2026-01-01T15:54:46.890Z
9037330 9037330 20251224064321_8WIzL BR001Q 2025-12-28T14:36:55.448Z 2026-01-01T15:54:46.641Z
9036787 9036787 20251224052533_dIZ29 BR001Q 2025-12-28T14:35:49.271Z 2026-01-01T15:54:40.291Z
9036665 9036665 20251224050154_R2ew2 BR001Q 2025-12-28T14:35:32.963Z 2026-01-01T15:54:38.369Z
9036520 9036520 20251224044138_1gCD8 BR001Q 2025-12-28T14:35:20.923Z 2026-01-01T15:54:36.830Z
9035991 9035991 20251224020221_qe5XE BR001Q 2025-12-28T14:33:45.325Z 2026-01-01T15:54:01.916Z
9032622 9032622 20251225064346_2IUc2 BR001Q 2025-12-28T14:23:17.561Z 2026-01-02T15:45:46.062Z
9032460 9032460 20251225062544_qPlOf BR001Q 2025-12-28T14:22:49.593Z 2026-01-02T15:45:43.935Z
9032451 9032451 20251225062511_HDIFr BR001Q 2025-12-28T14:22:48.877Z 2026-01-02T15:45:43.853Z
9032301 9032301 20251225061604_3EDxm BR001Q 2025-12-28T14:22:37.580Z 2026-01-02T15:45:41.552Z
9031113 9031113 20251225051709_Cb4Bg BR001Q 2025-12-28T14:20:10.887Z 2026-01-02T15:45:05.874Z
9029927 9029927 20251225042211_4knCZ BR001Q 2025-12-28T14:17:40.278Z 2026-01-02T15:44:48.103Z
9029665 9029665 20251225040723_SiNrp BR001Q 2025-12-28T14:16:59.448Z 2026-01-02T15:44:28.046Z
9029301 9029301 20251225034716_2tIJc BR001Q 2025-12-28T14:16:05.250Z 2026-01-02T15:44:20.263Z
9026793 9026793 20251225013419_Qf8fk BR001Q 2025-12-28T14:09:01.440Z 2026-01-02T15:43:02.406Z
9024616 9024616 20251224224425_GI83K BR001Q 2025-12-28T14:01:17.681Z 2026-01-02T15:42:02.073Z
9018441 9018441 20251220065332_EQLCQ BR001Q 2025-12-27T15:02:37.498Z 2025-12-29T15:23:40.667Z
9006636 9006636 20251221065350_En2yj BR001Q 2025-12-27T14:38:20.303Z 2025-12-27T14:38:20.303Z
9006091 9006091 20251221043535_si9md BR001Q 2025-12-27T14:36:49.097Z 2025-12-27T14:36:49.097Z
9005883 9005883 20251221034213_y9sN2 BR001Q 2025-12-27T14:36:07.606Z 2025-12-27T14:36:07.606Z
9005470 9005470 20251221014550_GQp3x BR001Q 2025-12-27T14:34:37.542Z 2025-12-27T14:34:37.542Z
9005401 9005401 20251221013103_tzEh2 BR001Q 2025-12-27T14:34:12.858Z 2025-12-27T14:34:12.858Z
9005211 9005211 20251221002232_PcjF2 BR001Q 2025-12-27T14:33:25.555Z 2025-12-27T14:33:25.555Z
8996174 8996174 20251222013609_1z31i BR001Q 2025-12-27T14:03:27.470Z 2025-12-30T15:45:44.815Z
8691780 8691780 20251206070529_BrrpL BR001Q 2025-12-07T14:00:37.290Z 2025-12-15T15:28:04.074Z
8658163 8658163 20251130070206_AJ80u BR001Q 2025-12-01T14:35:05.023Z 2025-12-08T14:56:48.486Z
8657407 8657407 20251130054228_ATQTD BR001Q 2025-12-01T14:34:22.529Z 2025-12-08T14:56:39.340Z
8656263 8656263 20251130044542_kGc5w BR001Q 2025-12-01T14:28:14.454Z 2025-12-08T14:56:09.833Z
8654225 8654225 20251130030442_wDAMn BR001Q 2025-12-01T14:24:59.892Z 2025-12-08T14:55:09.105Z
8654091 8654091 20251130025727_tdVKz BR001Q 2025-12-01T14:24:50.359Z 2025-12-08T14:55:07.353Z
8653897 8653897 20251130024706_BTuQm BR001Q 2025-12-01T14:24:27.127Z 2025-12-08T14:55:03.770Z
8653828 8653828 20251130024359_Lal25 BR001Q 2025-12-01T14:24:20.470Z 2025-12-08T14:55:02.582Z
8653615 8653615 20251130023025_SCeet BR001Q 2025-12-01T14:23:47.925Z 2025-12-08T14:54:59.666Z
8648263 8648263 20251129071640_Ah5Et BR001Q 2025-11-30T14:30:00.230Z 2025-12-07T14:59:31.064Z
8648161 8648161 20251129064947_dxNrN BR001Q 2025-11-30T14:29:41.880Z 2025-12-07T14:59:29.209Z
8647818 8647818 20251129053747_6IhOl BR001Q 2025-11-30T14:29:02.199Z 2025-12-07T14:59:20.269Z
8647813 8647813 20251129053558_GOkM2 BR001Q 2025-11-30T14:29:00.890Z 2025-12-07T14:59:20.209Z
8647202 8647202 20251129040302_YdVxd BR001Q 2025-11-30T14:27:49.605Z 2025-12-07T14:58:31.528Z
8647152 8647152 20251129035239_ywec7 BR001Q 2025-11-30T14:27:45.583Z 2025-12-07T14:58:30.346Z
8647103 8647103 20251129034340_7m3eV BR001Q 2025-11-30T14:27:41.227Z 2025-12-07T14:58:29.094Z
8646589 8646589 20251129022631_Y6Jxt BR001Q 2025-11-30T14:26:14.055Z 2025-12-07T14:58:14.303Z
8646493 8646493 20251129021118_zq3Z5 BR001Q 2025-11-30T14:26:04.504Z 2025-12-07T14:58:11.986Z
8553012 8553012 20251120044934_whHYb BR001Q 2025-11-22T14:33:16.743Z 2025-11-28T14:57:48.174Z
8552710 8552710 20251120042507_kXYm7 BR001Q 2025-11-22T14:32:39.705Z 2025-11-28T14:57:38.033Z
8552643 8552643 20251120042012_K8U97 BR001Q 2025-11-22T14:32:35.934Z 2025-11-28T14:57:35.893Z
8552372 8552372 20251120040341_RqXHB BR001Q 2025-11-22T14:32:21.248Z 2025-11-28T14:57:31.001Z
8551274 8551274 20251121003158_n212v BR001Q 2025-11-22T14:22:21.298Z 2025-11-29T14:54:28.548Z
8529305 8529305 20251119064652_l8P1b BR001Q 2025-11-20T14:44:50.164Z 2025-11-20T14:44:50.164Z
8529236 8529236 20251119061901_f20V1 BR001Q 2025-11-20T14:44:46.396Z 2025-11-27T15:13:23.314Z
8528941 8528941 20251119052839_wobND BR001Q 2025-11-20T14:44:21.028Z 2025-11-27T15:13:16.483Z
8528346 8528346 20251119040458_on3pG BR001Q 2025-11-20T14:42:41.456Z 2025-11-27T15:13:02.525Z
8527957 8527957 20251119031222_k53If BR001Q 2025-11-20T14:42:02.419Z 2025-11-27T15:12:42.014Z
8527843 8527843 20251119025910_YUUbo BR001Q 2025-11-20T14:41:59.119Z 2025-11-27T15:12:35.021Z
8440376 8440376 20251112061716_aXG7J BR001Q 2025-11-13T14:28:49.685Z 2025-11-20T15:25:49.231Z
8440373 8440373 20251112061708_IyFNw BR001Q 2025-11-13T14:28:49.468Z 2025-11-20T15:25:49.184Z
8440147 8440147 20251112053033_1axfJ BR001Q 2025-11-13T14:28:11.910Z 2025-11-20T15:25:42.740Z
8439043 8439043 20251112030553_aZotW BR001Q 2025-11-13T14:25:24.945Z 2025-11-20T15:24:56.926Z
8438265 8438265 20251112014103_OQfqq BR001Q 2025-11-13T14:23:12.762Z 2025-11-20T15:24:23.011Z
8438093 8438093 20251112012219_lZSwI BR001Q 2025-11-13T14:22:52.432Z 2025-11-20T15:24:13.645Z
8428169 8428169 20251111060102_PVmyx BR001Q 2025-11-12T14:30:01.145Z 2025-11-19T15:18:10.332Z
8427621 8427621 20251111045645_6ikt5 BR001Q 2025-11-12T14:28:50.291Z 2025-11-19T15:17:57.831Z
8415641 8415641 20251110060857_Vqd5Y BR001Q 2025-11-11T14:24:05.665Z 2025-11-18T15:21:31.440Z
8224921 8224921 20251024072202_qKdIC BR001Q 2025-10-26T12:42:55.725Z 2025-11-01T13:11:20.619Z
8224914 8224914 20251024072125_h30Gl BR001Q 2025-10-26T12:42:55.525Z 2025-11-01T13:11:20.593Z
8224906 8224906 20251024072021_w3Vh1 BR001Q 2025-10-26T12:42:55.200Z 2025-11-01T13:11:20.579Z
8224704 8224704 20251024070127_1g112 BR001Q 2025-10-26T12:42:35.330Z 2025-11-01T13:11:19.962Z
8224165 8224165 20251024060944_uQTV1 BR001Q 2025-10-26T12:41:19.446Z 2025-11-01T13:11:18.500Z
8224043 8224043 20251024055813_sfXiz BR001Q 2025-10-26T12:41:14.244Z 2025-11-01T13:11:18.027Z
8224000 8224000 20251024055323_RM7U2 BR001Q 2025-10-26T12:41:13.095Z 2025-11-01T13:11:17.956Z
8223360 8223360 20251024051841_nxKFR BR001Q 2025-10-26T12:40:48.306Z 2025-11-01T13:11:16.549Z
8223092 8223092 20251024050818_VKZZT BR001Q 2025-10-26T12:40:05.223Z 2025-11-01T13:11:15.752Z
8222431 8222431 20251024045117_VyS1Q BR001Q 2025-10-26T12:39:47.412Z 2025-11-01T13:11:14.448Z
8222167 8222167 20251024044423_jz7RD BR001Q 2025-10-26T12:39:41.648Z 2025-11-01T13:11:14.055Z
8220658 8220658 20251024040702_3Opka BR001Q 2025-10-26T12:37:59.474Z 2025-11-01T13:11:04.815Z
8220632 8220632 20251024040608_fwaJp BR001Q 2025-10-26T12:37:57.448Z 2025-11-01T13:11:04.724Z
8218917 8218917 20251024031622_SVG2g BR001Q 2025-10-26T12:35:30.904Z 2025-11-01T13:10:52.854Z
8218810 8218810 20251024031318_v2zkK BR001Q 2025-10-26T12:35:25.731Z 2025-11-01T13:10:51.671Z
8216026 8216026 20251024015007_JYnxh BR001Q 2025-10-26T12:31:43.419Z 2025-11-01T13:10:27.570Z
8214759 8214759 20251024010313_nki1u BR001Q 2025-10-26T12:29:25.269Z 2025-11-01T13:10:21.577Z
6869865 6869865 20250607075729_YfY2C BR001Q 2025-06-08T12:05:37.864Z 2025-06-15T12:27:11.747Z
6869716 6869716 20250607070413_SmilJ BR001Q 2025-06-08T12:05:06.966Z 2025-06-15T12:27:06.461Z
6861720 6861720 20250605070443_2va0v BR001Q 2025-06-06T12:08:03.801Z 2025-06-13T12:27:20.678Z
6849146 6849146 20250602071400_Hey4l BR001Q 2025-06-03T12:13:21.707Z 2025-06-10T12:29:38.032Z
6849038 6849038 20250602054421_IJGlq BR001Q 2025-06-03T12:12:53.860Z 2025-06-10T12:29:30.666Z
6849002 6849002 20250602050719_5qkNu BR001Q 2025-06-03T12:12:43.445Z 2025-06-10T12:29:29.239Z
6848985 6848985 20250602042235_nCnBu BR001Q 2025-06-03T12:12:40.037Z 2025-06-10T12:29:28.492Z
6848972 6848972 20250602035202_fkjeF BR001Q 2025-06-03T12:12:38.058Z 2025-06-10T12:29:28.136Z
6842863 6842863 20250601082439_3f2w9 BR001Q 2025-06-02T12:16:17.936Z 2025-06-09T12:46:49.187Z
6842811 6842811 20250601080603_ITh9T BR001Q 2025-06-02T12:16:10.660Z 2025-06-09T12:46:44.084Z
6842798 6842798 20250601080016_iclBv BR001Q 2025-06-02T12:16:08.874Z 2025-06-09T12:46:43.518Z
6842540 6842540 20250601062408_CoJls BR001Q 2025-06-02T12:15:24.754Z 2025-06-09T12:46:19.343Z

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