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,430 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
8617947 8617947 20251127110006_hsCHe CA001G 2025-11-28T14:02:53.649Z 2025-12-05T14:54:06.877Z
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
8516473 8516473 20251118070634_M27Su CA001G 2025-11-19T14:41:32.088Z 2025-11-26T15:08:07.714Z
8469879 8469879 20251115034625_QgblR CA001G 2025-11-16T14:21:26.130Z 2025-11-23T15:17:58.407Z
8430336 8430336 20251111122128_pXm2B CA001G 2025-11-13T14:00:49.540Z 2025-11-20T15:19:26.361Z
8429866 8429866 20251111114554_JyZp8 CA001G 2025-11-12T14:45:10.867Z 2025-11-19T15:19:09.704Z
8429780 8429780 20251111111700_DPo3g CA001G 2025-11-12T14:45:05.268Z 2025-11-19T15:18:59.672Z
8429544 8429544 20251111101651_2Dyis CA001G 2025-11-12T14:44:43.032Z 2025-11-19T15:18:45.775Z
8429109 8429109 20251111083308_GndVK CA001G 2025-11-12T14:43:21.738Z 2025-11-19T15:18:26.804Z
8428632 8428632 20251111071927_iwtkd CA001G 2025-11-12T14:30:54.827Z 2025-11-19T15:18:22.445Z
8428489 8428489 20251111065937_7DUbu CA001G 2025-11-12T14:30:45.336Z 2025-11-19T15:18:20.213Z
8428361 8428361 20251111063100_EQq2F CA001G 2025-11-12T14:30:36.141Z 2025-11-19T15:18:18.022Z
8428188 8428188 20251111060430_zjNyI CA001G 2025-11-12T14:30:02.886Z 2025-11-12T14:30:02.886Z
8427186 8427186 20251111041345_n5ioZ CA001G 2025-11-12T14:27:22.904Z 2025-11-19T15:17:46.145Z
8404769 8404769 20251109022208_ytMfB CA001G 2025-11-10T14:12:38.151Z 2025-11-17T14:58:50.964Z
8400689 8400689 20251108121827_Ve3Q8 CA001G 2025-11-09T14:21:29.548Z 2025-11-16T15:06:02.449Z
8400557 8400557 20251108115904_frDfa CA001G 2025-11-09T14:21:02.012Z 2025-11-16T15:06:00.968Z
8398597 8398597 20251108050727_Tc3cH CA001G 2025-11-09T14:15:54.021Z 2025-11-16T15:04:55.327Z
8383760 8383760 20251104124233_JWGS4 CA001G 2025-11-06T14:29:36.006Z 2025-11-12T15:12:40.643Z
8383506 8383506 20251104105813_ALlOL CA001G 2025-11-06T14:27:51.459Z 2025-11-12T15:12:04.219Z
8376208 8376208 20251103101539_Es1fL CA001G 2025-11-05T14:36:25.511Z 2025-11-11T15:08:26.278Z
8375026 8375026 20251103055006_8Pqry CA001G 2025-11-05T14:33:57.421Z 2025-11-11T15:08:10.998Z
8374897 8374897 20251103052538_7zBdy CA001G 2025-11-05T14:33:25.741Z 2025-11-11T15:08:09.509Z
8374654 8374654 20251103042430_6u8kI CA001G 2025-11-05T14:32:40.100Z 2025-11-11T15:07:54.580Z
8373977 8373977 20251103021027_H4E6k CA001G 2025-11-05T14:30:28.701Z 2025-11-11T15:06:31.686Z
8373228 8373228 20251104122502_CvEc3 CA001G 2025-11-05T14:20:33.950Z 2025-11-12T15:12:35.838Z
8373067 8373067 20251104113806_NaKni CA001G 2025-11-05T14:19:59.245Z 2025-11-05T14:20:42.416Z
8373030 8373030 20251104112041_BdMfe CA001G 2025-11-05T14:19:52.872Z 2025-11-12T15:12:09.867Z
8372996 8372996 20251104110934_CCecW CA001G 2025-11-05T14:19:48.557Z 2025-11-05T14:20:42.396Z
8372964 8372964 20251104110239_I6Mfa CA001G 2025-11-05T14:19:44.403Z 2025-11-12T15:12:04.989Z
8372878 8372878 20251104103919_PM4RN CA001G 2025-11-05T14:19:36.048Z 2025-11-12T15:11:58.035Z
8372739 8372739 20251104101434_melnE CA001G 2025-11-05T14:19:06.092Z 2025-11-12T15:11:52.270Z
8372361 8372361 20251104083606_I7iOg CA001G 2025-11-05T14:18:02.114Z 2025-11-12T15:11:21.397Z
8367757 8367757 20251104131219_BPc2q CA001G 2025-11-05T14:00:15.651Z 2025-11-13T15:13:10.903Z
8367755 8367755 20251104130639_poLwK CA001G 2025-11-05T14:00:15.124Z 2025-11-13T15:13:10.164Z
8366687 8366687 20251102110931_2oI2e CA001G 2025-11-04T14:35:45.409Z 2025-11-10T15:10:34.984Z
8366609 8366609 20251102110251_HU9Kk CA001G 2025-11-04T14:35:39.341Z 2025-11-10T15:10:34.208Z
8366379 8366379 20251102103612_fPOfb CA001G 2025-11-04T14:35:07.612Z 2025-11-10T15:10:31.257Z
8359412 8359412 20251102130242_kI7ZB CA001G 2025-11-04T14:00:33.562Z 2025-11-11T15:02:17.574Z
8358571 8358571 20251102085344_F1EJS CA001G 2025-11-03T14:45:36.214Z 2025-11-03T14:45:36.214Z
8358428 8358428 20251102083952_xKWMD CA001G 2025-11-03T14:45:01.141Z 2025-11-03T14:45:01.141Z
8357561 8357561 20251102062832_m7S67 CA001G 2025-11-03T14:43:10.772Z 2025-11-10T15:09:51.187Z
8357526 8357526 20251102061952_b2gvC CA001G 2025-11-03T14:43:09.597Z 2025-11-03T14:43:09.597Z
8357361 8357361 20251102054102_OaavY CA001G 2025-11-03T14:42:59.509Z 2025-11-10T15:09:29.262Z
8340775 8340775 20251031122400_padRu CA001G 2025-11-02T14:35:39.268Z 2025-11-08T15:18:21.557Z
8340489 8340489 20251031115811_gRx6b CA001G 2025-11-02T14:35:27.080Z 2025-11-08T15:18:10.501Z
8340474 8340474 20251031115717_ANRLH CA001G 2025-11-02T14:35:26.044Z 2025-11-08T15:18:09.773Z
8340405 8340405 20251031115253_1aAzC CA001G 2025-11-02T14:35:23.892Z 2025-11-08T15:18:07.683Z
8340323 8340323 20251031114349_s7VSC CA001G 2025-11-02T14:35:20.705Z 2025-11-08T15:18:05.638Z
8339483 8339483 20251031102751_5xYy3 CA001G 2025-11-02T14:34:15.819Z 2025-11-08T15:17:38.334Z
8339355 8339355 20251031101951_EwM1Z CA001G 2025-11-02T14:34:11.545Z 2025-11-08T15:17:34.609Z
8339330 8339330 20251031101751_Y15ah CA001G 2025-11-02T14:34:05.301Z 2025-11-08T15:17:34.283Z
8338991 8338991 20251031094704_hMmyM CA001G 2025-11-02T14:33:23.635Z 2025-11-08T15:17:24.113Z
8338847 8338847 20251031092739_O816I CA001G 2025-11-02T14:33:18.378Z 2025-11-08T15:17:17.921Z
8338689 8338689 20251031091033_Djrc3 CA001G 2025-11-02T14:32:58.618Z 2025-11-08T15:17:08.674Z
8338444 8338444 20251031084349_N2DMm CA001G 2025-11-02T14:32:37.887Z 2025-11-08T15:16:45.069Z
8338193 8338193 20251031082042_s6c1s CA001G 2025-11-02T14:31:55.362Z 2025-11-08T15:16:33.784Z
8338028 8338028 20251031075752_hdrPs CA001G 2025-11-02T14:31:41.608Z 2025-11-08T15:16:31.443Z
8337710 8337710 20251031071840_aEDot CA001G 2025-11-02T14:31:27.306Z 2025-11-08T15:16:25.078Z
8337430 8337430 20251031064332_P38yV CA001G 2025-11-02T14:30:58.126Z 2025-11-08T15:16:22.377Z
8337428 8337428 20251031064129_Mii8O CA001G 2025-11-02T14:30:58.041Z 2025-11-08T15:16:22.350Z
8336939 8336939 20251031053332_uFD3y CA001G 2025-11-02T14:30:19.142Z 2025-11-08T15:16:17.047Z
8335656 8335656 20251031034019_hq3EL CA001G 2025-11-02T14:27:59.887Z 2025-11-08T15:14:58.261Z
8334853 8334853 20251031022956_0sQXn CA001G 2025-11-02T14:26:14.615Z 2025-11-08T15:14:09.548Z
8334070 8334070 20251031011922_lTzL2 CA001G 2025-11-02T14:24:21.817Z 2025-11-08T15:13:07.080Z
8328625 8328625 20251031131244_aFFfK CA001G 2025-11-02T14:00:34.988Z 2025-11-09T14:57:59.523Z
8328344 8328344 20251030124854_R40Ed CA001G 2025-11-01T12:38:37.087Z 2025-11-07T15:19:14.151Z
8328323 8328323 20251030124516_8nZhm CA001G 2025-11-01T12:38:35.969Z 2025-11-07T15:19:13.886Z
8328045 8328045 20251030121319_XRyuT CA001G 2025-11-01T12:38:20.944Z 2025-11-07T15:19:09.971Z
8327984 8327984 20251030120908_xhZV3 CA001G 2025-11-01T12:38:17.714Z 2025-11-07T15:19:09.095Z
8327927 8327927 20251030120411_x2I77 CA001G 2025-11-01T12:38:15.682Z 2025-11-07T15:19:08.461Z
8327193 8327193 20251030105019_92HWY CA001G 2025-11-01T12:37:00.695Z 2025-11-07T15:18:49.581Z
8326953 8326953 20251030102635_6AIeo CA001G 2025-11-01T12:36:31.164Z 2025-11-07T15:18:36.018Z
8322015 8322015 20251030035404_InxnJ CA001G 2025-11-01T12:28:34.297Z 2025-11-07T15:15:35.429Z
8309650 8309650 20251029123606_LqXhc CA001G 2025-10-31T12:31:32.737Z 2025-11-06T15:16:50.966Z
8309090 8309090 20251029115302_3j9ay CA001G 2025-10-31T12:30:28.164Z 2025-11-06T15:16:29.167Z
8307927 8307927 20251029102139_kIDB2 CA001G 2025-10-31T12:28:36.908Z 2025-11-06T15:15:51.189Z
8306585 8306585 20251029082250_0C6f3 CA001G 2025-10-31T12:25:47.519Z 2025-11-06T15:15:13.149Z
8295999 8295999 20251028122855_RzHmZ CA001G 2025-10-30T12:43:20.311Z 2025-11-05T15:25:29.911Z
8295953 8295953 20251028122226_UiPJU CA001G 2025-10-30T12:43:18.200Z 2025-11-05T15:25:29.365Z
8295903 8295903 20251028121858_dX5v6 CA001G 2025-10-30T12:43:16.259Z 2025-11-05T15:25:28.273Z
8295532 8295532 20251028115758_fhvQo CA001G 2025-10-30T12:43:03.110Z 2025-11-05T15:25:18.466Z
8295401 8295401 20251028114346_DWB8K CA001G 2025-10-30T12:42:57.257Z 2025-11-05T15:25:13.305Z
8295389 8295389 20251028114209_Te2ui CA001G 2025-10-30T12:42:56.077Z 2025-11-05T15:25:12.012Z
8295048 8295048 20251028111501_3vHZK CA001G 2025-10-30T12:42:02.692Z 2025-11-05T15:24:55.686Z
8294928 8294928 20251028110656_KB5Hz CA001G 2025-10-30T12:41:35.890Z 2025-11-05T15:24:51.910Z

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