participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,480 rows where station_code = "CA002K" sorted by created_at descending
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 |
---|---|---|---|---|---|
3764543 | 3764543 | 20240105044729_E0ihG | CA002K | 2024-01-08T14:19:01.158Z | 2024-01-13T14:26:25.053Z |
3764495 | 3764495 | 20240105042922_EKM92 | CA002K | 2024-01-08T14:18:58.900Z | 2024-01-13T14:26:23.691Z |
3764318 | 3764318 | 20240105031600_3Vi9y | CA002K | 2024-01-08T14:18:49.314Z | 2024-01-13T14:26:21.772Z |
3764246 | 3764246 | 20240105024751_ZwSr4 | CA002K | 2024-01-08T14:18:42.989Z | 2024-01-13T14:26:21.219Z |
3759163 | 3759163 | 20240105093446_z4IMW | CA002K | 2024-01-08T14:08:51.217Z | 2024-01-14T14:23:03.399Z |
3759117 | 3759117 | 20240105091516_r02An | CA002K | 2024-01-08T14:08:46.735Z | 2024-01-14T14:23:02.836Z |
3758177 | 3758177 | 20240106110933_zzYOy | CA002K | 2024-01-08T14:06:23.805Z | 2024-01-15T14:23:59.656Z |
3758140 | 3758140 | 20240106110348_28P5v | CA002K | 2024-01-08T14:06:14.105Z | 2024-01-15T14:23:59.381Z |
3757480 | 3757480 | 20240106091329_I3b44 | CA002K | 2024-01-08T14:04:24.633Z | 2024-01-15T14:23:50.665Z |
3757371 | 3757371 | 20240106083042_K2LZf | CA002K | 2024-01-08T14:04:04.145Z | 2024-01-15T14:23:49.649Z |
3711230 | 3711230 | 20231223104215_WIGnM | CA002K | 2024-01-06T00:05:53.929Z | 2024-01-06T00:05:53.929Z |
3710748 | 3710748 | 20231223034556_hOuLo | CA002K | 2024-01-06T00:05:53.860Z | 2024-01-06T00:05:53.860Z |
3710518 | 3710518 | 20231223002517_a7ydO | CA002K | 2024-01-06T00:05:53.825Z | 2024-01-06T00:05:53.825Z |
3706710 | 3706710 | 20231222111552_XAQ5x | CA002K | 2024-01-06T00:05:53.471Z | 2024-01-06T00:05:53.471Z |
3706600 | 3706600 | 20231222104754_IzURA | CA002K | 2024-01-06T00:05:52.291Z | 2024-01-06T00:05:52.291Z |
3706540 | 3706540 | 20231222103600_1gxGd | CA002K | 2024-01-06T00:05:52.283Z | 2024-01-06T00:05:52.283Z |
3706493 | 3706493 | 20231222102733_PXjp1 | CA002K | 2024-01-06T00:05:52.278Z | 2024-01-06T00:05:52.278Z |
3706405 | 3706405 | 20231222101045_mknk4 | CA002K | 2024-01-06T00:05:52.268Z | 2024-01-06T00:05:52.268Z |
3706317 | 3706317 | 20231222095651_PFzDR | CA002K | 2024-01-06T00:05:52.256Z | 2024-01-06T00:05:52.256Z |
3706304 | 3706304 | 20231222095428_16sf0 | CA002K | 2024-01-06T00:05:52.254Z | 2024-01-06T00:05:52.254Z |
3706302 | 3706302 | 20231222095425_cMzfK | CA002K | 2024-01-06T00:05:52.253Z | 2024-01-06T00:05:52.253Z |
3706293 | 3706293 | 20231222094919_waTZ4 | CA002K | 2024-01-06T00:05:52.252Z | 2024-01-06T00:05:52.252Z |
3706282 | 3706282 | 20231222094635_vahTh | CA002K | 2024-01-06T00:05:52.250Z | 2024-01-06T00:05:52.250Z |
3706151 | 3706151 | 20231222092208_YmiNk | CA002K | 2024-01-06T00:05:52.231Z | 2024-01-06T00:05:52.231Z |
3704812 | 3704812 | 20231222001032_jSirH | CA002K | 2024-01-06T00:05:52.027Z | 2024-01-06T00:05:52.027Z |
3704766 | 3704766 | 20231221233010_bVeCu | CA002K | 2024-01-06T00:05:52.018Z | 2024-01-06T00:05:52.018Z |
3702096 | 3702096 | 20231221103856_2Hng3 | CA002K | 2024-01-06T00:05:50.138Z | 2024-01-06T00:05:50.138Z |
3702083 | 3702083 | 20231221103523_i4RVf | CA002K | 2024-01-06T00:05:50.135Z | 2024-01-06T00:05:50.135Z |
3702055 | 3702055 | 20231221103106_ewgHo | CA002K | 2024-01-06T00:05:50.127Z | 2024-01-06T00:05:50.127Z |
3701919 | 3701919 | 20231221095908_h2dRq | CA002K | 2024-01-06T00:05:50.077Z | 2024-01-06T00:05:50.077Z |
3701709 | 3701709 | 20231221090057_4i672 | CA002K | 2024-01-06T00:05:49.942Z | 2024-01-06T00:05:49.942Z |
3701636 | 3701636 | 20231221083753_i8PGL | CA002K | 2024-01-06T00:05:49.896Z | 2024-01-06T00:05:49.896Z |
3701416 | 3701416 | 20231221070224_dOH5Y | CA002K | 2024-01-06T00:05:49.778Z | 2024-01-06T00:05:49.778Z |
3701369 | 3701369 | 20231221063727_K3cSO | CA002K | 2024-01-06T00:05:49.747Z | 2024-01-06T00:05:49.747Z |
3701347 | 3701347 | 20231221062324_Mqy0B | CA002K | 2024-01-06T00:05:49.740Z | 2024-01-06T00:05:49.740Z |
3701329 | 3701329 | 20231221061706_IPuMj | CA002K | 2024-01-06T00:05:49.734Z | 2024-01-06T00:05:49.734Z |
3701167 | 3701167 | 20231221044801_ZK9P4 | CA002K | 2024-01-06T00:05:49.625Z | 2024-01-06T00:05:49.625Z |
3701146 | 3701146 | 20231221044403_YydQs | CA002K | 2024-01-06T00:05:49.615Z | 2024-01-06T00:05:49.615Z |
3701105 | 3701105 | 20231221042836_wbGS7 | CA002K | 2024-01-06T00:05:49.590Z | 2024-01-06T00:05:49.590Z |
3700879 | 3700879 | 20231221025119_cdAt5 | CA002K | 2024-01-06T00:05:49.461Z | 2024-01-06T00:05:49.461Z |
3697544 | 3697544 | 20231220103044_EotzI | CA002K | 2024-01-06T00:05:46.585Z | 2024-01-06T00:05:46.585Z |
3697259 | 3697259 | 20231220093346_ztN48 | CA002K | 2024-01-06T00:05:46.512Z | 2024-01-06T00:05:46.512Z |
3697198 | 3697198 | 20231220092119_Tdkot | CA002K | 2024-01-06T00:05:46.499Z | 2024-01-06T00:05:46.499Z |
3697016 | 3697016 | 20231220080652_EkJ4c | CA002K | 2024-01-06T00:05:46.428Z | 2024-01-06T00:05:46.428Z |
3696542 | 3696542 | 20231220054323_D74Ju | CA002K | 2024-01-06T00:05:46.114Z | 2024-01-06T00:05:46.114Z |
3696463 | 3696463 | 20231220052945_bRYqe | CA002K | 2024-01-06T00:05:46.061Z | 2024-01-06T00:05:46.061Z |
3669681 | 3669681 | 20231216110538_NxO5y | CA002K | 2024-01-06T00:05:34.213Z | 2024-01-06T00:05:34.213Z |
3669676 | 3669676 | 20231216110458_50lxm | CA002K | 2024-01-06T00:05:34.212Z | 2024-01-06T00:05:34.212Z |
3669294 | 3669294 | 20231216101513_2EZII | CA002K | 2024-01-06T00:05:34.171Z | 2024-01-06T00:05:34.171Z |
3669250 | 3669250 | 20231216100703_3Q6Kb | CA002K | 2024-01-06T00:05:34.166Z | 2024-01-06T00:05:34.166Z |
3669217 | 3669217 | 20231216100258_4WTMq | CA002K | 2024-01-06T00:05:34.162Z | 2024-01-06T00:05:34.162Z |
3669173 | 3669173 | 20231216095317_YWhZo | CA002K | 2024-01-06T00:05:34.157Z | 2024-01-06T00:05:34.157Z |
3669116 | 3669116 | 20231216094127_tqbgb | CA002K | 2024-01-06T00:05:34.149Z | 2024-01-06T00:05:34.149Z |
3669083 | 3669083 | 20231216093829_Qb6Fm | CA002K | 2024-01-06T00:05:34.146Z | 2024-01-06T00:05:34.146Z |
3668886 | 3668886 | 20231216090608_gXOlb | CA002K | 2024-01-06T00:05:34.125Z | 2024-01-06T00:05:34.125Z |
3668872 | 3668872 | 20231216090504_2Mok5 | CA002K | 2024-01-06T00:05:34.123Z | 2024-01-06T00:05:34.123Z |
3668860 | 3668860 | 20231216090204_KAlBF | CA002K | 2024-01-06T00:05:34.122Z | 2024-01-06T00:05:34.122Z |
3668730 | 3668730 | 20231216084025_1m28E | CA002K | 2024-01-06T00:05:34.107Z | 2024-01-06T00:05:34.107Z |
3668733 | 3668733 | 20231216084032_1Du7x | CA002K | 2024-01-06T00:05:34.107Z | 2024-01-06T00:05:34.107Z |
3668536 | 3668536 | 20231216080400_JkbzT | CA002K | 2024-01-06T00:05:34.085Z | 2024-01-06T00:05:34.085Z |
3668264 | 3668264 | 20231216072332_om354 | CA002K | 2024-01-06T00:05:34.058Z | 2024-01-06T00:05:34.058Z |
3659429 | 3659429 | 20231215101207_3uHUT | CA002K | 2024-01-06T00:05:31.628Z | 2024-01-06T00:05:31.628Z |
3659334 | 3659334 | 20231215100736_4I8Gd | CA002K | 2024-01-06T00:05:31.616Z | 2024-01-06T00:05:31.616Z |
3658964 | 3658964 | 20231215094238_nzlRe | CA002K | 2024-01-06T00:05:31.572Z | 2024-01-06T00:05:31.572Z |
3658678 | 3658678 | 20231215092724_nUgaQ | CA002K | 2024-01-06T00:05:31.442Z | 2024-01-06T00:05:31.442Z |
3658673 | 3658673 | 20231215092722_3P3Ah | CA002K | 2024-01-06T00:05:31.441Z | 2024-01-06T00:05:31.441Z |
3658492 | 3658492 | 20231215091713_rq3Zk | CA002K | 2024-01-06T00:05:31.418Z | 2024-01-06T00:05:31.418Z |
3658318 | 3658318 | 20231215090753_la1Xl | CA002K | 2024-01-06T00:05:31.397Z | 2024-01-06T00:05:31.397Z |
3658188 | 3658188 | 20231215085844_bH7tu | CA002K | 2024-01-06T00:05:31.381Z | 2024-01-06T00:05:31.381Z |
3657837 | 3657837 | 20231215083938_d73EN | CA002K | 2024-01-06T00:05:31.340Z | 2024-01-06T00:05:31.340Z |
3657230 | 3657230 | 20231215080953_ptOEk | CA002K | 2024-01-06T00:05:31.274Z | 2024-01-06T00:05:31.274Z |
3657176 | 3657176 | 20231215080756_PO1Rl | CA002K | 2024-01-06T00:05:31.269Z | 2024-01-06T00:05:31.269Z |
3657062 | 3657062 | 20231215080102_TtpvX | CA002K | 2024-01-06T00:05:31.256Z | 2024-01-06T00:05:31.256Z |
3656503 | 3656503 | 20231215073023_XdxN0 | CA002K | 2024-01-06T00:05:31.193Z | 2024-01-06T00:05:31.193Z |
3656282 | 3656282 | 20231215071528_kyzaT | CA002K | 2024-01-06T00:05:31.166Z | 2024-01-06T00:05:31.166Z |
3656198 | 3656198 | 20231215071127_KVvgc | CA002K | 2024-01-06T00:05:31.157Z | 2024-01-06T00:05:31.157Z |
3656187 | 3656187 | 20231215071052_Fjxqt | CA002K | 2024-01-06T00:05:31.155Z | 2024-01-06T00:05:31.155Z |
3655984 | 3655984 | 20231215065731_jCCzL | CA002K | 2024-01-06T00:05:31.131Z | 2024-01-06T00:05:31.131Z |
3655936 | 3655936 | 20231215065412_Dukzm | CA002K | 2024-01-06T00:05:31.124Z | 2024-01-06T00:05:31.124Z |
3655795 | 3655795 | 20231215064815_pWNxD | CA002K | 2024-01-06T00:05:31.107Z | 2024-01-06T00:05:31.107Z |
3655777 | 3655777 | 20231215064724_vUipl | CA002K | 2024-01-06T00:05:31.105Z | 2024-01-06T00:05:31.105Z |
3655575 | 3655575 | 20231215063837_RY0Ts | CA002K | 2024-01-06T00:05:31.082Z | 2024-01-06T00:05:31.082Z |
3655400 | 3655400 | 20231215063116_QzVTd | CA002K | 2024-01-06T00:05:31.059Z | 2024-01-06T00:05:31.059Z |
3654886 | 3654886 | 20231215060933_8VJcF | CA002K | 2024-01-06T00:05:30.998Z | 2024-01-06T00:05:30.998Z |
3654801 | 3654801 | 20231215060645_x97X2 | CA002K | 2024-01-06T00:05:30.987Z | 2024-01-06T00:05:30.987Z |
3654521 | 3654521 | 20231215055718_b3RSb | CA002K | 2024-01-06T00:05:30.952Z | 2024-01-06T00:05:30.952Z |
3654226 | 3654226 | 20231215054430_SMRMf | CA002K | 2024-01-06T00:05:30.918Z | 2024-01-06T00:05:30.918Z |
3654218 | 3654218 | 20231215054416_5F4dn | CA002K | 2024-01-06T00:05:30.917Z | 2024-01-06T00:05:30.917Z |
3654194 | 3654194 | 20231215054341_nEbKf | CA002K | 2024-01-06T00:05:30.914Z | 2024-01-06T00:05:30.914Z |
3654135 | 3654135 | 20231215054115_qpnr2 | CA002K | 2024-01-06T00:05:30.906Z | 2024-01-06T00:05:30.906Z |
3653906 | 3653906 | 20231215053130_0INON | CA002K | 2024-01-06T00:05:30.876Z | 2024-01-06T00:05:30.876Z |
3653794 | 3653794 | 20231215052729_6EBYd | CA002K | 2024-01-06T00:05:30.862Z | 2024-01-06T00:05:30.862Z |
3653026 | 3653026 | 20231215045400_T2ZRk | CA002K | 2024-01-06T00:05:30.760Z | 2024-01-06T00:05:30.760Z |
3652953 | 3652953 | 20231215045144_1vPg5 | CA002K | 2024-01-06T00:05:30.751Z | 2024-01-06T00:05:30.751Z |
3652907 | 3652907 | 20231215045023_x46w8 | CA002K | 2024-01-06T00:05:30.744Z | 2024-01-06T00:05:30.744Z |
3652897 | 3652897 | 20231215045001_LIbsb | CA002K | 2024-01-06T00:05:30.743Z | 2024-01-06T00:05:30.743Z |
3652859 | 3652859 | 20231215044702_crcS2 | CA002K | 2024-01-06T00:05:30.738Z | 2024-01-06T00:05:30.738Z |
3652708 | 3652708 | 20231215043925_fZAr0 | CA002K | 2024-01-06T00:05:30.718Z | 2024-01-06T00:05:30.718Z |
3652647 | 3652647 | 20231215043648_QjUr5 | CA002K | 2024-01-06T00:05:30.710Z | 2024-01-06T00:05:30.710Z |
3652571 | 3652571 | 20231215043319_RbPgY | CA002K | 2024-01-06T00:05:30.699Z | 2024-01-06T00:05:30.699Z |
Advanced export
JSON shape: default, array, newline-delimited
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);