names

80 rows where place_id = 590849

✎ 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
3602506 1868443 1868443 defendant Salter Walter husbandman 590849 590849 Salter, Walter, of Buxhale, husbandman 0
3602513 1868445 1868445 defendant Salter Edward husbandman 590849 590849 Salter, Edward, of Buxhale, husbandman 0
3602514 1868445 1868445 defendant Salter of Edmund butcher 590849 590849 Salter, of Edmund, of Buxhale, butcher 1
3604245 1868992 1868992 defendant Cokerell John gent 590849 590849 Cokerell, John, of Buxhale, gent 0
3604249 1868992 1868992 defendant Salter Edmund butcher 590849 590849 Salter, Edmund, of Buxhale, butcher 4
3616579 1872819 1872819 defendant Cokerell John gent 590849 590849 Cokerell, John, of Buxhale, gent 1
3886107 1985603 1985603 defendant Perle Robert laborer 590849 590849 Perle, Robert, of Buxhale, laborer 1
3886108 1985603 1985603 defendant Edwardys William pedder 590849 590849 Edwardys, William, of Buxhale, pedder 2
3919452 1996839 1996839 defendant Spynke Richard husbandman 590849 590849 Spynke, Richard, of Buxhale, husbandman 0
3922649 1997892 1997892 plaintiff Salter John (legal representative) 590849 590849 Salter, John, of Buxhale, butcher, executor of 0
4422390 2171868 2171868 defendant Balky John   590849 590849 Balky, John, of Buxhale 0
4432930 2175042 2175042 defendant Balky John   590849 590849 Balky, John, of Buxhale 0
4462634 2189009 2189009 plaintiff Tetford John   590849 590849 Tetford, John, of Buxhale, parson of the church 0
4465274 2189809 2189809 defendant Theford Thomas de   590849 590849 Theford, Thomas de, of Buxhale, parson 0
4470215 2191334 2191334 plaintiff Breton Seamus (legal representative) 590849 590849 Breton, Seamus, of Buxhale, executors of 0
4470221 2191335 2191335 plaintiff Breton Semanus (legal representative) 590849 590849 Breton, Semanus, of Buxhale, executors of 0
4579307 2225013 2225013 plaintiff Copynger John   590849 590849 Copynger, John, of Buxhale 0
4579309 2225013 2225013 plaintiff Hyham Robert   590849 590849 Hyham, Robert, of Buxhale 2
4579311 2225013 2225013 defendant Peel John   590849 590849 Peel, John, of Buxhale 1
4579312 2225014 2225014 plaintiff Copynger John   590849 590849 Copynger, John, of Buxhale 0
4579314 2225014 2225014 plaintiff Hyham Robert   590849 590849 Hyham, Robert, of Buxhale 2
4604958 2232712 2232712 defendant Canon Richard   590849 590849 Canon, Richard, of Buxhale, wright 1
4647934 2245465 2245465 plaintiff Spetylman Edmund   590849 590849 Spetylman, Edmund, of Buxhale 0
4690846 2262669 2262669 plaintiff Wode John   590849 590849 Wode, John, of Buxhale 0
4762855 2284364 2284364 defendant Ferthyng John husbandman 590849 590849 Ferthyng, John, of Buxhale, husbandman 4
4882183 2321330 2321330 defendant Thurmod Robert husbandman 590849 590849 Thurmod, Robert, of Buxhale, husbandman 0
4891902 2324201 2324201 defendant Rosshebroke Seman husbandman 590849 590849 Rosshebroke, Seman, of Buxhale, husbandman 0
4918978 2332450 2332450 defendant Barker Simon laborer 590849 590849 Barker, Simon, of Buxhale, laborer 0
4918979 2332450 2332450 defendant Aumener John laborer 590849 590849 Aumener, John, of buxhale, laborer 1
4919660 2332654 2332654 defendant Rosshebrook Seamus husbandman 590849 590849 Rosshebrook, Seamus, of Buxhale, husbandman 0
4923057 2333630 2333630 defendant Crykecote John yeoman 590849 590849 Crykecote, John, of Buxhale, yeoman 0
4926114 2334593 2334593 defendant Reysshbrook Seamus   590849 590849 Reysshbrook, Seamus, of Buxhale, wool man 3
4926737 2334782 2334782 defendant Aumener Thomas yeoman 590849 590849 Aumener, Thomas, of Buxhale, yeoman 7
4934933 2337330 2337330 defendant Renell or Revell Richard smith 590849 590849 Renell or Revell, Richard, of Buxhale, smith 0
4936611 2337834 2337834 defendant Russhebrook Seman woolman 590849 590849 Russhebrook, Seman, of Buxhale, woolman 0
4961950 2345529 2345529 defendant Skynner Seman husbandman 590849 590849 Skynner, Seman, of Buxhale, husbandman 0
4961951 2345529 2345529 defendant Howard John chaplain 590849 590849 Howard, John, of Buxhale, chaplain 1
4966375 2346874 2346874 defendant Hardhed Robert yeoman 590849 590849 Hardhed, Robert, of Buxhale, yeoman 4
4994967 2355353 2355353 defendant Baxter Robert husbandman 590849 590849 Baxter, Robert, of Buxhale, husbandman 1
5015491 2361415 2361415 defendant Reschebrok Seman husbandman 590849 590849 Reschebrok, Seman, of Buxhale, husbandman 0
5021874 2363290 2363290 defendant Copynger Walter gent 590849 590849 Copynger, Walter, of Buxhale, gent 0
5021875 2363290 2363290 defendant Spetilman Robert husbandman 590849 590849 Spetilman, Robert, of Buxhale, husbandman 1
5021877 2363291 2363291 defendant Copynger Walter gent 590849 590849 Copynger, Walter, of Buxhale, gent 0
5021878 2363291 2363291 defendant Spetilman Robert husbandman 590849 590849 Spetilman, Robert, of Buxhale, husbandman 1
5032006 2366234 2366234 plaintiff Rosshbrook John husbandman 590849 590849 Rosshbrook, John, of Buxhale, husbandman 0
5075363 2379128 2379128 defendant Langmere Geoffrey   590849 590849 Langmere, Geoffrey, of Buxhale, administrators of 0
5075364 2379128 2379128 defendant Langmere Rose widow 590849 590849 (Langmere, Rose, of Buxhale, widow 1
5075365 2379128 2379128 defendant Langmere John laborer 590849 590849 Langmere, John, of Buxhale, laborer 2
5078381 2380029 2380029 defendant Lynge John gent 590849 590849 Lynge, John, of Buxhale, or of Drenkeston, Suff, gent 0
5079799 2380436 2380436 defendant Copynger Walter gent 590849 590849 Copynger, Walter, of Buxhale, gent 0
5081516 2380970 2380970 defendant Copynger Walter gent 590849 590849 Copynger, Walter, of Buxhale, gent 0
5087328 2382674 2382674 defendant Copynger Walter esq 590849 590849 Copynger, Walter, of Buxhale, esq 0
5091983 2384035 2384035 defendant Cokerell Robert gent 590849 590849 Cokerell, Robert, of Buxhale, gent 1
5104588 2387775 2387775 defendant Ampner John husbandman 590849 590849 Ampner, John, of Buxhale, husbandman 1
5110874 2389577 2389577 plaintiff Hardhed Robert   590849 590849 Hardhed, Robert, of Buxhale 0
5132248 2395929 2395929 defendant Revell or Renell Thomas husbandman 590849 590849 Revell or Renell, Thomas, of Buxhale, husbandman 0
5132249 2395930 2395930 plaintiff Hardle- Robert   590849 590849 Hardle-, Robert, of Buxhale 0
5136732 2397265 2397265 defendant Cokerell Robert gent 590849 590849 Cokerell, Robert, of Buxhale, gent 0
5157295 2403273 2403273 defendant Cokerell Robert gent 590849 590849 Cokerell, Robert, of Buxhale, gent 0
5158605 2403637 2403637 defendant Cryktoft John husbandman 590849 590849 Cryktoft, John, of Buxhale, husbandman 3
5187163 2411971 2411971 plaintiff Hardhed Robert   590849 590849 Hardhed, Robert, of Buxhale 0
5193201 2413741 2413741 defendant Cokerell Robert gent 590849 590849 Cokerell, Robert, of Buxhale, gent 0
5206277 2417569 2417569 defendant Salter john tanner 590849 590849 Salter, john, of Buxhale, tanner 0
5208080 2418095 2418095 defendant Cokerell Robert gent 590849 590849 Cokerell, Robert, of Buxhale, gent 0
5211409 2419070 2419070 defendant Revell or Renell Richard, sen smith 590849 590849 Revell or Renell, Richard, sen, of Buxhale, smith 0
5211410 2419070 2419070 defendant Revell John fuller 590849 590849 Revell, John, of Buxhale, fuller 1
5211411 2419070 2419070 defendant Revell William laborer 590849 590849 Revell, William, of Buxhale, laborer 2
5219110 2421316 2421316 plaintiff Hardhed Robert   590849 590849 Hardhed, Robert, of Buxhale 0
5230128 2424427 2424427 defendant Chamberleyn Roger fuller 590849 590849 Chamberleyn, Roger, of Buxhale, fuller 1
5244905 2428683 2428683 defendant Salter Roger butcher 590849 590849 Salter, Roger, of Buxhale, butcher 2
5250741 2430341 2430341 defendant Wode Robert husbandman 590849 590849 Wode, Robert, of Buxhale, husbandman 0
5266229 2435191 2435191 defendant Wymbyssh Stephen yeoman 590849 590849 Wymbyssh, Stephen, of Buxhale, yeoman 2
5269674 2436242 2436242 plaintiff Cobbe Robert   590849 590849 Cobbe, Robert, of Buxhale 0
5277384 2438464 2438464 defendant Turnour Robert husandman 590849 590849 Turnour, Robert, of Buxhale, husandman 1
5287917 2441481 2441481 defendant Fuller John baker 590849 590849 Fuller, John, of Buxhale, baker 2
5298944 2444671 2444671 defendant Revel Thomas smith 590849 590849 Revel, Thomas, of Buxhale, smith 0
5298945 2444671 2444671 defendant Revel John fuller 590849 590849 Revel, John, of Buxhale, fuller 1
5303954 2446187 2446187 defendant Bolton Robert husbandman 590849 590849 Bolton, Robert, of Buxhale, husbandman 0
5519902 2511061 2511061 defendant Salter Edmund butcher 590849 590849 Salter, Edmund, of Buxhale, butcher 3
5551275 2520405 2520405 defendant Tenwynter Robert carpenter 590849 590849 Tenwynter, Robert, of Buxhale, carpenter 1

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);