Honkai Star Rail Character Dataset

Exploring the Characters of Honkai Star Rail in Patch 1.3

@kaggle.ridhopandhu_honkai_star_rail_character_data

Table List

1 table(38.33 KB)

Hsr Character Data

@kaggle.ridhopandhu_honkai_star_rail_character_data.hsr_character_data

38.33 KB
33 rows
51 columns

character Character	rarity Rarity	path Path	combat_type Combat Type	wb_b_atk Wb B-atk	wb_skill Wb Skill	wb_ult Wb Ult	er_b_atk Er B-atk	er_skill Er Skill	er_ult Er Ult	spd Spd	crit_r Crit-r	crit_d Crit-d	taunt Taunt	max_energy Max Energy	atk_80 Atk 80	def_80 Def 80	hp_80 Hp 80	atk_70a Atk 70a	def_70a Def 70a	hp_70a Hp 70a	atk_70 Atk 70	def_70 Def 70	hp_70 Hp 70	atk_60a Atk 60a	def_60a Def 60a	hp_60a Hp 60a	atk_60 Atk 60	def_60 Def 60	hp_60 Hp 60	atk_50a Atk 50a	def_50a Def 50a	hp_50a Hp 50a	atk_50 Atk 50	def_50 Def 50	hp_50 Hp 50	atk_40a Atk 40a	def_40a Def 40a	hp_40a Hp 40a	atk_40 Atk 40	def_40 Def 40	hp_40 Hp 40	atk_20a Atk 20a	def_20a Def 20a	hp_20a Hp 20a	atk_20 Atk 20	def_20 Def 20	hp_20 Hp 20	atk_1 Atk 1	def_1 Def 1	hp_1 Hp 1
march_7th	4	preservation	ice	30		60	20	30	5	101	0.05	0.5	150	120	511.56	573.3	1058	476.76	534.3	986	448.92	503.1	929	414.12	464.1	857	386.28	432.9	799	351.48	393.9	727	323.64	362.7	670	288.84	323.7	598	261	292.5	540	163.56	183.3	338	135.72	152.1	281	69.6	78	144
dan_heng	4	hunt	wind	30	60	90	20	30	5	110	0.05	0.5	75	100	546.84	396.9	882	509.64	369.9	822	479.88	348.3	774	442.68	321.3	714	412.92	299.7	666	375.72	272.7	606	345.96	251.1	558	308.76	224.1	498	279	202.5	450	174.84	126.9	282	145.08	105.3	234	74.4	54	120
himeko	5	erudition	fire	30	60	60	20	10	5	96	0.05	0.5	75	120	756.76	436.59	1048	705.28	406.89	977	664.09	383.13	920	612.61	353.43	848	571.43	329.67	791	519.95	299.97	720	478.76	276.21	663	427.28	246.51	592	386.1	222.75	535	241.96	139.59	335	200.77	115.83	278	102.96	59.4	143
welt	5	nihility	imaginary	30	30	60	20	30	5	102	0.05	0.5	100	120	620.93	509.36	1125.43	578.69	474.71	1049	544.9	446.99	988	502.66	412.34	911	468.86	384.62	850	426.62	349.97	773	392.83	322.25	712	350.59	287.6	635	316.8	259.88	574	198.53	162.86	360	164.74	135.14	299	84.48	69.3	153
kafka	5	nihility	lightning	30	60	60	20	30	5	100	0.05	0.5	100	120	679.14	485.1	1086.62	632.94	452.1	1013	595.98	425.7	954	549.78	392.7	880	512.82	366.3	821	466.62	333.3	747	429.66	306.9	687	383.46	273.9	614	346.5	247.5	554	217.14	155.1	347	180.18	128.7	288	92.4	66	148
silver_wolf	5	nihility	quantum	30	60	90	20	30	5	107	0.05	0.5	100	110	640.33	460.84	1047.82	596.77	429.49	977	561.92	404.41	920	518.36	373.06	848	483.52	347.98	791	439.96	316.63	720	405.11	291.55	663	361.55	260.2	592	326.7	235.12	535	204.73	147.34	335	169.88	122.26	278	87.12	62.7	143
arlan	4	destruction	lightning	30	60	60	20	30	5	102	0.05	0.5	125	110	599.76	330.75	1199.52	558.96	308.25	1118	526.32	290.25	1053	485.52	267.75	971	452.88	249.75	906	412.08	227.25	824	379.44	209.25	759	338.64	186.75	677	306	168.75	612	191.76	105.75	384	159.12	87.75	318	81.6	45	163
asta	4	harmony	fire	30	30		20	6	5	106	0.05	0.5	100	120	511.56	463.05	1023	476.76	431.55	954	448.92	406.35	898	414.12	374.85	828	386.28	349.65	773	351.48	318.15	703	323.64	292.95	647	288.84	261.45	578	261	236.25	522	163.56	148.05	327	135.72	122.85	271	69.6	63	139
herta	4	erudition	ice	30	30	60	20	30	5	100	0.05	0.5	75	110	582.12	396.9	953	542.52	369.9	888	510.84	348.3	836	471.24	321.3	771	439.56	299.7	719	399.96	272.7	654	368.28	251.1	603	328.68	224.1	538	297	202.5	486	186.12	126.9	305	154.44	105.3	253	79.2	54	130
bronya	5	harmony	wind	30			20	30	5	99	0.05	0.5	100	120	582.12	533.61	1242	542.52	497.31	1157	510.84	468.27	1090	471.24	431.97	1005	439.56	402.93	938	399.96	366.63	853	368.28	337.59	786	328.68	301.29	701	297	272.25	634	186.12	170.61	397	154.44	141.57	329	79.2	72.6	169


CREATE TABLE hsr_character_data (
  "character" VARCHAR,
  "rarity" BIGINT,
  "path" VARCHAR,
  "combat_type" VARCHAR,
  "wb_b_atk" BIGINT,
  "wb_skill" BIGINT,
  "wb_ult" BIGINT,
  "er_b_atk" BIGINT,
  "er_skill" BIGINT,
  "er_ult" BIGINT,
  "spd" BIGINT,
  "crit_r" DOUBLE,
  "crit_d" DOUBLE,
  "taunt" BIGINT,
  "max_energy" BIGINT,
  "atk_80" DOUBLE,
  "def_80" DOUBLE,
  "hp_80" DOUBLE,
  "atk_70a" DOUBLE,
  "def_70a" DOUBLE,
  "hp_70a" BIGINT,
  "atk_70" DOUBLE,
  "def_70" DOUBLE,
  "hp_70" BIGINT,
  "atk_60a" DOUBLE,
  "def_60a" DOUBLE,
  "hp_60a" BIGINT,
  "atk_60" DOUBLE,
  "def_60" DOUBLE,
  "hp_60" BIGINT,
  "atk_50a" DOUBLE,
  "def_50a" DOUBLE,
  "hp_50a" BIGINT,
  "atk_50" DOUBLE,
  "def_50" DOUBLE,
  "hp_50" BIGINT,
  "atk_40a" DOUBLE,
  "def_40a" DOUBLE,
  "hp_40a" BIGINT,
  "atk_40" DOUBLE,
  "def_40" DOUBLE,
  "hp_40" BIGINT,
  "atk_20a" DOUBLE,
  "def_20a" DOUBLE,
  "hp_20a" BIGINT,
  "atk_20" DOUBLE,
  "def_20" DOUBLE,
  "hp_20" BIGINT,
  "atk_1" DOUBLE,
  "def_1" DOUBLE,
  "hp_1" BIGINT
);