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

4,523 rows where station_code = "CA002L" 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
9268528 9268528 20260128104135_uiRuj CA002L 2026-01-29T14:03:29.918Z 2026-01-29T14:03:29.918Z
9268497 9268497 20260128103118_f5MAr CA002L 2026-01-29T14:03:23.602Z 2026-01-29T14:03:23.602Z
9268426 9268426 20260128101414_bfEh2 CA002L 2026-01-29T14:02:55.505Z 2026-01-29T14:02:55.505Z
9256569 9256569 20260125085531_agfFb CA002L 2026-01-26T14:00:36.967Z 2026-01-29T14:36:09.128Z
9223392 9223392 20260118003011_qfdju CA002L 2026-01-19T14:19:01.527Z 2026-01-26T15:02:04.973Z
9219425 9219425 20260117102750_vh9xp CA002L 2026-01-18T14:16:23.420Z 2026-01-25T14:59:27.004Z
9219387 9219387 20260117101733_yLKWe CA002L 2026-01-18T14:16:14.155Z 2026-01-25T14:59:25.927Z
9219385 9219385 20260117101550_3gutA CA002L 2026-01-18T14:16:13.556Z 2026-01-25T14:59:25.854Z
9219295 9219295 20260117095137_xm8H1 CA002L 2026-01-18T14:15:50.249Z 2026-01-25T14:59:09.504Z
9219251 9219251 20260117093940_MRRO1 CA002L 2026-01-18T14:15:40.250Z 2026-01-25T14:59:08.669Z
9218978 9218978 20260117065103_3Dj7y CA002L 2026-01-18T14:14:28.510Z 2026-01-25T14:58:57.199Z
9218971 9218971 20260117064823_szlG2 CA002L 2026-01-18T14:14:26.657Z 2026-01-25T14:58:57.005Z
9218867 9218867 20260117061445_p3gZs CA002L 2026-01-18T14:14:01.923Z 2026-01-25T14:58:54.154Z
9218757 9218757 20260117053741_q2pZo CA002L 2026-01-18T14:13:34.197Z 2026-01-25T14:58:38.268Z
9218093 9218093 20260116234332_tEX12 CA002L 2026-01-18T14:10:25.187Z 2026-01-25T14:57:58.692Z
9088175 9088175 20251228112059_39lAP CA002L 2025-12-30T14:45:45.066Z 2026-01-05T15:11:41.768Z
9088071 9088071 20251228111120_Zrn7q CA002L 2025-12-30T14:45:34.130Z 2026-01-05T15:11:39.455Z
9088069 9088069 20251228111028_YaCSX CA002L 2025-12-30T14:45:33.881Z 2026-01-05T15:11:39.329Z
9087848 9087848 20251228104002_4CVey CA002L 2025-12-30T14:45:03.378Z 2026-01-05T15:11:32.423Z
9087770 9087770 20251228103020_N5aOj CA002L 2025-12-30T14:44:54.227Z 2026-01-05T15:11:29.776Z
9087745 9087745 20251228102511_G3oAr CA002L 2025-12-30T14:44:51.533Z 2026-01-05T15:11:28.916Z
9087402 9087402 20251228091314_NBvVg CA002L 2025-12-30T14:43:53.556Z 2026-01-05T15:11:04.863Z
9087351 9087351 20251228085828_MV5u2 CA002L 2025-12-30T14:43:46.823Z 2026-01-05T15:11:02.676Z
9087340 9087340 20251228085526_w0PlV CA002L 2025-12-30T14:43:45.642Z 2026-01-05T15:11:02.401Z
9087326 9087326 20251228084822_TWEOI CA002L 2025-12-30T14:43:43.788Z 2026-01-05T15:11:01.655Z
9087310 9087310 20251228084000_Lr2qR CA002L 2025-12-30T14:43:41.588Z 2026-01-05T15:11:01.166Z
9087284 9087284 20251228082952_szQ5i CA002L 2025-12-30T14:43:37.742Z 2026-01-05T15:11:00.022Z
9087224 9087224 20251228075820_xVO3I CA002L 2025-12-30T14:43:30.123Z 2026-01-05T15:10:57.530Z
9087219 9087219 20251228075037_XQ4Kf CA002L 2025-12-30T14:43:22.381Z 2026-01-05T15:10:57.217Z
9087190 9087190 20251228073244_mBAm0 CA002L 2025-12-30T14:43:16.630Z 2026-01-05T15:10:56.031Z
9087108 9087108 20251228070346_kyuhn CA002L 2025-12-30T14:43:04.626Z 2026-01-05T15:10:53.273Z
9087093 9087093 20251228070031_xEs4c CA002L 2025-12-30T14:43:02.713Z 2026-01-05T15:10:52.648Z
9087086 9087086 20251228065933_jErQa CA002L 2025-12-30T14:43:01.549Z 2026-01-05T15:10:52.310Z
9087049 9087049 20251228065324_oo3zu CA002L 2025-12-30T14:42:56.248Z 2026-01-05T15:10:50.841Z
9087029 9087029 20251228064649_eUOYI CA002L 2025-12-30T14:42:52.740Z 2026-01-05T15:10:50.215Z
9086989 9086989 20251228063812_2B3ic CA002L 2025-12-30T14:42:39.470Z 2026-01-05T15:10:48.854Z
9086974 9086974 20251228063455_SlRZU CA002L 2025-12-30T14:42:36.150Z 2026-01-05T15:10:48.141Z
9086824 9086824 20251228054509_UEFd1 CA002L 2025-12-30T14:42:10.251Z 2026-01-05T15:10:33.247Z
9086643 9086643 20251228052211_9RoDG CA002L 2025-12-30T14:41:40.069Z 2026-01-05T15:10:25.623Z
9086534 9086534 20251228050957_puE0y CA002L 2025-12-30T14:41:25.439Z 2026-01-05T15:10:21.404Z
9086423 9086423 20251228045525_8f46b CA002L 2025-12-30T14:41:02.662Z 2026-01-05T15:10:18.188Z
9086257 9086257 20251228044202_t3lea CA002L 2025-12-30T14:40:45.412Z 2026-01-05T15:10:06.471Z
9086208 9086208 20251228043623_jglM2 CA002L 2025-12-30T14:40:32.141Z 2026-01-05T15:09:59.654Z
9085575 9085575 20251228033923_35f1D CA002L 2025-12-30T14:38:57.631Z 2026-01-05T15:09:38.249Z
9085204 9085204 20251228030352_EzxSP CA002L 2025-12-30T14:37:57.573Z 2026-01-05T15:09:15.968Z
9084835 9084835 20251228022510_XIlGn CA002L 2025-12-30T14:36:54.481Z 2026-01-05T15:09:05.516Z
9084550 9084550 20251228015424_CJLQC CA002L 2025-12-30T14:36:06.902Z 2026-01-05T15:08:46.720Z
9044756 9044756 20251223053113_RJhZP CA002L 2025-12-28T14:52:27.848Z 2025-12-31T15:42:39.793Z
8988478 8988478 20251218102459_sBI2o CA002L 2025-12-26T14:42:26.759Z 2025-12-27T15:21:47.271Z
8988325 8988325 20251218101146_dtqLY CA002L 2025-12-26T14:42:06.693Z 2025-12-27T15:21:36.852Z
8988036 8988036 20251218094440_CORCN CA002L 2025-12-26T14:41:29.928Z 2025-12-27T15:21:12.939Z
8987350 8987350 20251218081257_0Z2Ry CA002L 2025-12-26T14:40:05.692Z 2025-12-27T15:20:18.156Z
8694978 8694978 20251207082749_0D6b1 CA002L 2025-12-08T14:02:11.560Z 2025-12-16T15:09:42.614Z
8694971 8694971 20251207082439_f2ReG CA002L 2025-12-08T14:02:10.174Z 2025-12-16T15:09:42.481Z
8694838 8694838 20251207073156_0yb5s CA002L 2025-12-08T14:01:33.226Z 2025-12-16T15:09:40.110Z
8694691 8694691 20251207061949_1qkQG CA002L 2025-12-08T14:00:56.275Z 2025-12-16T15:09:37.467Z
8694619 8694619 20251207060002_Fatnh CA002L 2025-12-08T14:00:31.458Z 2025-12-16T15:09:29.464Z
8683281 8683281 20251203065107_biiQc CA002L 2025-12-04T14:19:04.069Z 2025-12-11T14:47:36.169Z
8677435 8677435 20251203095833_dDwoF CA002L 2025-12-04T14:01:14.339Z 2025-12-11T14:39:34.323Z
8677412 8677412 20251203094219_lq7JL CA002L 2025-12-04T14:01:07.164Z 2025-12-11T14:39:29.770Z
8677379 8677379 20251203092910_DUDUc CA002L 2025-12-04T14:00:58.752Z 2025-12-11T14:39:28.184Z
8677369 8677369 20251203092122_FKUsP CA002L 2025-12-04T14:00:56.321Z 2025-12-11T14:39:27.830Z
8677343 8677343 20251203085828_CwOjF CA002L 2025-12-04T14:00:50.849Z 2025-12-11T14:39:26.858Z
8677222 8677222 20251203072728_cGbGC CA002L 2025-12-04T14:00:24.229Z 2025-12-11T14:39:19.205Z
8583041 8583041 20251123094816_Brq2S CA002L 2025-11-24T14:34:46.952Z 2025-12-01T15:22:31.116Z
8582774 8582774 20251123082652_CVFnn CA002L 2025-11-24T14:34:30.074Z 2025-12-01T15:22:27.825Z
8582221 8582221 20251123044632_O65a5 CA002L 2025-11-24T14:33:23.506Z 2025-12-01T15:22:19.012Z
8581986 8581986 20251123033045_MLcnw CA002L 2025-11-24T14:32:57.291Z 2025-12-01T15:22:09.304Z
8581650 8581650 20251123013020_EW3jK CA002L 2025-11-24T14:32:29.699Z 2025-12-01T15:21:11.553Z
8581641 8581641 20251123012432_91YAr CA002L 2025-11-24T14:32:21.745Z 2025-12-01T15:21:11.085Z
8554588 8554588 20251120101508_jDEW0 CA002L 2025-11-22T14:35:36.010Z 2025-11-28T14:58:53.612Z
8554581 8554581 20251120101310_ZBpf7 CA002L 2025-11-22T14:35:34.913Z 2025-11-28T14:58:52.966Z
8554567 8554567 20251120100945_Jfosp CA002L 2025-11-22T14:35:34.580Z 2025-11-28T14:58:52.911Z
8554193 8554193 20251120085833_3Y8Lo CA002L 2025-11-22T14:34:51.104Z 2025-11-28T14:58:48.013Z
8554065 8554065 20251120074409_vvVYE CA002L 2025-11-22T14:34:42.643Z 2025-11-28T14:58:45.438Z
8554049 8554049 20251120070000_bovCB CA002L 2025-11-22T14:34:41.180Z 2025-11-28T14:58:44.846Z
8553413 8553413 20251120053300_R9uD8 CA002L 2025-11-22T14:33:56.434Z 2025-11-28T14:58:05.924Z
8541725 8541725 20251120103818_VP0cI CA002L 2025-11-22T14:00:14.325Z 2025-11-29T14:52:52.332Z
8529568 8529568 20251119094911_kIET4 CA002L 2025-11-20T14:45:04.054Z 2025-11-27T15:13:33.402Z
8529460 8529460 20251119083529_6zc7Z CA002L 2025-11-20T14:44:56.902Z 2025-11-27T15:13:30.087Z
8528028 8528028 20251119031915_kO8UJ CA002L 2025-11-20T14:42:04.325Z 2025-11-27T15:12:46.353Z
8375912 8375912 20251103092158_V3Eir CA002L 2025-11-05T14:35:38.932Z 2025-11-11T15:08:22.800Z
8325970 8325970 20251030084801_u86fI CA002L 2025-11-01T12:35:04.470Z 2025-11-07T15:17:35.879Z
8325385 8325385 20251030074102_nvS4q CA002L 2025-11-01T12:34:07.306Z 2025-11-07T15:17:21.518Z
8325245 8325245 20251030072727_C5hnh CA002L 2025-11-01T12:33:33.708Z 2025-11-07T15:17:19.684Z
8322907 8322907 20251030043025_cpqLG CA002L 2025-11-01T12:30:06.893Z 2025-11-07T15:15:50.020Z
8313042 8313042 20251029234904_ezvqM CA002L 2025-10-31T12:37:21.122Z 2025-11-07T15:12:26.064Z
8312787 8312787 20251029233007_F6WWk CA002L 2025-10-31T12:36:57.990Z 2025-11-07T15:12:14.989Z
8306314 8306314 20251029075224_pJGsA CA002L 2025-10-31T12:24:58.130Z 2025-11-06T15:15:03.093Z
8300736 8300736 20251029100730_GpsI0 CA002L 2025-10-30T12:54:04.454Z 2025-11-06T15:15:44.610Z
8300715 8300715 20251029094550_ZNgD9 CA002L 2025-10-30T12:54:02.672Z 2025-11-06T15:15:37.208Z
8300709 8300709 20251029094225_Ij7Vq CA002L 2025-10-30T12:54:02.171Z 2025-10-30T12:54:02.171Z
8300702 8300702 20251029093626_230Bt CA002L 2025-10-30T12:54:01.988Z 2025-10-30T12:54:01.988Z
8300700 8300700 20251029093509_mMGw9 CA002L 2025-10-30T12:54:01.866Z 2025-11-06T15:15:33.308Z
8300687 8300687 20251029092645_CJ5nk CA002L 2025-10-30T12:54:01.777Z 2025-11-06T15:15:26.949Z
8300685 8300685 20251029092429_26iC0 CA002L 2025-10-30T12:54:01.732Z 2025-11-06T15:15:26.718Z
8300681 8300681 20251029091814_A39TU CA002L 2025-10-30T12:54:01.526Z 2025-11-06T15:15:25.969Z
8300676 8300676 20251029091447_VzRJp CA002L 2025-10-30T12:54:01.339Z 2025-11-06T15:15:25.842Z
8300657 8300657 20251029085630_l491i CA002L 2025-10-30T12:54:00.863Z 2025-11-06T15:15:20.601Z
8300645 8300645 20251029084606_qrlDI CA002L 2025-10-30T12:54:00.431Z 2025-11-06T15:15:18.535Z

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