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

5,036 rows where station_code = "BR000F" 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
8683275 8683275 20251203064913_H5vBX BR000F 2025-12-04T14:19:03.237Z 2025-12-06T14:29:48.943Z
8683259 8683259 20251203064709_HxmQr BR000F 2025-12-04T14:19:00.835Z 2025-12-06T14:29:48.383Z
8682410 8682410 20251203052651_3p3JS BR000F 2025-12-04T14:17:07.299Z 2025-12-06T14:29:00.556Z
8677186 8677186 20251203070257_bhBvq BR000F 2025-12-04T14:00:17.924Z 2025-12-06T14:18:09.834Z
8677184 8677184 20251203070231_nt34Y BR000F 2025-12-04T14:00:17.445Z 2025-12-06T14:18:09.023Z
8668442 8668442 20251129045010_w2EIw BR000F 2025-12-02T14:48:23.693Z 2025-12-06T14:56:41.040Z
8668434 8668434 20251129040706_JcHf2 BR000F 2025-12-02T14:48:15.855Z 2025-12-06T14:56:34.095Z
8667960 8667960 20251130052922_gAzAE BR000F 2025-12-02T14:41:24.145Z 2025-12-06T14:49:44.651Z
8667835 8667835 20251130042238_2mFJq BR000F 2025-12-02T14:40:32.979Z 2025-12-06T14:49:28.772Z
8667797 8667797 20251130040705_G3ENO BR000F 2025-12-02T14:40:25.220Z 2025-12-06T14:49:25.160Z
8667492 8667492 20251130015504_Uk2ux BR000F 2025-12-02T14:38:42.076Z 2025-12-06T14:47:49.573Z
8667464 8667464 20251130014210_iFub9 BR000F 2025-12-02T14:38:20.383Z 2025-12-06T14:47:43.959Z
8658264 8658264 20251129060626_rFKVy BR000F 2025-12-01T14:46:01.212Z 2025-12-06T14:56:58.993Z
8658235 8658235 20251128234707_2jK8M BR000F 2025-12-01T14:44:08.009Z 2025-12-06T14:55:05.997Z
8658174 8658174 20251130071914_rUslx BR000F 2025-12-01T14:35:16.166Z 2025-12-06T14:50:30.275Z
8658172 8658172 20251130071457_AjQnk BR000F 2025-12-01T14:35:15.975Z 2025-12-06T14:50:30.106Z
8658170 8658170 20251130071301_2PoT7 BR000F 2025-12-01T14:35:15.032Z 2025-12-06T14:50:29.921Z
8658168 8658168 20251130070929_bTIFB BR000F 2025-12-01T14:35:14.154Z 2025-12-06T14:50:29.625Z
8657928 8657928 20251130062003_NQYqJ BR000F 2025-12-01T14:34:46.881Z 2025-12-06T14:50:24.467Z
8657920 8657920 20251130061836_ShGYH BR000F 2025-12-01T14:34:46.127Z 2025-12-06T14:50:24.178Z
8657515 8657515 20251130055048_4NVd3 BR000F 2025-12-01T14:34:31.794Z 2025-12-06T14:50:04.995Z
8657419 8657419 20251130054346_PB5YR BR000F 2025-12-01T14:34:24.804Z 2025-12-06T14:49:59.023Z
8657404 8657404 20251130054208_v9j0E BR000F 2025-12-01T14:34:22.305Z 2025-12-06T14:49:57.628Z
8657218 8657218 20251130053523_pkmhJ BR000F 2025-12-01T14:34:01.523Z 2025-12-06T14:49:46.046Z
8656351 8656351 20251130045123_2a3wt BR000F 2025-12-01T14:28:22.779Z 2025-12-06T14:49:33.955Z
8656069 8656069 20251130043438_EcdiD BR000F 2025-12-01T14:28:00.712Z 2025-12-06T14:49:30.263Z
8656018 8656018 20251130043056_D7CVC BR000F 2025-12-01T14:27:57.053Z 2025-12-06T14:49:29.817Z
8655992 8655992 20251130042851_KWeIb BR000F 2025-12-01T14:27:46.056Z 2025-12-06T14:49:29.585Z
8655975 8655975 20251130042824_i8yPA BR000F 2025-12-01T14:27:43.331Z 2025-12-06T14:49:29.489Z
8655612 8655612 20251130040915_mhUqF BR000F 2025-12-01T14:27:17.384Z 2025-12-01T14:27:17.384Z
8654803 8654803 20251130033325_RikOn BR000F 2025-12-01T14:26:03.303Z 2025-12-06T14:48:48.592Z
8654686 8654686 20251130032553_H2Nj5 BR000F 2025-12-01T14:25:44.217Z 2025-12-06T14:48:45.748Z
8653021 8653021 20251130015059_j3NOo BR000F 2025-12-01T14:22:39.143Z 2025-12-06T14:47:47.680Z
8652872 8652872 20251130014210_D7YQF BR000F 2025-12-01T14:22:18.819Z 2025-12-01T14:35:22.139Z
8648667 8648667 20251128042119_kDzWH BR000F 2025-11-30T14:37:30.685Z 2025-12-06T15:03:39.100Z
8648665 8648665 20251128041410_bR1Ej BR000F 2025-11-30T14:37:28.449Z 2025-12-06T15:03:34.154Z
8648661 8648661 20251128025603_oxZgY BR000F 2025-11-30T14:37:12.728Z 2025-12-06T15:02:53.579Z
8648659 8648659 20251128020041_Cysw4 BR000F 2025-11-30T14:36:43.117Z 2025-12-06T15:02:43.042Z
8648314 8648314 20251129072641_52PH5 BR000F 2025-11-30T14:30:03.184Z 2025-12-06T14:57:31.877Z
8648217 8648217 20251129070321_d5zsg BR000F 2025-11-30T14:29:58.190Z 2025-12-06T14:57:22.338Z
8648215 8648215 20251129070158_yERQd BR000F 2025-11-30T14:29:58.004Z 2025-12-06T14:57:21.783Z
8648208 8648208 20251129065743_id0Ob BR000F 2025-11-30T14:29:57.534Z 2025-12-06T14:57:19.587Z
8648184 8648184 20251129065258_kMACo BR000F 2025-11-30T14:29:54.492Z 2025-12-06T14:57:17.891Z
8648176 8648176 20251129065151_FRZv5 BR000F 2025-11-30T14:29:43.137Z 2025-12-06T14:57:17.624Z
8648125 8648125 20251129064050_cTzeL BR000F 2025-11-30T14:29:38.770Z 2025-12-06T14:57:14.143Z
8648046 8648046 20251129063112_a3nVM BR000F 2025-11-30T14:29:31.253Z 2025-12-06T14:57:10.494Z
8648040 8648040 20251129063020_bkvxL BR000F 2025-11-30T14:29:30.880Z 2025-12-06T14:57:09.283Z
8648034 8648034 20251129062900_pqS2r BR000F 2025-11-30T14:29:30.234Z 2025-12-06T14:57:08.311Z
8648014 8648014 20251129062345_6J7SW BR000F 2025-11-30T14:29:29.078Z 2025-12-06T14:57:06.578Z
8648012 8648012 20251129062141_iTzvg BR000F 2025-11-30T14:29:28.973Z 2025-12-06T14:57:06.497Z
8647101 8647101 20251129034315_yRFM2 BR000F 2025-11-30T14:27:40.941Z 2025-12-06T14:56:31.942Z
8646136 8646136 20251129011106_YG5Qh BR000F 2025-11-30T14:25:15.543Z 2025-12-06T14:55:36.051Z
8637604 8637604 20251128055927_3qCzS BR000F 2025-11-29T14:27:37.393Z 2025-12-06T15:04:01.702Z
8636748 8636748 20251128042202_xfUIy BR000F 2025-11-29T14:26:08.853Z 2025-12-06T15:03:39.515Z
8636653 8636653 20251128041506_RFJef BR000F 2025-11-29T14:25:55.368Z 2025-12-06T15:03:34.502Z
8636578 8636578 20251128040534_S3Yyl BR000F 2025-11-29T14:25:43.665Z 2025-12-06T15:03:31.372Z
8636568 8636568 20251128040525_WYDK0 BR000F 2025-11-29T14:25:43.190Z 2025-12-06T15:03:31.250Z
8636475 8636475 20251128034840_k0538 BR000F 2025-11-29T14:25:32.923Z 2025-12-06T15:03:19.986Z
8636436 8636436 20251128034611_I7JSq BR000F 2025-11-29T14:25:30.486Z 2025-12-06T15:03:18.716Z
8636350 8636350 20251128033755_IfBwb BR000F 2025-11-29T14:25:24.215Z 2025-12-06T15:03:08.980Z
8624959 8624959 20251127071758_g0xlq BR000F 2025-11-28T14:26:04.392Z 2025-12-05T15:05:34.445Z
8624946 8624946 20251127071443_QF3RA BR000F 2025-11-28T14:26:02.208Z 2025-12-05T15:05:33.136Z
8624727 8624727 20251127061910_CGzpG BR000F 2025-11-28T14:25:23.679Z 2025-12-05T15:05:25.092Z
8624725 8624725 20251127061816_ZcGQ6 BR000F 2025-11-28T14:25:23.334Z 2025-12-05T15:05:25.009Z
8624360 8624360 20251127042734_oFRCg BR000F 2025-11-28T14:24:32.255Z 2025-12-05T15:05:00.009Z
8624240 8624240 20251127034538_Q9sNN BR000F 2025-11-28T14:24:20.222Z 2025-12-05T15:04:55.757Z
8624238 8624238 20251127034536_tCmPF BR000F 2025-11-28T14:24:19.932Z 2025-12-05T15:04:55.741Z
8623931 8623931 20251127023004_b4Mv3 BR000F 2025-11-28T14:23:09.181Z 2025-12-05T15:04:26.432Z
8623534 8623534 20251127010123_vLPMs BR000F 2025-11-28T14:22:07.075Z 2025-12-05T15:03:58.708Z
8616912 8616912 20251126072108_yU1Yx BR000F 2025-11-27T14:32:00.256Z 2025-12-04T15:11:51.219Z
8616905 8616905 20251126071123_vnAFS BR000F 2025-11-27T14:31:59.537Z 2025-12-04T15:11:50.737Z
8616877 8616877 20251126065807_X3OEl BR000F 2025-11-27T14:31:57.124Z 2025-12-04T15:11:49.872Z
8615005 8615005 20251126044129_2BFuJ BR000F 2025-11-27T14:28:53.053Z 2025-12-04T15:11:25.152Z
8614204 8614204 20251126035754_FEkOv BR000F 2025-11-27T14:27:39.093Z 2025-12-04T15:10:31.512Z
8614177 8614177 20251126035548_A8Phb BR000F 2025-11-27T14:27:29.653Z 2025-12-04T15:10:27.342Z
8611135 8611135 20251126012329_Uh19v BR000F 2025-11-27T14:21:23.490Z 2025-12-04T15:08:52.101Z
8610839 8610839 20251126010930_g1hp2 BR000F 2025-11-27T14:20:52.637Z 2025-12-04T15:08:43.270Z
8609600 8609600 20251125235020_JNSpS BR000F 2025-11-27T14:18:29.991Z 2025-12-04T15:07:55.627Z
8574474 8574474 20251122070212_K7mDX BR000F 2025-11-23T14:43:37.147Z 2025-11-30T15:07:09.986Z
8574467 8574467 20251122065815_gKZaM BR000F 2025-11-23T14:43:36.735Z 2025-11-30T15:07:09.954Z
8574391 8574391 20251122061846_PZB7i BR000F 2025-11-23T14:43:24.182Z 2025-11-23T14:43:24.182Z
8574383 8574383 20251122061327_Vu4E6 BR000F 2025-11-23T14:43:21.168Z 2025-11-30T15:07:07.868Z
8574381 8574381 20251122061139_RpWmE BR000F 2025-11-23T14:43:20.982Z 2025-11-30T15:07:07.844Z
8574326 8574326 20251122055033_ZbCB5 BR000F 2025-11-23T14:43:06.266Z 2025-11-30T15:07:04.920Z
8574157 8574157 20251122051945_GkDJQ BR000F 2025-11-23T14:42:27.500Z 2025-11-23T14:42:27.500Z
8574096 8574096 20251122050859_MYAS5 BR000F 2025-11-23T14:42:17.829Z 2025-11-30T15:06:58.418Z
8573866 8573866 20251122042850_2ggcw BR000F 2025-11-23T14:42:04.502Z 2025-11-30T15:06:47.797Z
8573863 8573863 20251122042849_n8ZV4 BR000F 2025-11-23T14:42:04.370Z 2025-11-30T15:06:47.781Z
8573851 8573851 20251122042716_T8wt0 BR000F 2025-11-23T14:42:03.644Z 2025-11-30T15:06:44.856Z
8573507 8573507 20251122032240_Fu3Rs BR000F 2025-11-23T14:41:14.859Z 2025-11-30T15:06:28.848Z
8573043 8573043 20251122022126_4IUK0 BR000F 2025-11-23T14:40:41.181Z 2025-11-30T15:06:08.874Z
8569997 8569997 20251121065711_7TyD4 BR000F 2025-11-23T14:32:55.720Z 2025-11-29T14:54:51.156Z
8569981 8569981 20251121065359_Yf3GL BR000F 2025-11-23T14:32:54.375Z 2025-11-29T14:54:50.910Z
8569906 8569906 20251121062636_YbzLK BR000F 2025-11-23T14:32:49.304Z 2025-11-29T14:54:49.836Z
8569883 8569883 20251121062353_H8put BR000F 2025-11-23T14:32:43.867Z 2025-11-29T14:54:49.197Z
8569847 8569847 20251121061849_aPxZ6 BR000F 2025-11-23T14:32:31.292Z 2025-11-29T14:54:49.130Z
8569845 8569845 20251121061821_nIzXp BR000F 2025-11-23T14:32:31.102Z 2025-11-29T14:54:49.099Z
8569790 8569790 20251121061333_Zm7go BR000F 2025-11-23T14:32:28.790Z 2025-11-29T14:54:48.990Z
8568216 8568216 20251121050657_hybjz BR000F 2025-11-23T14:30:59.116Z 2025-11-29T14:54:46.383Z
8559656 8559656 20251121042039_83Pw5 BR000F 2025-11-22T14:42:00.831Z 2025-11-29T14:54:43.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