names

101 rows where place_id = 597169

✎ 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
3627526 1903468 1903468 plaintiff Bowlys John gent 597169 597169 Bowlys, John, of Walyngton, gent 0
3629618 1904116 1904116 defendant Sydenham John merchant 597169 597169 Sydenham, John, of Walyngton, merchant 2
3630233 1904304 1904304 defendant Newman William husbandman 597169 597169 Newman, William, of Walyngton, husbandman 1
3639992 1907324 1907324 defendant Neunam William husbandman 597169 597169 Neunam, William, of Walyngton, husbandman 2
3645103 1908876 1908876 defendant Newman William husbandman 597169 597169 Newman, William, of Walyngton, husbandman 2
3655509 1911982 1911982 plaintiff Bowles John gent 597169 597169 Bowles, John, of Walyngton, gent 0
3672300 1917337 1917337 defendant Dolphyn Ralph fisher 597169 597169 Dolphyn, Ralph, of Walyngton, fisher 1
3695398 1924784 1924784 defendant Harvy William, junior husbandman 597169 597169 Harvy, William, junior, of Walyngton, husbandman 1
3695400 1924784 1924784 defendant Harvy John husbandman 597169 597169 (Harvy, John, of Walyngton, husbandman 3
3704544 1927716 1927716 defendant Gawsell Thomas gent 597169 597169 Gawsell, Thomas, of Walyngton, gent 0
3718583 1932089 1932089 defendant Gansell Thomas gent 597169 597169 Gansell, Thomas, of Walyngton, gent 0
3807213 1960152 1960152 defendant Leyntall John, senior yeoman 597169 597169 Leyntall, John, senior, of Walyngton, yeoman 0
3810176 1961073 1961073 plaintiff Bowles John gent 597169 597169 Bowles, John, of Walyngton, gent 0
3842056 1971069 1971069 plaintiff Bowles John esq 597169 597169 Bowles, John, of Walyngton, esq 0
3885970 1985560 1985560 defendant Barley John, junior husbandman 597169 597169 Barley, John, junior, of Walyngton, husbandman 0
3899013 1989877 1989877 plaintiff Barley John, junior husbandman 597169 597169 Barley, John, junior, of Walyngton, husbandman 0
3959426 2010381 2010381 defendant Grave Leonard singleman 597169 597169 Grave, Leonard, of Walyngton, singleman 1
3960222 2010675 2010675 defendant Blowe William (legal representative) 597169 597169 Blowe, William, of Walyngton, yeoman, executors of 0
4002552 2025680 2025680 defendant Carrowe Simon husbandman 597169 597169 Carrowe, Simon, of Walyngton, husbandman 1
4442085 2182449 2182449 plaintiff Brid William   597169 597169 Brid, William, of Walyngton 0
4448122 2184335 2184335 plaintiff fitz Geffrey Thomas   597169 597169 fitz Geffrey, Thomas, of Walyngton, parson who warrants 0
4469315 2191075 2191075 defendant Pykkeleve Robert   597169 597169 Pykkeleve, Robert, of Walyngton 0
4470165 2191321 2191321 defendant Roper Thomas   597169 597169 Roper, Thomas, of Walyngton 0
4601711 2231753 2231753 plaintiff Walkerne William   597169 597169 Walkerne, William, of Walyngton 0
4604962 2232713 2232713 plaintiff Aldous William (legal representative) 597169 597169 Aldous, William, of Walyngton, executors of 0
4615172 2235753 2235753 plaintiff Everard Thomas   597169 597169 Everard, Thomas, of Walyngton 0
4632959 2241180 2241180 plaintiff Walkerne William   597169 597169 Walkerne, William, of Walyngton 0
4649710 2245942 2245942 plaintiff Walkern William   597169 597169 Walkern, William, of Walyngton 0
4689659 2262329 2262329 plaintiff Walkern William   597169 597169 Walkern, William, of Walyngton 0
4731044 2274914 2274914 plaintiff Michell Robert   597169 597169 Michell, Robert, of Walyngton 0
4755195 2282012 2282012 defendant Brantfeld John   597169 597169 Brantfeld, John, of Walyngton, mason 0
4761847 2284049 2284049 defendant Burgh John gent 597169 597169 Burgh, John, of Walyngton, gent 0
4773974 2287842 2287842 defendant Brayfeld John   597169 597169 Brayfeld, John, of Walyngton, mason 0
4777088 2288816 2288816 defendant Brantfeld John   597169 597169 Brantfeld, John, of Walyngton, mason 0
4786216 2291729 2291729 defendant Brantfeld John   597169 597169 Brantfeld, John, of Walyngton, mason 0
4825845 2304119 2304119 plaintiff Wakerne William, senior   597169 597169 Wakerne, William, senior, of Walyngton 0
4850558 2311636 2311636 defendant Brantfeld John   597169 597169 Brantfeld, John, of Walyngton, mason 0
4850560 2311637 2311637 defendant Brantfeld John   597169 597169 Brantfeld, John, of Walyngton, mason 0
4863003 2315407 2315407 defendant Everard Walter yeoman 597169 597169 Everard, Walter, of Walyngton, yeoman 0
4863004 2315407 2315407 defendant Blowe Thomas husbandman 597169 597169 Blowe, Thomas, of Walyngton, husbandman 1
4879928 2320636 2320636 defendant Wyn John husbandman 597169 597169 Wyn, John, of Walyngton, husbandman 0
4902167 2327289 2327289 plaintiff Bryd William   597169 597169 Bryd, William, of Walyngton 0
4905067 2328193 2328193 defendant Elot Simon yeoman 597169 597169 Elot, Simon, of Walyngton, yeoman 0
4934274 2337107 2337107 defendant Brodsale John husbandman 597169 597169 Brodsale, John, of Walyngton, husbandman 2
4934371 2337141 2337141 defendant Laver or Laner William (legal representative) 597169 597169 Laver or Laner, William, of Walyngton, executors of 0
4934527 2337193 2337193 defendant Sylkman William   597169 597169 Sylkman, William, of Walyngton, servant 0
4937990 2338258 2338258 defendant Lemman Thomas husbandman 597169 597169 Lemman, Thomas, of Walyngton, husbandman 0
4944667 2340315 2340315 defendant Strother Roger gent 597169 597169 Strother, Roger, of Walyngton, gent 1
4958480 2344506 2344506 defendant Bradshawe John husbandman 597169 597169 Bradshawe, John, of Walyngton, husbandman 1
4963517 2346001 2346001 defendant Lomman Thomas husbandman 597169 597169 Lomman, Thomas, of Walyngton, husbandman 0
5047016 2370730 2370730 defendant Slaughter Ralph husbandman 597169 597169 Slaughter, Ralph, of Walyngton, husbandman 3
5075607 2379203 2379203 defendant Sotill William husbandman 597169 597169 Sotill, William, of Walyngton, husbandman 0
5108877 2389016 2389016 plaintiff Folkemore William, junior carpenter 597169 597169 Folkemore, William, junior, of Walyngton, carpenter 1
5126784 2394308 2394308 defendant Priour Richard yeoman 597169 597169 Priour, Richard, of Walyngton, yeoman 9
5131457 2395685 2395685 plaintiff Geyhoo John   597169 597169 Geyhoo, John, of Walyngton 1
5150859 2401393 2401393 plaintiff Geyhoo John   597169 597169 Geyhoo, John, of Walyngton 1
5180062 2409905 2409905 defendant Lemman Thomas husbandman 597169 597169 Lemman, Thomas, of Walyngton, husbandman 0
5188496 2412353 2412353 defendant Fenwyk John esq 597169 597169 Fenwyk, John, of Walyngton, esq 0
5202240 2416419 2416419 defendant Lemman Thomas husbandman 597169 597169 Lemman, Thomas, of Walyngton, husbandman 0
5209709 2418579 2418579 defendant Power Richard   597169 597169 Power, Richard, of Walyngton, wheel wright 0
5209710 2418579 2418579 defendant Wotton Thomas husbandman 597169 597169 Wotton, Thomas, of Walyngton, husbandman 1
5218603 2421171 2421171 defendant Scudamore William gent 597169 597169 Scudamore, William, of Walyngton, gent 0
5218605 2421172 2421172 defendant Scudamore William gent 597169 597169 Scudamore, William, of Walyngton, gent 0
5237140 2426446 2426446 defendant Hervy John husbandman 597169 597169 Hervy, John, of Walyngton, husbandman 2
5239137 2427036 2427036 plaintiff Hendeley Nicholas   597169 597169 Hendeley, Nicholas, of Walyngton 0
5239722 2427205 2427205 defendant Blowe Richard husbandman 597169 597169 Blowe, Richard, of Walyngton, husbandman 1
5239723 2427205 2427205 defendant Hervy Nicholas husbandman 597169 597169 Hervy, Nicholas, of Walyngton, husbandman 2
5239724 2427205 2427205 defendant Kyllyg Robert husbandman 597169 597169 Kyllyg, Robert, of Walyngton, husbandman 3
5239725 2427205 2427205 defendant Hervy John, junior husbandman 597169 597169 Hervy, John, junior, of Walyngton, husbandman 4
5239726 2427205 2427205 defendant Folkemere William husbandman 597169 597169 Folkemere, William, of Walyngton, husbandman 5
5239727 2427205 2427205 defendant Folkemere John husbandman 597169 597169 Folkemere, John, of Walyngton, husbandman 6
5251617 2430609 2430609 defendant Hervy John butcher 597169 597169 Hervy, John, of Walyngton, butcher 0
5253316 2431139 2431139 defendant Lemman Thomas yeoman 597169 597169 Lemman, Thomas, of Walyngton, yeoman 0
5258746 2432855 2432855 defendant Hervy John, senior butcher 597169 597169 Hervy, John, senior, of Walyngton, butcher 0
5271313 2436703 2436703 defendant Haughton William gent 597169 597169 Haughton, William, of Walyngton, gent 0
5284343 2440438 2440438 defendant Kylbygge Robert smith 597169 597169 Kylbygge, Robert, of Walyngton, smith 2
5287003 2441210 2441210 defendant Deynys Walter gent 597169 597169 Deynys, Walter, of Walyngton, gent 0
5317953 2450459 2450459 defendant Kylbygge Robert smith 597169 597169 Kylbygge, Robert, of Walyngton, smith 1
5346474 2459043 2459043 defendant Pollard William husbandman 597169 597169 Pollard, William, of Walyngton, husbandman 0
5349062 2459834 2459834 plaintiff Burgh Thomas gent 597169 597169 Burgh, Thomas, of Walyngton, gent 0
5358553 2462735 2462735 defendant Punchon William carpenter 597169 597169 Punchon, William, of Walyngton, or of Cressalton, carpenter 0
5373474 2467298 2467298 defendant Reynys John husbandman 597169 597169 Reynys, John, of Walyngton, husbandman 0
5376962 2468391 2468391 defendant Kekall William gent 597169 597169 Kekall, William, of Walyngton, gent 0
5389643 2472100 2472100 defendant Folkemare John, junior husbandman 597169 597169 Folkemare, John, junior, of Walyngton, husbandman 0
5389673 2472108 2472108 defendant Hervy William husbandman 597169 597169 Hervy, William, of Walyngton, husbandman 2
5402369 2475752 2475752 defendant Folkemare John, junior husbandman 597169 597169 Folkemare, John, junior, of Walyngton, husbandman 0
5431462 2484364 2484364 defendant Folkemare Robert husbandman 597169 597169 Folkemare, Robert, of Walyngton, husbandman 0
5470472 2496088 2496088 defendant Warner Walter husbandman 597169 597169 Warner, Walter, of Walyngton, husbandman 0
5488846 2501538 2501538 defendant Parys Reginald husbandman 597169 597169 Parys, Reginald, of Walyngton, husbandman 0
5488849 2501538 2501538 defendant Folkemere John, senior husbandman 597169 597169 Folkemere, John, senior, of Walyngton, husbandman 3
5510414 2508098 2508098 defendant Foltemere John husbandman 597169 597169 Foltemere, John, of Walyngton, husbandman 2
5544707 2518454 2518454 defendant Calverley John husbandman 597169 597169 Calverley, John, of Walyngton, husbandman 2
5550235 2520102 2520102 defendant Kynge John husbandman 597169 597169 Kynge, John, of Walyngton, husbandman 0
5562596 2523662 2523662 defendant Hicche John husbandman 597169 597169 Hicche, John, of Walyngton, husbandman 1
5585806 2530618 2530618 plaintiff Gowsell Richard gent 597169 597169 Gowsell, Richard, of Walyngton, gent 2
5591589 2532350 2532350 defendant Kebell William (legal representative) 597169 597169 Kebell, William, of Walyngton, gent, administrator of 0
5601208 2535266 2535266 plaintiff Gowcell Richard gent 597169 597169 Gowcell, Richard, of Walyngton, gent 2
5601212 2535267 2535267 plaintiff Gowcell Richard gent 597169 597169 Gowcell, Richard, of Walyngton, gent 2
5622566 2550989 2550989 defendant Lacchebury Walter   597169 597169 Lacchebury, Walter, of Walyngton 1
5634822 2554888 2554888 plaintiff Walkern William   597169 597169 Walkern, William, of Walyngton 0

Next page

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