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

2,354 rows where station_code = "CA003A" 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
9273427 9273427 20260128060844_oOh6M CA003A 2026-01-29T14:29:45.001Z 2026-01-29T14:30:25.809Z
9268250 9268250 20260128093101_Y2pfO CA003A 2026-01-29T14:01:59.415Z 2026-01-29T14:01:59.415Z
9268084 9268084 20260128084441_ioD4h CA003A 2026-01-29T14:00:59.278Z 2026-01-29T14:00:59.278Z
9267994 9267994 20260128072855_6leWf CA003A 2026-01-29T14:00:19.620Z 2026-01-29T14:00:19.620Z
9267933 9267933 20260127065928_2IMz7 CA003A 2026-01-28T14:23:56.145Z 2026-01-29T14:35:54.967Z
9267774 9267774 20260127045508_3SNH1 CA003A 2026-01-28T14:23:15.638Z 2026-01-29T14:35:42.008Z
9267764 9267764 20260127044949_eCnd8 CA003A 2026-01-28T14:23:13.230Z 2026-01-29T14:35:40.663Z
9267686 9267686 20260127041625_YV23F CA003A 2026-01-28T14:22:52.698Z 2026-01-29T14:35:28.465Z
9267640 9267640 20260127035547_FBeQm CA003A 2026-01-28T14:22:38.823Z 2026-01-29T14:35:24.315Z
9263434 9263434 20260127075530_8hDv5 CA003A 2026-01-28T14:00:33.064Z 2026-01-29T14:30:16.503Z
9263432 9263432 20260127075510_Nhvo2 CA003A 2026-01-28T14:00:32.008Z 2026-01-29T14:30:16.503Z
9260359 9260359 20260125035849_IA0co CA003A 2026-01-26T14:21:23.856Z 2026-01-29T14:44:07.926Z
9259959 9259959 20260125013150_nthFH CA003A 2026-01-26T14:19:33.776Z 2026-01-29T14:43:37.209Z
9259773 9259773 20260125000257_oS1Ot CA003A 2026-01-26T14:18:32.995Z 2026-01-29T14:43:18.460Z
9256415 9256415 20260124082328_0Gla3 CA003A 2026-01-25T14:16:59.159Z 2026-01-29T14:48:48.641Z
9256394 9256394 20260124081418_D6bzj CA003A 2026-01-25T14:16:55.220Z 2026-01-29T14:48:47.304Z
9256313 9256313 20260124071353_J077d CA003A 2026-01-25T14:16:37.686Z 2026-01-29T14:48:36.818Z
9256301 9256301 20260124070513_5kh2N CA003A 2026-01-25T14:16:34.551Z 2026-01-29T14:48:36.071Z
9256278 9256278 20260124063712_j07lF CA003A 2026-01-25T14:16:24.595Z 2026-01-29T14:48:34.069Z
9255812 9255812 20260124050141_k49zb CA003A 2026-01-25T14:14:51.873Z 2026-01-29T14:47:59.256Z
9255690 9255690 20260124043153_TjWHF CA003A 2026-01-25T14:14:23.168Z 2026-01-29T14:47:51.536Z
9255261 9255261 20260124021510_22bLJ CA003A 2026-01-25T14:12:34.674Z 2026-01-29T14:47:13.004Z
9255213 9255213 20260124014907_yj3Zp CA003A 2026-01-25T14:12:23.977Z 2026-01-29T14:47:10.470Z
9253352 9253352 20260124110943_2CKdo CA003A 2026-01-25T14:02:12.190Z 2026-01-29T14:40:40.111Z
9253287 9253287 20260124104542_advKV CA003A 2026-01-25T14:01:49.518Z 2026-01-29T14:40:32.832Z
9253204 9253204 20260124100934_2ofAi CA003A 2026-01-25T14:01:18.624Z 2026-01-29T14:40:26.584Z
9252720 9252720 20260123054103_36uwA CA003A 2026-01-24T14:16:54.434Z 2026-01-29T14:53:20.685Z
9238849 9238849 20260120095841_1LKGl CA003A 2026-01-21T14:30:42.909Z 2026-01-28T15:03:04.093Z
9238580 9238580 20260120090733_nVtu4 CA003A 2026-01-21T14:29:59.832Z 2026-01-28T15:02:39.583Z
9238502 9238502 20260120084757_102g4 CA003A 2026-01-21T14:29:44.603Z 2026-01-28T15:02:35.994Z
9238370 9238370 20260120082803_2JDAU CA003A 2026-01-21T14:29:27.547Z 2026-01-28T15:02:31.266Z
9238347 9238347 20260120082432_0DZ7o CA003A 2026-01-21T14:29:24.674Z 2026-01-28T15:02:29.938Z
9215722 9215722 20260116105151_A05c2 CA003A 2026-01-17T14:26:40.920Z 2026-01-24T15:15:11.059Z
9215583 9215583 20260116103239_vn8ZO CA003A 2026-01-17T14:26:12.323Z 2026-01-24T15:15:04.146Z
9215303 9215303 20260116094946_F3Qmz CA003A 2026-01-17T14:25:07.414Z 2026-01-24T15:14:38.381Z
9215095 9215095 20260116091649_aqX11 CA003A 2026-01-17T14:24:24.962Z 2026-01-24T15:14:30.282Z
9176858 9176858 20260110063312_0lYcG CA003A 2026-01-11T14:10:12.048Z 2026-01-18T15:09:05.242Z
9156263 9156263 20260104090515_TqpWQ CA003A 2026-01-06T14:39:05.962Z 2026-01-12T15:12:02.725Z
9156237 9156237 20260104085532_ntW0S CA003A 2026-01-06T14:39:03.612Z 2026-01-12T15:11:51.564Z
9156224 9156224 20260104083952_PTA9b CA003A 2026-01-06T14:39:00.981Z 2026-01-12T15:11:45.549Z
9128331 9128331 20260102075028_8KsDT CA003A 2026-01-03T14:14:35.501Z 2026-01-09T14:50:43.057Z
9128137 9128137 20260102062228_mWzqa CA003A 2026-01-03T14:13:32.816Z 2026-01-09T14:50:26.270Z
9122624 9122624 20260101105926_rkqDp CA003A 2026-01-02T14:14:07.750Z 2026-01-09T14:53:38.314Z
9117421 9117421 20251231105620_owC7R CA003A 2026-01-01T14:31:32.844Z 2026-01-08T15:12:57.624Z
9117129 9117129 20251231092539_RR2mH CA003A 2026-01-01T14:30:14.917Z 2026-01-08T15:12:39.021Z
9087384 9087384 20251228090614_67poF CA003A 2025-12-30T14:43:51.366Z 2026-01-05T15:11:04.101Z
9087338 9087338 20251228085346_vlhkB CA003A 2025-12-30T14:43:45.353Z 2026-01-05T15:11:02.293Z
9087248 9087248 20251228081013_JoyWV CA003A 2025-12-30T14:43:33.651Z 2026-01-05T15:10:58.508Z
9087116 9087116 20251228070618_p7tfw CA003A 2025-12-30T14:43:05.623Z 2025-12-31T14:52:53.790Z
9087090 9087090 20251228070008_9an53 CA003A 2025-12-30T14:43:02.339Z 2026-01-05T15:10:52.554Z
9086988 9086988 20251228063745_zEcam CA003A 2025-12-30T14:42:38.182Z 2026-01-05T15:10:48.733Z
9086951 9086951 20251228062112_UhNjU CA003A 2025-12-30T14:42:32.682Z 2026-01-05T15:10:47.145Z
9086940 9086940 20251228061929_Une7Z CA003A 2025-12-30T14:42:31.237Z 2026-01-05T15:10:46.854Z
9086840 9086840 20251228054756_dvFus CA003A 2025-12-30T14:42:18.673Z 2026-01-05T15:10:33.570Z
9086536 9086536 20251228050957_puE0y CA003A 2025-12-30T14:41:25.439Z 2026-01-05T15:10:21.404Z
9086462 9086462 20251228050107_ADxru CA003A 2025-12-30T14:41:08.889Z 2025-12-31T14:52:11.856Z
9086246 9086246 20251228044021_GzbIQ CA003A 2025-12-30T14:40:35.920Z 2026-01-05T15:10:00.801Z
9083742 9083742 20251228002833_fq92X CA003A 2025-12-30T14:33:36.145Z 2026-01-05T15:08:09.170Z
9083063 9083063 20251227224920_rV30J CA003A 2025-12-30T14:31:28.136Z 2026-01-05T15:07:36.111Z
9067844 9067844 20251226104731_vNRRb CA003A 2025-12-29T14:42:56.776Z 2025-12-30T15:20:43.513Z
9067653 9067653 20251226101624_zb7wk CA003A 2025-12-29T14:42:27.587Z 2026-01-03T15:39:01.120Z
9067328 9067328 20251226091245_ZCe2g CA003A 2025-12-29T14:41:45.902Z 2025-12-30T15:20:11.211Z
9066800 9066800 20251226065115_YcxDT CA003A 2025-12-29T14:40:32.674Z 2025-12-30T15:19:58.201Z
9066470 9066470 20251226061828_mG3gS CA003A 2025-12-29T14:40:03.498Z 2026-01-03T15:37:50.847Z
9066329 9066329 20251226060620_e03IU CA003A 2025-12-29T14:39:52.276Z 2026-01-03T15:37:47.216Z
9066199 9066199 20251226055728_faaZF CA003A 2025-12-29T14:39:43.215Z 2026-01-03T15:37:34.202Z
9065608 9065608 20251226051952_5TjSt CA003A 2025-12-29T14:38:43.802Z 2025-12-29T14:51:15.473Z
9059821 9059821 20251225230244_P6p1r CA003A 2025-12-29T14:28:03.838Z 2025-12-29T14:51:12.374Z
9048036 9048036 20251222083652_odQXt CA003A 2025-12-28T15:00:14.349Z 2025-12-30T15:47:44.578Z
9047940 9047940 20251222035246_dsHxN CA003A 2025-12-28T14:58:21.922Z 2025-12-30T15:46:34.339Z
9019896 9019896 20251220105448_vUU2D CA003A 2025-12-27T15:05:04.429Z 2025-12-29T15:24:39.466Z
9019684 9019684 20251220102438_SdWAm CA003A 2025-12-27T15:04:57.444Z 2025-12-29T15:24:36.746Z
9019598 9019598 20251220101402_PgfBy CA003A 2025-12-27T15:04:50.827Z 2025-12-29T15:24:35.566Z
9019521 9019521 20251220100453_J3lma CA003A 2025-12-27T15:04:33.054Z 2025-12-29T15:24:34.907Z
9019416 9019416 20251220094721_XshsX CA003A 2025-12-27T15:04:16.232Z 2025-12-29T15:24:33.423Z
9019401 9019401 20251220094601_GWgkq CA003A 2025-12-27T15:04:14.995Z 2025-12-29T15:24:33.130Z
9019275 9019275 20251220092811_Spdw4 CA003A 2025-12-27T15:03:53.485Z 2025-12-29T15:24:31.446Z
9019213 9019213 20251220091642_L1WXx CA003A 2025-12-27T15:03:29.901Z 2025-12-29T15:24:30.426Z
9019154 9019154 20251220090824_Gj5Ec CA003A 2025-12-27T15:03:19.001Z 2025-12-29T15:24:29.487Z
9006680 9006680 20251221070500_voFRj CA003A 2025-12-27T14:38:24.590Z 2025-12-27T14:38:24.590Z
9006485 9006485 20251221061612_DhLZ2 CA003A 2025-12-27T14:37:52.721Z 2025-12-27T14:37:52.721Z
9000806 9000806 20251222092639_8CYJi CA003A 2025-12-27T14:20:28.292Z 2025-12-28T15:00:52.236Z
9000609 9000609 20251222091245_gw2Mr CA003A 2025-12-27T14:19:51.679Z 2025-12-30T15:47:50.092Z
9000374 9000374 20251222090007_zkWfe CA003A 2025-12-27T14:19:10.875Z 2025-12-30T15:47:47.950Z
9000252 9000252 20251222085208_Hht1j CA003A 2025-12-27T14:19:00.723Z 2025-12-28T15:00:21.384Z
9000215 9000215 20251222085023_tupOY CA003A 2025-12-27T14:18:57.163Z 2025-12-30T15:47:46.340Z
9000178 9000178 20251222084742_sZLkJ CA003A 2025-12-27T14:18:43.643Z 2025-12-28T15:00:19.380Z
9000120 9000120 20251222084320_0h0Tk CA003A 2025-12-27T14:18:32.600Z 2025-12-28T15:00:16.628Z
9000090 9000090 20251222084201_wvYUn CA003A 2025-12-27T14:18:28.888Z 2025-12-30T15:47:45.241Z
9000008 9000008 20251222083636_YeTGq CA003A 2025-12-27T14:18:22.239Z 2025-12-30T15:47:44.544Z
8999958 8999958 20251222083312_3hehe CA003A 2025-12-27T14:18:17.646Z 2025-12-28T15:00:13.207Z
8999921 8999921 20251222083032_BTeKQ CA003A 2025-12-27T14:18:13.556Z 2025-12-28T15:00:12.454Z
8999873 8999873 20251222082631_DgqdD CA003A 2025-12-27T14:18:04.206Z 2025-12-28T15:00:11.498Z
8999608 8999608 20251222075910_5HxO3 CA003A 2025-12-27T14:17:14.716Z 2025-12-28T15:00:05.567Z
8997840 8997840 20251222045532_Kjt8I CA003A 2025-12-27T14:11:29.844Z 2025-12-30T15:46:40.809Z
8997140 8997140 20251222034510_vJkHh CA003A 2025-12-27T14:08:29.057Z 2025-12-30T15:46:33.305Z
8997090 8997090 20251222033931_m9lgx CA003A 2025-12-27T14:08:15.801Z 2025-12-28T14:58:18.653Z
8996698 8996698 20251222024738_tYr1t CA003A 2025-12-27T14:06:02.477Z 2025-12-30T15:46:00.675Z
8996433 8996433 20251222021421_eUyaZ CA003A 2025-12-27T14:04:41.145Z 2025-12-30T15:45:47.767Z
8996401 8996401 20251222021115_P3hhE CA003A 2025-12-27T14:04:33.995Z 2025-12-30T15:45:47.541Z

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