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,583 rows where station_code = "CA0032" 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
9450934 9450934 20260309235404_OFk0E CA0032 2026-03-11T12:01:10.892Z 2026-03-18T12:38:37.965Z
9416329 9416329 20260302100731_cVGmg CA0032 2026-03-03T14:03:26.382Z 2026-03-10T12:36:03.068Z
9416146 9416146 20260302085934_IBbXh CA0032 2026-03-03T14:02:51.681Z 2026-03-10T12:35:59.658Z
9416057 9416057 20260302082401_UhlQ4 CA0032 2026-03-03T14:02:36.562Z 2026-03-10T12:35:56.822Z
9415796 9415796 20260302041340_fLkpv CA0032 2026-03-03T14:01:39.129Z 2026-03-10T12:35:50.485Z
9415567 9415567 20260302013235_XAgnO CA0032 2026-03-03T14:00:42.321Z 2026-03-10T12:35:44.250Z
9415556 9415556 20260302012425_ymwdx CA0032 2026-03-03T14:00:39.533Z 2026-03-10T12:35:43.921Z
9391070 9391070 20260225015733_RAgDc CA0032 2026-02-26T14:03:24.245Z 2026-03-05T14:36:05.407Z
9374884 9374884 20260223100438_gmiON CA0032 2026-02-24T14:07:24.000Z 2026-03-03T14:31:37.656Z
9374582 9374582 20260223085650_RkXeI CA0032 2026-02-24T14:06:28.819Z 2026-03-03T14:31:32.838Z
9374272 9374272 20260223073217_8G020 CA0032 2026-02-24T14:05:31.509Z 2026-03-03T14:31:19.027Z
9374261 9374261 20260223072204_EQNkS CA0032 2026-02-24T14:05:28.849Z 2026-03-03T14:31:18.827Z
9373848 9373848 20260223043115_hZY8u CA0032 2026-02-24T14:04:06.072Z 2026-03-03T14:31:10.595Z
9373639 9373639 20260223035414_fGRgP CA0032 2026-02-24T14:03:32.277Z 2026-03-03T14:31:07.015Z
9373447 9373447 20260223030833_CgMvA CA0032 2026-02-24T14:02:59.737Z 2026-03-03T14:31:03.344Z
9366136 9366136 20260222084544_I8M0K CA0032 2026-02-23T14:06:33.347Z 2026-02-24T14:16:01.995Z
9366031 9366031 20260222081702_gq3P2 CA0032 2026-02-23T14:06:07.838Z 2026-02-24T14:15:55.424Z
9365912 9365912 20260222071919_bQZqm CA0032 2026-02-23T14:05:34.281Z 2026-02-24T14:15:46.289Z
9365768 9365768 20260222055929_iOaSv CA0032 2026-02-23T14:04:59.055Z 2026-02-24T14:15:36.908Z
9365458 9365458 20260222035910_cihwm CA0032 2026-02-23T14:03:34.641Z 2026-02-24T14:15:14.450Z
9352854 9352854 20260220092408_Q7YXW CA0032 2026-02-21T14:03:06.896Z 2026-03-01T14:21:43.130Z
9352620 9352620 20260220084202_UZwWg CA0032 2026-02-21T14:02:33.208Z 2026-03-01T14:21:40.659Z
9352543 9352543 20260220081608_X6Mxt CA0032 2026-02-21T14:02:19.592Z 2026-03-01T14:21:39.380Z
9352396 9352396 20260220060159_Ih9h2 CA0032 2026-02-21T14:01:44.661Z 2026-03-01T14:21:36.959Z
9352325 9352325 20260220051524_2qJEP CA0032 2026-02-21T14:01:31.720Z 2026-03-01T14:21:35.989Z
9352270 9352270 20260220042015_1iScp CA0032 2026-02-21T14:01:19.918Z 2026-03-01T14:21:34.954Z
9341770 9341770 20260219104648_o1Aka CA0032 2026-02-20T14:00:57.446Z 2026-02-28T14:43:53.765Z
9341452 9341452 20260219090842_QGh3H CA0032 2026-02-20T14:00:56.728Z 2026-02-28T14:43:51.260Z
9341341 9341341 20260219081114_615VD CA0032 2026-02-20T14:00:56.385Z 2026-02-28T14:43:50.174Z
9331216 9331216 20260216042045_Nu9lh CA0032 2026-02-17T14:05:25.653Z 2026-02-25T14:41:40.443Z
9327132 9327132 20260215041242_Ui1qK CA0032 2026-02-16T14:02:41.226Z 2026-02-24T14:41:47.529Z
9298390 9298390 20260206021640_JdC6K CA0032 2026-02-07T14:23:04.406Z 2026-02-14T15:06:25.916Z
9295515 9295515 20260206094510_2c0JJ CA0032 2026-02-07T14:04:17.018Z 2026-02-15T14:56:36.004Z
9295510 9295510 20260206094253_Im1tW CA0032 2026-02-07T14:04:15.385Z 2026-02-15T14:56:35.722Z
9295501 9295501 20260206093929_HYHB7 CA0032 2026-02-07T14:04:12.117Z 2026-02-15T14:56:34.976Z
9295165 9295165 20260206083408_o4gK2 CA0032 2026-02-07T14:02:47.614Z 2026-02-15T14:56:09.712Z
9295005 9295005 20260206071631_s3Qbu CA0032 2026-02-07T14:01:43.694Z 2026-02-15T14:55:54.610Z
9294992 9294992 20260206070921_bBBIJ CA0032 2026-02-07T14:01:38.236Z 2026-02-15T14:55:53.792Z
9294945 9294945 20260206064012_zTsGe CA0032 2026-02-07T14:01:14.114Z 2026-02-15T14:55:48.653Z
9288672 9288672 20260203033836_k9afZ CA0032 2026-02-04T14:11:22.483Z 2026-02-11T14:51:10.196Z
9288633 9288633 20260203014830_yIifX CA0032 2026-02-04T14:11:07.807Z 2026-02-11T14:51:07.291Z
9288630 9288630 20260203013914_iIKX3 CA0032 2026-02-04T14:11:07.028Z 2026-02-11T14:51:07.128Z
9287409 9287409 20260203101518_3JOvF CA0032 2026-02-04T14:02:48.429Z 2026-02-12T14:50:32.576Z
9287362 9287362 20260203095710_zvq0b CA0032 2026-02-04T14:02:26.989Z 2026-02-12T14:50:23.893Z
9287329 9287329 20260203094118_UCA5N CA0032 2026-02-04T14:02:10.909Z 2026-02-12T14:50:18.765Z
9286622 9286622 20260202104853_3sBTy CA0032 2026-02-03T14:02:08.037Z 2026-02-11T14:50:11.851Z
9286463 9286463 20260202074457_ufoxR CA0032 2026-02-03T14:00:56.488Z 2026-02-11T14:49:56.655Z
9019911 9019911 20251220105703_JQiaL CA0032 2025-12-27T15:05:05.120Z 2025-12-29T15:24:39.554Z
8988479 8988479 20251218102459_sBI2o CA0032 2025-12-26T14:42:26.759Z 2025-12-27T15:21:47.271Z
8988208 8988208 20251218095730_QvbtJ CA0032 2025-12-26T14:41:52.270Z 2025-12-26T14:41:52.270Z
8987636 8987636 20251218085556_lcv7S CA0032 2025-12-26T14:40:44.080Z 2025-12-27T15:20:48.965Z
8987351 8987351 20251218081257_0Z2Ry CA0032 2025-12-26T14:40:05.710Z 2025-12-27T15:20:18.156Z
8987102 8987102 20251218073112_oE2KT CA0032 2025-12-26T14:39:30.176Z 2025-12-27T15:20:03.307Z
8951534 8951534 20251215014723_mJuzg CA0032 2025-12-24T15:08:51.213Z 2025-12-24T15:08:51.213Z
8950563 8950563 20251215010051_UDfq3 CA0032 2025-12-24T15:07:33.302Z 2025-12-24T15:07:33.302Z
8948931 8948931 20251214234614_ZGo2y CA0032 2025-12-24T15:05:59.310Z 2025-12-24T15:05:59.310Z
8948630 8948630 20251214233201_hX1yi CA0032 2025-12-24T15:05:41.433Z 2025-12-24T15:05:41.433Z
8928009 8928009 20251215043556_ntkar CA0032 2025-12-24T14:10:08.704Z 2025-12-24T15:09:30.917Z
8926540 8926540 20251215031329_XKVIk CA0032 2025-12-24T14:04:08.358Z 2025-12-24T15:09:29.323Z
8691277 8691277 20251205042144_kjcOS CA0032 2025-12-06T14:17:06.196Z 2025-12-13T16:05:17.504Z
8688183 8688183 20251205104225_nHPUb CA0032 2025-12-06T14:03:34.631Z 2025-12-14T16:05:15.752Z
8687900 8687900 20251205093621_voCVq CA0032 2025-12-06T14:02:17.823Z 2025-12-14T16:05:05.344Z
8687458 8687458 20251205062946_8Wk8e CA0032 2025-12-06T14:00:19.718Z 2025-12-14T16:04:55.378Z
8682628 8682628 20251203055252_FlAdG CA0032 2025-12-04T14:17:44.843Z 2025-12-11T14:47:23.459Z
8682300 8682300 20251203051217_l3mX2 CA0032 2025-12-04T14:16:46.528Z 2025-12-11T14:47:15.354Z
8677380 8677380 20251203092910_DUDUc CA0032 2025-12-04T14:00:58.752Z 2025-12-11T14:39:28.184Z
8677357 8677357 20251203091225_0v8Ge CA0032 2025-12-04T14:00:53.699Z 2025-12-11T14:39:27.318Z
8677344 8677344 20251203085828_CwOjF CA0032 2025-12-04T14:00:50.849Z 2025-12-11T14:39:26.858Z
8677311 8677311 20251203083430_KPVxZ CA0032 2025-12-04T14:00:43.859Z 2025-12-11T14:39:25.468Z
8677223 8677223 20251203072728_cGbGC CA0032 2025-12-04T14:00:24.229Z 2025-12-11T14:39:19.205Z
8677195 8677195 20251203070456_u99tc CA0032 2025-12-04T14:00:19.279Z 2025-12-11T14:39:18.183Z
8625206 8625206 20251127083146_3nANl CA0032 2025-11-28T14:26:25.437Z 2025-12-05T15:05:47.342Z
8584009 8584009 20251123103344_afhJZ CA0032 2025-11-25T14:05:00.446Z 2025-12-02T15:09:45.176Z
8583864 8583864 20251123095950_x3NyE CA0032 2025-11-25T14:04:17.679Z 2025-12-02T15:09:43.485Z
8583042 8583042 20251123094816_Brq2S CA0032 2025-11-24T14:34:46.952Z 2025-12-01T15:22:31.116Z
8582625 8582625 20251123072213_pbAMH CA0032 2025-11-24T14:34:22.438Z 2025-12-01T15:22:25.938Z
8582222 8582222 20251123044632_O65a5 CA0032 2025-11-24T14:33:23.506Z 2025-12-01T15:22:19.012Z
8582208 8582208 20251123044427_CdA1c CA0032 2025-11-24T14:33:22.716Z 2025-12-01T15:22:18.814Z
8582050 8582050 20251123035412_uVJ3x CA0032 2025-11-24T14:33:13.636Z 2025-12-01T15:22:14.902Z
8581987 8581987 20251123033045_MLcnw CA0032 2025-11-24T14:32:57.291Z 2025-12-01T15:22:09.304Z
8581651 8581651 20251123013020_EW3jK CA0032 2025-11-24T14:32:29.699Z 2025-12-01T15:21:11.553Z
8581645 8581645 20251123012609_RC0VS CA0032 2025-11-24T14:32:24.370Z 2025-12-01T15:21:11.232Z
8574380 8574380 20251122061119_7C4w4 CA0032 2025-11-23T14:43:17.481Z 2025-11-30T15:07:07.766Z
8574370 8574370 20251122060525_6T4ez CA0032 2025-11-23T14:43:13.025Z 2025-11-30T15:07:07.516Z
8574365 8574365 20251122060057_k3ZbQ CA0032 2025-11-23T14:43:11.562Z 2025-11-30T15:07:07.428Z
8574331 8574331 20251122055132_RhA2N CA0032 2025-11-23T14:43:06.605Z 2025-11-30T15:07:04.992Z
8574208 8574208 20251122052534_Y2Jo0 CA0032 2025-11-23T14:42:48.183Z 2025-11-30T15:07:02.534Z
8326159 8326159 20251030091523_5iFv3 CA0032 2025-11-01T12:35:18.106Z 2025-11-07T15:17:44.322Z
8325948 8325948 20251030084520_SCQV2 CA0032 2025-11-01T12:34:45.567Z 2025-11-07T15:17:34.247Z
8325095 8325095 20251030071325_8riqC CA0032 2025-11-01T12:33:21.467Z 2025-11-07T15:17:18.081Z
8324960 8324960 20251030065056_Oeq3y CA0032 2025-11-01T12:33:13.249Z 2025-11-07T15:17:16.149Z
8324777 8324777 20251030062600_QhRcs CA0032 2025-11-01T12:33:03.212Z 2025-11-07T15:17:12.968Z
8324764 8324764 20251030062415_PGHZ6 CA0032 2025-11-01T12:33:02.452Z 2025-11-07T15:17:12.668Z
8324743 8324743 20251030062224_nQrc2 CA0032 2025-11-01T12:33:01.724Z 2025-11-07T15:17:12.543Z
8324608 8324608 20251030060116_l24zb CA0032 2025-11-01T12:32:31.896Z 2025-11-07T15:17:10.214Z
8324559 8324559 20251030055430_rla2b CA0032 2025-11-01T12:32:26.437Z 2025-11-07T15:17:08.874Z
8324509 8324509 20251030054924_YBKE3 CA0032 2025-11-01T12:32:23.409Z 2025-11-07T15:17:07.640Z
8324462 8324462 20251030054429_jeSP7 CA0032 2025-11-01T12:32:21.738Z 2025-11-07T15:17:07.195Z
8324111 8324111 20251030052409_7FurV CA0032 2025-11-01T12:31:41.266Z 2025-11-07T15:17:00.764Z
8323893 8323893 20251030051412_y6HlU CA0032 2025-11-01T12:31:30.838Z 2025-11-07T15:16:42.599Z

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