names

47 rows where place_id = 710418

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4183420 2089681 2089681 defendant Payne Thomas husbandman 710418 710418 Payne, Thomas, of Ayleston, husbandman 1
4183421 2089681 2089681 defendant Payne Henry husbandman 710418 710418 Payne, Henry, of Ayleston, husbandman 2
4416897 2170155 2170155 plaintiff Piry John de   710418 710418 Piry, John de, of Ayleston, parson 0
4422813 2171993 2171993 plaintiff Fisshere Philip le   710418 710418 Fisshere, Philip le, of Ayleston 0
4426902 2173235 2173235 plaintiff Preez Maud de   710418 710418 Preez, Maud de, of Ayleston, formerly wife of John 0
4427980 2173592 2173592 defendant Wrygches Adam   710418 710418 Wrygches, Adam, of Ayleston 0
4444875 2183372 2183372 defendant Parker John   710418 710418 Parker, John, of Ayleston, parson 0
4458041 2187544 2187544 defendant Muleward John   710418 710418 Muleward, John, of Ayleston 0
4458042 2187544 2187544 defendant Doddewell John   710418 710418 Doddewell, John, of Ayleston 1
4474356 2192631 2192631 defendant Holdere John   710418 710418 Holdere, John, of Ayleston 1
4481066 2194760 2194760 defendant Koudelowe Richard   710418 710418 Koudelowe, Richard, of Ayleston 0
4484429 2195822 2195822 defendant Osyngton John   710418 710418 Osyngton, John, of Ayleston 0
4487520 2196814 2196814 plaintiff Smyth Robert   710418 710418 Smyth, Robert, of Ayleston 0
4487523 2196814 2196814 defendant Condelowe Richard   710418 710418 Condelowe, Richard, of Ayleston 0
4487524 2196814 2196814 defendant Cat Roger   710418 710418 Cat, Roger, of Ayleston 1
4489051 2197294 2197294 plaintiff Talgard (illegible)   710418 710418 Talgard, -----, of Ayleston 0
4505229 2202163 2202163 defendant Parker John clerk 710418 710418 Parker, John, of Ayleston, clerk 1
4555417 2217629 2217629 defendant Thorp Thomas   710418 710418 Thorp, Thomas, of Ayleston 0
4555420 2217630 2217630 defendant Thorp Thomas   710418 710418 Thorp, Thomas, of Ayleston 0
4559982 2219070 2219070 defendant Broun Robert   710418 710418 Broun, Robert, of Ayleston 0
4560241 2219153 2219153 defendant Harward Peter   710418 710418 Harward, Peter, of Ayleston 0
4561640 2219573 2219573 defendant Shawe John   710418 710418 Shawe, John, of Ayleston 1
4566704 2221162 2221162 defendant Thorp Thomas   710418 710418 Thorp, Thomas, of Ayleston 0
4568669 2221781 2221781 defendant Coudelowe Richard   710418 710418 Coudelowe, Richard, of Ayleston 1
4572881 2223060 2223060 defendant Condelowe William   710418 710418 Condelowe, William, of Ayleston 0
4692921 2263295 2263295 defendant Milner Robert husbandman 710418 710418 Milner, Robert, of Ayleston, husbandman 1
4711979 2269058 2269058 defendant Milner Robert miller 710418 710418 Milner, Robert, of Ayleston, miller 2
4720787 2271833 2271833 defendant Milner Robert husbandman 710418 710418 Milner, Robert, of Ayleston, husbandman 1
4733844 2275766 2275766 defendant Milner Robert miller 710418 710418 Milner, Robert, of Ayleston, miller 0
4739256 2277366 2277366 defendant Pillok John husbandman 710418 710418 Pillok, John, of Ayleston, husbandman 2
4755732 2282176 2282176 defendant Milnere Robert miller 710418 710418 Milnere, Robert, of Ayleston, miller 0
4775302 2288268 2288268 defendant Milner Thomas husbandman 710418 710418 Milner, Thomas, of Ayleston, husbandman 3
4775303 2288268 2288268 defendant Milner Robert miller 710418 710418 Milner, Robert, of Ayleston, miller 4
4777718 2289024 2289024 defendant Milnere Robert miller 710418 710418 Milnere, Robert, of Ayleston, miller 0
4777794 2289046 2289046 defendant Milner Robert miller 710418 710418 Milner, Robert, of Ayleston, miller 1
4801060 2296521 2296521 defendant Milner Thomas husbandman 710418 710418 Milner, Thomas, of Ayleston, husbandman 1
4801061 2296521 2296521 defendant Milner Robert miller 710418 710418 Milner, Robert, of Ayleston, miller 2
4813986 2300484 2300484 defendant Fraunces John husbandman 710418 710418 Fraunces, John, of Ayleston, husbandman 1
5009245 2359587 2359587 defendant Pavett William miller 710418 710418 Pavett, William, of Ayleston, miller 4
5066962 2376643 2376643 defendant Shene John husbandman 710418 710418 Shene, John, of Ayleston, husbandman 2
5086011 2382300 2382300 defendant Schawe William clerk 710418 710418 Schawe, William, of Ayleston, clerk 2
5102811 2387240 2387240 plaintiff Bollowe John yeoman 710418 710418 Bollowe, John, of Ayleston, yeoman 0
5178538 2409435 2409435 defendant Shawe William clerk 710418 710418 Shawe, William, of Ayleston, clerk 0
5178540 2409436 2409436 defendant Shawe William clerk 710418 710418 Shawe, William, of Ayleston, clerk 0
5201491 2416193 2416193 defendant Shawe William clerk 710418 710418 Shawe, William, of Ayleston, clerk 0
5267615 2435629 2435629 defendant Shawe William clerk 710418 710418 Shawe, William, of Ayleston, clerk 0
5355333 2461742 2461742 defendant Palmer John husbandman 710418 710418 Palmer, John, of Ayleston, 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);