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

5,433 rows where station_code = "CA001R" 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
9590422 9590422 20260328090745_eTPQa CA001R 2026-03-29T12:02:36.965Z 2026-04-06T12:38:07.180Z
9590416 9590416 20260328090327_NvcKM CA001R 2026-03-29T12:02:36.119Z 2026-04-06T12:38:06.894Z
9572711 9572711 20260324095855_0XvmQ CA001R 2026-03-25T12:06:05.247Z 2026-04-02T12:35:35.510Z
9572612 9572612 20260324093740_2PAtL CA001R 2026-03-25T12:05:45.472Z 2026-04-02T12:35:31.716Z
9572335 9572335 20260324083519_bVHxK CA001R 2026-03-25T12:04:44.181Z 2026-04-02T12:35:20.085Z
9572260 9572260 20260324082155_hOuND CA001R 2026-03-25T12:04:27.871Z 2026-04-02T12:35:11.384Z
9572255 9572255 20260324082147_k8Mjc CA001R 2026-03-25T12:04:26.620Z 2026-04-02T12:35:11.166Z
9563954 9563954 20260323094028_oGV3s CA001R 2026-03-24T12:07:04.029Z 2026-03-31T12:26:59.754Z
9563932 9563932 20260323093705_9kKHJ CA001R 2026-03-24T12:07:01.636Z 2026-03-31T12:26:59.371Z
9563737 9563737 20260323090538_MkPl0 CA001R 2026-03-24T12:06:37.997Z 2026-03-31T12:26:50.067Z
9563522 9563522 20260323082908_HGBTh CA001R 2026-03-24T12:06:09.984Z 2026-03-31T12:26:46.124Z
9563467 9563467 20260323082425_6TZ9y CA001R 2026-03-24T12:06:04.189Z 2026-03-31T12:26:43.870Z
9353242 9353242 20260220102458_izB3M CA001R 2026-02-21T14:04:04.088Z 2026-03-01T14:21:48.050Z
9330099 9330099 20260214234146_O8Ehf CA001R 2026-02-16T14:22:32.331Z 2026-02-23T14:47:41.245Z
9328412 9328412 20260215110305_F3ATj CA001R 2026-02-16T14:08:32.767Z 2026-02-24T14:42:24.143Z
9328265 9328265 20260215103637_9kiF0 CA001R 2026-02-16T14:08:02.996Z 2026-02-24T14:42:22.126Z
9327725 9327725 20260215082248_tnaJD CA001R 2026-02-16T14:05:43.630Z 2026-02-24T14:42:00.385Z
9327648 9327648 20260215075415_RMsk0 CA001R 2026-02-16T14:05:23.436Z 2026-02-24T14:41:59.003Z
9327600 9327600 20260215072410_DqY6b CA001R 2026-02-16T14:05:11.797Z 2026-02-24T14:41:58.142Z
9327517 9327517 20260215062701_iP6nh CA001R 2026-02-16T14:04:48.615Z 2026-02-24T14:41:56.239Z
9327155 9327155 20260215042105_NG568 CA001R 2026-02-16T14:02:49.278Z 2026-02-24T14:41:48.437Z
9326911 9326911 20260215025853_4eO2i CA001R 2026-02-16T14:01:28.269Z 2026-02-24T14:41:38.283Z
9312079 9312079 20260210070944_je32q CA001R 2026-02-11T14:03:34.651Z 2026-02-18T14:55:54.479Z
9311637 9311637 20260209022941_6LvLj CA001R 2026-02-10T14:24:43.889Z 2026-02-16T14:55:01.702Z
9311630 9311630 20260209022420_sRrK4 CA001R 2026-02-10T14:24:41.922Z 2026-02-16T14:55:01.047Z
9311622 9311622 20260209021833_SppTU CA001R 2026-02-10T14:24:40.187Z 2026-02-16T14:55:00.549Z
9311570 9311570 20260209013821_6yg9u CA001R 2026-02-10T14:24:26.030Z 2026-02-16T14:54:56.658Z
9311523 9311523 20260209000735_GWgKj CA001R 2026-02-10T14:24:12.751Z 2026-02-16T14:54:52.990Z
9306968 9306968 20260208025220_podi8 CA001R 2026-02-09T14:25:52.352Z 2026-02-16T15:01:17.818Z
9306902 9306902 20260208022910_ZSyiV CA001R 2026-02-09T14:25:34.444Z 2026-02-16T15:01:07.477Z
9306831 9306831 20260208020451_pYQ35 CA001R 2026-02-09T14:25:19.975Z 2026-02-16T15:01:00.282Z
9298378 9298378 20260206021433_mtznU CA001R 2026-02-07T14:23:01.966Z 2026-02-14T15:06:23.582Z
9298303 9298303 20260206011350_cXxQi CA001R 2026-02-07T14:22:40.240Z 2026-02-14T15:06:17.603Z
9298266 9298266 20260206001352_GS2Q5 CA001R 2026-02-07T14:22:30.105Z 2026-02-14T15:06:14.853Z
9298243 9298243 20260205234530_o35EJ CA001R 2026-02-07T14:22:17.856Z 2026-02-14T15:06:11.688Z
9294742 9294742 20260205032734_mVfl2 CA001R 2026-02-06T14:20:59.817Z 2026-02-13T14:58:03.031Z
9294735 9294735 20260205032148_6BOE2 CA001R 2026-02-06T14:20:58.219Z 2026-02-13T14:58:02.440Z
9292822 9292822 20260205110432_PzzLu CA001R 2026-02-06T14:06:54.841Z 2026-02-14T15:03:33.294Z
9292671 9292671 20260205104154_YoWIo CA001R 2026-02-06T14:06:11.900Z 2026-02-14T15:03:22.318Z
9292453 9292453 20260205095346_P4r2O CA001R 2026-02-06T14:05:02.920Z 2026-02-14T15:03:02.585Z
9292100 9292100 20260205085356_ikOe3 CA001R 2026-02-06T14:03:12.544Z 2026-02-14T15:02:27.893Z
9291960 9291960 20260205082523_m0oCg CA001R 2026-02-06T14:02:31.548Z 2026-02-14T15:02:15.726Z
9291930 9291930 20260205081139_I3jdQ CA001R 2026-02-06T14:02:17.366Z 2026-02-14T15:02:12.717Z
9291838 9291838 20260205071553_WGUoG CA001R 2026-02-06T14:01:40.794Z 2026-02-14T15:02:03.234Z
9287234 9287234 20260203084015_5dM7B CA001R 2026-02-04T14:01:30.676Z 2026-02-12T14:50:10.723Z
9287221 9287221 20260203082837_So7Fd CA001R 2026-02-04T14:01:24.568Z 2026-02-12T14:50:09.759Z
9286614 9286614 20260202103954_JpPGS CA001R 2026-02-03T14:02:05.527Z 2026-02-11T14:50:11.274Z
9286604 9286604 20260202103604_BjKE9 CA001R 2026-02-03T14:02:01.045Z 2026-02-11T14:50:08.919Z
9286577 9286577 20260202101629_aLnhh CA001R 2026-02-03T14:01:47.066Z 2026-02-11T14:50:06.049Z
9286550 9286550 20260202094722_5713D CA001R 2026-02-03T14:01:34.752Z 2026-02-11T14:50:03.831Z
9286530 9286530 20260202093805_KB72Q CA001R 2026-02-03T14:01:27.560Z 2026-02-11T14:50:02.387Z
9286512 9286512 20260202085726_eiMic CA001R 2026-02-03T14:01:18.464Z 2026-02-11T14:50:00.516Z
9286441 9286441 20260202071956_AZk0U CA001R 2026-02-03T14:00:47.158Z 2026-02-11T14:49:55.183Z
9278155 9278155 20260129060817_OgS2k CA001R 2026-01-30T14:24:40.620Z 2026-02-06T14:48:36.307Z
9273426 9273426 20260128060844_oOh6M CA001R 2026-01-29T14:29:45.001Z 2026-02-05T14:50:48.330Z
9268725 9268725 20260128110935_cSWOP CA001R 2026-01-29T14:04:34.573Z 2026-02-06T14:43:47.240Z
9268249 9268249 20260128093101_Y2pfO CA001R 2026-01-29T14:01:59.415Z 2026-02-06T14:43:03.681Z
9268137 9268137 20260128090129_EAfLT CA001R 2026-01-29T14:01:22.139Z 2026-02-06T14:42:56.158Z
9268083 9268083 20260128084441_ioD4h CA001R 2026-01-29T14:00:59.278Z 2026-02-06T14:42:52.082Z
9268059 9268059 20260128082700_snWJK CA001R 2026-01-29T14:00:49.474Z 2026-02-06T14:42:50.710Z
9267993 9267993 20260128072855_6leWf CA001R 2026-01-29T14:00:19.620Z 2026-02-06T14:42:46.164Z
9267932 9267932 20260127065928_2IMz7 CA001R 2026-01-28T14:23:56.145Z 2026-02-04T14:50:14.219Z
9267914 9267914 20260127064953_uhsZO CA001R 2026-01-28T14:23:52.099Z 2026-02-04T14:50:12.588Z
9267869 9267869 20260127062215_B4Agm CA001R 2026-01-28T14:23:38.604Z 2026-02-04T14:50:02.762Z
9267857 9267857 20260127061626_WCjIQ CA001R 2026-01-28T14:23:35.907Z 2026-02-04T14:50:01.921Z
9267773 9267773 20260127045508_3SNH1 CA001R 2026-01-28T14:23:15.638Z 2026-02-04T14:49:53.585Z
9267763 9267763 20260127044949_eCnd8 CA001R 2026-01-28T14:23:13.230Z 2026-02-04T14:49:52.660Z
9267745 9267745 20260127044226_123g3 CA001R 2026-01-28T14:23:05.268Z 2026-02-04T14:49:51.332Z
9267726 9267726 20260127043549_bDxGw CA001R 2026-01-28T14:23:01.076Z 2026-02-04T14:49:49.988Z
9267685 9267685 20260127041625_YV23F CA001R 2026-01-28T14:22:52.698Z 2026-02-04T14:49:46.092Z
9267639 9267639 20260127035547_FBeQm CA001R 2026-01-28T14:22:38.819Z 2026-02-04T14:49:36.304Z
9263433 9263433 20260127075530_8hDv5 CA001R 2026-01-28T14:00:33.064Z 2026-02-05T14:44:16.671Z
9263431 9263431 20260127075510_Nhvo2 CA001R 2026-01-28T14:00:32.008Z 2026-02-05T14:44:16.532Z
9263415 9263415 20260127074424_9nBcP CA001R 2026-01-28T14:00:24.311Z 2026-02-05T14:44:15.207Z
9260597 9260597 20260125054651_6ulSG CA001R 2026-01-26T14:22:31.506Z 2026-02-02T14:50:07.889Z
9260567 9260567 20260125053203_AmRfN CA001R 2026-01-26T14:22:25.600Z 2026-02-02T14:50:06.199Z
9260358 9260358 20260125035849_IA0co CA001R 2026-01-26T14:21:23.856Z 2026-02-02T14:49:44.126Z
9260015 9260015 20260125020626_VyGZJ CA001R 2026-01-26T14:19:47.460Z 2026-02-02T14:49:18.183Z
9259989 9259989 20260125014617_ZdcNY CA001R 2026-01-26T14:19:41.457Z 2026-02-02T14:49:16.571Z
9259958 9259958 20260125013150_nthFH CA001R 2026-01-26T14:19:33.776Z 2026-02-02T14:49:13.133Z
9259772 9259772 20260125000257_oS1Ot CA001R 2026-01-26T14:18:32.995Z 2026-02-02T14:49:01.357Z
9259736 9259736 20260124234542_xHICl CA001R 2026-01-26T14:18:19.647Z 2026-02-02T14:48:58.927Z
9256430 9256430 20260124083037_hYfvB CA001R 2026-01-25T14:17:06.775Z 2026-02-01T14:51:32.924Z
9256393 9256393 20260124081418_D6bzj CA001R 2026-01-25T14:16:55.220Z 2026-02-01T14:51:31.105Z
9256311 9256311 20260124071353_J077d CA001R 2026-01-25T14:16:37.686Z 2026-02-01T14:51:19.020Z
9256300 9256300 20260124070513_5kh2N CA001R 2026-01-25T14:16:34.551Z 2026-02-01T14:51:18.348Z
9256289 9256289 20260124064645_DBrv0 CA001R 2026-01-25T14:16:31.594Z 2026-02-01T14:51:17.605Z
9256097 9256097 20260124055352_W8Yth CA001R 2026-01-25T14:15:50.557Z 2026-02-01T14:51:09.262Z
9256079 9256079 20260124055056_TbJsS CA001R 2026-01-25T14:15:44.008Z 2026-02-01T14:51:08.489Z
9256072 9256072 20260124054938_mooZ0 CA001R 2026-01-25T14:15:42.250Z 2026-02-01T14:51:08.194Z
9256047 9256047 20260124054742_aM0f0 CA001R 2026-01-25T14:15:38.706Z 2026-02-01T14:51:07.577Z
9256044 9256044 20260124054646_9vvoO CA001R 2026-01-25T14:15:37.508Z 2026-02-01T14:51:07.305Z
9255872 9255872 20260124050951_tPTaJ CA001R 2026-01-25T14:15:01.039Z 2026-02-01T14:51:00.679Z
9255811 9255811 20260124050141_k49zb CA001R 2026-01-25T14:14:51.873Z 2026-02-01T14:50:58.437Z
9255737 9255737 20260124044152_pzAD3 CA001R 2026-01-25T14:14:30.719Z 2026-02-01T14:50:48.295Z
9255689 9255689 20260124043153_TjWHF CA001R 2026-01-25T14:14:23.168Z 2026-02-01T14:50:46.479Z
9255514 9255514 20260124035645_20TWO CA001R 2026-01-25T14:13:44.726Z 2026-02-01T14:50:38.806Z
9255341 9255341 20260124025716_I2zxz CA001R 2026-01-25T14:12:59.151Z 2026-02-01T14:50:29.928Z
9255260 9255260 20260124021510_22bLJ CA001R 2026-01-25T14:12:34.674Z 2026-02-01T14:50:17.919Z
9255212 9255212 20260124014907_yj3Zp CA001R 2026-01-25T14:12:23.977Z 2026-02-01T14:50:15.484Z

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