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,649 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
9603265 9603265 20260402091141_CEFR3 CA000Q 2026-04-03T12:02:27.515Z 2026-04-06T12:21:50.024Z
9593269 9593269 20260329085240_ekGdE CA000Q 2026-03-30T12:03:26.832Z 2026-04-06T12:35:01.222Z
9593264 9593264 20260329085107_zkKRn CA000Q 2026-03-30T12:03:25.896Z 2026-04-06T12:35:00.931Z
9593249 9593249 20260329083253_cReRB CA000Q 2026-03-30T12:03:23.344Z 2026-04-06T12:34:59.928Z
9593157 9593157 20260329070917_8sbZ6 CA000Q 2026-03-30T12:03:09.388Z 2026-04-06T12:34:53.960Z
9593145 9593145 20260329065312_8iSqT CA000Q 2026-03-30T12:03:05.750Z 2026-04-06T12:34:53.096Z
9593101 9593101 20260329060603_sYd5o CA000Q 2026-03-30T12:02:57.240Z 2026-04-06T12:34:50.608Z
9590385 9590385 20260328084515_G3XLK CA000Q 2026-03-29T12:02:31.827Z 2026-04-06T12:38:04.369Z
9590374 9590374 20260328084017_Xb29D CA000Q 2026-03-29T12:02:30.495Z 2026-04-06T12:38:03.838Z
9590334 9590334 20260328081910_jd3lS CA000Q 2026-03-29T12:02:26.340Z 2026-04-06T12:38:01.870Z
9590266 9590266 20260328075651_z8b49 CA000Q 2026-03-29T12:02:20.970Z 2026-04-06T12:37:59.060Z
9588949 9588949 20260328015616_XIIhQ CA000Q 2026-03-29T12:00:31.955Z 2026-04-06T12:36:57.163Z
9571917 9571917 20260324055109_hlFmS CA000Q 2026-03-25T12:03:11.199Z 2026-04-02T12:34:55.110Z
9571798 9571798 20260324042234_fufD1 CA000Q 2026-03-25T12:02:44.976Z 2026-04-02T12:34:49.410Z
9522273 9522273 20260319071139_DfAtA CA000Q 2026-03-20T12:09:27.969Z 2026-03-27T12:41:16.058Z
9518748 9518748 20260319012231_3B3E5 CA000Q 2026-03-20T12:03:13.975Z 2026-03-27T12:40:13.276Z
9518573 9518573 20260319011115_2daT2 CA000Q 2026-03-20T12:02:52.027Z 2026-03-27T12:40:11.555Z
9518021 9518021 20260319002220_6xIsL CA000Q 2026-03-20T12:01:44.690Z 2026-03-27T12:40:05.611Z
9513744 9513744 20260318095937_a5WSE CA000Q 2026-03-19T12:16:08.560Z 2026-03-26T12:38:03.678Z
9513553 9513553 20260318093252_rTEiF CA000Q 2026-03-19T12:15:39.159Z 2026-03-26T12:37:56.356Z
9513551 9513551 20260318093221_viUz4 CA000Q 2026-03-19T12:15:38.667Z 2026-03-26T12:37:56.325Z
9513366 9513366 20260318090258_jyiX3 CA000Q 2026-03-19T12:15:04.303Z 2026-03-26T12:37:54.536Z
9513149 9513149 20260318083938_m5vw0 CA000Q 2026-03-19T12:14:31.975Z 2026-03-26T12:37:52.931Z
9513077 9513077 20260318083105_oSrRM CA000Q 2026-03-19T12:14:19.960Z 2026-03-26T12:37:51.403Z
9513002 9513002 20260318081750_9yYxg CA000Q 2026-03-19T12:14:07.140Z 2026-03-26T12:37:50.728Z
9451918 9451918 20260310050226_o7klx CA000Q 2026-03-11T12:04:14.163Z 2026-03-18T12:39:06.999Z
9451833 9451833 20260310041615_eYMg5 CA000Q 2026-03-11T12:03:58.148Z 2026-03-18T12:39:05.380Z
9451787 9451787 20260310035402_Fkyjd CA000Q 2026-03-11T12:03:50.310Z 2026-03-18T12:39:04.531Z
9451545 9451545 20260310024638_p7RkM CA000Q 2026-03-11T12:03:08.276Z 2026-03-18T12:38:49.173Z
9451405 9451405 20260310020536_OAZkm CA000Q 2026-03-11T12:02:42.192Z 2026-03-18T12:38:45.925Z
9450935 9450935 20260309235702_goppn CA000Q 2026-03-11T12:01:11.573Z 2026-03-18T12:38:38.033Z
9447832 9447832 20260309090249_hHIt3 CA000Q 2026-03-10T12:07:58.852Z 2026-03-17T12:41:57.173Z
9447773 9447773 20260309084805_EQM9v CA000Q 2026-03-10T12:07:46.478Z 2026-03-17T12:41:56.511Z
9432904 9432904 20260306092414_tKZAh CA000Q 2026-03-07T14:06:34.909Z 2026-03-14T12:39:45.964Z
9432860 9432860 20260306091752_yvUCo CA000Q 2026-03-07T14:06:26.821Z 2026-03-14T12:39:44.183Z
9432560 9432560 20260306080339_405ss CA000Q 2026-03-07T14:05:16.359Z 2026-03-14T12:39:33.479Z
9432547 9432547 20260306075708_KAnAd CA000Q 2026-03-07T14:05:12.483Z 2026-03-14T12:39:32.979Z
9432425 9432425 20260306063054_K2IFp CA000Q 2026-03-07T14:04:42.456Z 2026-03-14T12:39:30.249Z
9432417 9432417 20260306062559_ZrTfx CA000Q 2026-03-07T14:04:40.329Z 2026-03-14T12:39:30.070Z
9432404 9432404 20260306055804_Jn1gR CA000Q 2026-03-07T14:04:37.842Z 2026-03-14T12:39:29.897Z
9432273 9432273 20260306041427_dyySK CA000Q 2026-03-07T14:04:06.411Z 2026-03-14T12:39:27.970Z
9432067 9432067 20260306032342_XWCZO CA000Q 2026-03-07T14:03:13.618Z 2026-03-14T12:39:24.217Z
9431944 9431944 20260306024125_kSXJ3 CA000Q 2026-03-07T14:02:36.309Z 2026-03-14T12:39:20.999Z
9431807 9431807 20260306020202_0Xeuf CA000Q 2026-03-07T14:02:05.214Z 2026-03-14T12:39:18.004Z
9419838 9419838 20260303100924_q4zP3 CA000Q 2026-03-04T14:02:14.570Z 2026-03-11T12:28:08.823Z
9419509 9419509 20260303041204_3Rvvk CA000Q 2026-03-04T14:01:35.267Z 2026-03-11T12:28:01.843Z
9419293 9419293 20260303025136_Ap0qX CA000Q 2026-03-04T14:01:10.169Z 2026-03-11T12:27:57.536Z
9419091 9419091 20260303012246_KOvgy CA000Q 2026-03-04T14:00:44.305Z 2026-03-11T12:27:44.928Z
9415825 9415825 20260302042004_iRQGN CA000Q 2026-03-03T14:01:44.800Z 2026-03-10T12:35:51.292Z
9409264 9409264 20260228022821_UAQQF CA000Q 2026-03-01T14:01:03.498Z 2026-03-08T12:41:03.825Z
9403465 9403465 20260227095047_LgAub CA000Q 2026-02-28T14:08:23.179Z 2026-03-07T14:47:53.691Z
9403237 9403237 20260227084213_2J9tH CA000Q 2026-02-28T14:07:37.952Z 2026-03-07T14:47:42.169Z
9403140 9403140 20260227081632_pZor6 CA000Q 2026-02-28T14:07:21.494Z 2026-03-07T14:47:35.441Z
9403089 9403089 20260227075638_AMTVv CA000Q 2026-02-28T14:07:10.111Z 2026-03-07T14:47:29.772Z
9403049 9403049 20260227072623_Mh4X3 CA000Q 2026-02-28T14:07:02.444Z 2026-03-07T14:47:25.892Z
9403038 9403038 20260227071831_AJpMX CA000Q 2026-02-28T14:06:59.934Z 2026-03-07T14:47:25.123Z
9403034 9403034 20260227071628_22c8j CA000Q 2026-02-28T14:06:59.038Z 2026-03-07T14:47:24.468Z
9402987 9402987 20260227061754_1bEik CA000Q 2026-02-28T14:06:47.527Z 2026-03-07T14:47:20.327Z
9392885 9392885 20260225081309_p3Sa1 CA000Q 2026-02-26T14:08:42.889Z 2026-03-05T14:37:12.959Z
9392835 9392835 20260225072932_2N663 CA000Q 2026-02-26T14:08:33.867Z 2026-03-05T14:37:10.658Z
9392822 9392822 20260225071157_3JKhz CA000Q 2026-02-26T14:08:31.206Z 2026-03-05T14:37:09.928Z
9392782 9392782 20260225062643_DWAx0 CA000Q 2026-02-26T14:08:20.504Z 2026-03-05T14:37:07.509Z
9392772 9392772 20260225060555_pI9u1 CA000Q 2026-02-26T14:08:16.023Z 2026-03-05T14:37:07.016Z
9392662 9392662 20260225051100_VtibV CA000Q 2026-02-26T14:07:57.908Z 2026-03-05T14:37:03.700Z
9392251 9392251 20260225035656_WlrAE CA000Q 2026-02-26T14:06:50.508Z 2026-03-05T14:36:52.684Z
9391327 9391327 20260225022905_XcBgw CA000Q 2026-02-26T14:04:05.233Z 2026-03-05T14:36:17.705Z
9383927 9383927 20260224093658_JVWQA CA000Q 2026-02-25T14:03:53.020Z 2026-03-04T14:17:58.176Z
9383576 9383576 20260224062331_HcHCf CA000Q 2026-02-25T14:02:13.832Z 2026-03-04T14:17:51.561Z
9383560 9383560 20260224060600_J2tvG CA000Q 2026-02-25T14:02:10.725Z 2026-03-04T14:17:51.355Z
9383535 9383535 20260224054307_tbvNH CA000Q 2026-02-25T14:02:06.304Z 2026-03-04T14:17:50.939Z
9374905 9374905 20260223101203_MOx3a CA000Q 2026-02-24T14:07:28.619Z 2026-03-03T14:31:38.154Z
9374359 9374359 20260223080625_2nn2t CA000Q 2026-02-24T14:05:47.654Z 2026-03-03T14:31:28.596Z
9374208 9374208 20260223063846_eue9S CA000Q 2026-02-24T14:05:16.698Z 2026-03-03T14:31:17.742Z
9374032 9374032 20260223052253_9jnfN CA000Q 2026-02-24T14:04:38.435Z 2026-03-03T14:31:13.398Z
9373903 9373903 20260223045101_iC3Ym CA000Q 2026-02-24T14:04:16.510Z 2026-03-03T14:31:11.284Z
9373764 9373764 20260223041650_xFxRq CA000Q 2026-02-24T14:03:54.282Z 2026-03-03T14:31:09.410Z
9373734 9373734 20260223041234_eWF5H CA000Q 2026-02-24T14:03:50.139Z 2026-03-03T14:31:08.934Z
9373702 9373702 20260223040404_txCR2 CA000Q 2026-02-24T14:03:41.630Z 2026-03-03T14:31:08.039Z
9373461 9373461 20260223030916_b4LjO CA000Q 2026-02-24T14:03:02.305Z 2026-03-03T14:31:03.609Z
9373093 9373093 20260223020918_SgOTN CA000Q 2026-02-24T14:02:11.756Z 2026-03-03T14:30:51.201Z
9372961 9372961 20260223013821_EAzTI CA000Q 2026-02-24T14:01:47.712Z 2026-03-03T14:30:49.138Z
9372919 9372919 20260223012915_A3065 CA000Q 2026-02-24T14:01:42.579Z 2026-03-03T14:30:48.730Z
9372666 9372666 20260223005350_4P23s CA000Q 2026-02-24T14:01:12.114Z 2026-03-03T14:30:44.191Z
9372470 9372470 20260223001904_Mmo7u CA000Q 2026-02-24T14:00:41.863Z 2026-03-03T14:30:40.945Z
9372423 9372423 20260223001122_HUyUZ CA000Q 2026-02-24T14:00:31.180Z 2026-03-03T14:30:40.190Z
9366807 9366807 20260222103652_7kfmR CA000Q 2026-02-23T14:08:39.082Z 2026-02-24T14:16:39.359Z
9366622 9366622 20260222100848_GFFU2 CA000Q 2026-02-23T14:08:08.700Z 2026-02-24T14:16:29.837Z
9366421 9366421 20260222094204_04d2E CA000Q 2026-02-23T14:07:33.984Z 2026-02-24T14:16:18.325Z
9366392 9366392 20260222093616_DrlSk CA000Q 2026-02-23T14:07:30.320Z 2026-02-24T14:16:17.457Z
9366359 9366359 20260222093011_FREbK CA000Q 2026-02-23T14:07:21.237Z 2026-02-24T14:16:15.445Z
9366302 9366302 20260222092008_Bq7fk CA000Q 2026-02-23T14:07:11.077Z 2026-02-24T14:16:11.610Z
9366223 9366223 20260222090713_k3LDl CA000Q 2026-02-23T14:06:56.407Z 2026-02-24T14:16:07.460Z
9366064 9366064 20260222082903_S1Af2 CA000Q 2026-02-23T14:06:14.607Z 2026-02-24T14:15:58.503Z
9366034 9366034 20260222082236_N5VfC CA000Q 2026-02-23T14:06:08.915Z 2026-02-24T14:15:55.627Z
9366019 9366019 20260222081415_gkEzF CA000Q 2026-02-23T14:06:05.618Z 2026-02-24T14:15:54.901Z
9365980 9365980 20260222075104_Z2d1s CA000Q 2026-02-23T14:05:53.277Z 2026-02-24T14:15:51.836Z
9365978 9365978 20260222075058_WH31o CA000Q 2026-02-23T14:05:52.694Z 2026-02-24T14:15:51.687Z
9365940 9365940 20260222073820_ew2aG CA000Q 2026-02-23T14:05:42.608Z 2026-02-24T14:15:48.197Z
9365854 9365854 20260222064632_Pgi4T CA000Q 2026-02-23T14:05:20.085Z 2026-02-24T14:15:42.632Z
9365783 9365783 20260222061229_3SPsd CA000Q 2026-02-23T14:05:05.863Z 2026-02-24T14:15:38.356Z

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