home / japari_dc_bot

attacks

163 rows where member_id = 651819395059810306

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: battle_day, lap, boss_number, is_residual, attack_datetime (date)

attack_id ▼ member_id attack_datetime battle_day lap boss_number is_residual damage notes related_full_attack_id
90 651819395059810306 651819395059810306 2025-06-26T15:15:34.416558+00:00 1 23 5 0 207356347    
91 651819395059810306 651819395059810306 2025-06-26T15:16:02.038788+00:00 1 23 5 0 14439137    
92 651819395059810306 651819395059810306 2025-06-26T15:31:07.835504+00:00 1 24 5 1 204333193    
97 651819395059810306 651819395059810306 2025-06-26T15:56:18.607352+00:00 1 23 4 0 125604800    
101 651819395059810306 651819395059810306 2025-06-26T16:08:47.959413+00:00 2 23 4 0 215175996    
103 651819395059810306 651819395059810306 2025-06-26T16:31:51.626948+00:00 2 23 1 0 180714660    
104 651819395059810306 651819395059810306 2025-06-26T16:38:08.019501+00:00 2 24 3 1 58710102    
107 651819395059810306 651819395059810306 2025-06-26T16:49:15.202414+00:00 2 24 3 0 163200188    
152 651819395059810306 651819395059810306 2025-06-27T14:00:35.620396+00:00 2 26 1 0 179819838    
154 651819395059810306 651819395059810306 2025-06-27T14:13:25.108913+00:00 2 26 1 0 180380543    
157 651819395059810306 651819395059810306 2025-06-27T14:45:36.921312+00:00 2 26 4 0 214742047    
158 651819395059810306 651819395059810306 2025-06-27T14:45:55.431014+00:00 2 26 4 0 72583142    
159 651819395059810306 651819395059810306 2025-06-27T14:52:17.939369+00:00 2 27 4 1 145098192    
161 651819395059810306 651819395059810306 2025-06-27T14:58:52.410622+00:00 2 26 3 0 65015492    
162 651819395059810306 651819395059810306 2025-06-27T15:08:21.514427+00:00 2 27 3 1 109422934    
163 651819395059810306 651819395059810306 2025-06-27T15:13:40.310188+00:00 2 27 3 0 168549560    
253 651819395059810306 651819395059810306 2025-06-28T13:43:24.153200+00:00 3 30 4 0 19401880    
254 651819395059810306 651819395059810306 2025-06-28T13:50:42.259215+00:00 3 31 4 1 214434920    
255 651819395059810306 651819395059810306 2025-06-28T14:01:28.862119+00:00 3 31 4 0 213559869    
258 651819395059810306 651819395059810306 2025-06-28T14:19:27.942493+00:00 3 31 1 0 179476873    
259 651819395059810306 651819395059810306 2025-06-28T14:19:43.738532+00:00 3 31 1 0 42505537    
262 651819395059810306 651819395059810306 2025-06-28T14:26:01.176385+00:00 3 32 1 1 176950999    
264 651819395059810306 651819395059810306 2025-06-28T14:33:25.682648+00:00 3 31 3 0 169498032    
265 651819395059810306 651819395059810306 2025-06-28T14:34:23.279460+00:00 3 31 3 0 168974362    
316 651819395059810306 651819395059810306 2025-06-29T10:14:12.582084+00:00 4 34 1 0 38598292    
317 651819395059810306 651819395059810306 2025-06-29T10:20:34.985221+00:00 4 35 1 1 135132828    
320 651819395059810306 651819395059810306 2025-06-29T10:26:25.600369+00:00 4 35 1 0 178909863    
322 651819395059810306 651819395059810306 2025-06-29T10:37:29.917921+00:00 4 34 3 0 167397104    
323 651819395059810306 651819395059810306 2025-06-29T10:37:43.761574+00:00 4 34 3 0 64323232    
324 651819395059810306 651819395059810306 2025-06-29T10:41:31.025881+00:00 4 35 3 1 121362339    
330 651819395059810306 651819395059810306 2025-06-29T11:20:55.827879+00:00 4 34 5 0 172370947    
331 651819395059810306 651819395059810306 2025-06-29T11:21:06.408697+00:00 4 34 5 0 138194958    
341 651819395059810306 651819395059810306 2025-06-29T12:52:05.095778+00:00 4 36 5 1 20169342    
430 651819395059810306 651819395059810306 2025-06-30T13:01:18.477234+00:00 5 40 4 0 199851527    
432 651819395059810306 651819395059810306 2025-06-30T13:10:08.279707+00:00 5 39 3 0 170971636    
433 651819395059810306 651819395059810306 2025-06-30T13:10:30.299399+00:00 5 39 3 0 8939183    
434 651819395059810306 651819395059810306 2025-06-30T13:14:28.180648+00:00 5 40 3 1 170757569    
437 651819395059810306 651819395059810306 2025-06-30T13:27:27.817678+00:00 5 40 1 0 76017309    
438 651819395059810306 651819395059810306 2025-06-30T13:32:26.470037+00:00 5 41 1 1 127097005    
439 651819395059810306 651819395059810306 2025-06-30T13:39:37.451415+00:00 5 41 4 0 193342744    
440 651819395059810306 651819395059810306 2025-06-30T13:46:24.684833+00:00 5 40 3 1 43386005    
441 651819395059810306 651819395059810306 2025-06-30T13:50:20.400950+00:00 5 40 3 1 43632761    
442 651819395059810306 651819395059810306 2025-06-30T13:56:43.518017+00:00 5 41 5 0 171532620    
622 651819395059810306 651819395059810306 2025-07-27T14:16:09.001268+00:00 1 23 5 0 296972407    
623 651819395059810306 651819395059810306 2025-07-27T14:25:26.694262+00:00 1 23 5 0 303546693    
636 651819395059810306 651819395059810306 2025-07-27T15:31:18.301641+00:00 1 23 4 0 239189391    
637 651819395059810306 651819395059810306 2025-07-27T15:31:40.437719+00:00 1 23 4 0 234391729    
645 651819395059810306 651819395059810306 2025-07-27T16:02:19.521193+00:00 1 23 3 0 260916425    
646 651819395059810306 651819395059810306 2025-07-27T16:02:34.099927+00:00 1 23 3 0 63285719    
649 651819395059810306 651819395059810306 2025-07-27T16:08:11.280769+00:00 1 24 3 1 251029499    
719 651819395059810306 651819395059810306 2025-07-28T14:09:56.710423+00:00 2 26 5 0 295680375    
726 651819395059810306 651819395059810306 2025-07-28T14:30:01.793969+00:00 2 27 2 0 66501598    
727 651819395059810306 651819395059810306 2025-07-28T14:33:49.055821+00:00 2 26 3 0 262468204    
738 651819395059810306 651819395059810306 2025-07-28T15:02:16.884096+00:00 2 28 2 1 341792006    
739 651819395059810306 651819395059810306 2025-07-28T15:11:48.185944+00:00 2 27 3 0 262442693    
741 651819395059810306 651819395059810306 2025-07-28T15:17:31.375937+00:00 2 27 4 0 241482177    
746 651819395059810306 651819395059810306 2025-07-28T15:30:10.581885+00:00 2 27 5 0 302427895    
835 651819395059810306 651819395059810306 2025-07-29T13:29:31.553086+00:00 3 31 5 0 296785616    
837 651819395059810306 651819395059810306 2025-07-29T13:38:34.976441+00:00 3 32 5 0 302109399    
841 651819395059810306 651819395059810306 2025-07-29T13:47:12.259319+00:00 3 31 4 0 240371196    
843 651819395059810306 651819395059810306 2025-07-29T14:00:05.805284+00:00 3 31 2 0 341638932    
844 651819395059810306 651819395059810306 2025-07-29T14:00:19.952790+00:00 3 31 2 0 23242069    
845 651819395059810306 651819395059810306 2025-07-29T14:07:31.607325+00:00 3 32 2 1 345991006    
852 651819395059810306 651819395059810306 2025-07-29T14:20:07.401979+00:00 3 31 4 0 241078381    
857 651819395059810306 651819395059810306 2025-07-29T14:47:49.232577+00:00 3 32 1 0 20416883    
945 651819395059810306 651819395059810306 2025-07-30T13:12:06.872368+00:00 4 35 5 0 305271665    
946 651819395059810306 651819395059810306 2025-07-30T13:12:14.918235+00:00 4 35 5 0 31760589    
948 651819395059810306 651819395059810306 2025-07-30T13:17:37.082119+00:00 4 36 5 1 303050311    
950 651819395059810306 651819395059810306 2025-07-30T13:26:29.717288+00:00 4 35 4 0 244018225    
951 651819395059810306 651819395059810306 2025-07-30T13:26:39.224468+00:00 4 35 4 0 185535507    
952 651819395059810306 651819395059810306 2025-07-30T13:37:35.883443+00:00 4 35 2 0 262483775    
958 651819395059810306 651819395059810306 2025-07-30T13:44:19.181044+00:00 4 36 3 0 262473841    
960 651819395059810306 651819395059810306 2025-07-30T13:49:39.622932+00:00 4 36 1 1 82637854    
1076 651819395059810306 651819395059810306 2025-07-31T13:18:16.985521+00:00 5 41 5 0 303322246    
1078 651819395059810306 651819395059810306 2025-07-31T13:30:30.163254+00:00 5 41 4 0 242576908    
1079 651819395059810306 651819395059810306 2025-07-31T13:30:37.005658+00:00 5 41 4 0 194853110    
1080 651819395059810306 651819395059810306 2025-07-31T13:44:34.924299+00:00 5 41 3 0 262484886    
1081 651819395059810306 651819395059810306 2025-07-31T13:44:47.014015+00:00 5 41 3 0 262485878    
1082 651819395059810306 651819395059810306 2025-07-31T13:52:06.940405+00:00 5 42 4 1 21923040    
1086 651819395059810306 651819395059810306 2025-07-31T14:39:18.715280+00:00 5 41 5 0 292955626    
1180 651819395059810306 651819395059810306 2025-08-27T08:37:51.598853+00:00 1 13 1 0      
1181 651819395059810306 651819395059810306 2025-08-27T08:37:51.598853+00:00 1 14 1 1   自動產生,關聯至完整刀 ID:1180 1180
1182 651819395059810306 651819395059810306 2025-08-27T08:43:36.532017+00:00 1 13 4 0      
1183 651819395059810306 651819395059810306 2025-08-27T08:43:36.532017+00:00 1 14 4 1   自動產生,關聯至完整刀 ID:1182 1182
1184 651819395059810306 651819395059810306 2025-08-27T08:48:31.015732+00:00 1 15 5 0      
1185 651819395059810306 651819395059810306 2025-08-27T08:48:31.015732+00:00 1 16 5 1   自動產生,關聯至完整刀 ID:1184 1184
1263 651819395059810306 651819395059810306 2025-08-27T15:47:52.439574+00:00 1 24 5 0 261618941    
1271 651819395059810306 651819395059810306 2025-08-27T16:18:03.928161+00:00 1 24 3 0 272310659    
1272 651819395059810306 651819395059810306 2025-08-27T16:19:12.367737+00:00 1 24 3 0 2150654    
1274 651819395059810306 651819395059810306 2025-08-27T16:29:55.048526+00:00 1 23 2 1 210562604    
1320 651819395059810306 651819395059810306 2025-08-28T12:29:32.432944+00:00 2 25 5 0 262766214    
1326 651819395059810306 651819395059810306 2025-08-28T12:37:33.005700+00:00 2 25 2 0 133079975    
1332 651819395059810306 651819395059810306 2025-08-28T12:49:00.025774+00:00 2 26 2 1 100038722    
1334 651819395059810306 651819395059810306 2025-08-28T12:55:40.719649+00:00 2 26 3 0 275842844    
1345 651819395059810306 651819395059810306 2025-08-28T13:17:53.577761+00:00 2 26 5 0 263431508    
1349 651819395059810306 651819395059810306 2025-08-28T13:24:56.165603+00:00 2 26 3 0 8108604    
1354 651819395059810306 651819395059810306 2025-08-28T13:42:36.021696+00:00 2 27 3 0 272850206    
1378 651819395059810306 651819395059810306 2025-08-28T16:30:19.571187+00:00 2 27 2 0 203942020    
1379 651819395059810306 651819395059810306 2025-08-28T16:33:49.097269+00:00 2 28 2 0 21142846    
1449 651819395059810306 651819395059810306 2025-08-29T13:42:24.427374+00:00 3 30 3 0 19800019    

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE attacks (
            attack_id INTEGER PRIMARY KEY AUTOINCREMENT,
            member_id INTEGER NOT NULL,
            attack_datetime TEXT NOT NULL, -- ISO8601 format UTC
            battle_day INTEGER NOT NULL, -- 1-5 for day 1 to 5 of guild battle
            lap INTEGER NOT NULL,
            boss_number INTEGER NOT NULL, -- 1-5
            is_residual BOOLEAN DEFAULT 0, -- 0 for False, 1 for True
            damage INTEGER, -- 新增傷害欄位,允許 NULL
            notes TEXT, related_full_attack_id INTEGER,
            FOREIGN KEY (member_id) REFERENCES members(member_id)
        );
Powered by Datasette · Queries took 37.351ms