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

3,514 rows where station_code = "CA001G" 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
9232765 9232765 20260120122625_enSnN CA001G 2026-01-21T14:03:11.555Z 2026-01-29T15:00:03.491Z
9231685 9231685 20260119092939_zI1TM CA001G 2026-01-20T14:33:55.048Z 2026-01-27T15:06:53.862Z
9231079 9231079 20260119055805_RvYmf CA001G 2026-01-20T14:31:09.310Z 2026-01-27T15:05:56.841Z
9225993 9225993 20260119104335_jrV7q CA001G 2026-01-20T14:00:16.009Z 2026-01-28T14:54:27.823Z
9224807 9224807 20260118060521_yI7z6 CA001G 2026-01-19T14:26:06.715Z 2026-01-26T15:03:49.567Z
9218551 9218551 20260117043639_irwqa CA001G 2026-01-18T14:12:37.284Z 2026-01-25T14:58:29.923Z
9218251 9218251 20260117021135_qdguN CA001G 2026-01-18T14:11:17.145Z 2026-01-25T14:58:18.675Z
9218190 9218190 20260117013804_cYidf CA001G 2026-01-18T14:10:56.175Z 2026-01-25T14:58:03.759Z
9216642 9216642 20260117123049_T2Ryu CA001G 2026-01-18T14:01:49.869Z 2026-01-26T14:59:22.224Z
9210768 9210768 20260116131406_vwpbL CA001G 2026-01-17T14:02:44.123Z 2026-01-25T14:56:55.400Z
9210085 9210085 20260115120246_ymTVT CA001G 2026-01-16T14:18:38.608Z 2026-01-22T15:05:47.106Z
9208652 9208652 20260115062015_u9L51 CA001G 2026-01-16T14:13:30.832Z 2026-01-22T15:04:36.249Z
9172054 9172054 20260109082819_RTvnP CA001G 2026-01-10T14:11:29.700Z 2026-01-17T15:25:01.271Z
9171719 9171719 20260109020716_VgVxf CA001G 2026-01-10T14:09:09.225Z 2026-01-17T15:24:21.943Z
9104817 9104817 20251230070712_lkUdw CA001G 2025-12-31T14:22:32.761Z 2025-12-31T14:29:54.628Z
9087403 9087403 20251228091344_PlfM3 CA001G 2025-12-30T14:43:53.866Z 2026-01-05T15:11:04.984Z
9087285 9087285 20251228083001_CQvRe CA001G 2025-12-30T14:43:38.111Z 2025-12-31T14:53:09.442Z
9086929 9086929 20251228061700_sxCwe CA001G 2025-12-30T14:42:29.809Z 2026-01-05T15:10:46.335Z
9086837 9086837 20251228054752_sO3Lf CA001G 2025-12-30T14:42:18.209Z 2025-12-31T14:52:37.449Z
9046505 9046505 20251223140410_Xg8nh CA001G 2025-12-28T14:54:59.458Z 2025-12-31T15:43:13.196Z
9046339 9046339 20251223131910_EQear CA001G 2025-12-28T14:54:50.887Z 2025-12-31T15:43:03.784Z
9045683 9045683 20251223105854_Q2Vtp CA001G 2025-12-28T14:53:56.329Z 2025-12-31T15:42:53.749Z
9045354 9045354 20251223093235_pX8fe CA001G 2025-12-28T14:53:21.077Z 2025-12-31T15:42:49.219Z
9045263 9045263 20251223085019_XyyCQ CA001G 2025-12-28T14:53:16.317Z 2025-12-31T15:42:47.895Z
9045181 9045181 20251223081624_zQEBb CA001G 2025-12-28T14:53:11.832Z 2025-12-31T15:42:46.378Z
9044730 9044730 20251223052605_8Mp0F CA001G 2025-12-28T14:52:26.970Z 2025-12-31T15:42:39.352Z
9044339 9044339 20251223012444_5Q3sq CA001G 2025-12-28T14:49:48.943Z 2025-12-31T15:42:09.302Z
9035821 9035821 20251224005441_8m0Ls CA001G 2025-12-28T14:33:24.198Z 2026-01-01T15:53:57.781Z
9034852 9034852 20251225141645_UyObh CA001G 2025-12-28T14:30:57.082Z 2026-01-02T15:47:12.182Z
9034527 9034527 20251225132930_k8cKO CA001G 2025-12-28T14:30:02.939Z 2025-12-29T14:58:18.702Z
9034233 9034233 20251225125515_qa3mm CA001G 2025-12-28T14:29:16.250Z 2026-01-02T15:46:58.899Z
9034164 9034164 20251225124833_hX7tJ CA001G 2025-12-28T14:29:06.318Z 2026-01-02T15:46:57.677Z
9020386 9020386 20251220121510_ndll5 CA001G 2025-12-27T15:05:41.436Z 2025-12-29T15:24:47.419Z
9020343 9020343 20251220120706_shZ7F CA001G 2025-12-27T15:05:23.556Z 2025-12-29T15:24:46.821Z
9020337 9020337 20251220120528_4Mhuc CA001G 2025-12-27T15:05:23.096Z 2025-12-29T15:24:46.573Z
9019532 9019532 20251220100549_nckN7 CA001G 2025-12-27T15:04:36.698Z 2025-12-27T15:04:36.698Z
9018758 9018758 20251220075713_mLNuO CA001G 2025-12-27T15:02:47.551Z 2025-12-29T15:24:04.740Z
9018161 9018161 20251220062311_gSTlR CA001G 2025-12-27T15:02:29.882Z 2025-12-29T15:23:38.250Z
9016424 9016424 20251220040439_bXc3o CA001G 2025-12-27T14:59:44.009Z 2025-12-29T15:23:23.191Z
9010695 9010695 20251221135919_lPKkd CA001G 2025-12-27T14:46:52.257Z 2025-12-27T14:46:52.257Z
9010550 9010550 20251221134724_KUQs7 CA001G 2025-12-27T14:46:38.214Z 2025-12-27T14:46:38.214Z
9008533 9008533 20251221113247_IbTbR CA001G 2025-12-27T14:42:55.187Z 2025-12-27T14:42:55.187Z
9008300 9008300 20251221111427_1syJq CA001G 2025-12-27T14:42:25.909Z 2025-12-27T14:42:25.909Z
9007655 9007655 20251221101915_xeQQw CA001G 2025-12-27T14:40:53.270Z 2025-12-27T14:40:53.270Z
9007052 9007052 20251221083904_tR3oo CA001G 2025-12-27T14:39:19.067Z 2025-12-27T14:39:19.067Z
9006980 9006980 20251221082536_Vpsgg CA001G 2025-12-27T14:39:06.498Z 2025-12-27T14:39:06.498Z
9000556 9000556 20251222091024_XMNQk CA001G 2025-12-27T14:19:46.469Z 2025-12-30T15:47:49.477Z
9000480 9000480 20251222090609_N41OQ CA001G 2025-12-27T14:19:22.776Z 2025-12-30T15:47:48.828Z
8999808 8999808 20251222081959_9CpbC CA001G 2025-12-27T14:17:48.765Z 2025-12-28T15:00:09.989Z
8999560 8999560 20251222075157_VpJbZ CA001G 2025-12-27T14:17:09.002Z 2025-12-30T15:47:19.699Z
8999335 8999335 20251222073314_scDOf CA001G 2025-12-27T14:16:25.019Z 2025-12-30T15:47:02.797Z
8997847 8997847 20251222045619_YSATQ CA001G 2025-12-27T14:11:30.701Z 2025-12-30T15:46:40.839Z
8997701 8997701 20251222044123_5xUn3 CA001G 2025-12-27T14:10:54.530Z 2025-12-30T15:46:39.580Z
8997150 8997150 20251222034524_XcQT0 CA001G 2025-12-27T14:08:30.528Z 2025-12-30T15:46:33.337Z
8985325 8985325 20251218015337_J5CSY CA001G 2025-12-26T14:34:27.796Z 2025-12-27T15:18:57.789Z
8985184 8985184 20251218012939_Xa48H CA001G 2025-12-26T14:33:23.316Z 2025-12-27T15:18:55.287Z
8977537 8977537 20251219051742_90fzC CA001G 2025-12-26T14:13:02.959Z 2025-12-28T15:17:33.669Z
8977047 8977047 20251219041511_PaSWl CA001G 2025-12-26T14:11:41.028Z 2025-12-26T14:32:01.160Z
8964563 8964563 20251216085827_Yf2uZ CA001G 2025-12-25T14:41:55.708Z 2025-12-25T14:41:55.708Z
8964453 8964453 20251216083435_7vsI6 CA001G 2025-12-25T14:41:29.292Z 2025-12-25T14:41:29.292Z
8964375 8964375 20251216082125_IajMs CA001G 2025-12-25T14:41:21.333Z 2025-12-25T14:41:21.333Z
8964259 8964259 20251216080415_2gckz CA001G 2025-12-25T14:41:12.797Z 2025-12-25T14:41:12.797Z
8964166 8964166 20251216075036_mrKGA CA001G 2025-12-25T14:41:04.751Z 2025-12-25T14:41:04.751Z
8964118 8964118 20251216074045_ZhdIh CA001G 2025-12-25T14:40:51.139Z 2025-12-25T14:40:51.139Z
8964024 8964024 20251216072500_62V9A CA001G 2025-12-25T14:40:39.318Z 2025-12-25T14:40:39.318Z
8963903 8963903 20251216065717_JR3oa CA001G 2025-12-25T14:40:13.321Z 2025-12-25T14:40:13.321Z
8962406 8962406 20251216031728_QpnnT CA001G 2025-12-25T14:35:46.221Z 2025-12-25T14:35:46.221Z
8918431 8918431 20251214103545_ilFuR CA001G 2025-12-23T14:12:43.414Z 2025-12-24T14:34:39.599Z
8918116 8918116 20251214103004_f6TDk CA001G 2025-12-23T14:12:40.869Z 2025-12-23T14:28:37.347Z
8918000 8918000 20251214102803_SxyED CA001G 2025-12-23T14:12:39.884Z 2025-12-24T14:34:00.301Z
8916989 8916989 20251214100657_16Jes CA001G 2025-12-23T14:12:33.062Z 2025-12-24T14:33:11.206Z
8915294 8915294 20251214092651_ubx0y CA001G 2025-12-23T14:11:28.721Z 2025-12-24T14:31:04.482Z
8915107 8915107 20251214092142_ZNTZO CA001G 2025-12-23T14:11:24.517Z 2025-12-24T14:30:35.818Z
8912313 8912313 20251214075505_bQ94j CA001G 2025-12-23T14:10:48.013Z 2025-12-24T14:27:32.391Z
8911984 8911984 20251214074447_XjcX0 CA001G 2025-12-23T14:10:46.338Z 2025-12-24T14:26:55.855Z
8911920 8911920 20251214074256_t7wk9 CA001G 2025-12-23T14:10:46.012Z 2025-12-23T14:28:32.940Z
8911853 8911853 20251214074047_hEGXe CA001G 2025-12-23T14:10:45.611Z 2025-12-24T14:26:37.813Z
8911621 8911621 20251214073512_MsMnR CA001G 2025-12-23T14:10:43.852Z 2025-12-24T14:26:12.378Z
8911525 8911525 20251214073216_dcNzf CA001G 2025-12-23T14:10:43.312Z 2025-12-24T14:26:08.328Z
8911512 8911512 20251214073206_w4HcB CA001G 2025-12-23T14:10:43.264Z 2025-12-24T14:26:07.920Z
8911319 8911319 20251214072642_zDdKP CA001G 2025-12-23T14:10:41.763Z 2025-12-24T14:26:00.115Z
8911294 8911294 20251214072539_0LBcR CA001G 2025-12-23T14:10:41.600Z 2025-12-24T14:25:59.567Z
8911247 8911247 20251214072346_mEIEr CA001G 2025-12-23T14:10:41.337Z 2025-12-24T14:25:58.462Z
8907400 8907400 20251214055953_ZhVmo CA001G 2025-12-23T14:08:12.694Z 2025-12-24T14:21:44.227Z
8617947 8617947 20251127110006_hsCHe CA001G 2025-11-28T14:02:53.649Z 2025-12-06T14:58:27.254Z
8584408 8584408 20251123120327_fasaA CA001G 2025-11-25T14:06:15.790Z 2025-12-02T15:09:48.460Z
8584342 8584342 20251123114525_GNxIj CA001G 2025-11-25T14:05:58.015Z 2025-12-02T15:09:47.974Z
8582402 8582402 20251123060353_tma5a CA001G 2025-11-24T14:33:34.761Z 2025-12-01T15:22:23.368Z
8581222 8581222 20251122100524_xs7fd CA001G 2025-11-24T14:29:40.350Z 2025-11-30T15:07:26.156Z
8570392 8570392 20251121091202_GUHCP CA001G 2025-11-23T14:33:40.207Z 2025-11-29T14:55:02.229Z
8570349 8570349 20251121090457_hA2sq CA001G 2025-11-23T14:33:37.564Z 2025-11-29T14:55:01.337Z
8554601 8554601 20251120101657_KsX4t CA001G 2025-11-22T14:35:36.703Z 2025-11-28T14:58:54.321Z
8554195 8554195 20251120090121_GjUSp CA001G 2025-11-22T14:34:51.406Z 2025-11-28T14:58:48.050Z
8542385 8542385 20251120120839_3H6Qt CA001G 2025-11-22T14:01:58.625Z 2025-11-29T14:53:11.143Z
8540552 8540552 20251120011249_9Is22 CA001G 2025-11-21T14:36:05.278Z 2025-11-28T14:56:15.388Z
8530898 8530898 20251119131821_yoJSD CA001G 2025-11-21T14:03:22.203Z 2025-11-28T14:53:26.970Z
8530821 8530821 20251119130243_Nv7UC CA001G 2025-11-21T14:03:08.535Z 2025-11-28T14:53:21.297Z
8516956 8516956 20251118092239_12Uu9 CA001G 2025-11-19T14:42:19.258Z 2025-11-19T14:42:19.258Z
8516841 8516841 20251118084326_tTEx3 CA001G 2025-11-19T14:42:14.344Z 2025-11-26T15:08:09.839Z
8516487 8516487 20251118070911_pImpe CA001G 2025-11-19T14:41:36.534Z 2025-11-26T15:08:07.846Z

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