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,288 rows where station_code = "CA003D" 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
9633504 9633504 20260408033751_kKuKB CA003D 2026-04-09T12:27:54.442Z 2026-04-09T12:28:35.255Z
9631620 9631620 20260408012425_cvQ0U CA003D 2026-04-09T12:24:09.043Z 2026-04-09T12:28:34.838Z
9631175 9631175 20260408005500_mUOFm CA003D 2026-04-09T12:23:07.890Z 2026-04-09T12:28:34.752Z
9624987 9624987 20260408090842_mbDgP CA003D 2026-04-09T12:03:42.891Z 2026-04-09T12:03:42.891Z
9624941 9624941 20260408085857_Rm5mk CA003D 2026-04-09T12:03:30.465Z 2026-04-09T12:03:30.465Z
9624737 9624737 20260408081903_0yJ4H CA003D 2026-04-09T12:02:41.084Z 2026-04-09T12:02:41.084Z
9607312 9607312 20260404072103_JLat5 CA003D 2026-04-05T12:01:32.851Z 2026-04-09T12:39:18.898Z
9602998 9602998 20260402054605_KzSZr CA003D 2026-04-03T12:01:26.687Z 2026-04-09T12:43:18.083Z
9602843 9602843 20260402033607_99tG9 CA003D 2026-04-03T12:00:53.624Z 2026-04-09T12:43:14.907Z
9590423 9590423 20260328090745_eTPQa CA003D 2026-03-29T12:02:36.965Z 2026-04-06T12:38:07.180Z
9590186 9590186 20260328072435_Zjn1A CA003D 2026-03-29T12:02:10.502Z 2026-04-06T12:37:55.282Z
9590115 9590115 20260328063544_O2EEX CA003D 2026-03-29T12:02:02.015Z 2026-04-06T12:37:51.308Z
9586804 9586804 20260327094218_F4LdF CA003D 2026-03-28T12:04:04.226Z 2026-04-05T12:33:49.289Z
9572712 9572712 20260324095855_0XvmQ CA003D 2026-03-25T12:06:05.247Z 2026-04-02T12:35:35.510Z
9572613 9572613 20260324093740_2PAtL CA003D 2026-03-25T12:05:45.472Z 2026-04-02T12:35:31.716Z
9572336 9572336 20260324083519_bVHxK CA003D 2026-03-25T12:04:44.181Z 2026-04-02T12:35:20.085Z
9571940 9571940 20260324061429_Aiy29 CA003D 2026-03-25T12:03:16.623Z 2026-04-02T12:34:56.181Z
9571918 9571918 20260324055109_hlFmS CA003D 2026-03-25T12:03:11.199Z 2026-04-02T12:34:55.110Z
9571799 9571799 20260324042234_fufD1 CA003D 2026-03-25T12:02:44.995Z 2026-04-02T12:34:49.410Z
9563956 9563956 20260323094028_oGV3s CA003D 2026-03-24T12:07:04.029Z 2026-03-31T12:26:59.754Z
9563933 9563933 20260323093705_9kKHJ CA003D 2026-03-24T12:07:01.636Z 2026-03-31T12:26:59.371Z
9563469 9563469 20260323082425_6TZ9y CA003D 2026-03-24T12:06:04.222Z 2026-03-31T12:26:43.870Z
9535354 9535354 20260320071356_alkUI CA003D 2026-03-21T12:10:28.750Z 2026-03-28T12:34:33.483Z
9513367 9513367 20260318090258_jyiX3 CA003D 2026-03-19T12:15:04.303Z 2026-03-26T12:37:54.536Z
9512515 9512515 20260318064156_tHqrV CA003D 2026-03-19T12:12:47.748Z 2026-03-26T12:37:46.202Z
9447099 9447099 20260309044543_CeN9w CA003D 2026-03-10T12:05:10.440Z 2026-03-17T12:41:47.518Z
9446909 9446909 20260309033431_Uu1Gg CA003D 2026-03-10T12:04:26.615Z 2026-03-17T12:41:44.577Z
9432658 9432658 20260306082759_noUGV CA003D 2026-03-07T14:05:39.133Z 2026-03-14T12:39:34.822Z
9432449 9432449 20260306064936_oEys9 CA003D 2026-03-07T14:04:47.188Z 2026-03-14T12:39:30.427Z
9432391 9432391 20260306054705_6Xod2 CA003D 2026-03-07T14:04:33.891Z 2026-03-14T12:39:29.637Z
9432222 9432222 20260306040004_kGIya CA003D 2026-03-07T14:03:56.084Z 2026-03-14T12:39:27.097Z
9432014 9432014 20260306030553_oRB2Z CA003D 2026-03-07T14:02:59.863Z 2026-03-14T12:39:22.968Z
9426984 9426984 20260305052217_Rjv4d CA003D 2026-03-06T14:07:08.338Z 2026-03-13T12:34:53.126Z
9426740 9426740 20260305043135_ruAQt CA003D 2026-03-06T14:06:10.692Z 2026-03-13T12:34:50.412Z
9423188 9423188 20260304083216_CqWmJ CA003D 2026-03-05T14:04:03.687Z 2026-03-12T12:32:53.065Z
9423012 9423012 20260304060411_cHO6D CA003D 2026-03-05T14:03:29.459Z 2026-03-12T12:32:50.209Z
9415974 9415974 20260302064219_V3AEx CA003D 2026-03-03T14:02:19.134Z 2026-03-10T12:35:54.937Z
9415968 9415968 20260302062602_iunja CA003D 2026-03-03T14:02:17.567Z 2026-03-10T12:35:54.777Z
9415966 9415966 20260302062250_C1yqI CA003D 2026-03-03T14:02:17.072Z 2026-03-10T12:35:54.703Z
9415712 9415712 20260302031946_bZEU4 CA003D 2026-03-03T14:01:17.306Z 2026-03-10T12:35:48.576Z
9402911 9402911 20260227051250_v4OIJ CA003D 2026-02-28T14:06:30.556Z 2026-03-07T14:47:15.288Z
9383428 9383428 20260224042429_ru3Ft CA003D 2026-02-25T14:01:30.811Z 2026-03-04T14:17:48.733Z
9352618 9352618 20260220084100_uwWtK CA003D 2026-02-21T14:02:32.783Z 2026-03-01T14:21:40.601Z
9352519 9352519 20260220075136_V2i20 CA003D 2026-02-21T14:02:12.230Z 2026-03-01T14:21:39.054Z
9352479 9352479 20260220073350_tUvAL CA003D 2026-02-21T14:02:05.031Z 2026-03-01T14:21:38.385Z
9352457 9352457 20260220071743_sEqe3 CA003D 2026-02-21T14:02:00.073Z 2026-03-01T14:21:38.073Z
9352376 9352376 20260220055015_JUIRR CA003D 2026-02-21T14:01:41.789Z 2026-03-01T14:21:36.622Z
9352138 9352138 20260220023025_qGX4q CA003D 2026-02-21T14:00:46.204Z 2026-03-01T14:21:32.885Z
9345414 9345414 20260218094452_lKYiF CA003D 2026-02-20T14:01:29.936Z 2026-02-27T14:34:37.797Z
9345330 9345330 20260218092835_sJZmX CA003D 2026-02-20T14:01:28.947Z 2026-02-27T14:34:36.921Z
9345052 9345052 20260218081514_BruDS CA003D 2026-02-20T14:01:23.493Z 2026-02-27T14:34:33.238Z
9341567 9341567 20260219094029_sEvho CA003D 2026-02-20T14:00:56.997Z 2026-02-28T14:43:52.058Z
9331762 9331762 20260216080635_gkIBa CA003D 2026-02-17T14:08:16.231Z 2026-02-25T14:42:01.732Z
9330100 9330100 20260214234146_O8Ehf CA003D 2026-02-16T14:22:32.331Z 2026-02-23T14:47:41.245Z
9327962 9327962 20260215093104_3Sukr CA003D 2026-02-16T14:06:45.885Z 2026-02-24T14:42:05.303Z
9327766 9327766 20260215083204_1SW6w CA003D 2026-02-16T14:05:54.934Z 2026-02-24T14:42:01.440Z
9327650 9327650 20260215075415_RMsk0 CA003D 2026-02-16T14:05:23.436Z 2026-02-24T14:41:59.003Z
9327555 9327555 20260215065555_4FM8z CA003D 2026-02-16T14:05:00.074Z 2026-02-24T14:41:56.817Z
9327391 9327391 20260215052938_532eZ CA003D 2026-02-16T14:04:06.439Z 2026-02-24T14:41:53.191Z
9322101 9322101 20260214014317_RLQNE CA003D 2026-02-15T14:00:10.264Z 2026-02-23T14:46:08.317Z
9322020 9322020 20260213010400_1z9SU CA003D 2026-02-14T14:22:17.181Z 2026-02-21T14:37:40.721Z
9320326 9320326 20260213093329_1tebt CA003D 2026-02-14T14:06:00.162Z 2026-02-22T14:41:52.997Z
9320271 9320271 20260213091224_AWnHT CA003D 2026-02-14T14:05:43.056Z 2026-02-22T14:41:52.072Z
9320099 9320099 20260213072159_r7sZz CA003D 2026-02-14T14:04:29.223Z 2026-02-22T14:41:46.958Z
9319647 9319647 20260213031115_QmQve CA003D 2026-02-14T14:01:28.965Z 2026-02-22T14:41:35.710Z
9311638 9311638 20260209022941_6LvLj CA003D 2026-02-10T14:24:43.889Z 2026-02-16T14:55:01.702Z
9311632 9311632 20260209022420_sRrK4 CA003D 2026-02-10T14:24:41.923Z 2026-02-16T14:55:01.047Z
9311623 9311623 20260209021833_SppTU CA003D 2026-02-10T14:24:40.187Z 2026-02-16T14:55:00.549Z
9311583 9311583 20260209014417_Znttr CA003D 2026-02-10T14:24:30.526Z 2026-02-16T14:54:57.341Z
9311572 9311572 20260209013821_6yg9u CA003D 2026-02-10T14:24:26.030Z 2026-02-16T14:54:56.658Z
9308095 9308095 20260209091535_PSPrF CA003D 2026-02-10T14:05:51.921Z 2026-02-18T14:59:31.819Z
9308034 9308034 20260209085921_22wzH CA003D 2026-02-10T14:05:33.386Z 2026-02-18T14:59:21.574Z
9307525 9307525 20260209062046_LC2J6 CA003D 2026-02-10T14:02:49.699Z 2026-02-18T14:58:41.165Z
9307413 9307413 20260209053436_yUXS2 CA003D 2026-02-10T14:02:08.850Z 2026-02-18T14:58:28.333Z
9306969 9306969 20260208025220_podi8 CA003D 2026-02-09T14:25:52.352Z 2026-02-16T15:01:17.818Z
9306832 9306832 20260208020451_pYQ35 CA003D 2026-02-09T14:25:19.975Z 2026-02-16T15:01:00.282Z
9298380 9298380 20260206021433_mtznU CA003D 2026-02-07T14:23:01.966Z 2026-02-14T15:06:23.582Z
9298268 9298268 20260206001352_GS2Q5 CA003D 2026-02-07T14:22:30.105Z 2026-02-14T15:06:14.853Z
9292672 9292672 20260205104154_YoWIo CA003D 2026-02-06T14:06:11.900Z 2026-02-14T15:03:22.318Z
9292454 9292454 20260205095346_P4r2O CA003D 2026-02-06T14:05:02.920Z 2026-02-14T15:03:02.585Z
9291962 9291962 20260205082523_m0oCg CA003D 2026-02-06T14:02:31.548Z 2026-02-14T15:02:15.726Z
9291932 9291932 20260205081139_I3jdQ CA003D 2026-02-06T14:02:17.367Z 2026-02-14T15:02:12.717Z
9291840 9291840 20260205071553_WGUoG CA003D 2026-02-06T14:01:40.813Z 2026-02-14T15:02:03.234Z
9286615 9286615 20260202103954_JpPGS CA003D 2026-02-03T14:02:05.527Z 2026-02-11T14:50:11.274Z
9286578 9286578 20260202101629_aLnhh CA003D 2026-02-03T14:01:47.066Z 2026-02-11T14:50:06.049Z
9286552 9286552 20260202094722_5713D CA003D 2026-02-03T14:01:34.752Z 2026-02-11T14:50:03.831Z
9286531 9286531 20260202093805_KB72Q CA003D 2026-02-03T14:01:27.560Z 2026-02-11T14:50:02.387Z
9286513 9286513 20260202085726_eiMic CA003D 2026-02-03T14:01:18.464Z 2026-02-11T14:50:00.516Z
9286443 9286443 20260202071956_AZk0U CA003D 2026-02-03T14:00:47.172Z 2026-02-11T14:49:55.183Z
9278156 9278156 20260129060817_OgS2k CA003D 2026-01-30T14:24:40.639Z 2026-02-06T14:48:36.307Z
9268726 9268726 20260128110935_cSWOP CA003D 2026-01-29T14:04:34.573Z 2026-02-06T14:43:47.241Z
9268251 9268251 20260128093101_Y2pfO CA003D 2026-01-29T14:01:59.415Z 2026-02-06T14:43:03.681Z
9268138 9268138 20260128090129_EAfLT CA003D 2026-01-29T14:01:22.139Z 2026-02-06T14:42:56.158Z
9268085 9268085 20260128084441_ioD4h CA003D 2026-01-29T14:00:59.278Z 2026-02-06T14:42:52.082Z
9268061 9268061 20260128082700_snWJK CA003D 2026-01-29T14:00:49.474Z 2026-02-06T14:42:50.710Z
9267915 9267915 20260127064953_uhsZO CA003D 2026-01-28T14:23:52.099Z 2026-02-04T14:50:12.588Z
9267870 9267870 20260127062215_B4Agm CA003D 2026-01-28T14:23:38.604Z 2026-02-04T14:50:02.762Z
9267858 9267858 20260127061626_WCjIQ CA003D 2026-01-28T14:23:35.908Z 2026-02-04T14:50:01.921Z
9267775 9267775 20260127045508_3SNH1 CA003D 2026-01-28T14:23:15.638Z 2026-02-04T14:49:53.585Z
9267746 9267746 20260127044226_123g3 CA003D 2026-01-28T14:23:05.268Z 2026-02-04T14:49:51.332Z

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