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,387 rows where station_code = "CA000Q" 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
9260644 9260644 20260125061711_lIKde CA000Q 2026-01-26T14:22:43.400Z 2026-01-29T14:44:33.216Z
9260628 9260628 20260125060117_fGteN CA000Q 2026-01-26T14:22:39.804Z 2026-01-29T14:44:32.219Z
9260603 9260603 20260125055054_HydEu CA000Q 2026-01-26T14:22:33.196Z 2026-01-29T14:44:30.235Z
9260562 9260562 20260125052950_gcO4a CA000Q 2026-01-26T14:22:24.665Z 2026-01-29T14:44:27.729Z
9260413 9260413 20260125041756_V2wQX CA000Q 2026-01-26T14:21:37.530Z 2026-01-29T14:44:11.356Z
9260249 9260249 20260125031515_SrQLN CA000Q 2026-01-26T14:20:56.514Z 2026-01-29T14:44:02.102Z
9260043 9260043 20260125021604_U2Hii CA000Q 2026-01-26T14:19:56.263Z 2026-01-29T14:43:43.250Z
9256335 9256335 20260124073044_mTPKY CA000Q 2026-01-25T14:16:42.945Z 2026-01-29T14:48:43.552Z
9256271 9256271 20260124063358_ZAxWR CA000Q 2026-01-25T14:16:23.640Z 2026-01-29T14:48:33.686Z
9255266 9255266 20260124021710_BQT0A CA000Q 2026-01-25T14:12:36.991Z 2026-01-29T14:47:14.086Z
9253331 9253331 20260124110201_F2vC0 CA000Q 2026-01-25T14:02:07.236Z 2026-01-29T14:40:38.762Z
9253325 9253325 20260124105702_xiSr7 CA000Q 2026-01-25T14:02:04.809Z 2026-01-29T14:40:37.906Z
9253263 9253263 20260124103649_0t0xW CA000Q 2026-01-25T14:01:43.538Z 2026-01-29T14:40:31.344Z
9253259 9253259 20260124103559_eRfwH CA000Q 2026-01-25T14:01:41.977Z 2026-01-29T14:40:30.945Z
9244360 9244360 20260121080016_N0YL3 CA000Q 2026-01-22T14:25:15.684Z 2026-01-29T15:06:03.225Z
9239322 9239322 20260121102636_OjWRc CA000Q 2026-01-22T14:00:56.773Z 2026-01-29T14:54:08.293Z
9231259 9231259 20260119065536_22MQQ CA000Q 2026-01-20T14:32:03.601Z 2026-01-27T15:06:10.256Z
9231118 9231118 20260119060634_9djQ5 CA000Q 2026-01-20T14:31:24.331Z 2026-01-27T15:05:59.493Z
9231054 9231054 20260119055118_q2n28 CA000Q 2026-01-20T14:31:03.386Z 2026-01-27T15:05:55.311Z
9230992 9230992 20260119054052_TxQSO CA000Q 2026-01-20T14:30:45.524Z 2026-01-27T15:05:51.898Z
9218234 9218234 20260117020455_r4sg2 CA000Q 2026-01-18T14:11:12.142Z 2026-01-25T14:58:17.962Z
9218098 9218098 20260117000310_kEMFv CA000Q 2026-01-18T14:10:27.259Z 2026-01-25T14:57:58.988Z
9172519 9172519 20260109105916_Hou3K CA000Q 2026-01-10T14:13:46.406Z 2026-01-17T15:25:38.001Z
9172295 9172295 20260109095138_wdsrM CA000Q 2026-01-10T14:12:38.155Z 2026-01-17T15:25:17.310Z
9172264 9172264 20260109094427_uRxzz CA000Q 2026-01-10T14:12:30.936Z 2026-01-17T15:25:15.086Z
9172121 9172121 20260109090546_iffzV CA000Q 2026-01-10T14:11:53.515Z 2026-01-17T15:25:07.790Z
9172119 9172119 20260109090401_uwrOn CA000Q 2026-01-10T14:11:50.345Z 2026-01-17T15:25:07.609Z
9087946 9087946 20251228105250_TqiqF CA000Q 2025-12-30T14:45:22.135Z 2026-01-05T15:11:35.736Z
9087942 9087942 20251228105054_PYM2B CA000Q 2025-12-30T14:45:21.814Z 2026-01-05T15:11:35.590Z
9087468 9087468 20251228092955_u2lvY CA000Q 2025-12-30T14:44:10.295Z 2026-01-05T15:11:09.097Z
9087453 9087453 20251228092601_CY7XZ CA000Q 2025-12-30T14:44:08.938Z 2026-01-05T15:11:08.601Z
9087437 9087437 20251228092318_irnFN CA000Q 2025-12-30T14:44:07.167Z 2026-01-05T15:11:06.692Z
9087386 9087386 20251228090706_nkaeS CA000Q 2025-12-30T14:43:51.761Z 2026-01-05T15:11:04.249Z
9087355 9087355 20251228085908_lCmID CA000Q 2025-12-30T14:43:47.642Z 2026-01-05T15:11:02.852Z
9087214 9087214 20251228074815_G6h1w CA000Q 2025-12-30T14:43:20.911Z 2026-01-05T15:10:57.010Z
9087184 9087184 20251228073201_vm1MO CA000Q 2025-12-30T14:43:16.100Z 2026-01-05T15:10:55.840Z
9087141 9087141 20251228071526_6eyw3 CA000Q 2025-12-30T14:43:09.439Z 2026-01-05T15:10:54.586Z
9087119 9087119 20251228070700_4WZ43 CA000Q 2025-12-30T14:43:06.173Z 2026-01-05T15:10:53.644Z
9087074 9087074 20251228065756_01A2O CA000Q 2025-12-30T14:43:00.308Z 2026-01-05T15:10:51.994Z
9087020 9087020 20251228064510_cTBwf CA000Q 2025-12-30T14:42:43.678Z 2026-01-05T15:10:49.967Z
9087000 9087000 20251228063937_rrYqO CA000Q 2025-12-30T14:42:40.525Z 2026-01-05T15:10:49.153Z
9086958 9086958 20251228062244_MCR7T CA000Q 2025-12-30T14:42:33.529Z 2026-01-05T15:10:47.410Z
9086933 9086933 20251228061844_T3PQa CA000Q 2025-12-30T14:42:30.583Z 2026-01-05T15:10:46.611Z
9086923 9086923 20251228060955_gWN48 CA000Q 2025-12-30T14:42:28.701Z 2026-01-05T15:10:46.082Z
9086807 9086807 20251228054000_Oe7J8 CA000Q 2025-12-30T14:42:07.898Z 2026-01-05T15:10:32.852Z
9086736 9086736 20251228053145_QB45E CA000Q 2025-12-30T14:41:58.016Z 2026-01-05T15:10:28.668Z
9086671 9086671 20251228052452_CDl9W CA000Q 2025-12-30T14:41:50.251Z 2026-01-05T15:10:26.498Z
9086537 9086537 20251228051015_GOFZ7 CA000Q 2025-12-30T14:41:25.988Z 2026-01-05T15:10:21.551Z
9086367 9086367 20251228045134_6v9Uh CA000Q 2025-12-30T14:40:57.674Z 2026-01-05T15:10:17.004Z
9086122 9086122 20251228042811_1q2MV CA000Q 2025-12-30T14:40:21.126Z 2026-01-05T15:09:56.499Z
9086067 9086067 20251228042604_G3PVP CA000Q 2025-12-30T14:40:14.526Z 2026-01-05T15:09:53.771Z
9085639 9085639 20251228034714_wNRZK CA000Q 2025-12-30T14:39:06.500Z 2026-01-05T15:09:40.650Z
9085599 9085599 20251228034235_0w2uz CA000Q 2025-12-30T14:39:01.289Z 2026-01-05T15:09:39.118Z
9085389 9085389 20251228032111_4L5xP CA000Q 2025-12-30T14:38:27.792Z 2026-01-05T15:09:22.139Z
9085025 9085025 20251228024531_7bhUL CA000Q 2025-12-30T14:37:26.035Z 2025-12-31T14:50:52.518Z
9083514 9083514 20251228000422_dok9T CA000Q 2025-12-30T14:32:56.393Z 2026-01-05T15:07:51.950Z
9067190 9067190 20251226083125_FUpF2 CA000Q 2025-12-29T14:41:21.337Z 2026-01-03T15:38:30.212Z
9067029 9067029 20251226074824_FoKQY CA000Q 2025-12-29T14:41:04.190Z 2026-01-03T15:38:22.274Z
9064342 9064342 20251226040401_B7lGU CA000Q 2025-12-29T14:36:46.381Z 2026-01-03T15:36:00.095Z
9045695 9045695 20251223110221_4TlV5 CA000Q 2025-12-28T14:53:57.301Z 2025-12-31T15:42:54.019Z
8988881 8988881 20251218110233_oaEL8 CA000Q 2025-12-26T14:43:14.254Z 2025-12-27T15:22:14.117Z
8988688 8988688 20251218104444_eebHi CA000Q 2025-12-26T14:42:49.115Z 2025-12-27T15:22:00.161Z
8988286 8988286 20251218100735_CVpEA CA000Q 2025-12-26T14:42:00.992Z 2025-12-27T15:21:32.359Z
8975390 8975390 20251219010828_Cx1uR CA000Q 2025-12-26T14:06:50.362Z 2025-12-28T15:17:01.082Z
8971528 8971528 20251217002101_46pl2 CA000Q 2025-12-25T14:53:54.709Z 2025-12-25T14:53:54.709Z
8952009 8952009 20251215021211_Qabbn CA000Q 2025-12-24T15:09:17.882Z 2025-12-24T15:09:17.882Z
8951921 8951921 20251215020850_crnFO CA000Q 2025-12-24T15:09:16.132Z 2025-12-24T15:09:16.132Z
8951757 8951757 20251215020009_X6Woh CA000Q 2025-12-24T15:09:13.785Z 2025-12-24T15:09:13.785Z
8951352 8951352 20251215013623_glxTi CA000Q 2025-12-24T15:08:14.394Z 2025-12-24T15:08:14.394Z
8949321 8949321 20251215000212_Icdsm CA000Q 2025-12-24T15:06:07.290Z 2025-12-24T15:06:07.290Z
8949099 8949099 20251214235300_8MKEr CA000Q 2025-12-24T15:06:03.700Z 2025-12-24T15:06:03.700Z
8948480 8948480 20251214232456_L4D0I CA000Q 2025-12-24T15:05:14.711Z 2025-12-24T15:05:14.711Z
8948183 8948183 20251214231053_36jpB CA000Q 2025-12-24T15:04:32.539Z 2025-12-24T15:04:32.539Z
8947608 8947608 20251214224155_8qAPT CA000Q 2025-12-24T15:04:22.389Z 2025-12-24T15:04:22.389Z
8947244 8947244 20251214222525_jlFjs CA000Q 2025-12-24T15:04:17.445Z 2025-12-24T15:04:17.445Z
8928269 8928269 20251215045103_J7igJ CA000Q 2025-12-24T14:10:57.621Z 2025-12-24T15:09:31.064Z
8926431 8926431 20251215030841_tjB2h CA000Q 2025-12-24T14:03:29.337Z 2025-12-24T15:09:29.096Z
8926233 8926233 20251215025753_N3tUC CA000Q 2025-12-24T14:02:42.282Z 2025-12-24T15:09:28.861Z
8926222 8926222 20251215025638_YpR3O CA000Q 2025-12-24T14:02:41.186Z 2025-12-24T15:09:28.851Z
8926155 8926155 20251215025231_3cGpV CA000Q 2025-12-24T14:02:18.825Z 2025-12-24T15:09:28.781Z
8925999 8925999 20251215024540_1yGKq CA000Q 2025-12-24T14:01:28.498Z 2025-12-24T15:09:28.561Z
8925950 8925950 20251215024206_ZkH3X CA000Q 2025-12-24T14:01:14.581Z 2025-12-24T15:09:28.515Z
8925809 8925809 20251215023229_caClX CA000Q 2025-12-24T14:00:22.614Z 2025-12-24T15:09:28.280Z
8713657 8713657 20251209044655_DexQt CA000Q 2025-12-10T14:16:58.542Z 2025-12-17T15:34:33.813Z
8713617 8713617 20251209043931_XGRG5 CA000Q 2025-12-10T14:16:55.917Z 2025-12-17T15:34:33.418Z
8713567 8713567 20251209042350_8L2yF CA000Q 2025-12-10T14:16:51.163Z 2025-12-17T15:34:32.676Z
8713394 8713394 20251209034118_AFZeR CA000Q 2025-12-10T14:16:20.121Z 2025-12-17T15:34:30.170Z
8713207 8713207 20251209030155_O4bp2 CA000Q 2025-12-10T14:15:54.146Z 2025-12-17T15:34:27.642Z
8713182 8713182 20251209025542_UwCwS CA000Q 2025-12-10T14:15:52.353Z 2025-12-17T15:34:27.381Z
8713125 8713125 20251209023927_9hv2N CA000Q 2025-12-10T14:15:42.908Z 2025-12-17T15:34:26.782Z
8713055 8713055 20251209022718_Ysny0 CA000Q 2025-12-10T14:15:33.911Z 2025-12-17T15:34:25.735Z
8713014 8713014 20251209021625_rE4Ee CA000Q 2025-12-10T14:15:22.720Z 2025-12-17T15:34:25.366Z
8712863 8712863 20251209013633_nIvf2 CA000Q 2025-12-10T14:15:06.524Z 2025-12-17T15:34:23.265Z
8712766 8712766 20251209010746_Ny6hQ CA000Q 2025-12-10T14:14:42.956Z 2025-12-17T15:34:21.778Z
8712728 8712728 20251209005932_3mQfs CA000Q 2025-12-10T14:14:39.311Z 2025-12-17T15:34:21.377Z
8712683 8712683 20251209004923_Y3adG CA000Q 2025-12-10T14:14:34.808Z 2025-12-17T15:34:20.560Z
8712446 8712446 20251208230138_e3TiG CA000Q 2025-12-10T14:13:58.347Z 2025-12-17T15:33:57.182Z
8709624 8709624 20251209082818_DiBEL CA000Q 2025-12-10T14:02:55.349Z 2025-12-17T15:22:48.377Z
8709616 8709616 20251209082358_4Vkp0 CA000Q 2025-12-10T14:02:54.025Z 2025-12-17T15:22:48.181Z
8709336 8709336 20251209072743_KWAI8 CA000Q 2025-12-10T14:02:09.199Z 2025-12-17T15:22:43.804Z

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