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

1,979 rows where station_code = "CA002N" 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
8671874 8671874 20251201131004_p1IHf CA002N 2025-12-03T14:14:03.048Z 2025-12-05T14:24:57.646Z
8666771 8666771 20251201020212_hvqgO CA002N 2025-12-02T14:27:44.785Z 2025-12-05T14:35:35.867Z
8666769 8666769 20251201020004_L8JhN CA002N 2025-12-02T14:27:42.895Z 2025-12-05T14:35:35.468Z
8620531 8620531 20251126125334_VlGNi CA002N 2025-11-28T14:13:08.762Z 2025-12-05T15:02:12.106Z
8618656 8618656 20251127125627_O2rC2 CA002N 2025-11-28T14:05:21.043Z 2025-12-05T14:54:19.412Z
8618324 8618324 20251127120256_9991Y CA002N 2025-11-28T14:04:15.184Z 2025-12-05T14:54:13.483Z
8617948 8617948 20251127110006_hsCHe CA002N 2025-11-28T14:02:53.649Z 2025-12-05T14:54:06.877Z
8617353 8617353 20251127091300_lGMCf CA002N 2025-11-28T14:00:31.046Z 2025-12-05T14:53:44.124Z
8617186 8617186 20251125072336_PZ37Y CA002N 2025-11-27T14:41:48.585Z 2025-12-02T15:09:38.385Z
8605508 8605508 20251125132934_qIg4i CA002N 2025-11-27T14:05:28.737Z 2025-12-04T15:05:26.862Z
8605435 8605435 20251125120155_F5YXy CA002N 2025-11-27T14:04:35.056Z 2025-12-04T15:05:20.359Z
8605399 8605399 20251125101042_uc22k CA002N 2025-11-27T14:03:39.236Z 2025-12-04T15:05:11.418Z
8584747 8584747 20251123131643_ItaKh CA002N 2025-11-25T14:07:23.593Z 2025-12-02T15:09:51.533Z
8584745 8584745 20251123131623_9y1i5 CA002N 2025-11-25T14:07:23.075Z 2025-12-02T15:09:51.532Z
8584409 8584409 20251123120327_fasaA CA002N 2025-11-25T14:06:15.790Z 2025-12-02T15:09:48.460Z
8584054 8584054 20251123104159_HwuMn CA002N 2025-11-25T14:05:10.257Z 2025-12-02T15:09:45.638Z
8582710 8582710 20251123080455_oUp5F CA002N 2025-11-24T14:34:26.308Z 2025-12-01T15:22:26.814Z
8582658 8582658 20251123074017_7ijiB CA002N 2025-11-24T14:34:23.989Z 2025-12-01T15:22:26.303Z
8582551 8582551 20251123070146_un7Xc CA002N 2025-11-24T14:34:02.762Z 2025-12-01T15:22:25.149Z
8582499 8582499 20251123063739_lhoI9 CA002N 2025-11-24T14:33:45.560Z 2025-12-01T15:22:24.535Z
8582403 8582403 20251123060353_tma5a CA002N 2025-11-24T14:33:34.761Z 2025-12-01T15:22:23.368Z
8581843 8581843 20251123024619_LNvP1 CA002N 2025-11-24T14:32:41.069Z 2025-12-01T15:21:45.500Z
8581224 8581224 20251122100524_xs7fd CA002N 2025-11-24T14:29:40.367Z 2025-11-30T15:07:26.156Z
8580844 8580844 20251122080631_Bu0pU CA002N 2025-11-24T14:28:59.095Z 2025-11-30T15:07:12.235Z
8574628 8574628 20251122101442_2dToy CA002N 2025-11-24T14:00:21.341Z 2025-12-01T15:17:17.502Z
8574603 8574603 20251122100829_4NU4E CA002N 2025-11-24T14:00:13.581Z 2025-12-01T15:17:15.034Z
8573559 8573559 20251122033218_lfFT7 CA002N 2025-11-23T14:41:17.293Z 2025-11-30T15:06:30.831Z
8570612 8570612 20251121095841_2mNk7 CA002N 2025-11-23T14:33:54.404Z 2025-11-29T14:55:07.066Z
8570492 8570492 20251121093613_vEmF4 CA002N 2025-11-23T14:33:47.281Z 2025-11-29T14:55:05.522Z
8570393 8570393 20251121091202_GUHCP CA002N 2025-11-23T14:33:40.207Z 2025-11-29T14:55:02.229Z
8570350 8570350 20251121090457_hA2sq CA002N 2025-11-23T14:33:37.592Z 2025-11-29T14:55:01.337Z
8560621 8560621 20251121102618_k4srU CA002N 2025-11-23T14:00:20.989Z 2025-11-30T15:02:33.748Z
8554602 8554602 20251120101657_KsX4t CA002N 2025-11-22T14:35:36.704Z 2025-11-28T14:58:54.322Z
8554444 8554444 20251120094449_4z1Fx CA002N 2025-11-22T14:35:28.232Z 2025-11-28T14:58:51.135Z
8554072 8554072 20251120074830_N6lnR CA002N 2025-11-22T14:34:43.057Z 2025-11-28T14:58:45.448Z
8554064 8554064 20251120074343_3msG9 CA002N 2025-11-22T14:34:42.289Z 2025-11-28T14:58:45.259Z
8554045 8554045 20251120065207_Sl2vG CA002N 2025-11-22T14:34:40.920Z 2025-11-28T14:58:44.745Z
8554035 8554035 20251120064316_RiwD0 CA002N 2025-11-22T14:34:40.077Z 2025-11-28T14:58:44.715Z
8553380 8553380 20251120053009_US8GZ CA002N 2025-11-22T14:33:54.384Z 2025-11-28T14:58:02.958Z
8552714 8552714 20251120042549_dohY8 CA002N 2025-11-22T14:32:41.454Z 2025-11-28T14:57:38.303Z
8542679 8542679 20251120124005_oYmC2 CA002N 2025-11-22T14:02:52.224Z 2025-11-29T14:53:14.409Z
8542386 8542386 20251120120839_3H6Qt CA002N 2025-11-22T14:01:58.643Z 2025-11-29T14:53:11.143Z
8542120 8542120 20251120113141_YmqW2 CA002N 2025-11-22T14:01:18.112Z 2025-11-29T14:53:05.734Z
8540553 8540553 20251120011249_9Is22 CA002N 2025-11-21T14:36:05.279Z 2025-11-28T14:56:15.388Z
8530822 8530822 20251119130243_Nv7UC CA002N 2025-11-21T14:03:08.554Z 2025-11-28T14:53:21.297Z
8517053 8517053 20251118093651_8Jlj0 CA002N 2025-11-19T14:42:24.280Z 2025-11-26T15:08:19.765Z
8516947 8516947 20251118091719_G9Oxc CA002N 2025-11-19T14:42:18.562Z 2025-11-26T15:08:13.617Z
8516323 8516323 20251118062248_4Dsxh CA002N 2025-11-19T14:40:50.572Z 2025-11-19T14:40:50.572Z
8469880 8469880 20251115034625_QgblR CA002N 2025-11-16T14:21:26.131Z 2025-11-23T15:17:58.407Z
8458870 8458870 20251114020348_5vW1w CA002N 2025-11-15T14:18:09.062Z 2025-11-22T15:21:24.533Z
8443378 8443378 20251111115733_kHJCy CA002N 2025-11-13T14:50:46.847Z 2025-11-19T15:19:14.618Z
8443288 8443288 20251111114427_uMHyo CA002N 2025-11-13T14:50:42.993Z 2025-11-19T15:19:09.532Z
8443008 8443008 20251111105511_wabxm CA002N 2025-11-13T14:49:54.605Z 2025-11-19T15:18:54.320Z
8442890 8442890 20251111103220_UG5S7 CA002N 2025-11-13T14:49:45.611Z 2025-11-19T15:18:49.553Z
8442625 8442625 20251111062423_9PjT4 CA002N 2025-11-13T14:48:35.135Z 2025-11-19T15:18:16.803Z
8442623 8442623 20251111061958_oX7pR CA002N 2025-11-13T14:48:34.153Z 2025-11-19T15:18:14.038Z
8442610 8442610 20251111054414_bPT5r CA002N 2025-11-13T14:48:29.889Z 2025-11-19T15:18:09.054Z
8442577 8442577 20251111041630_lLDcq CA002N 2025-11-13T14:47:39.630Z 2025-11-19T15:17:48.095Z
8431005 8431005 20251111132852_5ag3p CA002N 2025-11-13T14:03:06.062Z 2025-11-20T15:19:47.809Z
8430353 8430353 20251111122352_TUfL0 CA002N 2025-11-13T14:00:52.793Z 2025-11-20T15:19:29.275Z
8399125 8399125 20251108073916_XQ1u0 CA002N 2025-11-09T14:17:26.527Z 2025-11-16T15:05:23.051Z
8398598 8398598 20251108050727_Tc3cH CA002N 2025-11-09T14:15:54.043Z 2025-11-16T15:04:55.328Z
8383761 8383761 20251104124233_JWGS4 CA002N 2025-11-06T14:29:36.006Z 2025-11-12T15:12:40.643Z
8383614 8383614 20251104114007_3FuYN CA002N 2025-11-06T14:28:33.928Z 2025-11-12T15:12:18.059Z
8383507 8383507 20251104105813_ALlOL CA002N 2025-11-06T14:27:51.459Z 2025-11-12T15:12:04.219Z
8383411 8383411 20251104101008_YevSj CA002N 2025-11-06T14:27:38.057Z 2025-11-12T15:11:49.212Z
8383333 8383333 20251104092457_dKzec CA002N 2025-11-06T14:27:02.519Z 2025-11-12T15:11:33.320Z
8381070 8381070 20251105035749_ZCKCa CA002N 2025-11-06T14:13:57.201Z 2025-11-13T15:15:15.483Z
8374898 8374898 20251103052538_7zBdy CA002N 2025-11-05T14:33:25.741Z 2025-11-11T15:08:09.509Z
8374700 8374700 20251103043715_RoMZe CA002N 2025-11-05T14:33:03.686Z 2025-11-11T15:08:05.479Z
8374538 8374538 20251103040345_XDmaK CA002N 2025-11-05T14:32:22.126Z 2025-11-11T15:07:42.636Z
8373979 8373979 20251103021027_H4E6k CA002N 2025-11-05T14:30:28.701Z 2025-11-11T15:06:31.686Z
8373850 8373850 20251103011720_3ha2U CA002N 2025-11-05T14:29:45.784Z 2025-11-11T15:06:25.973Z
8367612 8367612 20251102124719_bAGtF CA002N 2025-11-04T14:37:45.070Z 2025-11-10T15:10:49.964Z
8367358 8367358 20251102122038_7iM40 CA002N 2025-11-04T14:37:11.207Z 2025-11-10T15:10:41.883Z
8367200 8367200 20251102120504_Sivku CA002N 2025-11-04T14:36:45.614Z 2025-11-10T15:10:40.222Z
8366734 8366734 20251102111439_coVZ1 CA002N 2025-11-04T14:35:48.933Z 2025-11-10T15:10:35.361Z
8366443 8366443 20251102104615_m35OV CA002N 2025-11-04T14:35:12.193Z 2025-11-10T15:10:32.008Z
8359413 8359413 20251102130242_kI7ZB CA002N 2025-11-04T14:00:33.563Z 2025-11-11T15:02:17.574Z
8359366 8359366 20251102125702_fiEjc CA002N 2025-11-04T14:00:19.858Z 2025-11-11T15:02:16.010Z
8359352 8359352 20251102125057_2ev2b CA002N 2025-11-04T14:00:15.272Z 2025-11-11T15:02:15.255Z
8356775 8356775 20251102031555_xxs68 CA002N 2025-11-03T14:42:03.937Z 2025-11-10T15:08:20.097Z
8356524 8356524 20251102020457_pE96I CA002N 2025-11-03T14:40:38.323Z 2025-11-10T15:07:24.648Z
8340697 8340697 20251031121740_s9t7N CA002N 2025-11-02T14:35:34.027Z 2025-11-08T15:18:17.731Z
8340618 8340618 20251031121059_8F6rB CA002N 2025-11-02T14:35:31.655Z 2025-11-08T15:18:14.346Z
8340490 8340490 20251031115811_gRx6b CA002N 2025-11-02T14:35:27.080Z 2025-11-08T15:18:10.501Z
8339529 8339529 20251031103326_PyCRb CA002N 2025-11-02T14:34:17.874Z 2025-11-08T15:17:40.289Z
8339212 8339212 20251031100612_2rLlD CA002N 2025-11-02T14:33:32.479Z 2025-11-08T15:17:30.820Z
8339207 8339207 20251031100547_dS1Wn CA002N 2025-11-02T14:33:32.228Z 2025-11-08T15:17:30.608Z
8338870 8338870 20251031093156_B9XJS CA002N 2025-11-02T14:33:19.145Z 2025-11-08T15:17:20.049Z
8338690 8338690 20251031091033_Djrc3 CA002N 2025-11-02T14:32:58.618Z 2025-11-08T15:17:08.674Z
8338654 8338654 20251031090801_Zi4ET CA002N 2025-11-02T14:32:48.694Z 2025-11-08T15:17:06.503Z
8338579 8338579 20251031090048_7vw7t CA002N 2025-11-02T14:32:45.123Z 2025-11-08T15:16:55.919Z
8338194 8338194 20251031082042_s6c1s CA002N 2025-11-02T14:31:55.362Z 2025-11-08T15:16:33.784Z
8338124 8338124 20251031081046_hycqt CA002N 2025-11-02T14:31:45.989Z 2025-11-08T15:16:32.587Z
8337673 8337673 20251031071459_RvgEq CA002N 2025-11-02T14:31:26.049Z 2025-11-08T15:16:24.615Z
8337429 8337429 20251031064129_Mii8O CA002N 2025-11-02T14:30:58.041Z 2025-11-08T15:16:22.350Z
8337408 8337408 20251031064034_6reWo CA002N 2025-11-02T14:30:57.659Z 2025-11-08T15:16:22.246Z
8336941 8336941 20251031053332_uFD3y CA002N 2025-11-02T14:30:19.163Z 2025-11-08T15:16:17.047Z
8328167 8328167 20251030122525_R8eiG CA002N 2025-11-01T12:38:26.819Z 2025-11-07T15:19:11.879Z

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