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,830 rows where station_code = "CA000Y" 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
9520115 9520115 20260319025501_0q1Mu CA000Y 2026-03-20T12:05:46.122Z 2026-03-27T12:40:39.205Z
9457795 9457795 20260311055016_S3UNh CA000Y 2026-03-12T12:04:37.592Z 2026-03-19T12:44:52.190Z
9457327 9457327 20260311033510_Z7xL9 CA000Y 2026-03-12T12:03:34.630Z 2026-03-19T12:44:39.208Z
9432677 9432677 20260306083143_c2ZbQ CA000Y 2026-03-07T14:05:44.275Z 2026-03-14T12:39:35.022Z
9431670 9431670 20260306011247_smlZ5 CA000Y 2026-03-07T14:01:34.374Z 2026-03-14T12:39:16.138Z
9409900 9409900 20260228065857_Q56st CA000Y 2026-03-01T14:02:29.575Z 2026-03-08T12:41:37.483Z
9403075 9403075 20260227074759_RZyBv CA000Y 2026-02-28T14:07:07.313Z 2026-03-07T14:47:29.019Z
9392824 9392824 20260225071230_3WxHj CA000Y 2026-02-26T14:08:31.713Z 2026-03-05T14:37:09.996Z
9374967 9374967 20260223102300_PWIEI CA000Y 2026-02-24T14:07:38.864Z 2026-03-03T14:31:39.215Z
9374577 9374577 20260223085508_DwlM7 CA000Y 2026-02-24T14:06:27.881Z 2026-03-03T14:31:32.749Z
9374351 9374351 20260223080512_FQQsB CA000Y 2026-02-24T14:05:46.042Z 2026-03-03T14:31:23.002Z
9374165 9374165 20260223061352_XyE01 CA000Y 2026-02-24T14:05:05.726Z 2026-03-03T14:31:16.796Z
9374139 9374139 20260223055346_jCK3y CA000Y 2026-02-24T14:05:00.232Z 2026-03-03T14:31:16.218Z
9373888 9373888 20260223044232_Vj8Ny CA000Y 2026-02-24T14:04:12.844Z 2026-03-03T14:31:11.076Z
9373738 9373738 20260223041336_H8ms5 CA000Y 2026-02-24T14:03:51.103Z 2026-03-03T14:31:09.033Z
9373606 9373606 20260223034208_e3i5y CA000Y 2026-02-24T14:03:26.871Z 2026-03-03T14:31:06.373Z
9373505 9373505 20260223031947_DoI3X CA000Y 2026-02-24T14:03:09.580Z 2026-03-03T14:31:04.682Z
9366574 9366574 20260222100245_NGrVM CA000Y 2026-02-23T14:08:00.228Z 2026-02-24T14:16:26.982Z
9366450 9366450 20260222094454_uNmfa CA000Y 2026-02-23T14:07:37.639Z 2026-02-24T14:16:20.751Z
9365786 9365786 20260222061325_Ssyr4 CA000Y 2026-02-23T14:05:06.506Z 2026-02-24T14:15:38.572Z
9365777 9365777 20260222060921_Qgp16 CA000Y 2026-02-23T14:05:04.401Z 2026-02-24T14:15:38.004Z
9365773 9365773 20260222060758_aLE44 CA000Y 2026-02-23T14:05:02.368Z 2026-02-24T14:15:37.662Z
9365567 9365567 20260222042919_eSaNw CA000Y 2026-02-23T14:04:06.484Z 2026-02-24T14:15:21.004Z
9365328 9365328 20260222032019_tmfWi CA000Y 2026-02-23T14:03:01.588Z 2026-02-24T14:15:06.964Z
9364636 9364636 20260220232134_d6Ag2 CA000Y 2026-02-22T14:21:52.982Z 2026-03-01T14:22:55.720Z
9359836 9359836 20260221100147_jbRTO CA000Y 2026-02-22T14:05:58.228Z 2026-03-02T14:21:19.970Z
9359436 9359436 20260221085350_V89Gg CA000Y 2026-02-22T14:04:45.898Z 2026-03-02T14:21:15.139Z
9359392 9359392 20260221084431_v3BCm CA000Y 2026-02-22T14:04:37.842Z 2026-03-02T14:21:14.678Z
9359201 9359201 20260221075825_RR82D CA000Y 2026-02-22T14:04:00.274Z 2026-03-02T14:21:12.426Z
9359114 9359114 20260221072512_62Gxi CA000Y 2026-02-22T14:03:49.160Z 2026-03-02T14:21:11.727Z
9358975 9358975 20260221062017_8Qu3F CA000Y 2026-02-22T14:03:12.724Z 2026-03-02T14:21:09.627Z
9358829 9358829 20260221051413_52mba CA000Y 2026-02-22T14:02:33.684Z 2026-03-02T14:20:54.694Z
9358684 9358684 20260221035153_CZokQ CA000Y 2026-02-22T14:01:57.738Z 2026-03-02T14:20:52.267Z
9358649 9358649 20260221033017_q0XEM CA000Y 2026-02-22T14:01:47.657Z 2026-03-02T14:20:51.810Z
9353145 9353145 20260220100732_lCgLn CA000Y 2026-02-21T14:03:52.133Z 2026-03-01T14:21:45.986Z
9353070 9353070 20260220095425_4Sy2E CA000Y 2026-02-21T14:03:41.046Z 2026-03-01T14:21:45.329Z
9352997 9352997 20260220094308_KdeeJ CA000Y 2026-02-21T14:03:29.660Z 2026-03-01T14:21:44.589Z
9352963 9352963 20260220093937_XBk64 CA000Y 2026-02-21T14:03:24.858Z 2026-03-01T14:21:44.434Z
9352603 9352603 20260220083652_D11lf CA000Y 2026-02-21T14:02:30.151Z 2026-03-01T14:21:40.388Z
9352535 9352535 20260220081053_KXfXq CA000Y 2026-02-21T14:02:18.173Z 2026-03-01T14:21:39.296Z
9352529 9352529 20260220080015_NBwl0 CA000Y 2026-02-21T14:02:16.391Z 2026-03-01T14:21:39.252Z
9352524 9352524 20260220075351_04du6 CA000Y 2026-02-21T14:02:15.389Z 2026-03-01T14:21:39.172Z
9352463 9352463 20260220072112_55gYY CA000Y 2026-02-21T14:02:01.654Z 2026-03-01T14:21:38.189Z
9352431 9352431 20260220064932_SUlZL CA000Y 2026-02-21T14:01:54.790Z 2026-03-01T14:21:37.755Z
9352328 9352328 20260220052449_AiA2t CA000Y 2026-02-21T14:01:32.386Z 2026-03-01T14:21:36.058Z
9352130 9352130 20260220022425_IAgy8 CA000Y 2026-02-21T14:00:44.630Z 2026-03-01T14:21:32.718Z
9352088 9352088 20260220014948_fTBzU CA000Y 2026-02-21T14:00:31.607Z 2026-03-01T14:21:32.045Z
9352041 9352041 20260220005930_DR7O6 CA000Y 2026-02-21T14:00:19.866Z 2026-03-01T14:21:31.238Z
9352037 9352037 20260220005829_Wj5Z3 CA000Y 2026-02-21T14:00:18.924Z 2026-03-01T14:21:31.168Z
9341692 9341692 20260219101944_rvGs9 CA000Y 2026-02-20T14:00:57.251Z 2026-02-28T14:43:52.880Z
9341666 9341666 20260219101007_m27bc CA000Y 2026-02-20T14:00:57.197Z 2026-02-28T14:43:52.696Z
9341613 9341613 20260219095306_n2a36 CA000Y 2026-02-20T14:00:57.104Z 2026-02-28T14:43:52.375Z
9341125 9341125 20260219040112_zGm3h CA000Y 2026-02-20T14:00:55.612Z 2026-02-28T14:43:46.332Z
9341089 9341089 20260219032800_DHK7l CA000Y 2026-02-20T14:00:55.465Z 2026-02-28T14:43:45.323Z
9332040 9332040 20260216100430_K9mWP CA000Y 2026-02-17T14:09:45.276Z 2026-02-25T14:42:05.293Z
9331723 9331723 20260216074346_3pIGF CA000Y 2026-02-17T14:08:02.265Z 2026-02-25T14:42:01.022Z
9331696 9331696 20260216072608_ND7wy CA000Y 2026-02-17T14:07:53.853Z 2026-02-25T14:42:00.479Z
9323637 9323637 20260214055018_MYFkR CA000Y 2026-02-15T14:06:50.645Z 2026-02-23T14:46:34.854Z
9323570 9323570 20260214054242_tT1zx CA000Y 2026-02-15T14:06:39.258Z 2026-02-23T14:46:34.048Z
9322895 9322895 20260214041715_7qhrl CA000Y 2026-02-15T14:04:28.934Z 2026-02-23T14:46:24.380Z
9322498 9322498 20260214031214_0MIAu CA000Y 2026-02-15T14:02:39.149Z 2026-02-23T14:46:17.594Z
9319782 9319782 20260213042557_vJVf6 CA000Y 2026-02-14T14:02:26.195Z 2026-02-22T14:41:39.047Z
9319750 9319750 20260213040611_vSf8R CA000Y 2026-02-14T14:02:12.640Z 2026-02-22T14:41:38.250Z
9319721 9319721 20260213035009_Rpd0S CA000Y 2026-02-14T14:02:00.758Z 2026-02-22T14:41:37.656Z
9312704 9312704 20260210104156_R1fvo CA000Y 2026-02-11T14:07:44.852Z 2026-02-18T14:56:47.242Z
9312647 9312647 20260210102553_asUIB CA000Y 2026-02-11T14:07:18.965Z 2026-02-18T14:56:38.585Z
9312602 9312602 20260210101504_kQBrD CA000Y 2026-02-11T14:07:01.512Z 2026-02-18T14:56:34.797Z
9312464 9312464 20260210094128_5wI8y CA000Y 2026-02-11T14:06:12.950Z 2026-02-18T14:56:27.902Z
9312439 9312439 20260210093427_6G5xF CA000Y 2026-02-11T14:05:58.132Z 2026-02-18T14:56:25.746Z
9312198 9312198 20260210082136_W9uH3 CA000Y 2026-02-11T14:04:20.620Z 2026-02-18T14:56:01.924Z
9312114 9312114 20260210073913_1AIVz CA000Y 2026-02-11T14:03:46.423Z 2026-02-18T14:55:56.708Z
9312102 9312102 20260210072912_bZ21O CA000Y 2026-02-11T14:03:42.856Z 2026-02-18T14:55:55.836Z
9312081 9312081 20260210070954_eeeWX CA000Y 2026-02-11T14:03:35.535Z 2026-02-18T14:55:54.642Z
9312070 9312070 20260210070342_WyHUY CA000Y 2026-02-11T14:03:30.852Z 2026-02-18T14:55:53.449Z
9311987 9311987 20260210060114_w6YZf CA000Y 2026-02-11T14:02:49.586Z 2026-02-18T14:55:40.859Z
9311851 9311851 20260210044013_Z822g CA000Y 2026-02-11T14:01:43.809Z 2026-02-18T14:55:32.527Z
9311820 9311820 20260210041947_0bKA2 CA000Y 2026-02-11T14:01:26.491Z 2026-02-18T14:55:30.961Z
9311724 9311724 20260210032632_HTh2Z CA000Y 2026-02-11T14:00:41.779Z 2026-02-18T14:55:17.791Z
9311718 9311718 20260210032356_rkjoQ CA000Y 2026-02-11T14:00:39.700Z 2026-02-18T14:55:17.384Z
9311672 9311672 20260210025049_u2DL1 CA000Y 2026-02-11T14:00:14.363Z 2026-02-18T14:55:13.751Z
9311541 9311541 20260209005007_N2QFh CA000Y 2026-02-10T14:24:17.108Z 2026-02-16T14:54:54.297Z
9311529 9311529 20260209001930_Z82GP CA000Y 2026-02-10T14:24:14.658Z 2026-02-16T14:54:53.548Z
9307888 9307888 20260209081732_Z5jUt CA000Y 2026-02-10T14:04:47.931Z 2026-02-18T14:59:10.625Z
9307444 9307444 20260209054847_vPROk CA000Y 2026-02-10T14:02:22.125Z 2026-02-18T14:58:36.268Z
9307423 9307423 20260209053659_v75eO CA000Y 2026-02-10T14:02:13.135Z 2026-02-18T14:58:29.162Z
9307402 9307402 20260209052746_bw09W CA000Y 2026-02-10T14:02:04.687Z 2026-02-18T14:58:27.254Z
9307289 9307289 20260209044257_YeGQ3 CA000Y 2026-02-10T14:01:23.047Z 2026-02-18T14:58:18.270Z
9307170 9307170 20260209032846_Zztwb CA000Y 2026-02-10T14:00:30.056Z 2026-02-18T14:58:10.563Z
9298489 9298489 20260206032711_dHAHD CA000Y 2026-02-07T14:23:39.059Z 2026-02-14T15:06:40.650Z
9298434 9298434 20260206024706_CiSWx CA000Y 2026-02-07T14:23:19.131Z 2026-02-14T15:06:30.139Z
9298310 9298310 20260206012751_RDfeG CA000Y 2026-02-07T14:22:41.860Z 2026-02-14T15:06:18.137Z
9298247 9298247 20260205235905_exyjG CA000Y 2026-02-07T14:22:19.156Z 2026-02-14T15:06:12.187Z
9291330 9291330 20260204002403_2VWzi CA000Y 2026-02-05T14:16:32.378Z 2026-02-12T14:52:17.215Z
9288569 9288569 20260202232756_WXLkg CA000Y 2026-02-04T14:10:44.812Z 2026-02-11T14:51:00.865Z
9287314 9287314 20260203093218_d2dV6 CA000Y 2026-02-04T14:02:06.737Z 2026-02-12T14:50:17.821Z
9278175 9278175 20260129061450_pB9Yx CA000Y 2026-01-30T14:24:46.061Z 2026-02-06T14:48:37.829Z
9273688 9273688 20260129082414_8QzHk CA000Y 2026-01-30T14:00:45.336Z 2026-02-07T14:49:03.397Z
9268527 9268527 20260128104135_uiRuj CA000Y 2026-01-29T14:03:29.918Z 2026-02-06T14:43:26.038Z
9268496 9268496 20260128103118_f5MAr CA000Y 2026-01-29T14:03:23.602Z 2026-02-06T14:43:24.652Z
9268425 9268425 20260128101414_bfEh2 CA000Y 2026-01-29T14:02:55.505Z 2026-02-06T14:43:20.616Z

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