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

6,559 rows where station_code = "CA0031" 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
9603266 9603266 20260402091141_CEFR3 CA0031 2026-04-03T12:02:27.532Z 2026-04-06T12:21:50.024Z
9450936 9450936 20260309235702_goppn CA0031 2026-03-11T12:01:11.586Z 2026-03-18T12:38:38.033Z
9447833 9447833 20260309090249_hHIt3 CA0031 2026-03-10T12:07:58.852Z 2026-03-17T12:41:57.173Z
9447774 9447774 20260309084805_EQM9v CA0031 2026-03-10T12:07:46.491Z 2026-03-17T12:41:56.511Z
9447572 9447572 20260309080224_D14YM CA0031 2026-03-10T12:07:04.131Z 2026-03-17T12:41:53.456Z
9447462 9447462 20260309073648_1Ulby CA0031 2026-03-10T12:06:36.903Z 2026-03-17T12:41:52.134Z
9447098 9447098 20260309044439_vjnbW CA0031 2026-03-10T12:05:09.886Z 2026-03-17T12:41:47.501Z
9446785 9446785 20260309030108_SfKMS CA0031 2026-03-10T12:03:53.295Z 2026-03-17T12:41:42.882Z
9432905 9432905 20260306092414_tKZAh CA0031 2026-03-07T14:06:34.909Z 2026-03-14T12:39:45.964Z
9432306 9432306 20260306042455_bevQe CA0031 2026-03-07T14:04:12.694Z 2026-03-14T12:39:28.326Z
9432068 9432068 20260306032342_XWCZO CA0031 2026-03-07T14:03:13.618Z 2026-03-14T12:39:24.217Z
9431945 9431945 20260306024125_kSXJ3 CA0031 2026-03-07T14:02:36.309Z 2026-03-14T12:39:20.999Z
9431808 9431808 20260306020202_0Xeuf CA0031 2026-03-07T14:02:05.240Z 2026-03-14T12:39:18.004Z
9419771 9419771 20260303090534_3Deyr CA0031 2026-03-04T14:02:07.178Z 2026-03-11T12:28:06.908Z
9418967 9418967 20260302234900_k2mHm CA0031 2026-03-04T14:00:24.399Z 2026-03-11T12:27:42.150Z
9416319 9416319 20260302100419_ImRCG CA0031 2026-03-03T14:03:24.114Z 2026-03-10T12:36:02.904Z
9416206 9416206 20260302092620_gK2N5 CA0031 2026-03-03T14:03:05.126Z 2026-03-10T12:36:00.798Z
9416122 9416122 20260302084921_sw5qR CA0031 2026-03-03T14:02:46.939Z 2026-03-10T12:35:58.969Z
9416107 9416107 20260302084609_YmqCr CA0031 2026-03-03T14:02:44.666Z 2026-03-10T12:35:58.777Z
9416077 9416077 20260302083534_ZDGrY CA0031 2026-03-03T14:02:39.993Z 2026-03-10T12:35:58.273Z
9415519 9415519 20260302002807_gh6ZF CA0031 2026-03-03T14:00:30.474Z 2026-03-10T12:35:43.145Z
9403062 9403062 20260227073912_lfwkP CA0031 2026-02-28T14:07:04.702Z 2026-03-07T14:47:26.866Z
9403050 9403050 20260227072623_Mh4X3 CA0031 2026-02-28T14:07:02.444Z 2026-03-07T14:47:25.892Z
9403039 9403039 20260227071831_AJpMX CA0031 2026-02-28T14:06:59.934Z 2026-03-07T14:47:25.123Z
9402988 9402988 20260227061754_1bEik CA0031 2026-02-28T14:06:47.539Z 2026-03-07T14:47:20.327Z
9402943 9402943 20260227052606_5Ex7E CA0031 2026-02-28T14:06:36.891Z 2026-03-07T14:47:17.151Z
9401936 9401936 20260227021201_mAGAf CA0031 2026-02-28T14:02:52.734Z 2026-03-07T14:46:15.784Z
9392868 9392868 20260225075457_9bfkR CA0031 2026-02-26T14:08:39.245Z 2026-03-05T14:37:12.191Z
9392774 9392774 20260225060657_Orytp CA0031 2026-02-26T14:08:17.889Z 2026-03-05T14:37:07.078Z
9392773 9392773 20260225060555_pI9u1 CA0031 2026-02-26T14:08:16.023Z 2026-03-05T14:37:07.016Z
9392767 9392767 20260225055240_zZJVO CA0031 2026-02-26T14:08:14.952Z 2026-03-05T14:37:06.869Z
9392762 9392762 20260225055012_mmw3D CA0031 2026-02-26T14:08:13.931Z 2026-03-05T14:37:06.671Z
9384048 9384048 20260224100327_UUeDC CA0031 2026-02-25T14:04:23.151Z 2026-03-04T14:18:00.252Z
9383961 9383961 20260224094759_wjmKO CA0031 2026-02-25T14:04:00.238Z 2026-03-04T14:17:58.653Z
9383930 9383930 20260224093658_JVWQA CA0031 2026-02-25T14:03:53.027Z 2026-03-04T14:17:58.176Z
9383658 9383658 20260224071710_43gl5 CA0031 2026-02-25T14:02:35.927Z 2026-03-04T14:17:52.860Z
9383647 9383647 20260224071130_F3Trt CA0031 2026-02-25T14:02:32.908Z 2026-03-04T14:17:52.710Z
9383599 9383599 20260224063516_5ADHM CA0031 2026-02-25T14:02:17.505Z 2026-03-04T14:17:51.865Z
9383578 9383578 20260224062331_HcHCf CA0031 2026-02-25T14:02:13.880Z 2026-03-04T14:17:51.561Z
9383561 9383561 20260224060600_J2tvG CA0031 2026-02-25T14:02:10.725Z 2026-03-04T14:17:51.355Z
9374360 9374360 20260223080625_2nn2t CA0031 2026-02-24T14:05:47.654Z 2026-03-03T14:31:28.596Z
9374209 9374209 20260223063846_eue9S CA0031 2026-02-24T14:05:16.698Z 2026-03-03T14:31:17.742Z
9374035 9374035 20260223052253_9jnfN CA0031 2026-02-24T14:04:38.458Z 2026-03-03T14:31:13.398Z
9373905 9373905 20260223045101_iC3Ym CA0031 2026-02-24T14:04:16.510Z 2026-03-03T14:31:11.284Z
9373765 9373765 20260223041650_xFxRq CA0031 2026-02-24T14:03:54.282Z 2026-03-03T14:31:09.410Z
9373735 9373735 20260223041234_eWF5H CA0031 2026-02-24T14:03:50.139Z 2026-03-03T14:31:08.934Z
9373704 9373704 20260223040404_txCR2 CA0031 2026-02-24T14:03:41.630Z 2026-03-03T14:31:08.039Z
9373462 9373462 20260223030916_b4LjO CA0031 2026-02-24T14:03:02.305Z 2026-03-03T14:31:03.609Z
9372963 9372963 20260223013821_EAzTI CA0031 2026-02-24T14:01:47.746Z 2026-03-03T14:30:49.138Z
9372920 9372920 20260223012915_A3065 CA0031 2026-02-24T14:01:42.579Z 2026-03-03T14:30:48.730Z
9372668 9372668 20260223005350_4P23s CA0031 2026-02-24T14:01:12.146Z 2026-03-03T14:30:44.191Z
9372471 9372471 20260223001904_Mmo7u CA0031 2026-02-24T14:00:41.863Z 2026-03-03T14:30:40.945Z
9372424 9372424 20260223001122_HUyUZ CA0031 2026-02-24T14:00:31.207Z 2026-03-03T14:30:40.190Z
9366809 9366809 20260222103652_7kfmR CA0031 2026-02-23T14:08:39.082Z 2026-02-24T14:16:39.359Z
9366625 9366625 20260222100848_GFFU2 CA0031 2026-02-23T14:08:08.700Z 2026-02-24T14:16:29.837Z
9366395 9366395 20260222093616_DrlSk CA0031 2026-02-23T14:07:30.320Z 2026-02-24T14:16:17.458Z
9366331 9366331 20260222092748_ZivHv CA0031 2026-02-23T14:07:15.888Z 2026-02-24T14:16:14.097Z
9366224 9366224 20260222090713_k3LDl CA0031 2026-02-23T14:06:56.407Z 2026-02-24T14:16:07.460Z
9366123 9366123 20260222084039_M7GlQ CA0031 2026-02-23T14:06:28.949Z 2026-02-24T14:16:01.232Z
9366067 9366067 20260222082903_S1Af2 CA0031 2026-02-23T14:06:14.607Z 2026-02-24T14:15:58.503Z
9366036 9366036 20260222082236_N5VfC CA0031 2026-02-23T14:06:08.915Z 2026-02-24T14:15:55.627Z
9365983 9365983 20260222075104_Z2d1s CA0031 2026-02-23T14:05:53.277Z 2026-02-24T14:15:51.836Z
9365979 9365979 20260222075058_WH31o CA0031 2026-02-23T14:05:52.694Z 2026-02-24T14:15:51.687Z
9365897 9365897 20260222070748_DcT8n CA0031 2026-02-23T14:05:30.149Z 2026-02-24T14:15:44.977Z
9365885 9365885 20260222070401_seuvy CA0031 2026-02-23T14:05:26.721Z 2026-02-24T14:15:44.193Z
9365785 9365785 20260222061229_3SPsd CA0031 2026-02-23T14:05:05.863Z 2026-02-24T14:15:38.356Z
9365766 9365766 20260222055823_Ob3K6 CA0031 2026-02-23T14:04:58.360Z 2026-02-24T14:15:36.730Z
9365757 9365757 20260222055213_Q7NUq CA0031 2026-02-23T14:04:55.251Z 2026-02-24T14:15:36.133Z
9365706 9365706 20260222053503_FVK4l CA0031 2026-02-23T14:04:44.666Z 2026-02-24T14:15:33.364Z
9365574 9365574 20260222043153_liGqu CA0031 2026-02-23T14:04:08.272Z 2026-02-24T14:15:21.521Z
9364987 9364987 20260222013137_rRUHm CA0031 2026-02-23T14:01:37.778Z 2026-02-24T14:14:44.397Z
9358122 9358122 20260219232901_RQudQ CA0031 2026-02-21T14:17:43.753Z 2026-02-28T14:44:48.990Z
9353271 9353271 20260220102804_yC2gw CA0031 2026-02-21T14:04:07.420Z 2026-03-01T14:21:48.310Z
9353254 9353254 20260220102522_elSNd CA0031 2026-02-21T14:04:05.253Z 2026-03-01T14:21:48.194Z
9353166 9353166 20260220100908_4F1Sg CA0031 2026-02-21T14:03:54.035Z 2026-03-01T14:21:46.107Z
9353121 9353121 20260220100356_r2VFr CA0031 2026-02-21T14:03:49.087Z 2026-03-01T14:21:45.812Z
9353102 9353102 20260220100129_RKzdR CA0031 2026-02-21T14:03:46.424Z 2026-03-01T14:21:45.591Z
9353085 9353085 20260220095728_BzVac CA0031 2026-02-21T14:03:43.630Z 2026-03-01T14:21:45.478Z
9352928 9352928 20260220093549_nrxcl CA0031 2026-02-21T14:03:19.555Z 2026-03-01T14:21:43.873Z
9352750 9352750 20260220090929_3ZP94 CA0031 2026-02-21T14:02:53.161Z 2026-03-01T14:21:41.991Z
9352568 9352568 20260220082641_pQUUs CA0031 2026-02-21T14:02:24.947Z 2026-03-01T14:21:39.781Z
9352540 9352540 20260220081255_RBAXh CA0031 2026-02-21T14:02:19.186Z 2026-03-01T14:21:39.359Z
9352523 9352523 20260220075338_pusTW CA0031 2026-02-21T14:02:14.455Z 2026-03-01T14:21:39.142Z
9352502 9352502 20260220074425_uzNsG CA0031 2026-02-21T14:02:08.655Z 2026-03-01T14:21:38.779Z
9352468 9352468 20260220072603_arOjB CA0031 2026-02-21T14:02:02.619Z 2026-03-01T14:21:38.287Z
9352436 9352436 20260220070013_y9EZL CA0031 2026-02-21T14:01:55.664Z 2026-03-01T14:21:37.827Z
9352407 9352407 20260220062431_StK6t CA0031 2026-02-21T14:01:48.917Z 2026-03-01T14:21:37.330Z
9352393 9352393 20260220060156_pRQyH CA0031 2026-02-21T14:01:44.235Z 2026-03-01T14:21:36.904Z
9352372 9352372 20260220054641_GK6XK CA0031 2026-02-21T14:01:41.220Z 2026-03-01T14:21:36.587Z
9352336 9352336 20260220052746_cqXRy CA0031 2026-02-21T14:01:33.984Z 2026-03-01T14:21:36.157Z
9352310 9352310 20260220050201_FbfAA CA0031 2026-02-21T14:01:29.157Z 2026-03-01T14:21:35.765Z
9352229 9352229 20260220033843_3KvoB CA0031 2026-02-21T14:01:08.648Z 2026-03-01T14:21:34.329Z
9352049 9352049 20260220010801_ocmrT CA0031 2026-02-21T14:00:22.908Z 2026-03-01T14:21:31.385Z
9345848 9345848 20260218104007_1uMJA CA0031 2026-02-20T14:01:36.993Z 2026-02-27T14:34:50.618Z
9345580 9345580 20260218101030_0uyKi CA0031 2026-02-20T14:01:33.897Z 2026-02-27T14:34:39.609Z
9345545 9345545 20260218100541_BmDbp CA0031 2026-02-20T14:01:33.346Z 2026-02-27T14:34:39.116Z
9345383 9345383 20260218094011_rAUaQ CA0031 2026-02-20T14:01:29.100Z 2026-02-27T14:34:37.551Z
9345329 9345329 20260218092835_sJZmX CA0031 2026-02-20T14:01:28.947Z 2026-02-27T14:34:36.921Z
9345293 9345293 20260218092304_sKrKO CA0031 2026-02-20T14:01:28.591Z 2026-02-27T14:34:36.541Z
9344964 9344964 20260218071446_zVSl9 CA0031 2026-02-20T14:01:22.577Z 2026-02-27T14:34:31.895Z

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