names

58 rows where place_id = 628586

✎ 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
3783211 1952500 1952500 defendant Lawkeland Richard clerk 628586 628586 Lawkeland, Richard, of Horblyng, clerk 2
3792912 1955636 1955636 defendant Palmer Robert mercer 628586 628586 Palmer, Robert, of Horblyng, mercer 1
3809596 1960888 1960888 defendant Palmer Robert mercer 628586 628586 Palmer, Robert, of Horblyng, mercer 1
3826904 1966265 1966265 defendant Denton George gent 628586 628586 Denton, George, of Horblyng, gent 0
3864531 1978337 1978337 defendant Richardson alias Coke Thomas husbandman 628586 628586 Richardson alias Coke, Thomas, of Horblyng, husbandman 0
3864532 1978337 1978337 defendant Pecke Robert husbandman 628586 628586 Pecke, Robert, of Horblyng, husbandman 1
3936091 2002392 2002392 defendant Brown John husbandman 628586 628586 Brown, John, of Horblyng, husbandman 0
3936972 2002695 2002695 defendant Skynner John husbandman 628586 628586 Skynner, John, of Horblyng, husbandman 0
3969340 2013881 2013881 defendant Shypp John husbandman 628586 628586 Shypp, John, of Horblyng, husbandman 0
4419169 2170866 2170866 plaintiff Aunsel William   628586 628586 Aunsel, William, of Horblyng 0
4419172 2170867 2170867 plaintiff Ausel William   628586 628586 Ausel, William, of Horblyng 0
4428367 2173706 2173706 plaintiff Stowe John de   628586 628586 Stowe, John de, of Horblyng 0
4428368 2173706 2173706 defendant Lyghtfote John   628586 628586 Lyghtfote, John, of Horblyng 0
4430918 2174431 2174431 plaintiff Aunssel William   628586 628586 Aunssel, William, of Horblyng 0
4517205 2205780 2205780 defendant Manle Walter   628586 628586 Manle, Walter, of Horblyng 0
4564699 2220523 2220523 defendant Baret Robert   628586 628586 Baret, Robert, of Horblyng, vicar 0
4588079 2227669 2227669 defendant Philyp Thomas   628586 628586 Philyp, Thomas, of Horblyng 1
4594995 2229691 2229691 defendant Ardern William   628586 628586 Ardern, William, of Horblyng 0
4677828 2258681 2258681 defendant Loterell John husbandman 628586 628586 Loterell, John, of Horblyng, husbandman 0
4683613 2260476 2260476 defendant Hardyng John husbandman 628586 628586 Hardyng, John, of Horblyng, husbandman 3
4684593 2260781 2260781 defendant Wykes William   628586 628586 Wykes, William, of Horblyng, knight 1
4720846 2271851 2271851 defendant Payntour John laborer 628586 628586 Payntour, John, of Horblyng, laborer 0
4723930 2272782 2272782 defendant Wade William husbandman 628586 628586 Wade, William, of Horblyng, husbandman 0
4724855 2273071 2273071 defendant Wade William husbandman 628586 628586 Wade, William, of Horblyng, husbandman 0
4732566 2275361 2275361 plaintiff Payntour John   628586 628586 Payntour, John, of Horblyng 0
4735127 2276135 2276135 defendant Barst Robert husbandman 628586 628586 Barst, Robert, of Horblyng, husbandman 0
4765640 2285244 2285244 defendant Wade William husbandman 628586 628586 Wade, William, of Horblyng, husbandman 1
4766806 2285613 2285613 defendant Barrit Robert husbandman 628586 628586 Barrit, Robert, of Horblyng, husbandman 0
4790044 2292959 2292959 defendant Wade William husbandman 628586 628586 Wade, William, of Horblyng, husbandman 1
4813153 2300229 2300229 defendant Wade William husbandman 628586 628586 Wade, William, of Horblyng, husbandman 0
4822776 2303203 2303203 defendant Wade William husbandman 628586 628586 Wade, William, of Horblyng, husbandman 0
4823048 2303291 2303291 defendant Wade William laborer 628586 628586 Wade, William, of Horblyng, laborer 1
4832969 2306330 2306330 defendant Careby Richard husbandman 628586 628586 Careby, Richard, of Horblyng, husbandman 0
4846363 2310370 2310370 defendant Arderne William husbandman 628586 628586 Arderne, William, of Horblyng, husbandman 0
4864462 2315861 2315861 defendant Wykes John gent 628586 628586 Wykes, John, of Horblyng, gent 0
4864466 2315861 2315861 defendant Arderne John husbandman 628586 628586 Arderne, John, of Horblyng, husbandman 4
4887813 2323017 2323017 plaintiff Baret Robert   628586 628586 Baret, Robert, of Horblyng 1
4891695 2324145 2324145 plaintiff Baret Robert   628586 628586 Baret, Robert, of Horblyng 1
4925299 2334345 2334345 defendant Wykes John, senior esq 628586 628586 Wykes, John, senior, of Horblyng, esq 0
4927904 2335162 2335162 defendant Swaby John   628586 628586 Swaby, John, of Horblyng, vicar 0
4947735 2341277 2341277 defendant Wade William husbandman 628586 628586 Wade, William, of Horblyng, husbandman 0
4967840 2347326 2347326 defendant Wykes John esq 628586 628586 Wykes, John, of Horblyng, esq 0
4994422 2355207 2355207 defendant Wykes John esq 628586 628586 Wykes, John, of Horblyng, esq 0
4994583 2355239 2355239 defendant Swaby John   628586 628586 Swaby, John, of Horblyng, vicar 0
5035218 2367163 2367163 defendant Wykes Johon esq 628586 628586 Wykes, Johon, of Horblyng, esq 0
5245966 2428981 2428981 defendant Webster Alan weaver 628586 628586 Webster, Alan, of Horblyng, weaver 0
5264861 2434768 2434768 defendant Burland William husbandman 628586 628586 Burland, William, of Horblyng, husbandman 0
5264862 2434768 2434768 defendant Mowere John husbandman 628586 628586 Mowere, John, of Horblyng, husbandman 1
5281085 2439543 2439543 defendant Bocher Henry butcher 628586 628586 Bocher, Henry, of Horblyng, butcher 0
5342297 2457787 2457787 defendant Depedale Alexander yeoman 628586 628586 Depedale, Alexander, of Horblyng, yeoman 0
5461241 2493307 2493307 defendant Gamell Robert husbandman 628586 628586 Gamell, Robert, of Horblyng, husbandman 4
5472813 2496829 2496829 defendant Gamell Robert husbandman 628586 628586 Gamell, Robert, of Horblyng, husbandman 3
5472818 2496830 2496830 defendant Gamell Robert husbandman 628586 628586 Gamell, Robert, of Horblyng, husbandman 3
5472824 2496831 2496831 defendant Gamell Robert husbandman 628586 628586 Gamell, Robert, of Horblyng, husbandman 4
5484372 2500244 2500244 defendant Camoll Robert yeoman 628586 628586 Camoll, Robert, of Horblyng, yeoman 4
5539826 2516935 2516935 defendant Asley James yeoman 628586 628586 Asley, James, of Horblyng, yeoman 0
5573429 2526785 2526785 defendant Asshemowe Richard husbandman 628586 628586 Asshemowe, Richard, of Horblyng, husbandman 1
5628182 2552775 2552775 defendant Hardyng William husbandman 628586 628586 Hardyng, William, of Horblyng, husbandman 2

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