names

43 rows where place_id = 619522

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3730383 1935737 1935737 defendant Foxford John husbandman 619522 619522 Foxford, John, of Blakedon, husbandman 0
3755555 1943694 1943694 defendant Wyllett John husbandman 619522 619522 Wyllett, John, of Blakedon, husbandman 4
3755647 1943722 1943722 defendant Osborne John husbandman 619522 619522 Osborne, John, of Blakedon, husbandman 0
3793334 1955775 1955775 defendant Trend William husbandman 619522 619522 Trend, William, of Blakedon Piper, husbandman 0
4113230 2064997 2064997 defendant Freman Maurice gent 619522 619522 Freman, Maurice, of Blakedon, or of Cresewell, Pembroke, gent 0
4423804 2172292 2172292 defendant del Newehalle Hugh   619522 619522 del Newehalle, Hugh, of Blakedon, parson 0
4480280 2194496 2194496 defendant Sley John   619522 619522 Sley, John, of Blakedon 1
4551911 2216547 2216547 defendant Ratour Thomas   619522 619522 Ratour, Thomas, of Blakedon 1
4604167 2232470 2232470 defendant Sherp John   619522 619522 Sherp, John, of Blakedon 2
4610108 2234249 2234249 defendant Hulle Mathew   619522 619522 Hulle, Mathew, of Blakedon 0
4615714 2235914 2235914 defendant Giffard Thomas   619522 619522 Giffard, Thomas, of Blakedon 0
4689606 2262308 2262308 defendant Spencer Thomas husbandman 619522 619522 Spencer, Thomas, of Blakedon, husbandman 2
4734789 2276036 2276036 defendant Bykevole Walter husbandman 619522 619522 Bykevole, Walter, of Blakedon, husbandman 0
4736452 2276533 2276533 defendant Chauflour John husbandman 619522 619522 Chauflour, John, of Blakedon, husbandman 1
4765773 2285291 2285291 defendant atte Herne William   619522 619522 atte Herne, William, of Blakedon, mynour or miner 2
4790954 2293263 2293263 defendant Shepherd John collier 619522 619522 Shepherd, John, of Blakedon, collier 0
4884858 2322162 2322162 defendant Broun Roger husbandman 619522 619522 Broun, Roger, of Blakedon, husbandman 0
4884865 2322164 2322164 defendant Frank William husbandman 619522 619522 Frank, William, of Blakedon, husbandman 0
4888137 2323095 2323095 defendant Denet or Devet William husbandman 619522 619522 Denet or Devet, William, of Blakedon, husbandman 0
4888138 2323095 2323095 defendant Wylmot William husbandman 619522 619522 Wylmot, William, of Blakedon, husbandman 1
4888139 2323095 2323095 defendant Feldehouse Robert husbandman 619522 619522 Feldehouse, Robert, of Blakedon, husbandman 2
4888140 2323095 2323095 defendant Herreys John husbandman 619522 619522 Herreys, John, of Blakedon, husbandman 3
4888141 2323095 2323095 defendant Shepherd Robert husbandman 619522 619522 Shepherd, Robert, of Blakedon, husbandman 4
4895656 2325313 2325313 defendant Milleward Lawrence husbandman 619522 619522 Milleward, Lawrence, of Blakedon, husbandman 3
4895657 2325313 2325313 defendant Chamfloure John husbandman 619522 619522 Chamfloure, John, of Blakedon, husbandman 4
4936152 2337706 2337706 defendant Martyn John husbandman 619522 619522 Martyn, John, of Blakedon, husbandman 1
4952521 2342713 2342713 defendant Spenser John husbandman 619522 619522 Spenser, John, of Blakedon, husbandman 2
5014233 2361015 2361015 defendant Crosman Nicholas husbandman 619522 619522 Crosman, Nicholas, of Blakedon, husbandman 0
5058985 2374251 2374251 defendant Wodeward John husbandman 619522 619522 Wodeward, John, of Blakedon, husbandman 0
5058986 2374251 2374251 defendant Wylmot John husbandman 619522 619522 Wylmot, John, of Blakedon, husbandman 1
5058987 2374251 2374251 defendant Walys Thomas husbandman 619522 619522 Walys, Thomas, of Blakedon, husbandman 2
5092779 2384267 2384267 defendant Ricard Robert husbandman 619522 619522 Ricard, Robert, of Blakedon, husbandman 0
5142750 2399005 2399005 defendant Bykefeld John collier 619522 619522 Bykefeld, John, of Blakedon, collier 1
5259339 2433041 2433041 defendant Sellyn William weaver 619522 619522 Sellyn, William, of Blakedon, Pytmynster, weaver 0
5449526 2489748 2489748 defendant Chaloner John husbandman 619522 619522 Chaloner, John, of Blakedon, husbandman 0
5449527 2489748 2489748 defendant style John laborer 619522 619522 style, John, of Blakedon, laborer 1
5449528 2489748 2489748 defendant Smyth William husbandman 619522 619522 Smyth, William, of Blakedon, husbandman 2
5449529 2489748 2489748 defendant White John husbandman 619522 619522 White, John, of Blakedon, husbandman 3
5449530 2489748 2489748 defendant Crosseman Walter laborer 619522 619522 Crosseman, Walter, of Blakedon, laborer 4
5461670 2493429 2493429 defendant Style John laborer 619522 619522 Style, John, of Blakedon, laborer 1
5461671 2493429 2493429 defendant Smyth William husbandman 619522 619522 Smyth, William, of Blakedon, husbandman 2
5461672 2493429 2493429 defendant White John husbandman 619522 619522 White, John, of Blakedon, husbandman 3
5461673 2493429 2493429 defendant Crosseman Walter laborer 619522 619522 Crosseman, Walter, of Blakedon, laborer 4

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);