names

90 rows where place_id = 753666

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4415054 2169608 2169608 defendant Hornere Richard   753666 753666 Hornere, Richard, of Storteford 0
4419837 2171099 2171099 defendant Davy Thomas   753666 753666 Davy, Thomas, of Storteford 0
4431323 2174560 2174560 defendant Davy Thomas   753666 753666 Davy, Thomas, of Storteford 0
4435849 2175960 2175960 defendant Curraunt Thomas   753666 753666 Curraunt, Thomas, of Storteford 0
4437987 2181198 2181198 plaintiff Algod William   753666 753666 Algod, William, of Storteford, parson of Bylchangre 0
4459835 2188130 2188130 defendant Bole John (legal representative) 753666 753666 Bole, John, of Storteford, executors of 0
4492801 2198452 2198452 defendant Pygeon John   753666 753666 Pygeon, John, of Storteford 0
4493617 2198705 2198705 defendant Cook John   753666 753666 Cook, John, of Storteford 5
4506301 2202472 2202472 plaintiff Tannere Nicholas   753666 753666 Tannere, Nicholas, of Storteford 0
4506302 2202472 2202472 defendant Rouhey John   753666 753666 Rouhey, John, of Storteford 0
4506304 2202473 2202473 plaintiff Tannere Nicholas   753666 753666 Tannere, Nicholas, of Storteford 0
4506305 2202473 2202473 defendant Webbe William   753666 753666 Webbe, William, of Storteford 0
4508671 2203193 2203193 defendant Pygeon John   753666 753666 Pygeon, John, of Storteford 0
4509808 2203553 2203553 defendant Cutrote Richard   753666 753666 Cutrote, Richard, of Storteford 0
4538145 2212214 2212214 defendant Cook John   753666 753666 Cook, John, of Storteford 0
4546710 2214896 2214896 defendant Yonge John   753666 753666 Yonge, John, of Storteford 0
4551299 2216343 2216343 plaintiff Drey John   753666 753666 Drey, John, of Storteford 0
4563632 2220190 2220190 defendant Pygeon Thomas   753666 753666 Pygeon, Thomas, of Storteford 1
4580409 2225356 2225356 defendant Smyth Walter chaplain 753666 753666 (Smyth, Walter, of Storteford, chaplain 1
4605650 2232886 2232886 defendant Cook John   753666 753666 Cook, John, of Storteford 0
4605652 2232887 2232887 defendant Cook John   753666 753666 Cook, John, of Storteford 0
4612754 2235055 2235055 defendant Cook John   753666 753666 Cook, John, of Storteford 0
4616997 2236323 2236323 defendant Bellam John   753666 753666 Bellam, John, of Storteford 0
4616999 2236324 2236324 defendant Bellam John   753666 753666 Bellam, John, of Storteford 0
4629432 2240133 2240133 defendant Wryght John   753666 753666 Wryght, John, of Storteford 0
4641872 2243729 2243729 defendant Kere Thomas   753666 753666 Kere, Thomas, of Storteford 0
4644080 2244367 2244367 defendant Cook John   753666 753666 Cook, John, of Storteford 3
4644081 2244367 2244367 defendant Gaal John   753666 753666 Gaal, John, of Storteford, warden of the fee 4
4649602 2245915 2245915 defendant Cook John   753666 753666 Cook, John, of Storteford 5
4666440 2250981 2250981 defendant Herolf Geoffrey husbandman 753666 753666 Herolf, Geoffrey, of Storteford, husbandman 0
4734173 2275868 2275868 plaintiff Salesbury John   753666 753666 Salesbury, John, of Storteford, parson 0
4787807 2292252 2292252 defendant Parker William laborer 753666 753666 Parker, William, of Storteford, laborer 0
4811700 2299767 2299767 defendant Keer Thomas yeoman 753666 753666 Keer, Thomas, of Storteford, yeoman 0
4832292 2306131 2306131 defendant Gose John husbandman 753666 753666 Gose, John, of Storteford, husbandman 0
4842099 2309063 2309063 defendant Long John   753666 753666 Long, John, of Storteford, mason 0
4851848 2312012 2312012 defendant Mason John yeoman 753666 753666 Mason, John, of Storteford, yeoman 1
4851849 2312012 2312012 defendant Audele Edward yeoman 753666 753666 Audele, Edward, of Storteford, yeoman 2
4858047 2313885 2313885 defendant Longe John   753666 753666 Longe, John, of Storteford, mason 0
4858049 2313886 2313886 defendant Longe John   753666 753666 Longe, John, of Storteford, mason 0
4876461 2319601 2319601 defendant Kere Thomas yeoman 753666 753666 Kere, Thomas, of Storteford, yeoman 0
4886779 2322720 2322720 plaintiff Kere Thomas   753666 753666 Kere, Thomas, of Storteford 0
4886783 2322721 2322721 defendant Panfeld Richard draper 753666 753666 Panfeld, Richard, of Storteford, draper 0
4888205 2323117 2323117 defendant Panfeld Richard draper 753666 753666 Panfeld, Richard, of Storteford, draper 0
4889430 2323486 2323486 plaintiff Fuller John   753666 753666 Fuller, John, of Storteford 0
4908415 2329189 2329189 plaintiff Asselyng Willam   753666 753666 Asselyng, Willam, of Storteford 0
4908417 2329189 2329189 plaintiff Asselyn Nicholas   753666 753666 Asselyn, Nicholas, of Storteford 2
4917220 2331892 2331892 plaintiff Fuller John   753666 753666 Fuller, John, of Storteford 0
4923096 2333642 2333642 defendant Thurkyll John butcher 753666 753666 Thurkyll, John, of Storteford, butcher 2
4927082 2334900 2334900 defendant Snowe Robert yeoman 753666 753666 Snowe, Robert, of Storteford, yeoman 4
4927615 2335073 2335073 plaintiff Thachem Hugh   753666 753666 Thachem, Hugh, of Storteford 2
4927616 2335073 2335073 defendant Cu---ote Richard husbandman 753666 753666 Cu---ote, Richard, of Storteford, husbandman 0
4938718 2338495 2338495 defendant Thurkyll John parker 753666 753666 Thurkyll, John, of Storteford, parker 0
4940049 2338915 2338915 defendant Goos John husbandman 753666 753666 Goos, John, of Storteford, husbandman 0
4953502 2343018 2343018 defendant Belham John, junior glover 753666 753666 Belham, John, junior, of Storteford, glover 0
4965853 2346717 2346717 defendant Goos John chandler 753666 753666 Goos, John, of Storteford, chandler 0
5045015 2370141 2370141 plaintiff Ilger William   753666 753666 Ilger, William, of Storteford 0
5045450 2370269 2370269 defendant Goos John   753666 753666 Goos, John, of Storteford, tallow chandler 0
5046935 2370706 2370706 defendant Pake Thomas tailor 753666 753666 Pake, Thomas, of Storteford, tailor 0
5065648 2376254 2376254 defendant Crakebone Mathew dyer 753666 753666 Crakebone, Mathew, of Storteford, dyer 0
5104914 2387872 2387872 defendant Illeger William husbandman 753666 753666 Illeger, William, of Storteford, husbandman 0
5109539 2389219 2389219 defendant Somerset John tailor 753666 753666 Somerset, John, of Storteford, tailor 1
5120121 2392322 2392322 defendant Belam Stephen ostler 753666 753666 Belam, Stephen, of Storteford, ostler 1
5126281 2394170 2394170 defendant Thacham John gent 753666 753666 Thacham, John, of Storteford, gent 0
5138602 2397785 2397785 defendant Stryvener Walter smith 753666 753666 Stryvener, Walter, of Storteford, smith 1
5171686 2407438 2407438 defendant Ruttour Thomas butcher 753666 753666 Ruttour, Thomas, of Storteford, butcher 0
5171688 2407438 2407438 defendant Waleys William husbandman 753666 753666 Waleys, William, of Storteford, husbandman 2
5251495 2430568 2430568 defendant Bryan Roger husbandman 753666 753666 Bryan, Roger, of Storteford, husbandman 0
5252601 2430929 2430929 defendant Akastre Thomas mercer 753666 753666 Akastre, Thomas, of Storteford, mercer 0
5253557 2431221 2431221 defendant Bryan Roger husbandman 753666 753666 Bryan, Roger, of Storteford, husbandman 0
5259328 2433037 2433037 defendant Waleys alias Glascok William husbandman 753666 753666 Waleys alias Glascok, William, of Storteford, husbandman 0
5260067 2433270 2433270 defendant Wylde Richard mercer 753666 753666 Wylde, Richard, of Storteford, mercer 0
5260068 2433270 2433270 defendant Waleys William husbandman 753666 753666 Waleys, William, of Storteford, husbandman 1
5284405 2440456 2440456 defendant Wryght John husbandman 753666 753666 Wryght, John, of Storteford, husbandman 1
5284410 2440457 2440457 defendant Wryght John husbandman 753666 753666 Wryght, John, of Storteford, husbandman 1
5312903 2448891 2448891 defendant Ive John butcher 753666 753666 Ive, John, of Storteford, butcher 3
5376920 2468379 2468379 defendant Palmer Thomas butcher 753666 753666 Palmer, Thomas, of Storteford, butcher 0
5495888 2503666 2503666 plaintiff Hogon John draper 753666 753666 Hogon, John, of Storteford, draper 0
5496746 2503948 2503948 defendant Belom Isabel widow 753666 753666 Belom, Isabel, of Storteford, widow 1
5500369 2505055 2505055 defendant Jardevill John, junior tanner 753666 753666 Jardevill, John, junior, of Storteford, tanner 0
5500370 2505055 2505055 defendant Grace John tanner 753666 753666 Grace, John, of Storteford, tanner 1
5500371 2505055 2505055 defendant Howe William   753666 753666 Howe, William, of Storteford, wheelwright 2
5506576 2506967 2506967 defendant Elys John husbandman 753666 753666 Elys, John, of Storteford, husbandman 2
5517920 2510448 2510448 defendant Rotour Thomas butcher 753666 753666 Rotour, Thomas, of Storteford, butcher 1
5518293 2510547 2510547 defendant Sale Thomas husbandman 753666 753666 Sale, Thomas, of Storteford, husbandman 0
5534494 2515335 2515335 defendant Page John butcher 753666 753666 Page, John, of Storteford, butcher 0
5612301 2547594 2547594 plaintiff Cameswell Robert   753666 753666 Cameswell, Robert, of Storteford 0
5618286 2549536 2549536 plaintiff Bele Robert   753666 753666 Bele, Robert, of Storteford 1
5620502 2550272 2550272 defendant Bolet William   753666 753666 Bolet, William, of Storteford 0
5620503 2550272 2550272 defendant Bolet John   753666 753666 Bolet, John, of Storteford 1
5621469 2550612 2550612 defendant Kere Bartholomew   753666 753666 Kere, Bartholomew, of Storteford 3

Advanced export

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

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);