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

633 rows where station_code = "CA001Z" 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
9274085 9274085 20260129103300_Jrcxq CA001Z 2026-01-30T14:02:47.278Z 2026-01-30T14:02:47.278Z
9273866 9273866 20260129094147_y2YAt CA001Z 2026-01-30T14:01:40.456Z 2026-01-30T14:01:40.456Z
9263637 9263637 20260127093214_f3MKX CA001Z 2026-01-28T14:01:54.826Z 2026-01-30T14:26:34.577Z
9262844 9262844 20260126034321_osG2r CA001Z 2026-01-27T14:15:39.189Z 2026-01-30T14:40:13.511Z
9249704 9249704 20260122071325_R6KOe CA001Z 2026-01-23T14:15:57.629Z 2026-01-30T14:55:51.773Z
9232766 9232766 20260120122625_enSnN CA001Z 2026-01-21T14:03:11.555Z 2026-01-29T15:00:03.491Z
9231938 9231938 20260119101845_2ldci CA001Z 2026-01-20T14:34:50.810Z 2026-01-27T15:07:06.704Z
9231158 9231158 20260119061342_lDc4f CA001Z 2026-01-20T14:31:36.174Z 2026-01-27T15:06:02.530Z
9229812 9229812 20260119024051_YF6Vu CA001Z 2026-01-20T14:24:21.842Z 2026-01-27T15:03:57.906Z
9229453 9229453 20260119014829_1dIKa CA001Z 2026-01-20T14:22:40.044Z 2026-01-27T15:03:26.895Z
9226882 9226882 20260119132548_AyKW3 CA001Z 2026-01-20T14:05:31.662Z 2026-01-28T14:55:33.608Z
9226300 9226300 20260119114433_3o3jH CA001Z 2026-01-20T14:02:21.626Z 2026-01-28T14:54:53.393Z
9224840 9224840 20260118061847_PucuG CA001Z 2026-01-19T14:26:21.995Z 2026-01-26T15:03:51.089Z
9216652 9216652 20260117123226_PLFdP CA001Z 2026-01-18T14:01:54.014Z 2026-01-26T14:59:22.768Z
9209016 9209016 20260115080531_wl8BX CA001Z 2026-01-16T14:14:48.740Z 2026-01-22T15:04:46.489Z
9208955 9208955 20260115074624_ptDdx CA001Z 2026-01-16T14:14:35.695Z 2026-01-22T15:04:44.743Z
9208944 9208944 20260115074030_Qzn5M CA001Z 2026-01-16T14:14:33.016Z 2026-01-22T15:04:44.422Z
9207406 9207406 20260115013059_LHkXe CA001Z 2026-01-16T14:08:38.724Z 2026-01-22T15:03:21.103Z
9207376 9207376 20260115011640_Z8MdU CA001Z 2026-01-16T14:08:30.343Z 2026-01-22T15:03:20.288Z
9206000 9206000 20260115131542_cCgDQ CA001Z 2026-01-16T14:01:18.264Z 2026-01-24T15:08:45.250Z
9205453 9205453 20260114120924_lLbKj CA001Z 2026-01-15T14:31:01.972Z 2026-01-22T15:11:15.215Z
9205408 9205408 20260114120314_DTp2j CA001Z 2026-01-15T14:30:45.687Z 2026-01-22T15:11:14.461Z
9205347 9205347 20260114114257_W21ik CA001Z 2026-01-15T14:30:37.131Z 2026-01-22T15:11:13.251Z
9204968 9204968 20260114095255_tKIlM CA001Z 2026-01-15T14:29:25.102Z 2026-01-22T15:11:06.479Z
9198096 9198096 20260114132700_MXhAf CA001Z 2026-01-15T14:00:36.986Z 2026-01-22T15:01:49.457Z
9198063 9198063 20260114130347_sysb1 CA001Z 2026-01-15T14:00:20.732Z 2026-01-22T15:01:47.525Z
9198061 9198061 20260114130315_WOQte CA001Z 2026-01-15T14:00:19.409Z 2026-01-22T15:01:47.453Z
9172442 9172442 20260109104247_KcGcH CA001Z 2026-01-10T14:13:22.667Z 2026-01-17T15:25:33.925Z
9172038 9172038 20260109081656_i2wJV CA001Z 2026-01-10T14:11:22.543Z 2026-01-17T15:24:53.860Z
9169710 9169710 20260108035004_Ghlde CA001Z 2026-01-09T14:14:27.533Z 2026-01-16T15:11:34.141Z
9163803 9163803 20260107103833_O8yzA CA001Z 2026-01-08T14:10:36.454Z 2026-01-13T15:03:39.346Z
9163734 9163734 20260107101121_idu7N CA001Z 2026-01-08T14:10:13.377Z 2026-01-13T15:03:34.817Z
9163657 9163657 20260107094738_qnIRr CA001Z 2026-01-08T14:10:00.770Z 2026-01-13T15:03:31.326Z
9163516 9163516 20260107081354_83E8X CA001Z 2026-01-08T14:09:29.200Z 2026-01-13T15:03:25.013Z
9162220 9162220 20260107004837_TIVFP CA001Z 2026-01-08T14:03:42.486Z 2026-01-13T15:01:47.061Z
9124508 9124508 20251231093751_dl5JC CA001Z 2026-01-02T14:47:33.477Z 2026-01-08T15:12:40.611Z
9122485 9122485 20260101072419_2IKgr CA001Z 2026-01-02T14:13:16.340Z 2026-01-09T14:53:28.624Z
9122007 9122007 20260101040731_BZM09 CA001Z 2026-01-02T14:10:43.450Z 2026-01-09T14:52:56.017Z
9105759 9105759 20251230124806_PBszr CA001Z 2025-12-31T14:26:20.497Z 2026-01-07T15:11:11.119Z
9104818 9104818 20251230070712_lkUdw CA001Z 2025-12-31T14:22:32.786Z 2025-12-31T14:29:54.628Z
9089755 9089755 20251228134625_WyfyK CA001Z 2025-12-30T14:49:05.164Z 2026-01-05T15:12:52.987Z
9089743 9089743 20251228134507_3NaFp CA001Z 2025-12-30T14:49:04.209Z 2026-01-05T15:12:52.644Z
9089578 9089578 20251228132423_Ln7vg CA001Z 2025-12-30T14:48:43.066Z 2026-01-05T15:12:48.303Z
9088066 9088066 20251228110953_bXNhW CA001Z 2025-12-30T14:45:33.535Z 2026-01-05T15:11:39.250Z
9087375 9087375 20251228090406_FVpDC CA001Z 2025-12-30T14:43:49.855Z 2026-01-05T15:11:03.731Z
9087066 9087066 20251228065643_uX329 CA001Z 2025-12-30T14:42:59.487Z 2026-01-05T15:10:51.617Z
9046506 9046506 20251223140410_Xg8nh CA001Z 2025-12-28T14:54:59.458Z 2025-12-31T15:43:13.196Z
9046486 9046486 20251223135825_KNbtJ CA001Z 2025-12-28T14:54:58.533Z 2025-12-28T14:54:58.533Z
9045770 9045770 20251223112310_VnVc7 CA001Z 2025-12-28T14:54:01.130Z 2025-12-31T15:42:54.958Z
9045433 9045433 20251223095452_W2sYA CA001Z 2025-12-28T14:53:25.382Z 2025-12-31T15:42:50.251Z
9044717 9044717 20251223051726_vVqdw CA001Z 2025-12-28T14:52:25.900Z 2025-12-31T15:42:38.861Z
9034414 9034414 20251225131925_Sm41w CA001Z 2025-12-28T14:29:40.942Z 2025-12-29T14:58:16.748Z
9008622 9008622 20251221113649_SAd2E CA001Z 2025-12-27T14:42:59.948Z 2025-12-27T14:42:59.948Z
9007536 9007536 20251221100213_1ligK CA001Z 2025-12-27T14:40:36.261Z 2025-12-27T14:40:36.261Z
9007481 9007481 20251221095222_gVYsi CA001Z 2025-12-27T14:40:27.351Z 2025-12-27T14:40:27.351Z
9007206 9007206 20251221091642_63KYm CA001Z 2025-12-27T14:39:44.451Z 2025-12-27T14:39:44.451Z
9006926 9006926 20251221080828_ZYbWM CA001Z 2025-12-27T14:39:01.466Z 2025-12-27T14:39:01.466Z
9006278 9006278 20251221053148_isukN CA001Z 2025-12-27T14:37:12.221Z 2025-12-27T14:37:12.221Z
9001033 9001033 20251222094346_m2B2f CA001Z 2025-12-27T14:20:55.706Z 2025-12-30T15:47:54.251Z
9000525 9000525 20251222090832_oKE6U CA001Z 2025-12-27T14:19:43.062Z 2025-12-28T15:00:48.094Z
8999314 8999314 20251222073052_Wm89Y CA001Z 2025-12-27T14:16:20.318Z 2025-12-30T15:47:01.158Z
8999061 8999061 20251222065534_S3Qzk CA001Z 2025-12-27T14:15:31.869Z 2025-12-30T15:46:54.195Z
8986893 8986893 20251218065518_Uuqsw CA001Z 2025-12-26T14:39:01.683Z 2025-12-27T15:19:46.844Z
8978887 8978887 20251219095330_XZSAZ CA001Z 2025-12-26T14:16:44.684Z 2025-12-28T15:17:43.756Z
8964454 8964454 20251216083435_7vsI6 CA001Z 2025-12-25T14:41:29.292Z 2025-12-25T14:41:29.292Z
8964167 8964167 20251216075036_mrKGA CA001Z 2025-12-25T14:41:04.751Z 2025-12-25T14:41:04.751Z
8964119 8964119 20251216074045_ZhdIh CA001Z 2025-12-25T14:40:51.139Z 2025-12-25T14:40:51.139Z
8963821 8963821 20251216063933_dMCck CA001Z 2025-12-25T14:40:02.378Z 2025-12-25T14:40:02.378Z
8963552 8963552 20251216055132_HXbHk CA001Z 2025-12-25T14:39:22.018Z 2025-12-25T14:39:22.018Z
8696466 8696466 20251207120627_3eB3r CA001Z 2025-12-08T14:08:03.044Z 2025-12-16T15:10:41.130Z
8695883 8695883 20251207103721_Yq1SA CA001Z 2025-12-08T14:05:32.083Z 2025-12-16T15:10:00.733Z
8695793 8695793 20251207103012_8b99M CA001Z 2025-12-08T14:05:17.182Z 2025-12-16T15:09:58.624Z
8695496 8695496 20251207094913_BXkKX CA001Z 2025-12-08T14:04:08.394Z 2025-12-16T15:09:52.425Z
8620530 8620530 20251126125334_VlGNi CA001Z 2025-11-28T14:13:08.762Z 2025-12-05T15:02:12.106Z
8617352 8617352 20251127091300_lGMCf CA001Z 2025-11-28T14:00:31.005Z 2025-12-06T14:57:53.652Z
8617185 8617185 20251125072336_PZ37Y CA001Z 2025-11-27T14:41:48.585Z 2025-12-02T15:09:38.385Z
8605507 8605507 20251125132934_qIg4i CA001Z 2025-11-27T14:05:28.737Z 2025-12-04T15:05:26.862Z
8605434 8605434 20251125120155_F5YXy CA001Z 2025-11-27T14:04:35.056Z 2025-12-04T15:05:20.359Z
8605398 8605398 20251125101042_uc22k CA001Z 2025-11-27T14:03:39.200Z 2025-12-04T15:05:11.418Z
8584746 8584746 20251123131643_ItaKh CA001Z 2025-11-25T14:07:23.593Z 2025-12-02T15:09:51.533Z
8584744 8584744 20251123131623_9y1i5 CA001Z 2025-11-25T14:07:23.075Z 2025-12-02T15:09:51.532Z
8584343 8584343 20251123114525_GNxIj CA001Z 2025-11-25T14:05:58.033Z 2025-12-02T15:09:47.974Z
8584053 8584053 20251123104159_HwuMn CA001Z 2025-11-25T14:05:10.238Z 2025-12-02T15:09:45.638Z
8582498 8582498 20251123063739_lhoI9 CA001Z 2025-11-24T14:33:45.560Z 2025-12-01T15:22:24.535Z
8581223 8581223 20251122100524_xs7fd CA001Z 2025-11-24T14:29:40.367Z 2025-11-30T15:07:26.156Z
8574627 8574627 20251122101442_2dToy CA001Z 2025-11-24T14:00:21.341Z 2025-12-01T15:17:17.502Z
8574602 8574602 20251122100829_4NU4E CA001Z 2025-11-24T14:00:13.563Z 2025-12-01T15:17:15.034Z
8573558 8573558 20251122033218_lfFT7 CA001Z 2025-11-23T14:41:17.293Z 2025-11-30T15:06:30.831Z
8570611 8570611 20251121095841_2mNk7 CA001Z 2025-11-23T14:33:54.401Z 2025-11-29T14:55:07.066Z
8554071 8554071 20251120074830_N6lnR CA001Z 2025-11-22T14:34:43.057Z 2025-11-28T14:58:45.448Z
8553379 8553379 20251120053009_US8GZ CA001Z 2025-11-22T14:33:54.384Z 2025-11-28T14:58:02.958Z
8552713 8552713 20251120042549_dohY8 CA001Z 2025-11-22T14:32:41.454Z 2025-11-28T14:57:38.303Z
8542119 8542119 20251120113141_YmqW2 CA001Z 2025-11-22T14:01:18.103Z 2025-11-29T14:53:05.734Z
8517052 8517052 20251118093651_8Jlj0 CA001Z 2025-11-19T14:42:24.279Z 2025-11-26T15:08:19.765Z
8516474 8516474 20251118070634_M27Su CA001Z 2025-11-19T14:41:32.186Z 2025-11-26T15:08:07.714Z
8443377 8443377 20251111115733_kHJCy CA001Z 2025-11-13T14:50:46.847Z 2025-11-19T15:19:14.617Z
8443287 8443287 20251111114427_uMHyo CA001Z 2025-11-13T14:50:42.993Z 2025-11-19T15:19:09.532Z
8443007 8443007 20251111105511_wabxm CA001Z 2025-11-13T14:49:54.605Z 2025-11-19T15:18:54.319Z
8442622 8442622 20251111061958_oX7pR CA001Z 2025-11-13T14:48:34.153Z 2025-11-19T15:18:14.038Z
8442609 8442609 20251111054414_bPT5r CA001Z 2025-11-13T14:48:29.889Z 2025-11-19T15:18:09.054Z

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