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

4,639 rows where station_code = "CA002L" 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
9520116 9520116 20260319025501_0q1Mu CA002L 2026-03-20T12:05:46.130Z 2026-03-27T12:40:39.205Z
9457796 9457796 20260311055016_S3UNh CA002L 2026-03-12T12:04:37.592Z 2026-03-19T12:44:52.190Z
9457328 9457328 20260311033510_Z7xL9 CA002L 2026-03-12T12:03:34.645Z 2026-03-19T12:44:39.208Z
9451668 9451668 20260310031651_U82FY CA002L 2026-03-11T12:03:30.404Z 2026-03-18T12:39:02.440Z
9450933 9450933 20260309235404_OFk0E CA002L 2026-03-11T12:01:10.873Z 2026-03-18T12:38:37.965Z
9432490 9432490 20260306072633_iGKpm CA002L 2026-03-07T14:04:59.037Z 2026-03-14T12:39:31.073Z
9431671 9431671 20260306011247_smlZ5 CA002L 2026-03-07T14:01:34.392Z 2026-03-14T12:39:16.138Z
9403076 9403076 20260227074759_RZyBv CA002L 2026-02-28T14:07:07.324Z 2026-03-07T14:47:29.019Z
9381585 9381585 20260222233310_DpxfF CA002L 2026-02-24T14:24:57.271Z 2026-02-24T14:24:57.271Z
9374968 9374968 20260223102300_PWIEI CA002L 2026-02-24T14:07:38.864Z 2026-03-03T14:31:39.215Z
9374882 9374882 20260223100438_gmiON CA002L 2026-02-24T14:07:24.000Z 2026-03-03T14:31:37.656Z
9374673 9374673 20260223091730_NKs2u CA002L 2026-02-24T14:06:40.589Z 2026-03-03T14:31:33.990Z
9374581 9374581 20260223085650_RkXeI CA002L 2026-02-24T14:06:28.819Z 2026-03-03T14:31:32.838Z
9374578 9374578 20260223085508_DwlM7 CA002L 2026-02-24T14:06:27.881Z 2026-03-03T14:31:32.749Z
9374352 9374352 20260223080512_FQQsB CA002L 2026-02-24T14:05:46.042Z 2026-03-03T14:31:23.002Z
9374271 9374271 20260223073217_8G020 CA002L 2026-02-24T14:05:31.509Z 2026-03-03T14:31:19.027Z
9374260 9374260 20260223072204_EQNkS CA002L 2026-02-24T14:05:28.849Z 2026-03-03T14:31:18.827Z
9374166 9374166 20260223061352_XyE01 CA002L 2026-02-24T14:05:05.726Z 2026-03-03T14:31:16.796Z
9374140 9374140 20260223055346_jCK3y CA002L 2026-02-24T14:05:00.232Z 2026-03-03T14:31:16.218Z
9373889 9373889 20260223044232_Vj8Ny CA002L 2026-02-24T14:04:12.844Z 2026-03-03T14:31:11.076Z
9373739 9373739 20260223041336_H8ms5 CA002L 2026-02-24T14:03:51.103Z 2026-03-03T14:31:09.033Z
9373637 9373637 20260223035414_fGRgP CA002L 2026-02-24T14:03:32.277Z 2026-03-03T14:31:07.015Z
9373623 9373623 20260223035007_OMLt2 CA002L 2026-02-24T14:03:29.362Z 2026-03-03T14:31:06.643Z
9373607 9373607 20260223034208_e3i5y CA002L 2026-02-24T14:03:26.871Z 2026-03-03T14:31:06.373Z
9373506 9373506 20260223031947_DoI3X CA002L 2026-02-24T14:03:09.628Z 2026-03-03T14:31:04.682Z
9373322 9373322 20260223024305_KLEJQ CA002L 2026-02-24T14:02:38.258Z 2026-03-03T14:31:01.133Z
9365905 9365905 20260222071222_YrnIj CA002L 2026-02-23T14:05:32.664Z 2026-02-24T14:15:45.708Z
9365787 9365787 20260222061325_Ssyr4 CA002L 2026-02-23T14:05:06.506Z 2026-02-24T14:15:38.572Z
9365778 9365778 20260222060921_Qgp16 CA002L 2026-02-23T14:05:04.401Z 2026-02-24T14:15:38.004Z
9365774 9365774 20260222060758_aLE44 CA002L 2026-02-23T14:05:02.368Z 2026-02-24T14:15:37.662Z
9365767 9365767 20260222055929_iOaSv CA002L 2026-02-23T14:04:59.055Z 2026-02-24T14:15:36.908Z
9365649 9365649 20260222050751_CEfN2 CA002L 2026-02-23T14:04:25.797Z 2026-02-24T14:15:27.595Z
9365568 9365568 20260222042919_eSaNw CA002L 2026-02-23T14:04:06.484Z 2026-02-24T14:15:21.004Z
9365329 9365329 20260222032019_tmfWi CA002L 2026-02-23T14:03:01.603Z 2026-02-24T14:15:06.964Z
9364637 9364637 20260220232134_d6Ag2 CA002L 2026-02-22T14:21:52.982Z 2026-03-01T14:22:55.720Z
9359837 9359837 20260221100147_jbRTO CA002L 2026-02-22T14:05:58.228Z 2026-03-02T14:21:19.970Z
9359437 9359437 20260221085350_V89Gg CA002L 2026-02-22T14:04:45.898Z 2026-03-02T14:21:15.140Z
9359393 9359393 20260221084431_v3BCm CA002L 2026-02-22T14:04:37.842Z 2026-03-02T14:21:14.678Z
9359202 9359202 20260221075825_RR82D CA002L 2026-02-22T14:04:00.274Z 2026-03-02T14:21:12.426Z
9359115 9359115 20260221072512_62Gxi CA002L 2026-02-22T14:03:49.160Z 2026-03-02T14:21:11.727Z
9359099 9359099 20260221072013_xAgTP CA002L 2026-02-22T14:03:46.439Z 2026-03-02T14:21:11.408Z
9359056 9359056 20260221070350_LTCHf CA002L 2026-02-22T14:03:35.837Z 2026-03-02T14:21:10.704Z
9358984 9358984 20260221063044_TW5Nx CA002L 2026-02-22T14:03:16.865Z 2026-03-02T14:21:09.827Z
9358976 9358976 20260221062017_8Qu3F CA002L 2026-02-22T14:03:12.724Z 2026-03-02T14:21:09.627Z
9358862 9358862 20260221052902_mJlVA CA002L 2026-02-22T14:02:43.191Z 2026-03-02T14:20:56.396Z
9358830 9358830 20260221051413_52mba CA002L 2026-02-22T14:02:33.684Z 2026-03-02T14:20:54.694Z
9358685 9358685 20260221035153_CZokQ CA002L 2026-02-22T14:01:57.738Z 2026-03-02T14:20:52.267Z
9358650 9358650 20260221033017_q0XEM CA002L 2026-02-22T14:01:47.678Z 2026-03-02T14:20:51.810Z
9353146 9353146 20260220100732_lCgLn CA002L 2026-02-21T14:03:52.133Z 2026-03-01T14:21:45.986Z
9353071 9353071 20260220095425_4Sy2E CA002L 2026-02-21T14:03:41.046Z 2026-03-01T14:21:45.329Z
9352964 9352964 20260220093937_XBk64 CA002L 2026-02-21T14:03:24.858Z 2026-03-01T14:21:44.435Z
9352853 9352853 20260220092408_Q7YXW CA002L 2026-02-21T14:03:06.896Z 2026-03-01T14:21:43.130Z
9352604 9352604 20260220083652_D11lf CA002L 2026-02-21T14:02:30.151Z 2026-03-01T14:21:40.388Z
9352542 9352542 20260220081608_X6Mxt CA002L 2026-02-21T14:02:19.592Z 2026-03-01T14:21:39.380Z
9352536 9352536 20260220081053_KXfXq CA002L 2026-02-21T14:02:18.173Z 2026-03-01T14:21:39.296Z
9352525 9352525 20260220075351_04du6 CA002L 2026-02-21T14:02:15.389Z 2026-03-01T14:21:39.172Z
9352489 9352489 20260220074018_y5UcG CA002L 2026-02-21T14:02:06.920Z 2026-03-01T14:21:38.592Z
9352432 9352432 20260220064932_SUlZL CA002L 2026-02-21T14:01:54.790Z 2026-03-01T14:21:37.755Z
9352329 9352329 20260220052449_AiA2t CA002L 2026-02-21T14:01:32.386Z 2026-03-01T14:21:36.058Z
9352269 9352269 20260220042015_1iScp CA002L 2026-02-21T14:01:19.918Z 2026-03-01T14:21:34.954Z
9352131 9352131 20260220022425_IAgy8 CA002L 2026-02-21T14:00:44.630Z 2026-03-01T14:21:32.718Z
9352089 9352089 20260220014948_fTBzU CA002L 2026-02-21T14:00:31.607Z 2026-03-01T14:21:32.045Z
9352042 9352042 20260220005930_DR7O6 CA002L 2026-02-21T14:00:19.866Z 2026-03-01T14:21:31.238Z
9352038 9352038 20260220005829_Wj5Z3 CA002L 2026-02-21T14:00:18.976Z 2026-03-01T14:21:31.168Z
9341693 9341693 20260219101944_rvGs9 CA002L 2026-02-20T14:00:57.251Z 2026-02-28T14:43:52.880Z
9341667 9341667 20260219101007_m27bc CA002L 2026-02-20T14:00:57.197Z 2026-02-28T14:43:52.696Z
9341614 9341614 20260219095306_n2a36 CA002L 2026-02-20T14:00:57.104Z 2026-02-28T14:43:52.375Z
9341451 9341451 20260219090842_QGh3H CA002L 2026-02-20T14:00:56.728Z 2026-02-28T14:43:51.260Z
9332041 9332041 20260216100430_K9mWP CA002L 2026-02-17T14:09:45.276Z 2026-02-25T14:42:05.293Z
9331719 9331719 20260216073643_hcDyU CA002L 2026-02-17T14:08:00.828Z 2026-02-25T14:42:00.893Z
9323940 9323940 20260214070436_fvLNt CA002L 2026-02-15T14:07:48.468Z 2026-02-23T14:46:49.571Z
9323638 9323638 20260214055018_MYFkR CA002L 2026-02-15T14:06:50.645Z 2026-02-23T14:46:34.854Z
9323571 9323571 20260214054242_tT1zx CA002L 2026-02-15T14:06:39.258Z 2026-02-23T14:46:34.048Z
9322896 9322896 20260214041715_7qhrl CA002L 2026-02-15T14:04:28.934Z 2026-02-23T14:46:24.380Z
9322664 9322664 20260214033925_RPvM6 CA002L 2026-02-15T14:03:29.736Z 2026-02-23T14:46:20.549Z
9322499 9322499 20260214031214_0MIAu CA002L 2026-02-15T14:02:39.149Z 2026-02-23T14:46:17.594Z
9321957 9321957 20260212235546_czcnQ CA002L 2026-02-14T14:22:01.112Z 2026-02-21T14:37:39.622Z
9320334 9320334 20260213093712_3z78k CA002L 2026-02-14T14:06:03.612Z 2026-02-22T14:41:53.203Z
9320320 9320320 20260213093140_b409X CA002L 2026-02-14T14:05:58.230Z 2026-02-22T14:41:52.853Z
9319783 9319783 20260213042557_vJVf6 CA002L 2026-02-14T14:02:26.195Z 2026-02-22T14:41:39.047Z
9319751 9319751 20260213040611_vSf8R CA002L 2026-02-14T14:02:12.640Z 2026-02-22T14:41:38.250Z
9319722 9319722 20260213035009_Rpd0S CA002L 2026-02-14T14:02:00.780Z 2026-02-22T14:41:37.656Z
9313828 9313828 20260210021432_RID70 CA002L 2026-02-11T14:18:59.931Z 2026-02-18T15:02:27.427Z
9312705 9312705 20260210104156_R1fvo CA002L 2026-02-11T14:07:44.853Z 2026-02-18T14:56:47.242Z
9312648 9312648 20260210102553_asUIB CA002L 2026-02-11T14:07:18.965Z 2026-02-18T14:56:38.585Z
9312603 9312603 20260210101504_kQBrD CA002L 2026-02-11T14:07:01.512Z 2026-02-18T14:56:34.797Z
9312465 9312465 20260210094128_5wI8y CA002L 2026-02-11T14:06:12.950Z 2026-02-18T14:56:27.902Z
9312440 9312440 20260210093427_6G5xF CA002L 2026-02-11T14:05:58.132Z 2026-02-18T14:56:25.746Z
9312199 9312199 20260210082136_W9uH3 CA002L 2026-02-11T14:04:20.620Z 2026-02-18T14:56:01.924Z
9312115 9312115 20260210073913_1AIVz CA002L 2026-02-11T14:03:46.423Z 2026-02-18T14:55:56.708Z
9312103 9312103 20260210072912_bZ21O CA002L 2026-02-11T14:03:42.856Z 2026-02-18T14:55:55.836Z
9312082 9312082 20260210070954_eeeWX CA002L 2026-02-11T14:03:35.535Z 2026-02-18T14:55:54.642Z
9312071 9312071 20260210070342_WyHUY CA002L 2026-02-11T14:03:30.852Z 2026-02-18T14:55:53.449Z
9311988 9311988 20260210060114_w6YZf CA002L 2026-02-11T14:02:49.586Z 2026-02-18T14:55:40.860Z
9311852 9311852 20260210044013_Z822g CA002L 2026-02-11T14:01:43.809Z 2026-02-18T14:55:32.527Z
9311821 9311821 20260210041947_0bKA2 CA002L 2026-02-11T14:01:26.491Z 2026-02-18T14:55:30.961Z
9311725 9311725 20260210032632_HTh2Z CA002L 2026-02-11T14:00:41.779Z 2026-02-18T14:55:17.791Z
9311719 9311719 20260210032356_rkjoQ CA002L 2026-02-11T14:00:39.700Z 2026-02-18T14:55:17.384Z
9311673 9311673 20260210025049_u2DL1 CA002L 2026-02-11T14:00:14.370Z 2026-02-18T14:55:13.751Z
9311542 9311542 20260209005007_N2QFh CA002L 2026-02-10T14:24:17.108Z 2026-02-16T14:54:54.297Z

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