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

289 rows where station_code = "CAWEC2" 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
9633752 9633752 20260408043316_TgSyi CAWEC2 2026-04-09T12:28:30.532Z 2026-04-09T12:28:35.311Z
9633750 9633750 20260408043233_LJ8hT CAWEC2 2026-04-09T12:28:30.324Z 2026-04-09T12:28:35.310Z
9633740 9633740 20260408042158_llrkH CAWEC2 2026-04-09T12:28:29.387Z 2026-04-09T12:28:35.306Z
9633135 9633135 20260408030547_45tKt CAWEC2 2026-04-09T12:27:16.448Z 2026-04-09T12:28:35.166Z
9632336 9632336 20260408020648_rFa1S CAWEC2 2026-04-09T12:25:34.565Z 2026-04-09T12:28:34.984Z
9632294 9632294 20260408020534_9MOZ8 CAWEC2 2026-04-09T12:25:32.317Z 2026-04-09T12:28:34.978Z
9631880 9631880 20260408014005_6PrB7 CAWEC2 2026-04-09T12:24:45.187Z 2026-04-09T12:28:34.896Z
9625004 9625004 20260408091403_oa14e CAWEC2 2026-04-09T12:03:47.126Z 2026-04-09T12:03:47.126Z
9624971 9624971 20260408090529_nPbBI CAWEC2 2026-04-09T12:03:37.284Z 2026-04-09T12:03:37.284Z
9624838 9624838 20260408084305_gX8cU CAWEC2 2026-04-09T12:03:06.460Z 2026-04-09T12:03:06.460Z
9624810 9624810 20260408083215_UwdyW CAWEC2 2026-04-09T12:03:00.612Z 2026-04-09T12:03:00.612Z
9624773 9624773 20260408082703_gtTUv CAWEC2 2026-04-09T12:02:53.488Z 2026-04-09T12:02:53.488Z
9624756 9624756 20260408082410_8owJm CAWEC2 2026-04-09T12:02:50.260Z 2026-04-09T12:02:50.260Z
9624538 9624538 20260408073329_3mXS6 CAWEC2 2026-04-09T12:01:54.171Z 2026-04-09T12:01:54.171Z
9624524 9624524 20260408072846_9wce0 CAWEC2 2026-04-09T12:01:51.050Z 2026-04-09T12:01:51.050Z
9624522 9624522 20260408072738_XJHbz CAWEC2 2026-04-09T12:01:50.068Z 2026-04-09T12:01:50.068Z
9624489 9624489 20260408071343_TGbuB CAWEC2 2026-04-09T12:01:42.449Z 2026-04-09T12:01:42.449Z
9624375 9624375 20260408063002_BVYv6 CAWEC2 2026-04-09T12:01:13.413Z 2026-04-09T12:01:13.413Z
9624276 9624276 20260408055902_M7CeJ CAWEC2 2026-04-09T12:00:46.985Z 2026-04-09T12:00:46.985Z
9624134 9624134 20260408045458_VvrHR CAWEC2 2026-04-09T12:00:14.334Z 2026-04-09T12:00:14.334Z
9589287 9589287 20260328031019_b2Vi3 CAWEC2 2026-03-29T12:01:02.679Z 2026-04-06T12:37:18.384Z
9589142 9589142 20260328023216_rQerX CAWEC2 2026-03-29T12:00:45.978Z 2026-04-06T12:37:02.985Z
9588818 9588818 20260328012737_AqY1I CAWEC2 2026-03-29T12:00:18.920Z 2026-04-06T12:36:52.693Z
9586717 9586717 20260327091920_zxST6 CAWEC2 2026-03-28T12:03:50.108Z 2026-04-05T12:33:38.922Z
9582711 9582711 20260326090939_lWwVB CAWEC2 2026-03-27T12:06:34.562Z 2026-04-04T12:40:24.215Z
9582500 9582500 20260326080357_VqwSu CAWEC2 2026-03-27T12:05:58.988Z 2026-04-04T12:40:05.024Z
9577643 9577643 20260325075750_z8fyA CAWEC2 2026-03-26T12:05:44.206Z 2026-04-03T12:37:11.861Z
9577494 9577494 20260325064521_t3h0g CAWEC2 2026-03-26T12:05:16.750Z 2026-04-03T12:37:03.753Z
9577460 9577460 20260325062250_vxHNp CAWEC2 2026-03-26T12:05:12.308Z 2026-04-03T12:37:02.593Z
9577430 9577430 20260325060937_X2pRU CAWEC2 2026-03-26T12:05:07.546Z 2026-04-03T12:37:01.408Z
9572455 9572455 20260324090435_EK2Qn CAWEC2 2026-03-25T12:05:13.298Z 2026-04-02T12:35:25.513Z
9572364 9572364 20260324084316_Hee1y CAWEC2 2026-03-25T12:04:50.742Z 2026-04-02T12:35:21.612Z
9572281 9572281 20260324082711_F7SkQ CAWEC2 2026-03-25T12:04:33.494Z 2026-04-02T12:35:12.337Z
9572155 9572155 20260324075612_LJiq8 CAWEC2 2026-03-25T12:04:02.857Z 2026-04-02T12:35:05.638Z
9572095 9572095 20260324073227_MdSPH CAWEC2 2026-03-25T12:03:48.075Z 2026-04-02T12:35:03.114Z
9572091 9572091 20260324072848_aDIu2 CAWEC2 2026-03-25T12:03:46.553Z 2026-04-02T12:35:02.820Z
9572056 9572056 20260324071831_f9z0l CAWEC2 2026-03-25T12:03:37.585Z 2026-04-02T12:35:01.146Z
9571990 9571990 20260324065134_5DRFm CAWEC2 2026-03-25T12:03:26.607Z 2026-04-02T12:34:58.399Z
9571959 9571959 20260324062834_ne0pt CAWEC2 2026-03-25T12:03:21.390Z 2026-04-02T12:34:57.091Z
9571866 9571866 20260324052549_mOupJ CAWEC2 2026-03-25T12:03:02.023Z 2026-04-02T12:34:52.973Z
9571843 9571843 20260324050739_nUvF2 CAWEC2 2026-03-25T12:02:56.200Z 2026-04-02T12:34:51.598Z
9571841 9571841 20260324050500_LRLKN CAWEC2 2026-03-25T12:02:55.684Z 2026-04-02T12:34:51.494Z
9571810 9571810 20260324043450_SSZ3b CAWEC2 2026-03-25T12:02:47.421Z 2026-04-02T12:34:50.010Z
9571544 9571544 20260324024806_ddAa3 CAWEC2 2026-03-25T12:01:52.020Z 2026-04-02T12:34:31.273Z
9571519 9571519 20260324024322_Joqtr CAWEC2 2026-03-25T12:01:47.497Z 2026-04-02T12:34:30.311Z
9571327 9571327 20260324011538_QAeLX CAWEC2 2026-03-25T12:01:02.880Z 2026-04-02T12:34:20.219Z
9571257 9571257 20260324004756_84Rcc CAWEC2 2026-03-25T12:00:42.697Z 2026-04-02T12:34:17.033Z
9535095 9535095 20260320053407_lIH8Q CAWEC2 2026-03-21T12:09:43.695Z 2026-03-28T12:34:27.141Z
9535038 9535038 20260320051703_2eFWu CAWEC2 2026-03-21T12:09:34.020Z 2026-03-28T12:34:26.124Z
9533756 9533756 20260320025428_pn2EK CAWEC2 2026-03-21T12:06:11.670Z 2026-03-28T12:34:00.115Z
9533216 9533216 20260320021313_7bVRa CAWEC2 2026-03-21T12:04:49.222Z 2026-03-28T12:33:50.581Z
9471031 9471031 20260313084515_hCf4U CAWEC2 2026-03-14T12:09:12.303Z 2026-03-21T12:49:16.958Z
9470862 9470862 20260313080323_32YVs CAWEC2 2026-03-14T12:08:39.924Z 2026-03-21T12:49:14.892Z
9470781 9470781 20260313074018_iU4sp CAWEC2 2026-03-14T12:08:24.471Z 2026-03-21T12:49:13.559Z
9470725 9470725 20260313073140_j81P5 CAWEC2 2026-03-14T12:08:12.904Z 2026-03-21T12:49:12.703Z
9470673 9470673 20260313071437_UFKrx CAWEC2 2026-03-14T12:08:04.908Z 2026-03-21T12:49:11.803Z
9470646 9470646 20260313070618_7C6w9 CAWEC2 2026-03-14T12:08:01.384Z 2026-03-21T12:49:11.520Z
9470635 9470635 20260313070150_dpLc2 CAWEC2 2026-03-14T12:07:59.032Z 2026-03-21T12:49:11.382Z
9470606 9470606 20260313064519_clU38 CAWEC2 2026-03-14T12:07:53.115Z 2026-03-21T12:49:11.183Z
9470481 9470481 20260313060656_G4zU9 CAWEC2 2026-03-14T12:07:32.451Z 2026-03-21T12:49:10.258Z
9470463 9470463 20260313055700_JF7QJ CAWEC2 2026-03-14T12:07:29.182Z 2026-03-21T12:49:09.973Z
9470446 9470446 20260313055156_jRObs CAWEC2 2026-03-14T12:07:24.850Z 2026-03-21T12:49:09.567Z
9470323 9470323 20260313051033_5nVKt CAWEC2 2026-03-14T12:07:01.418Z 2026-03-21T12:49:07.427Z
9470238 9470238 20260313045829_sZ0s0 CAWEC2 2026-03-14T12:06:46.318Z 2026-03-21T12:49:06.944Z
9469968 9469968 20260313041210_m2lRS CAWEC2 2026-03-14T12:06:06.696Z 2026-03-21T12:49:04.586Z
9469780 9469780 20260313034416_D3c0i CAWEC2 2026-03-14T12:05:30.944Z 2026-03-21T12:49:02.271Z
9469757 9469757 20260313034024_ykrHl CAWEC2 2026-03-14T12:05:25.961Z 2026-03-21T12:49:01.926Z
9469509 9469509 20260313025922_nVs72 CAWEC2 2026-03-14T12:04:30.931Z 2026-03-21T12:48:40.529Z
9469459 9469459 20260313025231_JMjoy CAWEC2 2026-03-14T12:04:19.901Z 2026-03-21T12:48:39.745Z
9469213 9469213 20260313021412_GNUEh CAWEC2 2026-03-14T12:03:27.499Z 2026-03-21T12:48:35.256Z
9469172 9469172 20260313020650_vOJ8D CAWEC2 2026-03-14T12:03:14.510Z 2026-03-21T12:48:34.639Z
9452571 9452571 20260310103310_7MXGO CAWEC2 2026-03-11T12:05:41.776Z 2026-03-18T12:39:13.974Z
9452080 9452080 20260310073735_lOA2h CAWEC2 2026-03-11T12:04:40.283Z 2026-03-18T12:39:09.377Z
9452035 9452035 20260310062728_AtC1m CAWEC2 2026-03-11T12:04:32.249Z 2026-03-18T12:39:08.675Z
9452026 9452026 20260310061820_p5h5L CAWEC2 2026-03-11T12:04:30.436Z 2026-03-18T12:39:08.492Z
9451663 9451663 20260310031533_V223u CAWEC2 2026-03-11T12:03:28.790Z 2026-03-18T12:39:02.296Z
9451342 9451342 20260310015125_2TGIh CAWEC2 2026-03-11T12:02:31.643Z 2026-03-18T12:38:45.053Z
9451238 9451238 20260310012627_2OpWP CAWEC2 2026-03-11T12:02:12.692Z 2026-03-18T12:38:43.532Z
9446627 9446627 20260309022559_cds1d CAWEC2 2026-03-10T12:03:11.994Z 2026-03-17T12:41:40.406Z
9446335 9446335 20260309010633_Raz7A CAWEC2 2026-03-10T12:02:01.332Z 2026-03-17T12:41:36.640Z
9446330 9446330 20260309010551_ntga9 CAWEC2 2026-03-10T12:02:00.199Z 2026-03-17T12:41:36.556Z
9446201 9446201 20260309002304_AYQLt CAWEC2 2026-03-10T12:01:24.875Z 2026-03-17T12:41:34.554Z
9422534 9422534 20260304023013_3H1sB CAWEC2 2026-03-05T14:01:41.930Z 2026-03-12T12:32:30.612Z
9399383 9399383 20260226064052_c2cVl CAWEC2 2026-02-27T14:07:40.933Z 2026-03-06T14:44:17.863Z
9399379 9399379 20260226064001_8bqMn CAWEC2 2026-02-27T14:07:40.150Z 2026-03-06T14:44:17.712Z
9399363 9399363 20260226061931_vGL97 CAWEC2 2026-02-27T14:07:37.456Z 2026-03-06T14:44:17.045Z
9327930 9327930 20260215092108_h0Qiz CAWEC2 2026-02-16T14:06:34.885Z 2026-02-24T14:42:04.312Z
9324263 9324263 20260214102705_5yAwI CAWEC2 2026-02-15T14:09:40.055Z 2026-02-23T14:46:55.527Z
9320488 9320488 20260213104201_uPzHL CAWEC2 2026-02-14T14:07:00.291Z 2026-02-22T14:42:05.172Z
9320406 9320406 20260213100346_PioT9 CAWEC2 2026-02-14T14:06:29.448Z 2026-02-22T14:42:02.888Z
9320277 9320277 20260213091604_8efJF CAWEC2 2026-02-14T14:05:44.455Z 2026-02-22T14:41:52.146Z
9320275 9320275 20260213091240_AuoQI CAWEC2 2026-02-14T14:05:43.757Z 2026-02-22T14:41:52.105Z
9320230 9320230 20260213085346_kca8u CAWEC2 2026-02-14T14:05:26.679Z 2026-02-22T14:41:51.050Z
9320208 9320208 20260213084321_UheD5 CAWEC2 2026-02-14T14:05:19.188Z 2026-02-22T14:41:50.634Z
9320178 9320178 20260213080629_UkYuh CAWEC2 2026-02-14T14:05:04.256Z 2026-02-22T14:41:49.785Z
9320138 9320138 20260213074210_105Nx CAWEC2 2026-02-14T14:04:45.759Z 2026-02-22T14:41:48.040Z
9320104 9320104 20260213072246_kplRl CAWEC2 2026-02-14T14:04:30.747Z 2026-02-22T14:41:47.104Z
9320101 9320101 20260213072234_OzDzj CAWEC2 2026-02-14T14:04:29.949Z 2026-02-22T14:41:46.998Z
9320071 9320071 20260213071206_39llf CAWEC2 2026-02-14T14:04:17.468Z 2026-02-22T14:41:46.386Z
9320069 9320069 20260213071109_f2Lmk CAWEC2 2026-02-14T14:04:16.588Z 2026-02-22T14:41:46.263Z

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