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

80 rows where station_code = "CAWEC1" 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
9268655 9268655 20260128105849_qg2yW CAWEC1 2026-01-29T14:04:15.185Z 2026-01-29T14:04:15.185Z
9268561 9268561 20260128104648_AhGqt CAWEC1 2026-01-29T14:03:48.702Z 2026-01-29T14:03:48.702Z
9267912 9267912 20260127064920_9XCpX CAWEC1 2026-01-28T14:23:51.842Z 2026-01-29T14:35:53.468Z
9256000 9256000 20260124053624_8Ua7Q CAWEC1 2026-01-25T14:15:31.108Z 2026-01-29T14:48:17.498Z
9255393 9255393 20260124031826_MmnVM CAWEC1 2026-01-25T14:13:11.512Z 2026-01-29T14:47:27.972Z
9253239 9253239 20260124102159_tdPsr CAWEC1 2026-01-25T14:01:33.808Z 2026-01-29T14:40:29.368Z
9250150 9250150 20260123104944_nxCI6 CAWEC1 2026-01-24T14:01:27.747Z 2026-01-29T14:45:02.136Z
9184429 9184429 20260111112841_3pdlo CAWEC1 2026-01-12T14:20:35.589Z 2026-01-19T15:20:57.946Z
9184254 9184254 20260111110227_HXJ6H CAWEC1 2026-01-12T14:20:07.205Z 2026-01-19T15:20:30.485Z
9183447 9183447 20260111093134_0sU3U CAWEC1 2026-01-12T14:17:50.022Z 2026-01-19T15:19:39.937Z
9183111 9183111 20260111083830_8t2co CAWEC1 2026-01-12T14:16:48.993Z 2026-01-19T15:19:27.317Z
9177162 9177162 20260110075235_NSqKX CAWEC1 2026-01-11T14:11:05.669Z 2026-01-18T15:09:18.242Z
9060796 9060796 20251226001157_N4Vpx CAWEC1 2025-12-29T14:30:09.195Z 2026-01-03T15:33:08.883Z
9019192 9019192 20251220091226_pWvKx CAWEC1 2025-12-27T15:03:24.441Z 2025-12-29T15:24:30.144Z
9019015 9019015 20251220085249_yDc3A CAWEC1 2025-12-27T15:02:59.138Z 2025-12-29T15:24:27.723Z
8986286 8986286 20251218045624_SD2EJ CAWEC1 2025-12-26T14:37:33.972Z 2025-12-27T15:19:14.789Z
8986124 8986124 20251218042624_wpcOk CAWEC1 2025-12-26T14:37:02.790Z 2025-12-27T15:19:11.504Z
8949441 8949441 20251215000854_NO77n CAWEC1 2025-12-24T15:06:09.171Z 2025-12-24T15:06:09.171Z
8949092 8949092 20251214235231_76cg8 CAWEC1 2025-12-24T15:06:03.399Z 2025-12-24T15:06:03.399Z
8767498 8767498 20251212001350_UNkNk CAWEC1 2025-12-14T15:12:09.853Z 2025-12-20T14:25:25.751Z
8756862 8756862 20251212040517_EwT3b CAWEC1 2025-12-14T14:01:29.675Z 2025-12-21T14:17:20.773Z
8720833 8720833 20251211053643_82e9L CAWEC1 2025-12-12T14:04:20.088Z 2025-12-20T14:22:05.904Z
8712604 8712604 20251209002351_ullS7 CAWEC1 2025-12-10T14:14:26.349Z 2025-12-17T15:34:19.462Z
8709177 8709177 20251209065245_JS3iD CAWEC1 2025-12-10T14:01:44.005Z 2025-12-17T15:22:41.902Z
8708731 8708731 20251209052240_CgJFF CAWEC1 2025-12-10T14:00:35.563Z 2025-12-17T15:22:35.866Z
8708365 8708365 20251208041107_mI96D CAWEC1 2025-12-09T14:29:35.144Z 2025-12-16T15:13:21.996Z
8706780 8706780 20251207232824_vGv1C CAWEC1 2025-12-09T14:25:05.428Z 2025-12-16T15:12:36.458Z
8701474 8701474 20251208095315_gC4V4 CAWEC1 2025-12-09T14:05:13.967Z 2025-12-17T15:30:31.171Z
8701424 8701424 20251208094940_x8wP0 CAWEC1 2025-12-09T14:05:05.461Z 2025-12-17T15:30:23.587Z
8700900 8700900 20251208083902_eNiux CAWEC1 2025-12-09T14:02:54.708Z 2025-12-17T15:29:56.235Z
8700746 8700746 20251208080055_AYeYU CAWEC1 2025-12-09T14:02:18.159Z 2025-12-17T15:29:43.654Z
8700725 8700725 20251208075514_ueh3u CAWEC1 2025-12-09T14:02:14.532Z 2025-12-17T15:29:43.554Z
8700475 8700475 20251208064244_pMErY CAWEC1 2025-12-09T14:01:18.000Z 2025-12-17T15:29:41.367Z
8681720 8681720 20251203035027_9i4bR CAWEC1 2025-12-04T14:15:20.518Z 2025-12-11T14:46:36.726Z
8592793 8592793 20251124092505_Up5TI CAWEC1 2025-11-25T14:27:49.685Z 2025-12-02T15:13:07.541Z
8592742 8592742 20251124091616_J9RRN CAWEC1 2025-11-25T14:27:34.784Z 2025-12-02T15:13:06.975Z
8592652 8592652 20251124085317_4UC86 CAWEC1 2025-11-25T14:27:24.290Z 2025-12-02T15:13:06.085Z
8592618 8592618 20251124084509_LVr2j CAWEC1 2025-11-25T14:27:20.651Z 2025-12-02T15:13:05.770Z
8592591 8592591 20251124083818_V65r7 CAWEC1 2025-11-25T14:27:17.485Z 2025-12-02T15:13:05.468Z
8592559 8592559 20251124082226_jGoaC CAWEC1 2025-11-25T14:27:13.691Z 2025-12-02T15:13:05.274Z
8592517 8592517 20251124081028_Rbblr CAWEC1 2025-11-25T14:26:53.931Z 2025-12-02T15:13:04.713Z
8583371 8583371 20251124104552_8uJbV CAWEC1 2025-11-25T14:01:31.331Z 2025-12-02T15:05:29.325Z
8583350 8583350 20251124103914_oyw6P CAWEC1 2025-11-25T14:01:25.033Z 2025-12-02T15:05:29.079Z
8583302 8583302 20251124102535_jNGAS CAWEC1 2025-11-25T14:01:15.684Z 2025-12-02T15:05:28.425Z
8583236 8583236 20251124100624_PWBSD CAWEC1 2025-11-25T14:00:56.222Z 2025-12-02T15:05:27.397Z
8583201 8583201 20251124095847_uaauG CAWEC1 2025-11-25T14:00:43.873Z 2025-12-02T15:05:26.845Z
8583195 8583195 20251124095706_R5jPp CAWEC1 2025-11-25T14:00:41.663Z 2025-12-02T15:05:26.688Z
8580988 8580988 20251122091916_DhPe7 CAWEC1 2025-11-24T14:29:11.552Z 2025-11-30T15:07:19.066Z
8580980 8580980 20251122091605_lidlI CAWEC1 2025-11-24T14:29:10.829Z 2025-11-30T15:07:19.040Z
8574045 8574045 20251122050233_WiuOj CAWEC1 2025-11-23T14:42:13.289Z 2025-11-30T15:06:56.255Z
8554303 8554303 20251120092358_lcdKI CAWEC1 2025-11-22T14:35:00.235Z 2025-11-28T14:58:49.012Z
8551899 8551899 20251120032242_imPsD CAWEC1 2025-11-22T14:31:32.075Z 2025-11-28T14:57:17.798Z
8529746 8529746 20251119103834_vZh8f CAWEC1 2025-11-20T14:45:27.281Z 2025-11-27T15:13:38.675Z
8529538 8529538 20251119092817_7qLIr CAWEC1 2025-11-20T14:45:01.345Z 2025-11-27T15:13:32.731Z
8529077 8529077 20251119054556_23h7p CAWEC1 2025-11-20T14:44:39.700Z 2025-11-27T15:13:19.186Z
8517231 8517231 20251118102324_h3JrY CAWEC1 2025-11-19T14:42:58.137Z 2025-11-26T15:08:23.858Z
8517142 8517142 20251118100450_vdAy7 CAWEC1 2025-11-19T14:42:46.696Z 2025-11-26T15:08:23.330Z
8517140 8517140 20251118100442_nXdlY CAWEC1 2025-11-19T14:42:44.426Z 2025-11-26T15:08:22.604Z
8517002 8517002 20251118092922_m4KLs CAWEC1 2025-11-19T14:42:21.881Z 2025-11-26T15:08:17.445Z
8515464 8515464 20251118042821_ML3aM CAWEC1 2025-11-19T14:39:47.113Z 2025-11-26T15:08:01.258Z
8515434 8515434 20251118042616_uleSi CAWEC1 2025-11-19T14:39:45.834Z 2025-11-26T15:08:01.012Z
8515380 8515380 20251118042124_kY1Rz CAWEC1 2025-11-19T14:39:43.025Z 2025-11-26T15:08:00.692Z
8515349 8515349 20251118041554_2zh49 CAWEC1 2025-11-19T14:39:41.802Z 2025-11-26T15:08:00.505Z
8515171 8515171 20251118035235_kWNT6 CAWEC1 2025-11-19T14:38:58.367Z 2025-11-26T15:07:59.430Z
8515017 8515017 20251118033529_BmVlu CAWEC1 2025-11-19T14:38:37.351Z 2025-11-26T15:07:58.473Z
8514887 8514887 20251118032153_MkYAr CAWEC1 2025-11-19T14:38:31.782Z 2025-11-26T15:07:57.776Z
8496705 8496705 20251117045143_ecmhl CAWEC1 2025-11-18T14:27:54.756Z 2025-11-25T15:10:20.758Z
8483373 8483373 20251115082524_2H2nY CAWEC1 2025-11-17T14:31:21.955Z 2025-11-23T15:18:53.424Z
8468278 8468278 20251114233336_70M3e CAWEC1 2025-11-16T14:17:09.099Z 2025-11-23T15:17:15.211Z
8461890 8461890 20251114101423_O7ZnR CAWEC1 2025-11-15T14:25:00.918Z 2025-11-22T15:23:44.496Z
8461707 8461707 20251114095522_3zE2p CAWEC1 2025-11-15T14:24:47.108Z 2025-11-22T15:23:37.273Z
8461469 8461469 20251114092407_ODMeG CAWEC1 2025-11-15T14:24:18.762Z 2025-11-22T15:23:26.665Z
8461103 8461103 20251114083828_ekEWR CAWEC1 2025-11-15T14:23:36.047Z 2025-11-22T15:23:09.889Z
8461095 8461095 20251114083654_IB5Qm CAWEC1 2025-11-15T14:23:34.993Z 2025-11-22T15:23:09.600Z
8461056 8461056 20251114083103_2IbjW CAWEC1 2025-11-15T14:23:31.774Z 2025-11-22T15:23:02.027Z
8460565 8460565 20251114071913_LnJkO CAWEC1 2025-11-15T14:22:17.249Z 2025-11-22T15:22:41.952Z
8460538 8460538 20251114071343_U6iQl CAWEC1 2025-11-15T14:22:15.072Z 2025-11-22T15:22:41.144Z
8460371 8460371 20251114064637_vPQUl CAWEC1 2025-11-15T14:22:02.308Z 2025-11-22T15:22:34.894Z
8459942 8459942 20251114051348_cJANS CAWEC1 2025-11-15T14:20:53.869Z 2025-11-22T15:22:19.807Z
8458908 8458908 20251114020921_35BG0 CAWEC1 2025-11-15T14:18:14.673Z 2025-11-22T15:21:27.283Z

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