names

96 rows where place_id = 595660

✎ 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
3621383 1874228 1874228 defendant Toke John husbandman 595660 595660 Toke, John, of Walpole, Norf, husbandman 1
3621769 1874347 1874347 defendant Browne John clerk 595660 595660 Browne, John, of Walpole, Norf, clerk 1
3654163 1911565 1911565 defendant Welpedale William yeoman 595660 595660 Welpedale, William, of Walpole, Norf, yeoman 0
3729887 1935602 1935602 defendant Parker George husbandman and cart driver 595660 595660 Parker, George, of Walpole, Norf, husbandman and cart driver 2
3750884 1942198 1942198 defendant Hunston Henry gent 595660 595660 Hunston, Henry, of Walpole, Norf, gent 0
3871358 1980670 1980670 defendant Whetham John clerk 595660 595660 Whetham, John, of Walpole, Norf, clerk 1
3889448 1986702 1986702 defendant Orgar Robert husbandman 595660 595660 Orgar, Robert, of Walpole, Norf, husbandman 3
3894123 1988251 1988251 defendant Smythson James husbandman 595660 595660 Smythson, James, of Walpole, Norf, husbandman 0
3901486 1990720 1990720 defendant Hunston William gent 595660 595660 Hunston, William, of Walpole, Norf, gent 0
3901488 1990721 1990721 defendant Smythson James yeoman 595660 595660 Smythson, James, of Walpole, Norf, yeoman 0
3901490 1990722 1990722 defendant Smythson James yeoman 595660 595660 Smythson, James, of Walpole, Norf, yeoman 0
3937131 2002753 2002753 defendant Harte Simons yeoman 595660 595660 Harte, Simons, of Walpole, Norf, yeoman 3
3959480 2010406 2010406 defendant Knyght Robert yeoman 595660 595660 Knyght, Robert, of Walpole, Norf, yeoman 0
3960189 2010664 2010664 defendant Myller alias Smyth Richard smith 595660 595660 Myller alias Smyth, Richard, of Walpole, Norf, smith 1
3982732 2018593 2018593 defendant Tooke Thomas yeoman 595660 595660 Tooke, Thomas, of Walpole, Norf, yeoman 0
3991016 2021550 2021550 plaintiff Bothomley Richard yeoman 595660 595660 Bothomley, Richard, of Walpole, Norf, yeoman 0
4009623 2028210 2028210 defendant Feane or Fayne Roger husbandman 595660 595660 Feane or Fayne, Roger, of Walpole, Norf, husbandman 4
4009628 2028212 2028212 defendant Reppes John gent 595660 595660 Reppes, John, of Walpole, Norf, gent 0
4009873 2028307 2028307 defendant Reppes John gent 595660 595660 Reppes, John, of Walpole, Norf, gent 0
4061697 2046583 2046583 defendant Cawnerbye William husbandman 595660 595660 Cawnerbye, William, of Walpole, Norf, husbandman 0
4071385 2050065 2050065 defendant Robynson Adam glasier 595660 595660 Robynson, Adam, of Walpole, Norf, or of Ely, Cams, glasier 0
4092938 2057783 2057783 defendant Austen Walter husbandman 595660 595660 Austen, Walter, of Walpole, Norf, husbandman 2
4096226 2058978 2058978 defendant Watson John yeoman 595660 595660 Watson, John, of Walpole, Norf, yeoman 0
4128180 2070367 2070367 defendant Hunston Henry gent 595660 595660 Hunston, Henry, of Walpole, Norf, gent 0
4132351 2071884 2071884 defendant Hunston Henry esq 595660 595660 Hunston, Henry, of Walpole, Norf, gent, son of William Hunston, esq 0
4155222 2079918 2079918 defendant Hunston Henry gent 595660 595660 Hunston, Henry, of Walpole, Norf, gent 3
4156596 2080384 2080384 defendant Hunston Henry esq 595660 595660 Hunston, Henry, of Walpole, Norf, gent, son of William Hunston, esq 0
4169181 2084722 2084722 defendant Hunston Henry gent 595660 595660 Hunston, Henry, of Walpole, Norf, gent 0
4169189 2084725 2084725 defendant Hunston Henry gent 595660 595660 Hunston, Henry, of Walpole, Norf, gent 0
4180596 2088697 2088697 defendant Hunston Henry gent 595660 595660 Hunston, Henry, of Walpole, Norf, gent 0
4242358 2110442 2110442 defendant Snellinge Adam laborer 595660 595660 Snellinge, Adam, of Walpole, Norf, laborer 1
4340152 2143816 2143816 defendant Gibbes Richard butcher 595660 595660 Gibbes, Richard, of Walpole, Norf, butcher 1
4340473 2143934 2143934 defendant Farthinge Robert yeoman 595660 595660 Farthinge, Robert, of Walpole, Norf, yeoman 2
4357678 2149919 2149919 defendant Jones Brigit widow 595660 595660 Jones, Brigit, of Walpole, Norf, widow 4
4669547 2256181 2256181 defendant Boure Robert husbandman & son of Walter Boure 595660 595660 Boure, Robert, of Walpole, Norf, husbandman & son of Walter Boure 0
4681455 2259816 2259816 defendant Austyn Richard chaplain 595660 595660 Austyn, Richard, of Walpole, Norf, chaplain 2
4770292 2286680 2286680 defendant Tyler Richard brewer 595660 595660 Tyler, Richard, of Walpole, Norf, brewer 0
4784819 2291259 2291259 defendant Broke John yeoman 595660 595660 Broke, John, of Walpole, Norf, yeoman 1
4785357 2291436 2291436 defendant Boure John esq 595660 595660 Boure, John, of Walpole, Norf, esq 1
4785368 2291439 2291439 defendant Boure John esq 595660 595660 Boure, John, of Walpole, Norf, esq 1
4802063 2296831 2296831 plaintiff Yorke Nicholas chaplain 595660 595660 Yorke, Nicholas, of Walpole, Norf, chaplain 0
4803126 2297168 2297168 defendant Broune Wiliam chapman 595660 595660 Broune, Wiliam, of Walpole, Norf, chapman 1
4900732 2326868 2326868 defendant Tomson William yeoman 595660 595660 Tomson, William, of Walpole, Norf, yeoman 1
4913642 2330761 2330761 defendant Kyng John husbandman 595660 595660 Kyng, John, of Walpole, Norf, husbandman 2
4937429 2338078 2338078 defendant Boure Peter chaplain 595660 595660 Boure, Peter, of Walpole, Norf, chaplain 0
4940235 2338975 2338975 defendant Pepir Geoffrey husbandman 595660 595660 Pepir, Geoffrey, of Walpole, Norf, husbandman 3
4978781 2350604 2350604 defendant Reve John chaplain 595660 595660 Reve, John, of Walpole, Norf, chaplain 1
4991591 2354368 2354368 defendant Perte William chapman 595660 595660 Perte, William, of Walpole, Norf, chapman 1
5008601 2359409 2359409 defendant Rawlyn John butcher 595660 595660 Rawlyn, John, of Walpole, Norf, butcher 0
5015481 2361410 2361410 defendant Rocheford Ralph esq 595660 595660 Rocheford, Ralph, of Walpole, Norf, esq 0
5015483 2361411 2361411 defendant Rocheford Ralph esq 595660 595660 Rocheford, Ralph, of Walpole, Norf, esq 0
5016298 2361657 2361657 defendant Kyng John chapman 595660 595660 Kyng, John, of Walpole, Norf, chapman 1
5026819 2364716 2364716 defendant Bocher Simon husbandman 595660 595660 Bocher, Simon, of Walpole, Norf, husbandman 2
5035130 2367138 2367138 defendant Rawlyn John butcher 595660 595660 Rawlyn, John, of Walpole, Norf, butcher 0
5079354 2380322 2380322 defendant Danyell William carter 595660 595660 Danyell, William, of Walpole, Norf, carter 4
5105081 2387921 2387921 defendant Payn Thomas yeoman 595660 595660 Payn, Thomas, of Walpole, Norf, yeoman 0
5133998 2396440 2396440 defendant Aston John   595660 595660 Aston, John, of Walpole, Norf, mill wright 0
5134991 2396733 2396733 defendant Davyson John clerk 595660 595660 Davyson, John, of Walpole, Norf, clerk 0
5155052 2402631 2402631 defendant Davyson John clerk & parson 595660 595660 Davyson, John, of Walpole, Norf, clerk & parson 0
5155643 2402808 2402808 defendant Sutton (illegible) gent 595660 595660 Sutton, _, of Walpole, Norf, gent 0
5160217 2404085 2404085 defendant Kyvell or Kynell John yeoman 595660 595660 Kyvell or Kynell, John, of Walpole, Norf, yeoman 0
5172184 2407587 2407587 defendant Sutton Philip gent 595660 595660 Sutton, Philip, of Walpole, Norf, gent 0
5175112 2408416 2408416 defendant Kyvell John yeoman 595660 595660 Kyvell, John, of Walpole, Norf, yeoman 0
5178237 2409339 2409339 defendant Kyng John chapman 595660 595660 Kyng, John, of Walpole, Norf, chapman 0
5191386 2413222 2413222 defendant Sutton John gent 595660 595660 Sutton, John, of Walpole, Norf, gent 0
5201349 2416152 2416152 defendant Kyng John chapman 595660 595660 Kyng, John, of Walpole, Norf, chapman 0
5215347 2420218 2420218 defendant Damet Thomas gent 595660 595660 Damet, Thomas, of Walpole, Norf, gent 0
5215350 2420219 2420219 defendant Damet Thomas gent 595660 595660 Damet, Thomas, of Walpole, Norf, gent 0
5240941 2427554 2427554 defendant Cannok John clerk 595660 595660 Cannok, John, of Walpole, Norf, clerk 0
5244126 2428473 2428473 defendant Doughty John chaplain 595660 595660 Doughty, John, of Walpole, Norf, chaplain 1
5249074 2429850 2429850 defendant Neuhous Thomas husbandman 595660 595660 Neuhous, Thomas, of Walpole, Norf, husbandman 1
5249080 2429851 2429851 defendant Neuhous Thomas husbandman 595660 595660 Neuhous, Thomas, of Walpole, Norf, husbandman 1
5269943 2436317 2436317 defendant Lane Robert yeoman 595660 595660 Lane, Robert, of Walpole, Norf, yeoman 3
5280373 2439336 2439336 defendant Clay Robert gent 595660 595660 Clay, Robert, of Walpole, Norf, gent 3
5280378 2439337 2439337 defendant Clay Robert gent 595660 595660 Clay, Robert, of Walpole, Norf, gent 3
5280453 2439356 2439356 defendant Frost Thomas husbandman 595660 595660 Frost, Thomas, of Walpole, Norf, husbandman 2
5315140 2449585 2449585 defendant Heywode Richard yeoman 595660 595660 Heywode, Richard, of Walpole, Norf, yeoman 0
5315925 2449838 2449838 defendant Este John husbandman 595660 595660 Este, John, of Walpole, Norf, husbandman 2
5324207 2452327 2452327 defendant Mayhewe Thomas (legal representative) 595660 595660 Mayhewe, Thomas, of Walpole, Norf, yeoman, executrix of 0
5349591 2460007 2460007 defendant Brandon Robert esq 595660 595660 Brandon, Robert, of Walpole, Norf, esq 1
5350723 2460336 2460336 defendant Dykyll John husbandman 595660 595660 Dykyll, John, of Walpole, Norf, husbandman 1
5370782 2466449 2466449 defendant Degyll John husbandman 595660 595660 Degyll, John, of Walpole, Norf, husbandman 0
5370849 2466471 2466471 defendant Degyll John husbandman 595660 595660 Degyll, John, of Walpole, Norf, husbandman 0
5456008 2491710 2491710 defendant Edward William husbandman 595660 595660 Edward, William, of Walpole, Norf, husbandman 0
5480835 2499226 2499226 defendant Sherman Robert husbandman 595660 595660 Sherman, Robert, of Walpole, Norf, husbandman 4
5484201 2500202 2500202 defendant Sutton Philip (legal representative) 595660 595660 Sutton, Philip, of Walpole, Norf, gent, executor of 3
5486943 2500990 2500990 defendant Shelys Simon innholder 595660 595660 Shelys, Simon, of Walpole, Norf, innholder 2
5497466 2504183 2504183 defendant Hounston Thomas gent 595660 595660 Hounston, Thomas, of Walpole, Norf, gent 1
5503383 2505966 2505966 defendant Hunston Thomas gent 595660 595660 Hunston, Thomas, of Walpole, Norf, gent 1
5529104 2513618 2513618 defendant Browne John (legal representative) 595660 595660 Browne, John, of Walpole, Norf, clerk, executor of 0
5530266 2513974 2513974 defendant Heywode Richard yeoman 595660 595660 Heywode, Richard, of Walpole, Norf, yeoman 0
5530269 2513975 2513975 defendant Heywode Richard yeoman 595660 595660 Heywode, Richard, of Walpole, Norf, yeoman 0
5549964 2520026 2520026 defendant Hunston Henry gent 595660 595660 Hunston, Henry, of Walpole, Norf, gent 0
5565075 2524373 2524373 defendant Hunston Henry gent 595660 595660 Hunston, Henry, of Walpole, Norf, gent 0
5603823 2536063 2536063 defendant Hubert John husbandman 595660 595660 Hubert, John, of Walpole, Norf, husbandman 1
5605363 2536556 2536556 defendant Googhe Peter husbandman 595660 595660 Googhe, Peter, of Walpole, Norf, 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);