names

71 rows where place_id = 603666

✎ 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
3655328 1911925 1911925 defendant Owte Richard husbandman 603666 603666 Owte, Richard, of Wytton, husbandman 0
3666483 1915464 1915464 defendant Carre Robert gent 603666 603666 Carre, Robert, of Wytton, gent 3
3720594 1932724 1932724 defendant Myles John husbandman 603666 603666 Myles, John, of Wytton, husbandman 0
3733930 1936858 1936858 defendant Smyth Robert husbandman 603666 603666 Smyth, Robert, of Wytton, husbandman 0
3747571 1941157 1941157 defendant Reynston John husbandman 603666 603666 Reynston, John, of Wytton, husbandman 1
3748821 1941567 1941567 defendant Palgrave John husbandman 603666 603666 Palgrave, John, of Wytton, husbandman 0
3750415 1942050 1942050 plaintiff Love Edward (legal representative) 603666 603666 Love, Edward, of Wytton, executors of 0
3750416 1942050 1942050 plaintiff Drake William   603666 603666 (Drake, William, of Wytton 1
3761445 1945593 1945593 defendant Reynston John husbandman 603666 603666 Reynston, John, of Wytton, husbandman 0
3777933 1950807 1950807 defendant Markam William yeoman 603666 603666 Markam, William, of Wytton, yeoman 0
3777934 1950807 1950807 defendant Richardson Robert yeoman 603666 603666 Richardson, Robert, of Wytton, yeoman 1
3802339 1958631 1958631 defendant Wynche William cooper 603666 603666 Wynche, William, of Wytton, cooper 0
3802340 1958631 1958631 defendant Longe Robert laborer 603666 603666 Longe, Robert, of Wytton, laborer 1
3822345 1964895 1964895 defendant Masterman Thomas yeoman 603666 603666 Masterman, Thomas, of Wytton, yeoman 5
3894284 1988306 1988306 defendant Hurst George husbandman 603666 603666 Hurst, George, of Wytton, husbandman 0
3959991 2010593 2010593 defendant Bennett William   603666 603666 Bennett, William, of Wytton, worsted weaver 0
3972878 2015086 2015086 defendant Shorte Lawrence husbandman 603666 603666 Shorte, Lawrence, of Wytton, husbandman 0
4002570 2025689 2025689 defendant Dade John gent 603666 603666 Dade, John, of Wytton, gent 0
4032580 2036302 2036302 defendant Massy Richard gent 603666 603666 Massy, Richard, of Wytton, gent 1
4032584 2036303 2036303 defendant Massy Richard gent 603666 603666 Massy, Richard, of Wytton, gent 1
4042313 2039732 2039732 defendant Dade John gent 603666 603666 Dade, John, of Wytton, gent 0
4046210 2041086 2041086 plaintiff Shorte Lawrence husbandman 603666 603666 Shorte, Lawrence, of Wytton, husbandman 0
4046682 2041266 2041266 defendant Dade John gent 603666 603666 Dade, John, of Wytton, gent 0
4047650 2041606 2041606 defendant Dade John gent 603666 603666 Dade, John, of Wytton, gent 0
4050116 2042472 2042472 defendant Dande or Daude John gent 603666 603666 Dande or Daude, John, of Wytton, gent 0
4061194 2046412 2046412 plaintiff Drake William yeoman 603666 603666 Drake, William, of Wytton, yeoman 0
4072567 2050493 2050493 defendant Graye Thomas tailor 603666 603666 Graye, Thomas, of Wytton, tailor 1
4072568 2050493 2050493 defendant Drake Robert yeoman 603666 603666 Drake, Robert, of Wytton, yeoman 2
4075079 2051389 2051389 defendant Dade John gent 603666 603666 Dade, John, of Wytton, gent 0
4085720 2055164 2055164 defendant Scotte Hugh yeoman 603666 603666 Scotte, Hugh, of Wytton, yeoman 0
4092620 2057669 2057669 defendant Rowseley Thomas gent 603666 603666 Rowseley, Thomas, of Wytton, gent 0
4104243 2061793 2061793 defendant Berye Robert clerk 603666 603666 Berye, Robert, of Wytton, clerk 0
4126903 2069915 2069915 defendant Boothe Edward clerk 603666 603666 Boothe, Edward, of Wytton, clerk 2
4134188 2072552 2072552 defendant Berrye Robert clerk 603666 603666 Berrye, Robert, of Wytton, clerk 1
4172157 2085721 2085721 defendant Elwyn Robert husbandman 603666 603666 Elwyn, Robert, of Wytton, husbandman 3
4175044 2086737 2086737 defendant Drake Robert yeoman 603666 603666 Drake, Robert, of Wytton, yeoman 0
4213998 2100418 2100418 defendant Churche Christopher husbandman 603666 603666 Churche, Christopher, of Wytton, husbandman 0
4213999 2100418 2100418 defendant Bradfeild Joseph husbandman 603666 603666 Bradfeild, Joseph, of Wytton, husbandman 1
4214004 2100419 2100419 defendant Myles John husbandman 603666 603666 Myles, John, of Wytton, husbandman 1
4214005 2100419 2100419 defendant Bamford or Bainford Leonard husbandman 603666 603666 Bamford or Bainford, Leonard, of Wytton, husbandman 2
4249088 2112680 2112680 defendant Hennont or Hennout Edmund, senior yeoman 603666 603666 Hennont or Hennout, Edmund, senior, of Wytton, yeoman 0
4249089 2112680 2112680 defendant Hennont or Hennout John yeoman 603666 603666 Hennont or Hennout, John, of Wytton, yeoman 1
4249090 2112680 2112680 defendant Cherye Henry mariner 603666 603666 Cherye, Henry, of Wytton, mariner 2
4249091 2112680 2112680 defendant Fayerman Thomas husbandman 603666 603666 Fayerman, Thomas, of Wytton, husbandman 3
4250341 2113095 2113095 defendant Hasting Thomas tailor 603666 603666 Hasting, Thomas, of Wytton, tailor 3
4334610 2141845 2141845 defendant Bamford or Bainford Leonard yeoman 603666 603666 Bamford or Bainford, Leonard, of Wytton, yeoman 2
4374491 2155942 2155942 defendant Barker Ralph yeoman 603666 603666 Barker, Ralph, of Wytton, yeoman 1
4462200 2188877 2188877 plaintiff Swetyng Henry   603666 603666 Swetyng, Henry, of Wytton 0
4482126 2195119 2195119 plaintiff Mascal John, junior   603666 603666 Mascal, John, junior, of Wytton 0
4517267 2205801 2205801 defendant Coo Randolf   603666 603666 Coo, Randolf, of Wytton 0
4528859 2209306 2209306 defendant Koo Ralph   603666 603666 Koo, Ralph, of Wytton 0
4608726 2233833 2233833 defendant Burwell John   603666 603666 Burwell, John, of Wytton 2
4620072 2237258 2237258 defendant Cook Richard   603666 603666 Cook, Richard, of Wytton 0
4655334 2247559 2247559 defendant Tycell or Tyrell Richard husbandman 603666 603666 Tycell or Tyrell, Richard, of Wytton, husbandman 1
4705816 2267191 2267191 defendant Wytton John gent 603666 603666 Wytton, John, of Wytton, gent 0
4892250 2324318 2324318 defendant Colyns Henry husbandman 603666 603666 Colyns, Henry, of Wytton, husbandman 0
4905055 2328190 2328190 defendant Colyn John, senior husbandman 603666 603666 Colyn, John, senior, of Wytton, husbandman 0
4984451 2352284 2352284 plaintiff Wilton John   603666 603666 Wilton, John, of Wytton 0
5136886 2397308 2397308 defendant Lethome Robert gent 603666 603666 with Lethome, Robert, of Wytton, gent 4
5136898 2397310 2397310 defendant Dokeworth Ellis yeoman 603666 603666 Dokeworth, Ellis, of Wytton, yeoman 3
5136899 2397310 2397310 defendant Coket John yeoman 603666 603666 Coket, John, of Wytton, yeoman 4
5219441 2421413 2421413 defendant Belott Richard yeoman 603666 603666 Belott, Richard, of Wytton, yeoman 2
5229229 2424159 2424159 plaintiff Wylton John gent 603666 603666 Wylton, John, of Wytton, gent 0
5252499 2430891 2430891 defendant Corbury Richard husbandman 603666 603666 Corbury, Richard, of Wytton, husbandman 3
5252500 2430891 2430891 defendant Walle Thomas husbandman 603666 603666 Walle, Thomas, of Wytton, husbandman 4
5315283 2449625 2449625 defendant Couper Alan husbandman 603666 603666 Couper, Alan, of Wytton, husbandman 0
5315284 2449625 2449625 defendant Moye John husbandman 603666 603666 Moye, John, of Wytton, husbandman 1
5526842 2512962 2512962 defendant Nicollys Simon husbandman 603666 603666 Nicollys, Simon, of Wytton, husbandman 1
5526864 2512970 2512970 defendant Garbotte Robert husbandman 603666 603666 Garbotte, Robert, of Wytton, husbandman 1
5548024 2519453 2519453 defendant Baseley John husbandman 603666 603666 Baseley, John, of Wytton, husbandman 0
5608576 2537582 2537582 plaintiff Cook Thomas   603666 603666 Cook, Thomas, of Wytton 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);