names

75 rows where place_id = 597033

✎ 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
3627014 1903308 1903308 defendant Brown John husbandman 597033 597033 Brown, John, of West Haddon, husbandman 0
3627015 1903308 1903308 defendant Freman Nicholas husbandman 597033 597033 Freman, Nicholas, of West Haddon, husbandman 1
3627017 1903308 1903308 defendant Dunkley Thomas husbandman 597033 597033 Dunkley, Thomas, of West Haddon, husbandman 3
3627018 1903308 1903308 defendant Wylson Thomas husbandman 597033 597033 Wylson, Thomas, of West Haddon, husbandman 4
3637691 1906602 1906602 defendant Congner or Conquer Thomas yeoman 597033 597033 Congner or Conquer, Thomas, of West Haddon, yeoman 0
3746361 1940780 1940780 plaintiff Coke Thomas husbandman 597033 597033 Coke, Thomas, of West Haddon, husbandman 0
3788503 1954206 1954206 defendant Kyng William yeoman 597033 597033 Kyng, William, of West Haddon, yeoman 0
4021391 2032375 2032375 defendant Palmer Thomas yeoman 597033 597033 Palmer, Thomas, of West Haddon, yeoman 0
4053331 2043567 2043567 defendant Spryngfeild John husbandman 597033 597033 Spryngfeild, John, of West Haddon, husbandman 0
4053332 2043567 2043567 defendant Jenewaye William husbandman 597033 597033 Jenewaye, William, of West Haddon, husbandman 1
4057112 2044928 2044928 defendant Andrewe Edward gent 597033 597033 Andrewe, Edward, of West Haddon, gent 0
4058243 2045331 2045331 defendant Palmer Thomas husbandman 597033 597033 Palmer, Thomas, of West Haddon, husbandman 2
4233659 2107295 2107295 defendant Knowles Roger gent 597033 597033 Knowles, Roger, of West Haddon, or of Cold Ashebye, gent 0
4233661 2107296 2107296 defendant Knowles Roger gent 597033 597033 Knowles, Roger, of West Haddon, or of Cold Ashebye, gent 0
4323214 2138179 2138179 defendant Worceter Peter husbandman 597033 597033 Worceter, Peter, of West Haddon, husbandman 0
4335677 2142210 2142210 defendant Gullyver William husbandman 597033 597033 Gullyver, William, of West Haddon, husbandman 0
4340069 2143794 2143794 defendant Blasse or Classe William yeoman 597033 597033 Blasse or Classe, William, of West Haddon, yeoman 1
4354950 2148948 2148948 defendant Denton Samuel clerk 597033 597033 Denton, Samuel, of West Haddon, clerk 0
4506008 2202392 2202392 defendant Tracy Thomas   597033 597033 Tracy, Thomas, of West Haddon 0
4530229 2209746 2209746 defendant Wircestre Richard weaver 597033 597033 Wircestre, Richard, of West Haddon, weaver 1
4532148 2210320 2210320 defendant Deyster Thomas   597033 597033 Deyster, Thomas, of West Haddon 1
4541540 2213249 2213249 plaintiff Wryght John   597033 597033 Wryght, John, of West Haddon 0
4568641 2221771 2221771 defendant Tracy Thomas   597033 597033 Tracy, Thomas, of West Haddon 0
4670764 2256534 2256534 defendant Lychebarowe Henry husbandman 597033 597033 Lychebarowe, Henry, of West Haddon, husbandman 0
4670770 2256536 2256536 defendant Lychburwe Henry husbandman 597033 597033 Lychburwe, Henry, of West Haddon, husbandman 0
4675679 2258003 2258003 defendant Tracy Thomas husbandman 597033 597033 Tracy, Thomas, of West Haddon, husbandman 0
4681422 2259810 2259810 defendant Cranesley John   597033 597033 Cranesley, John, of West Haddon, bailiff 3
4711975 2269057 2269057 defendant Tracy Thomas husbandman 597033 597033 Tracy, Thomas, of West Haddon, husbandman 1
4715897 2270286 2270286 defendant Cranesle John   597033 597033 Cranesle, John, of West Haddon, bailiff 0
4745033 2279060 2279060 defendant Maget John husbandman 597033 597033 Maget, John, of West Haddon, husbandman 0
4797993 2295556 2295556 defendant Gilbard John husbandman 597033 597033 Gilbard, John, of West Haddon, husbandman 0
4797994 2295556 2295556 defendant Gilbard Thomas husbandman 597033 597033 Gilbard, Thomas, of West Haddon, husbandman 1
4822182 2303016 2303016 defendant Colas John husbandman 597033 597033 Colas, John, of West Haddon, husbandman 0
4838837 2308077 2308077 defendant Gylbert Thomas husbandman 597033 597033 Gylbert, Thomas, of West Haddon, husbandman 1
4865835 2316283 2316283 defendant Couper John husbandman 597033 597033 Couper, John, of West Haddon, husbandman 3
4878141 2320115 2320115 defendant Gylbert Thomas butcher 597033 597033 Gylbert, Thomas, of West Haddon, butcher 1
4929749 2335721 2335721 defendant Colas John husbandman 597033 597033 Colas, John, of West Haddon, husbandman 0
4929750 2335721 2335721 defendant Page Thomas husbandman 597033 597033 Page, Thomas, of West Haddon, husbandman 1
4939694 2338800 2338800 defendant Bryan Richard husbandman 597033 597033 Bryan, Richard, of West Haddon, husbandman 0
4965435 2346578 2346578 plaintiff Gylberd John   597033 597033 Gylberd, John, of West Haddon 1
4965436 2346578 2346578 plaintiff Smyth Sampso   597033 597033 Smyth, Sampso, of West Haddon 2
4970574 2348141 2348141 defendant Page Thomas husbandman 597033 597033 Page, Thomas, of West Haddon, husbandman 3
4985379 2352548 2352548 defendant Colas John husbandman 597033 597033 Colas, John, of West Haddon, husbandman 4
5101237 2386772 2386772 defendant Gilbert Thomas husbandman 597033 597033 Gilbert, Thomas, of West Haddon, husbandman 0
5101238 2386772 2386772 defendant Harecourt John husbandman 597033 597033 Harecourt, John, of West Haddon, husbandman 1
5101239 2386772 2386772 defendant Crane John husbandman 597033 597033 Crane, John, of West Haddon, husbandman 2
5101240 2386772 2386772 defendant Freman John husbandman 597033 597033 Freman, John, of West Haddon, husbandman 3
5101241 2386772 2386772 defendant Freman Philip husbandman 597033 597033 Freman, Philip, of West Haddon, husbandman 4
5143718 2399294 2399294 defendant Gilbert Thomas husbandman 597033 597033 Gilbert, Thomas, of West Haddon, husbandman 0
5143719 2399294 2399294 defendant Harecourt John husbandman 597033 597033 Harecourt, John, of West Haddon, husbandman 1
5143720 2399294 2399294 defendant Crane John husbandman 597033 597033 Crane, John, of West Haddon, husbandman 2
5143721 2399294 2399294 defendant Freman John husbandman 597033 597033 Freman, John, of West Haddon, husbandman 3
5143722 2399294 2399294 defendant Freman Philip husbandman 597033 597033 Freman, Philip, of West Haddon, husbandman 4
5183238 2410838 2410838 defendant Harecourt John husbandman 597033 597033 Harecourt, John, of West Haddon, husbandman 0
5183239 2410838 2410838 defendant Bernard Richard husbandman 597033 597033 Bernard, Richard, of West Haddon, husbandman 1
5235217 2425878 2425878 defendant Olney Richard husbandman 597033 597033 Olney, Richard, of West Haddon, husbandman 1
5283295 2440170 2440170 defendant Harecourt John yeoman 597033 597033 Harecourt, John, of West Haddon, yeoman 2
5294770 2443452 2443452 defendant Yoman Robert yeoman 597033 597033 Yoman, Robert, of West Haddon, yeoman 0
5339365 2456881 2456881 defendant Harecourt John yeoman 597033 597033 Harecourt, John, of West Haddon, yeoman 0
5355917 2461928 2461928 defendant Harecourt John yeoman 597033 597033 Harecourt, John, of West Haddon, yeoman 0
5355919 2461929 2461929 defendant Myles Roger husbandman 597033 597033 Myles, Roger, of West Haddon, husbandman 0
5355920 2461929 2461929 defendant Cristyan Richard sherman 597033 597033 Cristyan, Richard, of West Haddon, sherman 1
5372474 2466987 2466987 defendant (illegible) William husbandman 597033 597033 ---, William, of West Haddon, husbandman 0
5407393 2477179 2477179 defendant Coton William husbandman 597033 597033 Coton, William, of West Haddon, husbandman 0
5420624 2481093 2481093 defendant Coton William husbandman 597033 597033 Coton, William, of West Haddon, husbandman 0
5439486 2486744 2486744 defendant Coton William husbandman 597033 597033 Coton, William, of West Haddon, husbandman 0
5454227 2491169 2491169 defendant Yoman Robert   597033 597033 Yoman, Robert, of West Haddon 0
5481666 2499448 2499448 defendant Harecourt John yeoman 597033 597033 Harecourt, John, of West Haddon, yeoman 0
5481667 2499448 2499448 defendant Cristian Richard husbandman 597033 597033 Cristian, Richard, of West Haddon, husbandman 1
5510217 2508032 2508032 defendant Yoman Robert husbandman 597033 597033 Yoman, Robert, of West Haddon, husbandman 0
5513212 2508981 2508981 defendant Smyth Henry yeoman 597033 597033 Smyth, Henry, of West Haddon, yeoman 0
5513213 2508981 2508981 defendant Yoman Robert husbandman 597033 597033 Yoman, Robert, of West Haddon, husbandman 1
5513214 2508981 2508981 defendant Harecourt John yeoman 597033 597033 Harecourt, John, of West Haddon, yeoman 2
5513215 2508981 2508981 defendant Crane William yeoman 597033 597033 Crane, William, of West Haddon, yeoman 3
5595727 2533580 2533580 defendant Wyld Nicholas husbandman 597033 597033 Wyld, Nicholas, of West Haddon, husbandman 0

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