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,792 rows where station_code = "CA002R" 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
8667837 8667837 20251130042239_8MkTU CA002R 2025-12-02T14:40:33.972Z 2025-12-05T14:44:40.651Z
8617906 8617906 20251127105103_nDUD3 CA002R 2025-11-28T14:02:46.386Z 2025-12-05T14:54:06.280Z
8617878 8617878 20251127104407_kZdLP CA002R 2025-11-28T14:02:42.129Z 2025-12-05T14:54:05.873Z
8617785 8617785 20251127103410_KbX3G CA002R 2025-11-28T14:02:24.664Z 2025-12-05T14:54:04.684Z
8584057 8584057 20251123104345_eenn0 CA002R 2025-11-25T14:05:11.725Z 2025-12-02T15:09:45.725Z
8583935 8583935 20251123101859_STCW4 CA002R 2025-11-25T14:04:38.808Z 2025-12-02T15:09:44.439Z
8583038 8583038 20251123094725_gJhHw CA002R 2025-11-24T14:34:46.622Z 2025-12-01T15:22:31.082Z
8583035 8583035 20251123094608_gnLBv CA002R 2025-11-24T14:34:46.464Z 2025-12-01T15:22:31.037Z
8583030 8583030 20251123094430_QewAG CA002R 2025-11-24T14:34:46.056Z 2025-12-01T15:22:31.003Z
8583018 8583018 20251123094223_KcTsm CA002R 2025-11-24T14:34:45.554Z 2025-12-01T15:22:30.780Z
8582967 8582967 20251123092253_32TcM CA002R 2025-11-24T14:34:40.071Z 2025-12-01T15:22:30.139Z
8582950 8582950 20251123091758_3hChu CA002R 2025-11-24T14:34:38.875Z 2025-12-01T15:22:29.921Z
8582914 8582914 20251123091008_7qMbe CA002R 2025-11-24T14:34:37.101Z 2025-12-01T15:22:29.483Z
8582911 8582911 20251123090954_AOixO CA002R 2025-11-24T14:34:36.975Z 2025-12-01T15:22:29.409Z
8582901 8582901 20251123090555_uSCX8 CA002R 2025-11-24T14:34:36.435Z 2025-12-01T15:22:29.270Z
8582637 8582637 20251123073141_ILbXF CA002R 2025-11-24T14:34:23.231Z 2025-12-01T15:22:26.087Z
8582592 8582592 20251123071119_a6d98 CA002R 2025-11-24T14:34:17.639Z 2025-12-01T15:22:25.627Z
8582555 8582555 20251123070248_sQqG8 CA002R 2025-11-24T14:34:03.175Z 2025-12-01T15:22:25.191Z
8582469 8582469 20251123062910_DZ6Zw CA002R 2025-11-24T14:33:39.205Z 2025-12-01T15:22:24.267Z
8582453 8582453 20251123062353_XwHg9 CA002R 2025-11-24T14:33:38.008Z 2025-12-01T15:22:24.046Z
8582425 8582425 20251123061203_2PPxh CA002R 2025-11-24T14:33:36.347Z 2025-12-01T15:22:23.658Z
8582417 8582417 20251123060742_il2aj CA002R 2025-11-24T14:33:35.824Z 2025-12-01T15:22:23.481Z
8582399 8582399 20251123060245_Gdgws CA002R 2025-11-24T14:33:33.589Z 2025-12-01T15:22:23.210Z
8582352 8582352 20251123054959_D828x CA002R 2025-11-24T14:33:31.115Z 2025-12-01T15:22:22.551Z
8582329 8582329 20251123053807_nst9W CA002R 2025-11-24T14:33:29.908Z 2025-12-01T15:22:22.189Z
8582270 8582270 20251123050844_7kJc3 CA002R 2025-11-24T14:33:26.760Z 2025-12-01T15:22:20.865Z
8582254 8582254 20251123050123_l2EMG CA002R 2025-11-24T14:33:25.856Z 2025-12-01T15:22:20.289Z
8582250 8582250 20251123045942_vtz2r CA002R 2025-11-24T14:33:25.574Z 2025-12-01T15:22:20.205Z
8582210 8582210 20251123044508_HAueO CA002R 2025-11-24T14:33:22.760Z 2025-12-01T15:22:18.833Z
8582161 8582161 20251123042628_TBlNW CA002R 2025-11-24T14:33:20.294Z 2025-12-01T15:22:17.646Z
8582092 8582092 20251123040435_aoHtl CA002R 2025-11-24T14:33:16.308Z 2025-12-01T15:22:15.934Z
8582046 8582046 20251123035407_2Gpss CA002R 2025-11-24T14:33:13.587Z 2025-12-01T15:22:14.896Z
8582001 8582001 20251123033417_sltFb CA002R 2025-11-24T14:33:02.932Z 2025-12-01T15:22:11.444Z
8581963 8581963 20251123032418_mxD2Q CA002R 2025-11-24T14:32:50.358Z 2025-12-01T15:22:05.266Z
8581946 8581946 20251123031403_bLpJr CA002R 2025-11-24T14:32:49.072Z 2025-12-01T15:22:03.362Z
8581945 8581945 20251123031302_BZvPv CA002R 2025-11-24T14:32:48.888Z 2025-12-01T15:22:02.822Z
8581903 8581903 20251123025940_HIDK0 CA002R 2025-11-24T14:32:45.997Z 2025-12-01T15:21:56.756Z
8581863 8581863 20251123024918_9bIbP CA002R 2025-11-24T14:32:42.256Z 2025-12-01T15:21:49.929Z
8581848 8581848 20251123024725_v9PH5 CA002R 2025-11-24T14:32:41.409Z 2025-12-01T15:21:45.801Z
8581835 8581835 20251123024348_2AqiV CA002R 2025-11-24T14:32:40.853Z 2025-12-01T15:21:44.748Z
8581810 8581810 20251123023522_2G3T4 CA002R 2025-11-24T14:32:39.496Z 2025-12-01T15:21:42.083Z
8581740 8581740 20251123020120_GTt5o CA002R 2025-11-24T14:32:35.422Z 2025-12-01T15:21:25.255Z
8581730 8581730 20251123015533_xZcv8 CA002R 2025-11-24T14:32:34.746Z 2025-12-01T15:21:20.466Z
8574447 8574447 20251122064420_6L2uj CA002R 2025-11-23T14:43:35.668Z 2025-11-30T15:07:09.333Z
8574428 8574428 20251122063831_W2SxZ CA002R 2025-11-23T14:43:34.389Z 2025-11-23T14:43:34.389Z
8574412 8574412 20251122063051_l3RyM CA002R 2025-11-23T14:43:33.435Z 2025-11-23T14:43:33.435Z
8574389 8574389 20251122061845_38RI2 CA002R 2025-11-23T14:43:23.299Z 2025-11-30T15:07:07.943Z
8574350 8574350 20251122055635_xvfwh CA002R 2025-11-23T14:43:08.381Z 2025-11-30T15:07:05.180Z
8569811 8569811 20251121061442_m0OKP CA002R 2025-11-23T14:32:29.526Z 2025-11-29T14:54:49.042Z
8568887 8568887 20251121054007_eT6fQ CA002R 2025-11-23T14:31:47.076Z 2025-11-29T14:54:47.561Z
8554589 8554589 20251120101508_jDEW0 CA002R 2025-11-22T14:35:36.010Z 2025-11-28T14:58:53.612Z
8554582 8554582 20251120101310_ZBpf7 CA002R 2025-11-22T14:35:34.913Z 2025-11-28T14:58:52.966Z
8554568 8554568 20251120100945_Jfosp CA002R 2025-11-22T14:35:34.580Z 2025-11-28T14:58:52.911Z
8554470 8554470 20251120095345_7WAw5 CA002R 2025-11-22T14:35:29.533Z 2025-11-28T14:58:51.624Z
8554345 8554345 20251120093336_SYjpw CA002R 2025-11-22T14:35:04.514Z 2025-11-28T14:58:49.642Z
8554302 8554302 20251120092242_c1CHZ CA002R 2025-11-22T14:34:59.931Z 2025-11-28T14:58:48.998Z
8554194 8554194 20251120085833_3Y8Lo CA002R 2025-11-22T14:34:51.104Z 2025-11-28T14:58:48.013Z
8554103 8554103 20251120082446_eypVU CA002R 2025-11-22T14:34:45.864Z 2025-11-28T14:58:46.389Z
8554066 8554066 20251120074409_vvVYE CA002R 2025-11-22T14:34:42.643Z 2025-11-28T14:58:45.438Z
8554060 8554060 20251120072650_J24Jp CA002R 2025-11-22T14:34:42.158Z 2025-11-28T14:58:45.251Z
8554050 8554050 20251120070000_bovCB CA002R 2025-11-22T14:34:41.180Z 2025-11-28T14:58:44.846Z
8552083 8552083 20251120033545_V2eXY CA002R 2025-11-22T14:31:46.276Z 2025-11-28T14:57:25.368Z
8551987 8551987 20251120032603_LQ5cq CA002R 2025-11-22T14:31:41.128Z 2025-11-28T14:57:19.467Z
8541816 8541816 20251120104918_1ovV2 CA002R 2025-11-22T14:00:29.416Z 2025-11-29T14:52:56.671Z
8541728 8541728 20251120103854_YST8k CA002R 2025-11-22T14:00:14.906Z 2025-11-29T14:52:52.380Z
8541726 8541726 20251120103818_VP0cI CA002R 2025-11-22T14:00:14.345Z 2025-11-29T14:52:52.332Z
8541278 8541278 20251120021047_SKlsK CA002R 2025-11-21T14:37:11.892Z 2025-11-21T14:37:11.892Z
8529525 8529525 20251119092317_6EDIT CA002R 2025-11-20T14:45:00.499Z 2025-11-27T15:13:32.088Z
8529492 8529492 20251119085627_bzp06 CA002R 2025-11-20T14:44:58.544Z 2025-11-27T15:13:30.934Z
8529449 8529449 20251119082210_80Cvh CA002R 2025-11-20T14:44:56.293Z 2025-11-27T15:13:30.026Z
8529448 8529448 20251119082051_CB9MQ CA002R 2025-11-20T14:44:56.152Z 2025-11-27T15:13:29.461Z
8529445 8529445 20251119082002_Ew2xM CA002R 2025-11-20T14:44:56.096Z 2025-11-27T15:13:29.452Z
8529441 8529441 20251119081724_9Gxi9 CA002R 2025-11-20T14:44:55.878Z 2025-11-27T15:13:29.418Z
8529418 8529418 20251119080234_nhq0u CA002R 2025-11-20T14:44:55.227Z 2025-11-20T14:44:55.227Z
8529375 8529375 20251119072225_wcjyh CA002R 2025-11-20T14:44:53.361Z 2025-11-20T14:44:53.361Z
8528809 8528809 20251119050930_yWIX5 CA002R 2025-11-20T14:43:54.147Z 2025-11-20T14:43:54.147Z
8528560 8528560 20251119043431_Na7Lu CA002R 2025-11-20T14:43:17.765Z 2025-11-27T15:13:07.255Z
8393668 8393668 20251107094806_mr2nv CA002R 2025-11-08T14:21:45.411Z 2025-11-15T15:00:55.591Z
8393534 8393534 20251107092703_0AiwD CA002R 2025-11-08T14:21:15.653Z 2025-11-15T15:00:54.136Z
8393379 8393379 20251107090556_aFCvr CA002R 2025-11-08T14:21:00.384Z 2025-11-15T15:00:52.995Z
8393318 8393318 20251107085704_nz8d4 CA002R 2025-11-08T14:20:54.639Z 2025-11-15T15:00:51.607Z
8393183 8393183 20251107083831_U3vXX CA002R 2025-11-08T14:20:25.356Z 2025-11-15T15:00:50.575Z
8393067 8393067 20251107081701_ymjE3 CA002R 2025-11-08T14:20:12.444Z 2025-11-15T15:00:49.526Z
8393034 8393034 20251107081102_rrmx5 CA002R 2025-11-08T14:19:56.257Z 2025-11-15T15:00:49.347Z
8392964 8392964 20251107075459_Qfwr8 CA002R 2025-11-08T14:19:43.022Z 2025-11-15T15:00:48.874Z
8392929 8392929 20251107074936_H9Mau CA002R 2025-11-08T14:19:38.775Z 2025-11-15T15:00:48.638Z
8392806 8392806 20251107071813_Q4eai CA002R 2025-11-08T14:19:25.103Z 2025-11-15T15:00:47.691Z
8392760 8392760 20251107070314_kM6a3 CA002R 2025-11-08T14:19:05.202Z 2025-11-15T15:00:47.248Z
8392665 8392665 20251107063542_Z5hBV CA002R 2025-11-08T14:18:54.188Z 2025-11-15T15:00:46.470Z
8392647 8392647 20251107062946_Q4Q22 CA002R 2025-11-08T14:18:50.672Z 2025-11-15T15:00:46.268Z
8392568 8392568 20251107060830_3imaD CA002R 2025-11-08T14:18:42.194Z 2025-11-15T15:00:45.705Z
8392545 8392545 20251107060641_FZnNC CA002R 2025-11-08T14:18:40.863Z 2025-11-15T15:00:45.667Z
8392364 8392364 20251107052416_ydtAd CA002R 2025-11-08T14:18:04.270Z 2025-11-15T15:00:44.502Z
8392329 8392329 20251107051640_oqjnR CA002R 2025-11-08T14:18:00.532Z 2025-11-15T15:00:44.248Z
8381643 8381643 20251105064739_UqPe7 CA002R 2025-11-06T14:15:43.990Z 2025-11-13T15:15:34.762Z
8381601 8381601 20251105061502_KG3Bh CA002R 2025-11-06T14:15:39.336Z 2025-11-13T15:15:34.350Z
8381547 8381547 20251105054826_OlPvn CA002R 2025-11-06T14:15:33.064Z 2025-11-13T15:15:32.284Z
8381524 8381524 20251105054418_4ojjz CA002R 2025-11-06T14:15:30.373Z 2025-11-13T15:15:31.745Z
8381510 8381510 20251105053754_p3ml5 CA002R 2025-11-06T14:15:28.916Z 2025-11-13T15:15:31.156Z
8381509 8381509 20251105053522_xm6zA CA002R 2025-11-06T14:15:28.536Z 2025-11-13T15:15:31.053Z

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