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

137 rows where station_code = "CA0036" 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
9589141 9589141 20260328023216_rQerX CA0036 2026-03-29T12:00:45.978Z 2026-04-06T12:37:02.985Z
9586716 9586716 20260327091920_zxST6 CA0036 2026-03-28T12:03:50.091Z 2026-04-05T12:33:38.922Z
9572454 9572454 20260324090435_EK2Qn CA0036 2026-03-25T12:05:13.298Z 2026-04-02T12:35:25.513Z
9572363 9572363 20260324084316_Hee1y CA0036 2026-03-25T12:04:50.742Z 2026-04-02T12:35:21.612Z
9572160 9572160 20260324075828_jtL4j CA0036 2026-03-25T12:04:04.347Z 2026-04-02T12:35:05.907Z
9572154 9572154 20260324075612_LJiq8 CA0036 2026-03-25T12:04:02.857Z 2026-04-02T12:35:05.638Z
9571865 9571865 20260324052549_mOupJ CA0036 2026-03-25T12:03:02.023Z 2026-04-02T12:34:52.973Z
9571842 9571842 20260324050739_nUvF2 CA0036 2026-03-25T12:02:56.200Z 2026-04-02T12:34:51.598Z
9571326 9571326 20260324011538_QAeLX CA0036 2026-03-25T12:01:02.880Z 2026-04-02T12:34:20.219Z
9571256 9571256 20260324004756_84Rcc CA0036 2026-03-25T12:00:42.675Z 2026-04-02T12:34:17.033Z
9533755 9533755 20260320025428_pn2EK CA0036 2026-03-21T12:06:11.652Z 2026-03-28T12:34:00.115Z
9470860 9470860 20260313080323_32YVs CA0036 2026-03-14T12:08:39.924Z 2026-03-21T12:49:14.892Z
9470672 9470672 20260313071437_UFKrx CA0036 2026-03-14T12:08:04.908Z 2026-03-21T12:49:11.803Z
9470480 9470480 20260313060656_G4zU9 CA0036 2026-03-14T12:07:32.451Z 2026-03-21T12:49:10.258Z
9470322 9470322 20260313051033_5nVKt CA0036 2026-03-14T12:07:01.418Z 2026-03-21T12:49:07.427Z
9469507 9469507 20260313025922_nVs72 CA0036 2026-03-14T12:04:30.931Z 2026-03-21T12:48:40.529Z
9469457 9469457 20260313025231_JMjoy CA0036 2026-03-14T12:04:19.888Z 2026-03-21T12:48:39.745Z
9452025 9452025 20260310061820_p5h5L CA0036 2026-03-11T12:04:30.405Z 2026-03-18T12:39:08.492Z
9446626 9446626 20260309022559_cds1d CA0036 2026-03-10T12:03:11.994Z 2026-03-17T12:41:40.406Z
9446199 9446199 20260309002304_AYQLt CA0036 2026-03-10T12:01:24.846Z 2026-03-17T12:41:34.554Z
9320273 9320273 20260213091240_AuoQI CA0036 2026-02-14T14:05:43.757Z 2026-02-22T14:41:52.105Z
9320228 9320228 20260213085346_kca8u CA0036 2026-02-14T14:05:26.679Z 2026-02-22T14:41:51.050Z
9320213 9320213 20260213084543_OVHuS CA0036 2026-02-14T14:05:21.905Z 2026-02-22T14:41:50.767Z
9320207 9320207 20260213084321_UheD5 CA0036 2026-02-14T14:05:19.188Z 2026-02-22T14:41:50.634Z
9320136 9320136 20260213074210_105Nx CA0036 2026-02-14T14:04:45.758Z 2026-02-22T14:41:48.039Z
9320102 9320102 20260213072246_kplRl CA0036 2026-02-14T14:04:30.747Z 2026-02-22T14:41:47.104Z
9320100 9320100 20260213072234_OzDzj CA0036 2026-02-14T14:04:29.949Z 2026-02-22T14:41:46.998Z
9320033 9320033 20260213064546_OftNy CA0036 2026-02-14T14:04:02.439Z 2026-02-22T14:41:45.436Z
9320002 9320002 20260213061737_MAY0t CA0036 2026-02-14T14:03:48.108Z 2026-02-22T14:41:44.622Z
9319927 9319927 20260213054332_UcdMd CA0036 2026-02-14T14:03:22.584Z 2026-02-22T14:41:42.546Z
9319743 9319743 20260213035658_zSsC3 CA0036 2026-02-14T14:02:09.675Z 2026-02-22T14:41:38.105Z
9319734 9319734 20260213035421_lfevv CA0036 2026-02-14T14:02:05.287Z 2026-02-22T14:41:37.899Z
9319662 9319662 20260213032156_N3V3l CA0036 2026-02-14T14:01:38.568Z 2026-02-22T14:41:36.220Z
9308398 9308398 20260209101136_oe6wd CA0036 2026-02-10T14:07:19.397Z 2026-02-18T14:59:50.901Z
9308084 9308084 20260209091407_i2hyY CA0036 2026-02-10T14:05:49.661Z 2026-02-18T14:59:31.183Z
9308018 9308018 20260209085333_rOSio CA0036 2026-02-10T14:05:28.946Z 2026-02-18T14:59:20.562Z
9308013 9308013 20260209085322_U0m1u CA0036 2026-02-10T14:05:27.770Z 2026-02-18T14:59:20.227Z
9307773 9307773 20260209074207_E4lWe CA0036 2026-02-10T14:04:13.971Z 2026-02-18T14:59:04.003Z
9307611 9307611 20260209065502_vj12d CA0036 2026-02-10T14:03:19.678Z 2026-02-18T14:58:46.884Z
9307526 9307526 20260209062119_CLV10 CA0036 2026-02-10T14:02:50.656Z 2026-02-18T14:58:41.349Z
9307213 9307213 20260209035435_ZSp5s CA0036 2026-02-10T14:00:52.976Z 2026-02-18T14:58:13.395Z
9307164 9307164 20260209032825_ClVry CA0036 2026-02-10T14:00:27.422Z 2026-02-18T14:58:10.229Z
9307146 9307146 20260209031133_7Uh2n CA0036 2026-02-10T14:00:17.101Z 2026-02-18T14:58:08.722Z
9304109 9304109 20260208094102_gGeiy CA0036 2026-02-09T14:06:32.700Z 2026-02-16T14:50:14.412Z
9299807 9299807 20260207112057_IN2ii CA0036 2026-02-08T14:06:47.052Z 2026-02-16T14:57:02.854Z
9299066 9299066 20260207080432_2uSH1 CA0036 2026-02-08T14:03:19.821Z 2026-02-16T14:56:04.723Z
9256194 9256194 20260124061655_q4oxH CA0036 2026-01-25T14:16:10.032Z 2026-02-01T14:51:12.805Z
8767508 8767508 20251212003222_h3x73 CA0036 2025-12-14T15:12:16.589Z 2025-12-20T14:25:26.578Z
8723863 8723863 20251211102111_8QTDV CA0036 2025-12-12T14:13:28.115Z 2025-12-12T14:13:28.115Z
8720847 8720847 20251211053754_GBRgy CA0036 2025-12-12T14:04:24.235Z 2025-12-20T14:22:05.952Z
8708300 8708300 20251208035443_U6ns2 CA0036 2025-12-09T14:29:17.597Z 2025-12-16T15:13:21.013Z
8708099 8708099 20251208031559_2fTAZ CA0036 2025-12-09T14:28:54.724Z 2025-12-16T15:13:16.583Z
8708043 8708043 20251208030621_WoZBh CA0036 2025-12-09T14:28:39.961Z 2025-12-16T15:13:15.629Z
8708007 8708007 20251208030035_g8qO2 CA0036 2025-12-09T14:28:27.595Z 2025-12-16T15:13:14.811Z
8701832 8701832 20251208102445_f2Y32 CA0036 2025-12-09T14:06:30.362Z 2025-12-17T15:30:49.370Z
8701830 8701830 20251208102436_8DBJY CA0036 2025-12-09T14:06:29.785Z 2025-12-17T15:30:49.298Z
8701707 8701707 20251208101221_iS843 CA0036 2025-12-09T14:05:55.756Z 2025-12-17T15:30:44.267Z
8701352 8701352 20251208093820_6l3BD CA0036 2025-12-09T14:04:41.256Z 2025-12-17T15:30:20.684Z
8701118 8701118 20251208091352_PvC7Q CA0036 2025-12-09T14:03:51.758Z 2025-12-17T15:30:06.515Z
8700573 8700573 20251208071737_M2k3d CA0036 2025-12-09T14:01:47.159Z 2025-12-17T15:29:42.248Z
8700315 8700315 20251208060054_UZ80X CA0036 2025-12-09T14:00:44.133Z 2025-12-17T15:29:39.503Z
8700311 8700311 20251208055921_uhKkl CA0036 2025-12-09T14:00:42.968Z 2025-12-17T15:29:39.437Z
8592790 8592790 20251124092502_zmTv2 CA0036 2025-11-25T14:27:49.510Z 2025-12-02T15:13:07.517Z
8583390 8583390 20251124104911_vGtad CA0036 2025-11-25T14:01:44.328Z 2025-12-02T15:05:29.554Z
8583328 8583328 20251124103206_Gqyyc CA0036 2025-11-25T14:01:21.881Z 2025-12-02T15:05:28.886Z
8583322 8583322 20251124103011_v5a0U CA0036 2025-11-25T14:01:20.396Z 2025-11-25T14:01:20.396Z
8583309 8583309 20251124102627_Zsqse CA0036 2025-11-25T14:01:17.213Z 2025-11-25T14:01:17.213Z
8583196 8583196 20251124095716_4VDRn CA0036 2025-11-25T14:00:42.462Z 2025-12-02T15:05:26.714Z
8583153 8583153 20251124094931_RMYcd CA0036 2025-11-25T14:00:30.274Z 2025-12-02T15:05:26.142Z
8537371 8537371 20251119104700_Hw62D CA0036 2025-11-21T14:31:33.204Z 2025-11-27T15:13:39.139Z
8530192 8530192 20251119111616_hEOIK CA0036 2025-11-21T14:00:48.372Z 2025-11-28T14:53:02.838Z
8529708 8529708 20251119103243_jlJNu CA0036 2025-11-20T14:45:21.110Z 2025-11-27T15:13:37.813Z
8529673 8529673 20251119102324_xlva6 CA0036 2025-11-20T14:45:11.847Z 2025-11-27T15:13:36.433Z
8529643 8529643 20251119101545_QujJW CA0036 2025-11-20T14:45:07.558Z 2025-11-27T15:13:34.661Z
8529481 8529481 20251119085233_sTmMC CA0036 2025-11-20T14:44:57.873Z 2025-11-27T15:13:30.827Z
8529465 8529465 20251119083705_V3qCb CA0036 2025-11-20T14:44:57.176Z 2025-11-27T15:13:30.486Z
8529381 8529381 20251119072623_z3cy1 CA0036 2025-11-20T14:44:53.704Z 2025-11-20T14:44:53.704Z
8529369 8529369 20251119071326_aal3j CA0036 2025-11-20T14:44:53.131Z 2025-11-27T15:13:28.492Z
8529356 8529356 20251119071022_Wm2Ar CA0036 2025-11-20T14:44:52.540Z 2025-11-27T15:13:28.382Z
8529351 8529351 20251119071006_hwgse CA0036 2025-11-20T14:44:52.384Z 2025-11-27T15:13:28.077Z
8529345 8529345 20251119070743_8Hdfg CA0036 2025-11-20T14:44:52.044Z 2025-11-27T15:13:27.209Z
8515399 8515399 20251118042241_Kk8eu CA0036 2025-11-19T14:39:43.588Z 2025-11-26T15:08:00.733Z
8515279 8515279 20251118040721_xuo3o CA0036 2025-11-19T14:39:26.238Z 2025-11-26T15:07:59.994Z
8461891 8461891 20251114101441_FQjq9 CA0036 2025-11-15T14:25:01.117Z 2025-11-22T15:23:44.531Z
8461833 8461833 20251114100805_l82TC CA0036 2025-11-15T14:24:56.325Z 2025-11-22T15:23:42.572Z
8461714 8461714 20251114095533_FBFev CA0036 2025-11-15T14:24:47.605Z 2025-11-22T15:23:37.337Z
8461217 8461217 20251114085432_274G8 CA0036 2025-11-15T14:24:00.737Z 2025-11-22T15:23:15.154Z
8461181 8461181 20251114085053_Jq8Qn CA0036 2025-11-15T14:23:57.556Z 2025-11-22T15:23:14.574Z
8461171 8461171 20251114084837_k8JD9 CA0036 2025-11-15T14:23:56.554Z 2025-11-22T15:23:14.310Z
8461088 8461088 20251114083451_m0rr2 CA0036 2025-11-15T14:23:34.210Z 2025-11-22T15:23:06.246Z
8460589 8460589 20251114072246_k2JoP CA0036 2025-11-15T14:22:18.590Z 2025-11-22T15:22:42.440Z
8460562 8460562 20251114071758_53En8 CA0036 2025-11-15T14:22:16.902Z 2025-11-22T15:22:41.891Z
8460342 8460342 20251114063938_Z2JwT CA0036 2025-11-15T14:22:00.141Z 2025-11-22T15:22:34.030Z
8460165 8460165 20251114060742_ZCb7U CA0036 2025-11-15T14:21:28.387Z 2025-11-22T15:22:25.217Z
8373821 8373821 20251103010430_wINqA CA0036 2025-11-05T14:29:39.040Z 2025-11-11T15:06:23.782Z
8300652 8300652 20251029085033_33ZiK CA0036 2025-10-30T12:54:00.807Z 2025-11-06T15:15:19.518Z
8300284 8300284 20251029053025_NIKRU CA0036 2025-10-30T12:53:26.000Z 2025-10-30T12:53:26.000Z
8291687 8291687 20251028072454_et7lV CA0036 2025-10-30T12:36:18.749Z 2025-11-05T15:23:15.582Z
8275942 8275942 20251027075207_9veSD CA0036 2025-10-29T12:28:59.443Z 2025-11-04T15:46:36.344Z
7110703 7110703 20250718074105_5RtWM CA0036 2025-07-20T12:16:03.410Z 2025-07-26T12:46:13.601Z

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