names

44 rows where place_id = 606128

✎ 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
3664144 1914736 1914736 defendant Whitsyde William smith 606128 606128 Whitsyde, William, of Rippon, smith 1
3812976 1961960 1961960 defendant Pratte Thomas clerk 606128 606128 Pratte, Thomas, of Rippon, clerk 0
3820339 1964239 1964239 defendant Dyxson William yeoman 606128 606128 Dyxson, William, of Rippon, yeoman 0
4077573 2052268 2052268 defendant Day Richard yeoman 606128 606128 Day, Richard, of Rippon, yeoman 0
4077574 2052268 2052268 defendant Rigg John yeoman 606128 606128 Rigg, John, of Rippon, yeoman 1
4077575 2052268 2052268 defendant Todd Thomas yeoman 606128 606128 Todd, Thomas, of Rippon, yeoman 2
4077576 2052268 2052268 defendant Jackson Philip yeoman 606128 606128 Jackson, Philip, of Rippon, yeoman 3
4093052 2057830 2057830 defendant Wharton William gent 606128 606128 Wharton, William, of Rippon, gent 0
4093053 2057830 2057830 defendant Wharton Charles gent 606128 606128 Wharton, Charles, of Rippon, gent 1
4111476 2064351 2064351 defendant Harland Thomas yeoman 606128 606128 Harland, Thomas, of Rippon, yeoman 3
4158401 2081009 2081009 defendant Staveley Miles gent 606128 606128 Staveley, Miles, of Rippon, gent 0
4184667 2090147 2090147 defendant Clarke John vintner 606128 606128 Clarke, John, of Rippon, vintner 0
4215152 2100797 2100797 defendant Watson Anthony shoemaker 606128 606128 Watson, Anthony, of Rippon, shoemaker 1
4216336 2101207 2101207 defendant Normavell Francis tanner 606128 606128 Normavell, Francis, of Rippon, tanner 0
4223423 2103683 2103683 defendant Dodsworth Christopher gent 606128 606128 Dodsworth, Christopher, of Rippon, gent 0
4250679 2113207 2113207 defendant Watson Anthony shoemaker 606128 606128 Watson, Anthony, of Rippon, shoemaker 1
4260513 2116484 2116484 defendant Teisdayle John laborer 606128 606128 Teisdayle, John, of Rippon, laborer 0
4284361 2124456 2124456 defendant Bowmer Richard yeoman 606128 606128 Bowmer, Richard, of Rippon, yeoman 0
4284363 2124457 2124457 defendant Bowmer Richard yeoman 606128 606128 Bowmer, Richard, of Rippon, yeoman 0
4300408 2130247 2130247 defendant Abraham alias Sunderland Christopher yeoman 606128 606128 Abraham alias Sunderland, Christopher, of Rippon, yeoman 0
4309781 2133577 2133577 defendant Smyth John innholder 606128 606128 Smyth, John, of Rippon, innholder 0
4311871 2134286 2134286 defendant Singleton John gent 606128 606128 Singleton, John, of Rippon, gent 3
4315282 2135458 2135458 defendant Harland Thomas merchant 606128 606128 Harland, Thomas, of Rippon, merchant 2
4316861 2136016 2136016 defendant Kettlewell Marmaduke yeoman 606128 606128 Kettlewell, Marmaduke, of Rippon, yeoman 0
4323566 2138298 2138298 defendant Johnson John gent 606128 606128 Johnson, John, of Rippon, gent 0
4325061 2138765 2138765 defendant Johnson John gent 606128 606128 Johnson, John, of Rippon, gent 1
4335663 2142206 2142206 defendant Leache George yeoman 606128 606128 Leache, George, of Rippon, yeoman 0
4340113 2143805 2143805 defendant Coward Henry husbandman 606128 606128 Coward, Henry, of Rippon, husbandman 3
4359096 2150415 2150415 defendant Ellerker Christopher yeoman 606128 606128 Ellerker, Christopher, of Rippon, yeoman 0
4377348 2156974 2156974 defendant Fowler Moses clerk 606128 606128 Fowler, Moses, of Rippon, clerk 0
4393060 2162290 2162290 defendant Robson Thomas tailor 606128 606128 Robson, Thomas, of Rippon, tailor 0
4393062 2162291 2162291 defendant Bickerdike William tailor 606128 606128 Bickerdike, William, of Rippon, tailor 0
4401255 2165013 2165013 defendant Leache George chapman 606128 606128 Leache, George, of Rippon, chapman 0
4403154 2165627 2165627 defendant Pepper Anne spinster 606128 606128 Pepper, Anne, of Rippon, spinster 1
4412743 2168855 2168855 defendant Leache George merchant 606128 606128 Leache, George, of Rippon, merchant 1
4676171 2258160 2258160 defendant Fencotes William esq 606128 606128 Fencotes, William, of Rippon, esq 2
5273769 2437410 2437410 defendant Walworth John   606128 606128 Walworth, John, of Rippon 0
5353522 2461177 2461177 plaintiff Goldsburgh Richard esq 606128 606128 Goldsburgh, Richard, of Rippon, esq 0
5463806 2494090 2494090 defendant Brathwathe Thomas chaplain 606128 606128 Brathwathe, Thomas, of Rippon, chaplain 1
5463840 2494100 2494100 defendant Brathwathe Thomas chaplain 606128 606128 Brathwathe, Thomas, of Rippon, chaplain 1
5463845 2494101 2494101 defendant Brathwathe Thomas chaplain 606128 606128 Brathwathe, Thomas, of Rippon, chaplain 1
5463851 2494102 2494102 defendant Brathwathe Thomas chaplain 606128 606128 Brathwathe, Thomas, of Rippon, chaplain 1
5486932 2500988 2500988 defendant Brathwathe Thomas chaplain 606128 606128 Brathwathe, Thomas, of Rippon, chaplain 1
5557949 2522278 2522278 defendant Osborn Robert (legal representative) 606128 606128 Osborn, Robert, of Rippon, tailor, executor of 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);