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

2,198 rows where station_code = "CA003D" 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
9268726 9268726 20260128110935_cSWOP CA003D 2026-01-29T14:04:34.573Z 2026-01-29T14:04:34.573Z
9268251 9268251 20260128093101_Y2pfO CA003D 2026-01-29T14:01:59.415Z 2026-01-29T14:01:59.415Z
9268138 9268138 20260128090129_EAfLT CA003D 2026-01-29T14:01:22.139Z 2026-01-29T14:01:22.139Z
9268085 9268085 20260128084441_ioD4h CA003D 2026-01-29T14:00:59.278Z 2026-01-29T14:00:59.278Z
9268061 9268061 20260128082700_snWJK CA003D 2026-01-29T14:00:49.474Z 2026-01-29T14:00:49.474Z
9267915 9267915 20260127064953_uhsZO CA003D 2026-01-28T14:23:52.099Z 2026-01-29T14:35:53.679Z
9267870 9267870 20260127062215_B4Agm CA003D 2026-01-28T14:23:38.604Z 2026-01-29T14:35:49.809Z
9267858 9267858 20260127061626_WCjIQ CA003D 2026-01-28T14:23:35.908Z 2026-01-29T14:35:49.022Z
9267775 9267775 20260127045508_3SNH1 CA003D 2026-01-28T14:23:15.638Z 2026-01-29T14:35:42.008Z
9267746 9267746 20260127044226_123g3 CA003D 2026-01-28T14:23:05.268Z 2026-01-29T14:35:35.941Z
9267727 9267727 20260127043549_bDxGw CA003D 2026-01-28T14:23:01.076Z 2026-01-29T14:35:34.533Z
9263416 9263416 20260127074424_9nBcP CA003D 2026-01-28T14:00:24.333Z 2026-01-29T14:30:16.491Z
9260360 9260360 20260125035849_IA0co CA003D 2026-01-26T14:21:23.856Z 2026-01-29T14:44:07.926Z
9260016 9260016 20260125020626_VyGZJ CA003D 2026-01-26T14:19:47.460Z 2026-01-29T14:43:41.547Z
9259990 9259990 20260125014617_ZdcNY CA003D 2026-01-26T14:19:41.457Z 2026-01-29T14:43:39.624Z
9259960 9259960 20260125013150_nthFH CA003D 2026-01-26T14:19:33.776Z 2026-01-29T14:43:37.209Z
9259737 9259737 20260124234542_xHICl CA003D 2026-01-26T14:18:19.647Z 2026-01-29T14:43:16.270Z
9256431 9256431 20260124083037_hYfvB CA003D 2026-01-25T14:17:06.775Z 2026-01-29T14:48:49.974Z
9256357 9256357 20260124074225_cGoTF CA003D 2026-01-25T14:16:46.498Z 2026-01-29T14:48:44.657Z
9256302 9256302 20260124070513_5kh2N CA003D 2026-01-25T14:16:34.551Z 2026-01-29T14:48:36.071Z
9256290 9256290 20260124064645_DBrv0 CA003D 2026-01-25T14:16:31.595Z 2026-01-29T14:48:35.240Z
9256098 9256098 20260124055352_W8Yth CA003D 2026-01-25T14:15:50.557Z 2026-01-29T14:48:23.074Z
9256080 9256080 20260124055056_TbJsS CA003D 2026-01-25T14:15:44.008Z 2026-01-29T14:48:21.734Z
9256073 9256073 20260124054938_mooZ0 CA003D 2026-01-25T14:15:42.250Z 2026-01-29T14:48:21.174Z
9256048 9256048 20260124054742_aM0f0 CA003D 2026-01-25T14:15:38.706Z 2026-01-29T14:48:20.238Z
9255873 9255873 20260124050951_tPTaJ CA003D 2026-01-25T14:15:01.039Z 2026-01-29T14:48:02.465Z
9255738 9255738 20260124044152_pzAD3 CA003D 2026-01-25T14:14:30.719Z 2026-01-29T14:47:54.334Z
9255515 9255515 20260124035645_20TWO CA003D 2026-01-25T14:13:44.726Z 2026-01-29T14:47:35.535Z
9255416 9255416 20260124032531_Wva5M CA003D 2026-01-25T14:13:18.507Z 2026-01-29T14:47:29.326Z
9255342 9255342 20260124025716_I2zxz CA003D 2026-01-25T14:12:59.151Z 2026-01-29T14:47:24.873Z
9255214 9255214 20260124014907_yj3Zp CA003D 2026-01-25T14:12:23.977Z 2026-01-29T14:47:10.470Z
9255130 9255130 20260124010522_YI8M2 CA003D 2026-01-25T14:11:59.070Z 2026-01-29T14:47:03.833Z
9253334 9253334 20260124110201_F2vC0 CA003D 2026-01-25T14:02:07.236Z 2026-01-29T14:40:38.762Z
9253328 9253328 20260124105728_7No4H CA003D 2026-01-25T14:02:05.666Z 2026-01-29T14:40:38.040Z
9253317 9253317 20260124105344_2uOIo CA003D 2026-01-25T14:02:01.655Z 2026-01-29T14:40:37.110Z
9253310 9253310 20260124105039_murYy CA003D 2026-01-25T14:01:59.498Z 2026-01-29T14:40:36.692Z
9253302 9253302 20260124104915_NSsmw CA003D 2026-01-25T14:01:54.768Z 2026-01-29T14:40:35.737Z
9253277 9253277 20260124104138_YjgXi CA003D 2026-01-25T14:01:47.048Z 2026-01-29T14:40:32.127Z
9253205 9253205 20260124100934_2ofAi CA003D 2026-01-25T14:01:18.629Z 2026-01-29T14:40:26.584Z
9253169 9253169 20260124095202_dahVA CA003D 2026-01-25T14:01:06.066Z 2026-01-29T14:40:22.785Z
9253088 9253088 20260124091514_mYY32 CA003D 2026-01-25T14:00:36.031Z 2026-01-29T14:40:14.382Z
9253085 9253085 20260124090939_c4PxM CA003D 2026-01-25T14:00:34.897Z 2026-01-29T14:40:14.216Z
9253055 9253055 20260124085455_jV2Li CA003D 2026-01-25T14:00:24.307Z 2026-01-29T14:40:12.764Z
9253028 9253028 20260124083733_Gk0Kz CA003D 2026-01-25T14:00:10.508Z 2026-01-29T14:40:10.873Z
9238905 9238905 20260120101240_O6epo CA003D 2026-01-21T14:31:01.412Z 2026-01-28T15:03:06.171Z
9238583 9238583 20260120090850_X1Xls CA003D 2026-01-21T14:30:00.199Z 2026-01-28T15:02:39.755Z
9238581 9238581 20260120090733_nVtu4 CA003D 2026-01-21T14:29:59.832Z 2026-01-28T15:02:39.583Z
9228960 9228960 20260119002442_iInuh CA003D 2026-01-20T14:20:19.768Z 2026-01-27T15:02:45.313Z
9215463 9215463 20260116101805_3L0Ta CA003D 2026-01-17T14:25:40.280Z 2026-01-24T15:14:58.101Z
9215461 9215461 20260116101749_nDojo CA003D 2026-01-17T14:25:39.186Z 2026-01-24T15:14:57.845Z
9215327 9215327 20260116095438_ZZP35 CA003D 2026-01-17T14:25:11.636Z 2026-01-24T15:14:41.398Z
9215134 9215134 20260116092211_Jrfrm CA003D 2026-01-17T14:24:32.279Z 2026-01-24T15:14:31.781Z
9215096 9215096 20260116091649_aqX11 CA003D 2026-01-17T14:24:24.962Z 2026-01-24T15:14:30.282Z
9176859 9176859 20260110063312_0lYcG CA003D 2026-01-11T14:10:12.060Z 2026-01-18T15:09:05.242Z
9176778 9176778 20260110062031_GJ0rt CA003D 2026-01-11T14:09:57.544Z 2026-01-18T15:08:53.907Z
9175861 9175861 20260110040023_melU3 CA003D 2026-01-11T14:07:33.129Z 2026-01-18T15:08:11.064Z
9175765 9175765 20260110034331_iGgkE CA003D 2026-01-11T14:07:18.660Z 2026-01-18T15:08:07.406Z
9171944 9171944 20260109050928_awRj3 CA003D 2026-01-10T14:10:44.657Z 2026-01-17T15:24:44.153Z
9156392 9156392 20260104103225_yh0Zp CA003D 2026-01-06T14:39:31.041Z 2026-01-12T15:12:08.397Z
9156348 9156348 20260104095432_zS48E CA003D 2026-01-06T14:39:18.332Z 2026-01-12T15:12:06.073Z
9156288 9156288 20260104091719_Ctf8e CA003D 2026-01-06T14:39:10.362Z 2026-01-12T15:12:03.828Z
9156238 9156238 20260104085532_ntW0S CA003D 2026-01-06T14:39:03.612Z 2026-01-12T15:11:51.564Z
9156214 9156214 20260104082520_1SFhl CA003D 2026-01-06T14:38:59.025Z 2026-01-12T15:11:44.895Z
9156208 9156208 20260104081147_thaja CA003D 2026-01-06T14:38:47.871Z 2026-01-12T15:11:44.435Z
9128433 9128433 20260102112704_uh3eB CA003D 2026-01-03T14:15:21.651Z 2026-01-09T14:50:49.485Z
9128332 9128332 20260102075028_8KsDT CA003D 2026-01-03T14:14:35.501Z 2026-01-09T14:50:43.057Z
9128317 9128317 20260102071616_XS2vK CA003D 2026-01-03T14:14:25.951Z 2026-01-09T14:50:42.158Z
9128153 9128153 20260102062610_qINY3 CA003D 2026-01-03T14:13:40.623Z 2026-01-09T14:50:27.171Z
9122649 9122649 20260101111117_XnpEy CA003D 2026-01-02T14:14:14.199Z 2026-01-09T14:53:39.810Z
9122638 9122638 20260101110359_Y6JYn CA003D 2026-01-02T14:14:11.393Z 2026-01-09T14:53:39.029Z
9122636 9122636 20260101110346_YVfx7 CA003D 2026-01-02T14:14:10.826Z 2026-01-09T14:53:38.886Z
9122630 9122630 20260101110241_j7peX CA003D 2026-01-02T14:14:09.286Z 2026-01-09T14:53:38.613Z
9122579 9122579 20260101102307_OEogj CA003D 2026-01-02T14:13:51.579Z 2026-01-09T14:53:34.821Z
9117507 9117507 20251231111337_1fknW CA003D 2026-01-01T14:31:59.250Z 2026-01-08T15:13:11.046Z
9117422 9117422 20251231105620_owC7R CA003D 2026-01-01T14:31:32.844Z 2026-01-08T15:12:57.624Z
9117253 9117253 20251231101143_Eh38Q CA003D 2026-01-01T14:30:45.850Z 2026-01-08T15:12:45.886Z
9117172 9117172 20251231094934_227sI CA003D 2026-01-01T14:30:30.084Z 2026-01-08T15:12:42.289Z
9117130 9117130 20251231092539_RR2mH CA003D 2026-01-01T14:30:14.934Z 2026-01-08T15:12:39.021Z
9117051 9117051 20251231085813_W5CD3 CA003D 2026-01-01T14:30:00.414Z 2026-01-08T15:12:26.916Z
9087949 9087949 20251228105250_TqiqF CA003D 2025-12-30T14:45:22.135Z 2026-01-05T15:11:35.736Z
9087661 9087661 20251228101151_k3eyA CA003D 2025-12-30T14:44:36.125Z 2026-01-05T15:11:26.605Z
9087296 9087296 20251228083305_8iyNW CA003D 2025-12-30T14:43:39.387Z 2026-01-05T15:11:00.497Z
9087282 9087282 20251228082831_jIIM4 CA003D 2025-12-30T14:43:37.438Z 2026-01-05T15:10:59.954Z
9087255 9087255 20251228081402_JuY36 CA003D 2025-12-30T14:43:34.740Z 2026-01-05T15:10:58.942Z
9087213 9087213 20251228074745_KijIQ CA003D 2025-12-30T14:43:19.860Z 2026-01-05T15:10:56.902Z
9087118 9087118 20251228070643_sB2js CA003D 2025-12-30T14:43:05.861Z 2026-01-05T15:10:53.567Z
9087091 9087091 20251228070008_9an53 CA003D 2025-12-30T14:43:02.339Z 2026-01-05T15:10:52.554Z
9087033 9087033 20251228064739_qKojA CA003D 2025-12-30T14:42:54.120Z 2026-01-05T15:10:50.335Z
9086961 9086961 20251228062621_P8g6c CA003D 2025-12-30T14:42:33.948Z 2025-12-31T14:52:43.812Z
9086529 9086529 20251228050915_MeDKX CA003D 2025-12-30T14:41:24.854Z 2026-01-05T15:10:21.121Z
9085700 9085700 20251228035215_cVr4K CA003D 2025-12-30T14:39:13.144Z 2026-01-05T15:09:42.160Z
9085040 9085040 20251228024627_Cf7Ho CA003D 2025-12-30T14:37:28.153Z 2026-01-05T15:09:11.266Z
9084616 9084616 20251228020105_7bIis CA003D 2025-12-30T14:36:17.350Z 2026-01-05T15:08:50.329Z
9083908 9083908 20251228005057_qPqcq CA003D 2025-12-30T14:34:10.011Z 2026-01-05T15:08:20.513Z
9083517 9083517 20251228000422_dok9T CA003D 2025-12-30T14:32:56.394Z 2026-01-05T15:07:51.951Z
9083251 9083251 20251227232609_5QGtB CA003D 2025-12-30T14:32:04.329Z 2026-01-05T15:07:42.136Z
9067904 9067904 20251226105515_NC3zh CA003D 2025-12-29T14:43:02.001Z 2026-01-03T15:39:23.437Z
9067541 9067541 20251226095907_g7hcg CA003D 2025-12-29T14:42:15.611Z 2026-01-03T15:38:56.407Z
9067470 9067470 20251226094724_NEt2u CA003D 2025-12-29T14:41:58.377Z 2026-01-03T15:38:53.929Z
9067446 9067446 20251226094122_bE53f CA003D 2025-12-29T14:41:55.839Z 2026-01-03T15:38:52.748Z

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