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

137 rows where station_code = "BR0005" 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
7309226 7309226 20250801075023_yJYN4 BR0005 2025-08-03T12:23:57.163Z 2025-08-09T13:08:00.532Z
7308109 7308109 20250801044222_Lb6aQ BR0005 2025-08-03T12:22:37.529Z 2025-08-09T13:07:31.571Z
7303863 7303863 20250801000219_u23PV BR0005 2025-08-03T12:18:11.904Z 2025-08-09T13:06:23.773Z
7303076 7303076 20250731232718_SqcEG BR0005 2025-08-03T12:17:13.889Z 2025-08-09T13:06:17.029Z
7294179 7294179 20250731055700_Tq3o8 BR0005 2025-08-02T12:21:41.794Z 2025-08-08T12:56:34.273Z
7293928 7293928 20250731052242_aydQX BR0005 2025-08-02T12:21:30.601Z 2025-08-08T12:56:33.857Z
7293646 7293646 20250731042857_8esEV BR0005 2025-08-02T12:21:13.039Z 2025-08-08T12:56:33.351Z
7293615 7293615 20250731042207_oeKIE BR0005 2025-08-02T12:21:12.105Z 2025-08-08T12:56:33.282Z
7293240 7293240 20250731024912_q7UUJ BR0005 2025-08-02T12:20:45.333Z 2025-08-08T12:56:32.621Z
7292777 7292777 20250731020649_QA4hs BR0005 2025-08-02T12:20:27.500Z 2025-08-08T12:56:31.722Z
7291059 7291059 20250731001736_6cWuM BR0005 2025-08-02T12:19:09.593Z 2025-08-08T12:56:28.136Z
7283037 7283037 20250731085819_gqZc5 BR0005 2025-08-02T12:02:14.919Z 2025-08-09T13:02:56.147Z
7283014 7283014 20250731085520_9se2M BR0005 2025-08-02T12:02:11.704Z 2025-08-09T13:02:55.849Z
7282972 7282972 20250731084910_3rcMf BR0005 2025-08-02T12:02:08.000Z 2025-08-09T13:02:55.690Z
7282742 7282742 20250731082002_KdUFV BR0005 2025-08-02T12:01:32.674Z 2025-08-09T13:02:51.926Z
7282685 7282685 20250731081419_qU68n BR0005 2025-08-02T12:01:26.806Z 2025-08-09T13:02:50.431Z
7282300 7282300 20250731072400_qAssC BR0005 2025-08-02T12:00:29.953Z 2025-08-09T13:02:43.745Z
7278886 7278886 20250730060547_SJl4N BR0005 2025-08-01T12:07:30.121Z 2025-08-07T12:49:19.922Z
7278585 7278585 20250730045506_X0rRq BR0005 2025-08-01T12:07:24.830Z 2025-08-07T12:49:17.732Z
7278563 7278563 20250730044826_BR6Hf BR0005 2025-08-01T12:07:24.481Z 2025-08-07T12:49:17.671Z
7278365 7278365 20250730022748_ElJBD BR0005 2025-08-01T12:07:03.800Z 2025-08-07T12:49:16.384Z
7278186 7278186 20250729235456_KVGu9 BR0005 2025-08-01T12:06:16.794Z 2025-08-07T12:49:03.927Z
7278167 7278167 20250729233716_kkbiP BR0005 2025-08-01T12:06:14.280Z 2025-08-07T12:49:01.982Z
7269165 7269165 20250730084223_k71lb BR0005 2025-08-01T12:00:57.833Z 2025-08-08T12:55:30.718Z
7269028 7269028 20250730082852_98hcN BR0005 2025-08-01T12:00:54.650Z 2025-08-08T12:55:30.359Z
7268676 7268676 20250730075911_tc4NE BR0005 2025-08-01T12:00:39.986Z 2025-08-08T12:55:28.366Z
7268654 7268654 20250730075746_sfvNB BR0005 2025-08-01T12:00:39.501Z 2025-08-08T12:55:27.760Z
7268626 7268626 20250730075558_2qdcy BR0005 2025-08-01T12:00:38.682Z 2025-08-08T12:55:27.595Z
6973022 6973022 20250625074640_OKqDD BR0005 2025-06-26T12:17:15.973Z 2025-07-03T13:01:59.546Z
6972751 6972751 20250625065123_GyvRp BR0005 2025-06-26T12:16:47.570Z 2025-07-03T13:01:51.177Z
6972728 6972728 20250625064519_dOnun BR0005 2025-06-26T12:16:38.053Z 2025-07-03T13:01:49.921Z
6972284 6972284 20250625045421_OPm3X BR0005 2025-06-26T12:15:34.533Z 2025-07-03T13:01:33.800Z
6972262 6972262 20250625044317_g4f0r BR0005 2025-06-26T12:15:30.798Z 2025-07-03T13:01:32.981Z
6972166 6972166 20250625040443_Z2oDX BR0005 2025-06-26T12:15:19.421Z 2025-07-03T13:01:30.685Z
6971817 6971817 20250625014712_89RzF BR0005 2025-06-26T12:14:20.724Z 2025-07-03T13:01:17.909Z
6970346 6970346 20250624230830_Fso8B BR0005 2025-06-26T12:09:57.201Z 2025-07-03T13:00:12.897Z
6965145 6965145 20250624081225_ik1G3 BR0005 2025-06-25T12:18:07.007Z 2025-07-02T12:49:11.009Z
6964860 6964860 20250624072604_mUDx7 BR0005 2025-06-25T12:17:24.453Z 2025-07-02T12:49:07.033Z
6964617 6964617 20250624064041_ablHm BR0005 2025-06-25T12:16:59.065Z 2025-07-02T12:49:03.873Z
6964607 6964607 20250624063730_JK3N9 BR0005 2025-06-25T12:16:53.313Z 2025-07-02T12:49:03.671Z
6964574 6964574 20250624062559_DG73n BR0005 2025-06-25T12:16:45.844Z 2025-07-02T12:49:03.324Z
6964489 6964489 20250624060659_BGGF8 BR0005 2025-06-25T12:16:31.972Z 2025-07-02T12:49:02.305Z
6964168 6964168 20250624042704_0jSkj BR0005 2025-06-25T12:15:38.941Z 2025-07-02T12:48:57.162Z
6964112 6964112 20250624035926_cYvf5 BR0005 2025-06-25T12:15:32.612Z 2025-07-02T12:48:56.221Z
6964056 6964056 20250624032833_DUTR8 BR0005 2025-06-25T12:15:25.878Z 2025-07-02T12:48:55.176Z
6964023 6964023 20250624025915_iWW3n BR0005 2025-06-25T12:15:20.263Z 2025-07-02T12:48:54.506Z
6963996 6963996 20250624024023_JB2qT BR0005 2025-06-25T12:15:00.745Z 2025-07-02T12:48:53.643Z
6963465 6963465 20250624010707_hSiiJ BR0005 2025-06-25T12:13:30.491Z 2025-07-02T12:48:44.756Z
6937625 6937625 20250621070012_f2cRH BR0005 2025-06-22T12:17:46.323Z 2025-06-29T12:36:53.611Z
6937419 6937419 20250621063056_k6QWf BR0005 2025-06-22T12:17:08.105Z 2025-06-29T12:36:51.739Z
6937123 6937123 20250621052012_GXks3 BR0005 2025-06-22T12:16:23.589Z 2025-06-29T12:36:47.819Z
6936926 6936926 20250621034340_miHZb BR0005 2025-06-22T12:15:46.871Z 2025-06-29T12:36:46.656Z
6936882 6936882 20250621030922_rrOvd BR0005 2025-06-22T12:15:37.273Z 2025-06-29T12:36:45.691Z
6916204 6916204 20250618055556_CwNIO BR0005 2025-06-19T12:18:50.104Z 2025-06-26T12:36:46.824Z
6903501 6903501 20250616043318_3RW3c BR0005 2025-06-17T12:18:59.936Z 2025-06-24T12:59:54.660Z
6903439 6903439 20250616040532_f1DU6 BR0005 2025-06-17T12:18:42.295Z 2025-06-24T12:59:53.760Z
6902781 6902781 20250615224618_bMUYU BR0005 2025-06-17T12:16:38.106Z 2025-06-24T12:59:10.557Z
6885940 6885940 20250613054357_Oav0y BR0005 2025-06-14T12:00:46.253Z 2025-06-22T12:38:24.776Z
6883940 6883940 20250612085327_LDVM2 BR0005 2025-06-13T12:02:18.211Z 2025-06-21T12:36:45.976Z
6883676 6883676 20250612060128_IYNBE BR0005 2025-06-13T12:01:15.373Z 2025-06-21T12:36:41.742Z
6881843 6881843 20250611072812_3vNWL BR0005 2025-06-12T12:02:09.833Z 2025-06-20T12:52:57.050Z
6881735 6881735 20250611051405_ww8if BR0005 2025-06-12T12:01:39.127Z 2025-06-20T12:52:50.976Z
6842856 6842856 20250601082206_FP4GY BR0005 2025-06-02T12:16:17.265Z 2025-06-09T12:46:48.660Z
6842824 6842824 20250601081047_xewJC BR0005 2025-06-02T12:16:12.889Z 2025-06-09T12:46:45.024Z
6842217 6842217 20250601020757_PHQOL BR0005 2025-06-02T12:14:17.915Z 2025-06-09T12:45:53.631Z
6828791 6828791 20250529223549_MQkmi BR0005 2025-05-31T12:16:45.253Z 2025-06-07T12:36:22.362Z
6825549 6825549 20250527231935_naByl BR0005 2025-05-30T12:25:36.397Z 2025-06-05T12:54:28.798Z
6825542 6825542 20250527225351_4KOpn BR0005 2025-05-30T12:25:30.689Z 2025-06-05T12:54:26.730Z
6825540 6825540 20250527215216_yYq33 BR0005 2025-05-30T12:25:17.994Z 2025-06-05T12:54:20.871Z
6825053 6825053 20250529082519_odYeh BR0005 2025-05-30T12:19:45.837Z 2025-06-06T13:02:55.491Z
6723562 6723562 20250514224712_AuxUZ BR0005 2025-05-16T12:00:52.010Z 2025-05-23T12:35:55.689Z
6707955 6707955 20250511075359_h7ba7 BR0005 2025-05-12T12:09:13.924Z 2025-05-19T12:36:58.979Z
6707796 6707796 20250511071242_R62TV BR0005 2025-05-12T12:08:51.701Z 2025-05-19T12:36:54.365Z
6707723 6707723 20250511064651_K8utp BR0005 2025-05-12T12:08:28.727Z 2025-05-19T12:36:52.079Z
6707705 6707705 20250511062909_AOlqi BR0005 2025-05-12T12:08:25.491Z 2025-05-19T12:36:51.586Z
6707683 6707683 20250511061853_8cHFS BR0005 2025-05-12T12:08:21.667Z 2025-05-19T12:36:50.817Z
6707573 6707573 20250511044328_dCpPc BR0005 2025-05-12T12:07:50.900Z 2025-05-19T12:36:47.289Z
6706445 6706445 20250511001722_OqV0K BR0005 2025-05-12T12:05:05.634Z 2025-05-19T12:36:15.934Z
6679961 6679961 20250507072926_KXs4R BR0005 2025-05-08T12:18:18.249Z 2025-05-15T12:37:59.602Z
6670860 6670860 20250506074527_9egTs BR0005 2025-05-07T12:19:15.991Z 2025-05-14T12:41:44.481Z
6670788 6670788 20250506055330_XFGez BR0005 2025-05-07T12:19:09.234Z 2025-05-14T12:41:41.808Z
6660492 6660492 20250505081516_uUsmg BR0005 2025-05-06T12:20:17.985Z 2025-05-13T12:39:00.474Z
6660460 6660460 20250505073746_12RZ3 BR0005 2025-05-06T12:20:13.287Z 2025-05-13T12:38:57.983Z
6648110 6648110 20250504083347_imU9W BR0005 2025-05-05T12:16:38.778Z 2025-05-12T12:35:17.827Z
6647954 6647954 20250504075558_zLhVk BR0005 2025-05-05T12:16:20.455Z 2025-05-12T12:35:16.184Z
6647732 6647732 20250504061140_XxEep BR0005 2025-05-05T12:15:40.447Z 2025-05-12T12:35:13.783Z
6630697 6630697 20250502070000_0epHo BR0005 2025-05-03T12:17:51.504Z 2025-05-10T12:37:35.169Z
6630667 6630667 20250502064306_56UtP BR0005 2025-05-03T12:17:48.485Z 2025-05-10T12:37:34.906Z
6620189 6620189 20250501000835_5c6ko BR0005 2025-05-02T12:13:57.186Z 2025-05-09T12:38:10.548Z
6614950 6614950 20250430034736_0aFLf BR0005 2025-05-01T12:19:38.156Z 2025-05-08T12:35:17.222Z
6614881 6614881 20250430032411_kGRwc BR0005 2025-05-01T12:19:34.680Z 2025-05-08T12:35:16.966Z
6606721 6606721 20250429085145_rOqpE BR0005 2025-04-30T12:23:44.707Z 2025-05-07T12:35:17.990Z
6606683 6606683 20250429083649_MdRCM BR0005 2025-04-30T12:23:42.682Z 2025-05-07T12:35:17.888Z
6606640 6606640 20250429082726_DfJSG BR0005 2025-04-30T12:23:40.265Z 2025-05-07T12:35:17.810Z
6606504 6606504 20250429074803_sNgv8 BR0005 2025-04-30T12:23:31.655Z 2025-05-07T12:35:17.113Z
6605993 6605993 20250429050155_0Wtaf BR0005 2025-04-30T12:22:34.189Z 2025-05-07T12:35:13.842Z
6605952 6605952 20250429044618_hqy77 BR0005 2025-04-30T12:22:31.589Z 2025-05-07T12:35:13.404Z
6605921 6605921 20250429044019_cYkVE BR0005 2025-04-30T12:22:30.176Z 2025-05-07T12:35:13.057Z
6603560 6603560 20250429004838_95qlB BR0005 2025-04-30T12:18:53.890Z 2025-05-07T12:34:59.666Z
6586707 6586707 20250427065115_WbEfe BR0005 2025-04-28T12:24:24.812Z 2025-05-05T12:31:35.042Z

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