names

78 rows where place_id = 619157

✎ 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
3625650 1875557 1875557 defendant Farneham John esq 619157 619157 Farneham, John, of Querndon, or of Bewman, Leics, esq 0
3728435 1935141 1935141 defendant Chaveney William gent 619157 619157 Chaveney, William, of Querndon, gent 2
3830215 1967344 1967344 plaintiff Farnham Robert gent 619157 619157 Farnham, Robert, of Querndon, gent 0
4444671 2183311 2183311 defendant Herbert Thomas   619157 619157 Herbert, Thomas, of Querndon 2
4453503 2186103 2186103 defendant Broun Robert   619157 619157 Broun, Robert, of Querndon 0
4466178 2190085 2190085 plaintiff Yongman Robert   619157 619157 Yongman, Robert, of Querndon, on his own account 0
4524978 2208149 2208149 defendant Herberd John   619157 619157 Herberd, John, of Querndon 2
4555416 2217629 2217629 plaintiff Herbard John   619157 619157 Herbard, John, of Querndon 0
4555419 2217630 2217630 plaintiff Herbard John   619157 619157 Herbard, John, of Querndon 0
4556589 2217998 2217998 defendant Herberd John   619157 619157 Herberd, John, of Querndon 1
4594761 2229618 2229618 defendant Herberd John   619157 619157 Herberd, John, of Querndon 0
4594765 2229619 2229619 defendant Herberd John   619157 619157 Herberd, John, of Querndon 0
4604814 2232674 2232674 defendant Taillour John   619157 619157 Taillour, John, of Querndon 0
4651175 2246373 2246373 defendant Smyth William   619157 619157 Smyth, William, of Querndon, scythe smith 1
4720874 2271862 2271862 defendant Prichet John, sen husbandman 619157 619157 Prichet, John, sen, of Querndon, husbandman 3
4785507 2291489 2291489 plaintiff Farnham Thomas   619157 619157 Farnham, Thomas, of Querndon 0
4785692 2291556 2291556 defendant Fernham Thomas gent 619157 619157 Fernham, Thomas, of Querndon, gent 0
4789833 2292887 2292887 defendant Fernham Thomas gent 619157 619157 Fernham, Thomas, of Querndon, gent 0
4791604 2293469 2293469 defendant Barbour Thomas gent 619157 619157 Barbour, Thomas, of Querndon, gent 0
4827599 2304683 2304683 defendant Smyth William smith 619157 619157 Smyth, William, of Querndon, smith 2
4831467 2305873 2305873 defendant Prechet John yeoman 619157 619157 Prechet, John, of Querndon, yeoman 0
4867141 2316683 2316683 defendant Squyer Richard miller 619157 619157 Squyer, Richard, of Querndon, miller 3
4891252 2323996 2323996 defendant Smyth William   619157 619157 Smyth, William, of Querndon, scythe smith 1
4891255 2323996 2323996 defendant Hauke or Hanke Robert husbandman 619157 619157 Hauke or Hanke, Robert, of Querndon, husbandman 4
4891256 2323996 2323996 defendant Hewet Henry husbandman 619157 619157 Hewet, Henry, of Querndon, husbandman 5
4959437 2344788 2344788 defendant Farnham Thomas gent 619157 619157 Farnham, Thomas, of Querndon, gent 2
5025132 2364250 2364250 defendant Richard Nicholas husbandman 619157 619157 Richard, Nicholas, of Querndon, husbandman 0
5025133 2364250 2364250 defendant Fyssher Richard husbandman 619157 619157 Fyssher, Richard, of Querndon, husbandman 1
5025134 2364250 2364250 defendant Potter Thomas husbandman 619157 619157 Potter, Thomas, of Querndon, husbandman 2
5025135 2364250 2364250 defendant Huet Henry husbandman 619157 619157 Huet, Henry, of Querndon, husbandman 3
5025136 2364250 2364250 defendant Hawke Robert husbandman 619157 619157 Hawke, Robert, of Querndon, husbandman 4
5025137 2364250 2364250 defendant Taillour Thomas husbandman 619157 619157 Taillour, Thomas, of Querndon, husbandman 5
5025138 2364250 2364250 defendant Warde Henry husbandman 619157 619157 Warde, Henry, of Querndon, husbandman 6
5025139 2364250 2364250 defendant Pereson Richard husbandman 619157 619157 Pereson, Richard, of Querndon, husbandman 7
5025140 2364250 2364250 defendant Smyth John husbandman 619157 619157 Smyth, John, of Querndon, husbandman 8
5025141 2364250 2364250 defendant Cossall John husbandman 619157 619157 Cossall, John, of Querndon, husbandman 9
5025142 2364250 2364250 defendant Smyth Robert husbandman 619157 619157 Smyth, Robert, of Querndon, husbandman 10
5025143 2364250 2364250 defendant Potter William husbandman 619157 619157 Potter, William, of Querndon, husbandman 11
5025144 2364250 2364250 defendant Kennet William husbandman 619157 619157 Kennet, William, of Querndon, husbandman 12
5025145 2364250 2364250 defendant Tomlynson John husbandman 619157 619157 Tomlynson, John, of Querndon, husbandman 13
5025146 2364250 2364250 defendant Taillour John husbandman 619157 619157 Taillour, John, of Querndon, husbandman 14
5035744 2367310 2367310 defendant Routhorne Henry husbandman 619157 619157 together with Routhorne, Henry, of Querndon, husbandman 2
5045053 2370154 2370154 defendant Taillour Thomas husbandman 619157 619157 Taillour, Thomas, of Querndon, husbandman 1
5063020 2375472 2375472 defendant Farnham Robert gent 619157 619157 Farnham, Robert, of Querndon, gent 0
5068727 2377143 2377143 defendant Dunstall Adam butcher 619157 619157 Dunstall, Adam, of Querndon, butcher 1
5068788 2377160 2377160 defendant Farnham Robert gent 619157 619157 Farnham, Robert, of Querndon, gent 0
5083096 2381452 2381452 defendant Pery John laborer 619157 619157 Pery, John, of Querndon, laborer 2
5103891 2387563 2387563 defendant Pontrell Henry husbandman 619157 619157 Pontrell, Henry, of Querndon, husbandman 0
5114031 2390493 2390493 defendant Barnard Thomas husbandman 619157 619157 Barnard, Thomas, of Querndon, husbandman 0
5122996 2393155 2393155 defendant Blakamour Henry husbandman 619157 619157 Blakamour, Henry, of Querndon, husbandman 0
5122997 2393155 2393155 defendant Pontrell Henry husbandman 619157 619157 Pontrell, Henry, of Querndon, husbandman 1
5125533 2393954 2393954 defendant Blakamore Henry merchant 619157 619157 Blakamore, Henry, of Querndon, merchant 0
5125534 2393954 2393954 defendant Powtrell Henry husbandman 619157 619157 Powtrell, Henry, of Querndon, husbandman 1
5129554 2395131 2395131 defendant Poutrell Henry husbandman 619157 619157 Poutrell, Henry, of Querndon, husbandman 0
5137465 2397469 2397469 defendant Walter William husbandman 619157 619157 Walter, William, of Querndon, husbandman 3
5144172 2399447 2399447 defendant Blakamore Henry merchant 619157 619157 Blakamore, Henry, of Querndon, merchant 0
5144173 2399447 2399447 defendant Powtrell Henry husbandman 619157 619157 Powtrell, Henry, of Querndon, husbandman 1
5144175 2399448 2399448 defendant Blakamore Henry merchant 619157 619157 Blakamore, Henry, of Querndon, merchant 0
5144176 2399448 2399448 defendant Powtrell Henry husbandman 619157 619157 Powtrell, Henry, of Querndon, husbandman 1
5148768 2400761 2400761 defendant Pontrell Henry husbandman 619157 619157 Pontrell, Henry, of Querndon, husbandman 0
5148862 2400790 2400790 defendant Pontrell Henry husbandman 619157 619157 Pontrell, Henry, of Querndon, husbandman 0
5161115 2404351 2404351 defendant Prychet John husbandman 619157 619157 Prychet, John, of Querndon, husbandman 0
5162678 2404805 2404805 defendant Taillour Thomas husbandman 619157 619157 Taillour, Thomas, of Querndon, husbandman 1
5165377 2405621 2405621 defendant Blakamore Henry merchant 619157 619157 Blakamore, Henry, of Querndon, merchant 0
5165378 2405621 2405621 defendant Powtrell Henry husbandman 619157 619157 Powtrell, Henry, of Querndon, husbandman 1
5165380 2405622 2405622 defendant Blakamore Henry merchant 619157 619157 Blakamore, Henry, of Querndon, merchant 0
5165381 2405622 2405622 defendant Powtrell Henry husbandman 619157 619157 Powtrell, Henry, of Querndon, husbandman 1
5175628 2408557 2408557 defendant Prychet John husbandman 619157 619157 Prychet, John, of Querndon, husbandman 0
5181964 2410474 2410474 defendant Farnham John esq 619157 619157 Farnham, John, of Querndon, esq 0
5197054 2414882 2414882 defendant Prychet John husbandman 619157 619157 Prychet, John, of Querndon, husbandman 0
5197057 2414883 2414883 defendant Prychet John husbandman 619157 619157 Prychet, John, of Querndon, husbandman 0
5215027 2420117 2420117 defendant Farnham John esq 619157 619157 Farnham, John, of Querndon, esq 0
5238789 2426933 2426933 defendant Farnham John gent 619157 619157 Farnham, John, of Querndon, gent 4
5238799 2426935 2426935 defendant Farnham John gent 619157 619157 Farnham, John, of Querndon, gent 4
5247598 2429455 2429455 defendant Beeston John miller 619157 619157 Beeston, John, of Querndon, miller 0
5257627 2432505 2432505 defendant Helwys Richard yeoman 619157 619157 Helwys, Richard, of Querndon, yeoman 2
5526912 2512983 2512983 defendant Atkyns John husbandman 619157 619157 Atkyns, John, of Querndon, husbandman 0
5614600 2548366 2548366 plaintiff Farnham John   619157 619157 Farnham, John, of Querndon 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);