names

72 rows where place_id = 588941

✎ 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
3596065 1866398 1866398 defendant Forman Robert gent 588941 588941 Forman, Robert, of Keleby, gent 0
3612684 1871612 1871612 defendant Forman Robert gent 588941 588941 Forman, Robert, of Keleby, gent 0
3612686 1871613 1871613 defendant Forman Robert gent 588941 588941 Forman, Robert, of Keleby, gent 0
3722615 1933332 1933332 defendant Myssyndyn William gent 588941 588941 Myssyndyn, William, of Keleby, gent 0
3951135 2007466 2007466 defendant Screvener Nicholas yeoman 588941 588941 Screvener, Nicholas, of Keleby, yeoman 0
4588091 2227674 2227674 plaintiff Keleby Robert   588941 588941 Keleby, Robert, of Keleby 0
4616325 2236097 2236097 plaintiff Frankyssh John   588941 588941 Frankyssh, John, of Keleby 0
4644409 2244455 2244455 defendant Almot Robert   588941 588941 Almot, Robert, of Keleby 3
4645697 2244809 2244809 defendant Webster Thomas   588941 588941 Webster, Thomas, of Keleby 0
4661081 2249291 2249291 defendant Keleby Robert gent 588941 588941 Keleby, Robert, of Keleby, gent 0
4668967 2255997 2255997 defendant Litster William tailor 588941 588941 Litster, William, of Keleby, tailor 0
4668969 2255998 2255998 defendant Litster William tailor 588941 588941 Litster, William, of Keleby, tailor 0
4715874 2270279 2270279 defendant Pysall William merchant 588941 588941 Pysall, William, of Keleby, merchant 0
4745983 2279326 2279326 defendant Byddes Richard husbandman 588941 588941 Byddes, Richard, of Keleby, husbandman 1
4758061 2282893 2282893 defendant Graunt Thomas   588941 588941 Graunt, Thomas, of Keleby 0
4784115 2291030 2291030 defendant Grant Thomas chaplain 588941 588941 Grant, Thomas, of Keleby, chaplain 0
4788516 2292469 2292469 defendant Spycer John chapman 588941 588941 Spycer, John, of Keleby, chapman 0
4809950 2299273 2299273 plaintiff Elvy Margaret   588941 588941 Elvy, Margaret, of Keleby 0
4809952 2299273 2299273 defendant Pysall William husbandman 588941 588941 Pysall, William, of Keleby, husbandman 0
4815369 2300916 2300916 defendant Pysale William husbandman 588941 588941 Pysale, William, of keleby, husbandman 0
4834063 2306661 2306661 defendant Plomber Robert plumber 588941 588941 Plomber, Robert, of Keleby, plumber 0
4834065 2306662 2306662 defendant Plomber Robert plumber 588941 588941 Plomber, Robert, of Keleby, plumber 0
4834066 2306662 2306662 defendant Jonson William husbandman 588941 588941 Jonson, William, of Keleby, husbandman 1
4834067 2306662 2306662 defendant Artilrus William husbandman 588941 588941 Artilrus, William, of Keleby, husbandman 2
4835846 2307201 2307201 defendant Pysall William   588941 588941 Pysall, William, of Keleby 1
4837295 2307609 2307609 defendant Begram John   588941 588941 Begram, John, of Keleby, servant 0
4841324 2308823 2308823 plaintiff Jonesson William   588941 588941 Jonesson, William, of Keleby 0
4849998 2311471 2311471 defendant Pysall William yeoman 588941 588941 Pysall, William, of Keleby, yeoman 1
4849999 2311471 2311471 defendant Arclus Walter husbandman 588941 588941 Arclus, Walter, of Keleby, husbandman 2
4863397 2315521 2315521 defendant Jonson William husbandman 588941 588941 Jonson, William, of Keleby, husbandman 1
4897503 2325878 2325878 defendant Pysall William husbandman 588941 588941 Pysall, William, of Keleby, husbandman 5
4900718 2326863 2326863 defendant Byngham John butcher 588941 588941 Byngham, John, of Keleby, butcher 0
4946146 2340778 2340778 defendant Pysall William husbandman 588941 588941 Pysall, William, of Keleby, husbandman 0
4969816 2347918 2347918 defendant Byngham John butcher 588941 588941 Byngham, John, of Keleby, butcher 5
4969817 2347918 2347918 defendant Bocher John butcher 588941 588941 Bocher, John, of Keleby, butcher 6
4976837 2350024 2350024 defendant Cartwryght John husbandman 588941 588941 Cartwryght, John, of Keleby, husbandman 0
4980233 2351032 2351032 defendant Tylly Walter husbandman 588941 588941 Tylly, Walter, of Keleby, husbandman 1
4985960 2352717 2352717 defendant Byngham John butcher 588941 588941 Byngham, John, of Keleby, butcher 0
4985961 2352717 2352717 defendant Wixley John shoemaker 588941 588941 Wixley, John, of keleby, shoemaker 1
5000080 2356909 2356909 defendant Pysall William husbandman 588941 588941 Pysall, William, of Keleby, husbandman 1
5023114 2363665 2363665 defendant Bonefaunt William husbandman 588941 588941 Bonefaunt, William, of Keleby, husbandman 8
5023115 2363665 2363665 defendant Chosyll John husbandman 588941 588941 Chosyll, John, of Keleby, husbandman 9
5023116 2363665 2363665 defendant Pysall William husbandman 588941 588941 Pysall, William, of Keleby, husbandman 10
5029104 2365388 2365388 defendant Byngham John butcher 588941 588941 Byngham, John, of Keleby, butcher 0
5044168 2369883 2369883 defendant Hanlay Henry gent 588941 588941 Hanlay, Henry, of Keleby, gent 0
5087721 2382794 2382794 defendant Pursell William   588941 588941 Pursell, William, of Keleby, wright 0
5091470 2383893 2383893 defendant Pysall John husbandman 588941 588941 Pysall, John, of Keleby, husbandman 0
5099984 2386433 2386433 defendant Frayne John husbandman 588941 588941 Frayne, John, of Keleby, husbandman 1
5102903 2387269 2387269 defendant Chaumberleyn Robert husbandman 588941 588941 Chaumberleyn, Robert, of Keleby, husbandman 2
5107586 2388650 2388650 defendant Pysall William husbandman 588941 588941 Pysall, William, of Keleby, husbandman 1
5122134 2392894 2392894 defendant Boston Gilbert husbandman 588941 588941 Boston, Gilbert, of Keleby, husbandman 1
5123839 2393429 2393429 defendant Frayne John husbandman 588941 588941 Frayne, John, of Keleby, husbandman 2
5125039 2393795 2393795 defendant Frayne John husbandman 588941 588941 Frayne, John, of Keleby, husbandman 1
5140636 2398370 2398370 defendant Purcell William husbandman 588941 588941 Purcell, William, of keleby, husbandman 0
5142816 2399028 2399028 defendant Chesyll John husbandman 588941 588941 Chesyll, John, of Keleby, husbandman 0
5143670 2399282 2399282 defendant Frayne John husbandman 588941 588941 Frayne, John, of Keleby, husbandman 0
5153471 2402169 2402169 defendant Boston Gilbert yeoman 588941 588941 Boston, Gilbert, of Keleby, yeoman 1
5164814 2405440 2405440 defendant Frayne John husbandman 588941 588941 Frayne, John, of Keleby, husbandman 0
5178285 2409351 2409351 defendant Frayne John husbandman 588941 588941 Frayne, John, of Keleby, husbandman 0
5200620 2415939 2415939 defendant Chosyll John husbandman 588941 588941 Chosyll, John, of Keleby, husbandman 0
5201390 2416161 2416161 defendant Frayne John husbandman 588941 588941 Frayne, John, of Keleby, husbandman 0
5210269 2418731 2418731 defendant Stokes William yeoman 588941 588941 Stokes, William, of Keleby, yeoman 1
5212056 2419265 2419265 defendant Frayne John husbandman 588941 588941 Frayne, John, of Keleby, husbandman 0
5255508 2431842 2431842 defendant Passemere William weaver 588941 588941 Passemere, William, of Keleby, weaver 6
5255516 2431843 2431843 defendant Passemere William weaver 588941 588941 Passemere, William, of Keleby, weaver 6
5260945 2433544 2433544 defendant Passemere William weaver 588941 588941 Passemere, William, of Keleby, weaver 6
5261059 2433571 2433571 defendant Passemere William weaver 588941 588941 Passemere, William, of Keleby, weaver 6
5278998 2438967 2438967 defendant Jekyll Roger laborer 588941 588941 Jekyll, Roger, of Keleby, laborer 1
5443830 2488071 2488071 defendant Skypwyth Thomas gent 588941 588941 Skypwyth, Thomas, of Keleby, gent 2
5456578 2491890 2491890 defendant Skypewyth Thomas gent 588941 588941 Skypewyth, Thomas, of Keleby, gent 2
5468413 2495493 2495493 defendant Rybe James   588941 588941 Rybe, James, of Keleby 1
5582574 2529617 2529617 defendant Forman Robert gent 588941 588941 Forman, Robert, of Keleby, gent 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);