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

6,352 rows where station_code = "CA0022" 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
8403913 8403913 20251109003421_5lj8A CA0022 2025-11-10T14:10:21.353Z 2025-11-17T14:58:40.397Z
8393676 8393676 20251107094831_dyn93 CA0022 2025-11-08T14:21:45.628Z 2025-11-15T15:00:55.718Z
8392952 8392952 20251107075313_Ei7Qw CA0022 2025-11-08T14:19:41.562Z 2025-11-15T15:00:48.818Z
8392841 8392841 20251107072629_sO3EM CA0022 2025-11-08T14:19:28.496Z 2025-11-15T15:00:48.154Z
8382054 8382054 20251105090044_jRnyp CA0022 2025-11-06T14:16:58.449Z 2025-11-13T15:15:45.959Z
8374946 8374946 20251103053550_71dBB CA0022 2025-11-05T14:33:28.402Z 2025-11-11T15:08:09.959Z
8374786 8374786 20251103045424_7ievt CA0022 2025-11-05T14:33:12.146Z 2025-11-11T15:08:07.394Z
8374715 8374715 20251103043946_V7yGG CA0022 2025-11-05T14:33:05.467Z 2025-11-11T15:08:05.856Z
8374662 8374662 20251103042441_DxB6B CA0022 2025-11-05T14:32:42.485Z 2025-11-11T15:07:58.724Z
8374268 8374268 20251103031918_mtbGY CA0022 2025-11-05T14:31:31.622Z 2025-11-11T15:07:22.462Z
8373837 8373837 20251103011332_ojOl3 CA0022 2025-11-05T14:29:43.056Z 2025-11-11T15:06:24.881Z
8373728 8373728 20251103000941_ZCns3 CA0022 2025-11-05T14:28:56.430Z 2025-11-11T15:06:18.912Z
8356823 8356823 20251102032613_VfBCD CA0022 2025-11-03T14:42:14.730Z 2025-11-10T15:08:26.893Z
8326136 8326136 20251030091321_Q06u8 CA0022 2025-11-01T12:35:17.570Z 2025-11-07T15:17:43.295Z
8326129 8326129 20251030091150_GDCwO CA0022 2025-11-01T12:35:17.399Z 2025-11-07T15:17:43.211Z
8325320 8325320 20251030073404_Z7iL2 CA0022 2025-11-01T12:33:43.299Z 2025-11-07T15:17:20.633Z
8325050 8325050 20251030070953_iNftm CA0022 2025-11-01T12:33:19.970Z 2025-11-07T15:17:17.607Z
8325004 8325004 20251030070029_5nLAL CA0022 2025-11-01T12:33:15.280Z 2025-11-07T15:17:16.888Z
8324890 8324890 20251030064021_Rk0LS CA0022 2025-11-01T12:33:09.474Z 2025-11-07T15:17:14.655Z
8324872 8324872 20251030063853_f4k3e CA0022 2025-11-01T12:33:08.771Z 2025-11-07T15:17:14.519Z
8324836 8324836 20251030063409_nDBO6 CA0022 2025-11-01T12:33:06.887Z 2025-11-07T15:17:14.156Z
8324792 8324792 20251030062802_yqdL2 CA0022 2025-11-01T12:33:03.925Z 2025-11-07T15:17:13.158Z
8324785 8324785 20251030062724_dyNSG CA0022 2025-11-01T12:33:03.362Z 2025-11-07T15:17:13.020Z
8324653 8324653 20251030060847_O93Cm CA0022 2025-11-01T12:32:34.456Z 2025-11-07T15:17:10.942Z
8324648 8324648 20251030060619_3wQmB CA0022 2025-11-01T12:32:34.015Z 2025-11-07T15:17:10.828Z
8324599 8324599 20251030055848_hFtD8 CA0022 2025-11-01T12:32:30.802Z 2025-11-07T15:17:09.969Z
8324582 8324582 20251030055757_wG0Y5 CA0022 2025-11-01T12:32:28.105Z 2025-11-07T15:17:09.580Z
8324538 8324538 20251030055226_Efady CA0022 2025-11-01T12:32:25.021Z 2025-11-07T15:17:08.175Z
8324471 8324471 20251030054617_BF0nJ CA0022 2025-11-01T12:32:22.261Z 2025-11-07T15:17:07.300Z
8324174 8324174 20251030052800_XyVZC CA0022 2025-11-01T12:31:58.755Z 2025-11-07T15:17:03.815Z
8323884 8323884 20251030051332_QltUE CA0022 2025-11-01T12:31:30.507Z 2025-11-07T15:16:42.061Z
8323824 8323824 20251030051121_OEU1G CA0022 2025-11-01T12:31:28.028Z 2025-11-07T15:16:31.394Z
8323476 8323476 20251030045640_umhEO CA0022 2025-11-01T12:30:42.130Z 2025-11-07T15:16:02.601Z
8323473 8323473 20251030045631_2x39f CA0022 2025-11-01T12:30:42.052Z 2025-11-07T15:16:02.348Z
8322804 8322804 20251030042659_nmsPC CA0022 2025-11-01T12:29:43.735Z 2025-11-07T15:15:45.752Z
8322567 8322567 20251030041702_4Jspb CA0022 2025-11-01T12:29:30.546Z 2025-11-07T15:15:41.587Z
8321948 8321948 20251030035220_J5oqE CA0022 2025-11-01T12:28:32.030Z 2025-11-07T15:15:34.563Z
8321838 8321838 20251030034738_fa3hA CA0022 2025-11-01T12:28:26.413Z 2025-11-07T15:15:33.448Z
8320885 8320885 20251030031717_oH2v3 CA0022 2025-11-01T12:26:56.343Z 2025-11-07T15:14:51.951Z
8319632 8319632 20251030021730_Ku76m CA0022 2025-11-01T12:25:03.924Z 2025-11-07T15:13:43.587Z
8319550 8319550 20251030021302_i0vq6 CA0022 2025-11-01T12:24:58.942Z 2025-11-07T15:13:42.891Z
8306913 8306913 20251029085214_6SFnn CA0022 2025-10-31T12:26:26.814Z 2025-11-06T15:15:19.577Z
8306739 8306739 20251029083545_ZpCUe CA0022 2025-10-31T12:26:12.496Z 2025-11-06T15:15:14.825Z
8306631 8306631 20251029082714_5SeP2 CA0022 2025-10-31T12:25:56.763Z 2025-11-06T15:15:13.908Z
8306582 8306582 20251029082245_iJsNr CA0022 2025-10-31T12:25:46.519Z 2025-11-06T15:15:13.145Z
8306514 8306514 20251029081338_YjnE3 CA0022 2025-10-31T12:25:15.705Z 2025-11-06T15:15:10.955Z
8306440 8306440 20251029080456_37NbG CA0022 2025-10-31T12:25:07.580Z 2025-11-06T15:15:07.268Z
8306393 8306393 20251029080143_ixQ1e CA0022 2025-10-31T12:25:04.259Z 2025-11-06T15:15:04.931Z
8306266 8306266 20251029074628_5rxTI CA0022 2025-10-31T12:24:54.472Z 2025-11-06T15:15:01.721Z
8306180 8306180 20251029073418_IixoW CA0022 2025-10-31T12:24:31.609Z 2025-11-06T15:14:59.275Z
8306049 8306049 20251029071519_9rwlQ CA0022 2025-10-31T12:24:19.292Z 2025-11-06T15:14:56.727Z
8306010 8306010 20251029070949_S2Duh CA0022 2025-10-31T12:24:16.244Z 2025-11-06T15:14:55.381Z
8305947 8305947 20251029065924_ly79q CA0022 2025-10-31T12:24:06.624Z 2025-11-06T15:14:54.550Z
8305871 8305871 20251029065306_BFfto CA0022 2025-10-31T12:23:50.861Z 2025-11-06T15:14:52.793Z
8305734 8305734 20251029062330_ZQDvY CA0022 2025-10-31T12:23:10.037Z 2025-11-06T15:14:48.397Z
8305511 8305511 20251029053825_AD58X CA0022 2025-10-31T12:22:47.570Z 2025-11-06T15:14:40.803Z
8305472 8305472 20251029053103_V3A6c CA0022 2025-10-31T12:22:35.640Z 2025-11-06T15:14:39.924Z
8305176 8305176 20251029042404_aWuVY CA0022 2025-10-31T12:21:06.792Z 2025-11-06T15:14:14.838Z
8304958 8304958 20251029030132_saowV CA0022 2025-10-31T12:17:52.249Z 2025-11-06T15:13:37.446Z
8304948 8304948 20251029025812_pO4ja CA0022 2025-10-31T12:17:46.717Z 2025-11-06T15:13:36.688Z
8304938 8304938 20251029025356_iBppZ CA0022 2025-10-31T12:17:44.093Z 2025-11-06T15:13:36.162Z
8304936 8304936 20251029025232_z41u6 CA0022 2025-10-31T12:17:43.635Z 2025-11-06T15:13:36.105Z
8304918 8304918 20251029024351_t2w2y CA0022 2025-10-31T12:17:38.845Z 2025-11-06T15:13:34.670Z
8304910 8304910 20251029023723_rUOOs CA0022 2025-10-31T12:17:36.292Z 2025-11-06T15:13:33.959Z
8304859 8304859 20251029020802_cu3h3 CA0022 2025-10-31T12:17:03.866Z 2025-11-06T15:13:20.007Z
8304856 8304856 20251029020531_tvWf0 CA0022 2025-10-31T12:17:02.551Z 2025-11-06T15:13:19.808Z
8304808 8304808 20251029012051_16uBb CA0022 2025-10-31T12:16:32.519Z 2025-11-06T15:12:55.767Z
8304803 8304803 20251029011700_36btN CA0022 2025-10-31T12:16:30.284Z 2025-11-06T15:12:54.382Z
8304797 8304797 20251029010952_4Mw1Z CA0022 2025-10-31T12:16:20.855Z 2025-11-06T15:12:53.373Z
8304787 8304787 20251029005209_oW33V CA0022 2025-10-31T12:16:10.308Z 2025-11-06T15:12:48.035Z
8304785 8304785 20251029004627_7zBnv CA0022 2025-10-31T12:16:07.485Z 2025-11-06T15:12:46.721Z
8304771 8304771 20251028233420_pa9T2 CA0022 2025-10-31T12:15:18.354Z 2025-11-06T15:12:29.391Z
8304769 8304769 20251028230925_x3Kxm CA0022 2025-10-31T12:15:09.296Z 2025-11-06T15:12:27.314Z
8304759 8304759 20251028225648_tAbIS CA0022 2025-10-31T12:14:56.928Z 2025-11-06T15:12:26.453Z
8294347 8294347 20251028102929_Myrkt CA0022 2025-10-30T12:40:59.502Z 2025-11-05T15:24:23.932Z
8294017 8294017 20251028101059_kHeUb CA0022 2025-10-30T12:40:36.974Z 2025-11-05T15:24:16.483Z
8293716 8293716 20251028095258_OkSoP CA0022 2025-10-30T12:39:46.936Z 2025-11-05T15:24:04.455Z
8293570 8293570 20251028094436_2LwQK CA0022 2025-10-30T12:39:40.525Z 2025-11-05T15:24:01.160Z
8293527 8293527 20251028094052_7Fb9U CA0022 2025-10-30T12:39:38.528Z 2025-11-05T15:24:00.706Z
8293376 8293376 20251028093215_pxv3m CA0022 2025-10-30T12:39:31.626Z 2025-11-05T15:23:55.186Z
8293221 8293221 20251028092416_8xmQt CA0022 2025-10-30T12:39:07.287Z 2025-11-05T15:23:51.952Z
8293209 8293209 20251028092325_0M6Bm CA0022 2025-10-30T12:39:04.140Z 2025-11-05T15:23:51.930Z
8292969 8292969 20251028090502_OzJ0x CA0022 2025-10-30T12:38:36.443Z 2025-11-05T15:23:41.384Z
8292745 8292745 20251028084749_AqO3X CA0022 2025-10-30T12:38:25.356Z 2025-11-05T15:23:33.978Z
8292685 8292685 20251028084428_zOM6X CA0022 2025-10-30T12:38:22.809Z 2025-11-05T15:23:33.507Z
8292551 8292551 20251028083217_hLW9B CA0022 2025-10-30T12:37:50.186Z 2025-11-05T15:23:31.676Z
8292488 8292488 20251028082851_0SCH0 CA0022 2025-10-30T12:37:39.610Z 2025-11-05T15:23:30.880Z
8292373 8292373 20251028082027_XqQlx CA0022 2025-10-30T12:37:32.333Z 2025-11-05T15:23:29.583Z
8292353 8292353 20251028081823_vusCV CA0022 2025-10-30T12:37:31.441Z 2025-11-05T15:23:29.514Z
8292325 8292325 20251028081619_DFvtg CA0022 2025-10-30T12:37:30.034Z 2025-11-05T15:23:29.205Z
8291970 8291970 20251028074928_vIRlv CA0022 2025-10-30T12:36:40.478Z 2025-11-05T15:23:23.052Z
8291928 8291928 20251028074603_jGjHu CA0022 2025-10-30T12:36:37.784Z 2025-11-05T15:23:22.551Z
8291799 8291799 20251028073451_4uCwy CA0022 2025-10-30T12:36:23.726Z 2025-11-05T15:23:17.797Z
8291678 8291678 20251028072405_6O4cJ CA0022 2025-10-30T12:36:17.979Z 2025-11-05T15:23:15.407Z
8291489 8291489 20251028070359_s3qMA CA0022 2025-10-30T12:36:09.127Z 2025-11-05T15:23:13.987Z
8291355 8291355 20251028064625_Ty2yS CA0022 2025-10-30T12:35:38.684Z 2025-11-05T15:23:12.367Z
8291130 8291130 20251028061523_QcIsP CA0022 2025-10-30T12:35:21.814Z 2025-11-05T15:23:08.832Z
8225837 8225837 20251024083952_FhYNo CA0022 2025-10-26T12:43:53.045Z 2025-11-01T13:11:23.023Z
8225826 8225826 20251024083923_RlM4a CA0022 2025-10-26T12:43:51.750Z 2025-11-01T13:11:23.008Z
8225438 8225438 20251024080528_Dg80q CA0022 2025-10-26T12:43:16.917Z 2025-11-01T13:11:21.911Z

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