names

69 rows where place_id = 588052

✎ 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
3593192 1865501 1865501 defendant Spence or Spencer Thomas yeoman 588052 588052 Spence or Spencer, Thomas, of Kyngeston on Thames, Surrey, yeoman 2
3595386 1866188 1866188 defendant Soper Richard chapman 588052 588052 Soper, Richard, of Kyngeston on Thames, Surrey, chapman 0
3596288 1866469 1866469 defendant Stamford John innholder 588052 588052 Stamford, John, of Kyngeston on Thames, Surrey, innholder 1
3612508 1871542 1871542 defendant Bone Thomas husbandman 588052 588052 Bone, Thomas, of Kyngeston on Thames, Surrey, husbandman 11
3617146 1872986 1872986 defendant Mylam Clement yeoman 588052 588052 Mylam, Clement, of Kyngeston on Thames, Surrey, yeoman 2
3617570 1873118 1873118 defendant Hall John dyer 588052 588052 Hall, John, of Kyngeston on Thames, Surrey, dyer 4
3618649 1873459 1873459 defendant Boll William brewer 588052 588052 Boll, William, of Kyngeston on Thames, Surrey, brewer 4
3625087 1875381 1875381 defendant Stephenson Hugh yeoman 588052 588052 Stephenson, Hugh, of Kyngeston on Thames, Surrey, yeoman 0
3635895 1906023 1906023 defendant Whyghtbred John butcher 588052 588052 Whyghtbred, John, of Kyngeston on Thames, Surrey, butcher 2
3638792 1906953 1906953 defendant Virgo William innholder 588052 588052 Virgo, William, of Kyngeston on Thames, Surrey, innholder 0
3644534 1908707 1908707 defendant Skerne Swithun gent 588052 588052 Skerne, Swithun, of Kyngeston on Thames, Surrey, gent 1
3648927 1910053 1910053 defendant Starky John gent 588052 588052 Starky, John, of Kyngeston on Thames, Surrey, gent 0
3651429 1910811 1910811 defendant Virgo William yeoman 588052 588052 Virgo, William, of Kyngeston on Thames, Surrey, yeoman 0
3651432 1910812 1910812 defendant Virgo William yeoman 588052 588052 Virgo, William, of Kyngeston on Thames, Surrey, yeoman 0
3652753 1911180 1911180 defendant Starkey John gent 588052 588052 Starkey, John, of Kyngeston on Thames, Surrey, gent 0
3674863 1918166 1918166 defendant Batron William yeoman 588052 588052 Batron, William, of Kyngeston on Thames, Surrey, yeoman 0
3692791 1923936 1923936 defendant Chapman John barber 588052 588052 Chapman, John, of Kyngeston on Thames, Surrey, barber 0
3705490 1928008 1928008 defendant Vynar John yeoman 588052 588052 Vynar, John, of Kyngeston on Thames, Surrey, yeoman 4
3713816 1930619 1930619 defendant Shale William yeoman of the crown 588052 588052 Shale, William, of Kyngeston on Thames, Surrey, yeoman of the crown 0
3719159 1932277 1932277 plaintiff Grover John   588052 588052 Grover, John, of Kyngeston on Thames, Surrey, draper, executirx of 0
3729253 1935399 1935399 defendant Shale William yeoman of the crown 588052 588052 Shale, William, of Kyngeston on Thames, Surrey, yeoman of the crown 0
3733328 1936654 1936654 plaintiff Clerke Richard gent 588052 588052 Clerke, Richard, of Kyngeston on Thames, Surrey, gent 1
3767005 1947346 1947346 plaintiff Moorer William mercer 588052 588052 Moorer, William, of Kyngeston on Thames, Surrey, mercer 0
3784448 1952918 1952918 defendant Snowe John butcher 588052 588052 Snowe, John, of Kyngeston on Thames, Surrey, butcher 0
3784450 1952919 1952919 defendant Snowe John butcher 588052 588052 Snowe, John,of Kyngeston on Thames, Surrey, butcher 0
3803173 1958895 1958895 defendant Shale alias Fryer William yeoman of the crown 588052 588052 Shale alias Fryer, William, of Kyngeston on Thames, Surrey, yeoman of the crown 0
3804245 1959261 1959261 plaintiff Shale alias Fryer William yeoman of the crown 588052 588052 Shale alias Fryer, William, of Kyngeston on Thames, Surrey, yeoman of the crown 0
3820400 1964260 1964260 defendant Saunders John shoemaker 588052 588052 Saunders, John, of Kyngeston on Thames, Surrey, shoemaker 0
3833988 1968572 1968572 defendant Snowe John butcher 588052 588052 Snowe, John, of Kyngeston on Thames, Surrey, butcher 0
3833996 1968573 1968573 defendant Snowe John butcher 588052 588052 Snowe, John, of Kyngeston on Thames, Surrey, butcher 1
3838784 1970058 1970058 defendant Agmondesham John gent 588052 588052 Agmondesham, John, of Kyngeston on Thames, Surrey, gent 0
3888617 1986448 1986448 defendant Peny John   588052 588052 Peny, John, of Kyngeston on Thames, Surrey, freemason 0
3888629 1986453 1986453 defendant Peny John   588052 588052 (Peny, John, of Kyngeston on Thames, Surrey, freemason 1
3892931 1987883 1987883 defendant Grece Robert yeoman 588052 588052 Grece, Robert, of Kyngeston on Thames, Surrey, yeoman 2
3896994 1989211 1989211 defendant Plathwayte alias Playfote John sherman 588052 588052 Plathwayte alias Playfote, John, of Kyngeston on Thames, Surrey, sherman 0
3897549 1989393 1989393 defendant Dene William   588052 588052 Dene, William, of Kyngeston on Thames, Surrey, yeoman, king's surveyor at Hamton Court 1
3900811 1990501 1990501 defendant Draper John butcher 588052 588052 Draper, John, of Kyngeston on Thames, Surrey, butcher 0
3900964 1990549 1990549 defendant Deane William yeoman 588052 588052 (Deane, William, of Kyngeston on Thames, Surrey, yeoman 1
3912849 1994627 1994627 defendant Ford Julia widow 588052 588052 Ford, Julia, of Kyngeston on Thames, Surrey, widow 0
4038929 2038544 2038544 defendant Gould John husbandman 588052 588052 Gould, John, of Kyngeston on Thames, Surrey, husbandman 1
5076574 2379497 2379497 defendant Gregory Thomas dyer 588052 588052 Gregory, Thomas, of Kyngeston on Thames, Surrey, dyer 0
5114953 2390788 2390788 defendant Welyngham William ostler 588052 588052 Welyngham, William, of Kyngeston on Thames, Surrey, ostler 2
5162113 2404652 2404652 defendant Cotes George chapman 588052 588052 Cotes, George, of Kyngeston on Thames, Surrey, chapman 3
5224265 2422769 2422769 defendant Hert John draper 588052 588052 Hert, John, of Kyngeston on Thames, Surrey, draper 0
5246244 2429063 2429063 defendant Spycer Thomas husbandman 588052 588052 Spycer, Thomas, of Kyngeston on Thames, Surrey, husbandman 0
5258966 2432919 2432919 defendant Lambale or Lamvale Richard yeoman 588052 588052 Lambale or Lamvale, Richard, of Kyngeston on Thames, Surrey, yeoman 2
5280022 2439230 2439230 defendant Skerne Robert esq 588052 588052 Skerne, Robert, of Kyngeston on Thames, Surrey, esq 0
5280027 2439231 2439231 defendant Skerne Robert esq 588052 588052 Skerne, Robert, of Kyngeston on Thames, Surrey, esq 0
5309274 2447810 2447810 defendant Fourde William yeoman 588052 588052 Fourde, William, of Kyngeston on Thames, Surrey, yeoman 0
5316774 2450103 2450103 defendant Kyngeston Thomas yeoman 588052 588052 Kyngeston, Thomas, of Kyngeston on Thames, Surrey, yeoman 0
5325087 2452585 2452585 defendant Skern Robert esq 588052 588052 Skern, Robert, of Kyngeston on Thames, Surrey, esq 0
5331406 2454471 2454471 defendant Skern Robert esq 588052 588052 Skern, Robert, of Kyngeston on Thames, Surrey, esq 0
5331830 2454599 2454599 defendant Kyngeston Thomas ostler or innholder 588052 588052 Kyngeston, Thomas, of Kyngeston on Thames, Surrey, ostler or innholder 2
5341466 2457523 2457523 defendant Skyrn Robert esq 588052 588052 Skyrn, Robert, of Kyngeston on Thames, Surrey, esq 2
5358267 2462641 2462641 defendant Parker Richard skinner 588052 588052 Parker, Richard, of Kyngeston on Thames, Surrey, skinner 1
5361935 2463759 2463759 defendant Skerne Robert esq 588052 588052 Skerne, Robert, of Kyngeston on Thames, Surrey, esq 0
5487391 2501123 2501123 defendant Claye Henry yeoman of Ric III 588052 588052 Claye, Henry, of Kyngeston on Thames, Surrey, yeoman of Ric III 1
5489124 2501631 2501631 defendant Comersale William yeoman 588052 588052 Comersale, William, of Kyngeston on Thames, Surrey, yeoman 1
5499375 2504754 2504754 defendant Gyllot Thomas husbandman 588052 588052 Gyllot, Thomas, of Kyngeston on Thames, Surrey, husbandman 3
5503387 2505968 2505968 defendant Dorset George cordwainer 588052 588052 Dorset, George, of Kyngeston on Thames, Surrey, cordwainer 0
5509380 2507783 2507783 defendant Holgrave William yeoman 588052 588052 Holgrave, William, of Kyngeston on Thames, Surrey, yeoman 0
5534665 2515386 2515386 defendant Virgo William innholder 588052 588052 Virgo, William, of Kyngeston on Thames, Surrey, innholder 0
5539428 2516820 2516820 defendant Ware Nicholas dyer 588052 588052 Ware, Nicholas, of Kyngeston on Thames, Surrey, dyer 0
5560089 2522910 2522910 defendant Mauncy John carpenter 588052 588052 Mauncy, John, of Kyngeston on Thames, Surrey, carpenter 3
5567550 2525082 2525082 defendant Spicer John chapman 588052 588052 Spicer, John, of Kyngeston on Thames, Surrey, chapman 1
5579322 2528610 2528610 defendant Colyns John yeoman 588052 588052 Colyns, John, of Kyngeston on Thames, Surrey, yeoman 0
5579325 2528611 2528611 defendant Colyns John yeoman 588052 588052 Colyns, John, of Kyngeston on Thames, Surrey, yeoman 1
5580184 2528887 2528887 defendant Willot William yeoman 588052 588052 Willot, William, of Kyngeston on Thames, Surrey, yeoman 3
5606060 2536785 2536785 defendant Verygo William yeoman 588052 588052 Verygo, William, of Kyngeston on Thames, Surrey, yeoman 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);