names

53 rows where place_id = 606551

✎ 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
3665642 1915204 1915204 defendant Baker Ingeliam clothier 606551 606551 Baker, Ingeliam, of Alresford, clothier 0
3692254 1923747 1923747 defendant Baker William yeoman 606551 606551 Baker, William, of Alresford, yeoman 0
3764598 1946585 1946585 defendant Goodchere Thomas innholder 606551 606551 Goodchere, Thomas, of Alresford, innholder 1
3782584 1952295 1952295 defendant Goodchere Thomas innholder 606551 606551 Goodchere, Thomas, of Alresford, innholder 1
3874237 1981604 1981604 defendant Warton John dyer 606551 606551 Warton, John, of Alresford, dyer 2
3874248 1981606 1981606 defendant Warton John dyer 606551 606551 Warton, John, of Alresford, dyer 2
4103579 2061564 2061564 defendant Grene William innholder 606551 606551 Grene, William, of Alresford, yeoman, innholder 0
4198949 2095188 2095188 defendant Gaskyn Robert gent 606551 606551 Gaskyn, Robert, of Alresford, gent 1
4466557 2190217 2190217 defendant Halle John   606551 606551 Halle, John, of Alresford 0
4466560 2190218 2190218 defendant Halle John   606551 606551 Halle, John, of Alresford 0
4481805 2195013 2195013 defendant Danel or Davel Walter   606551 606551 Danel or Davel, Walter, of Alresford 0
4488653 2197173 2197173 defendant atte Hasshe John painter 606551 606551 atte Hasshe, John, of Alresford, painter 0
4647566 2245346 2245346 defendant atte Nasshe John   606551 606551 atte Nasshe, John, of Alresford 0
4668891 2255971 2255971 defendant Gye John laborer 606551 606551 Gye, John, of Alresford, laborer 0
4690795 2262657 2262657 defendant Beltyng John husbandman 606551 606551 Beltyng, John, of Alresford, husbandman 3
4780723 2289969 2289969 defendant Webbe Nicholas husbandman 606551 606551 Webbe, Nicholas, of Alresford, husbandman 1
4805121 2297804 2297804 defendant Calle Thomas chapman 606551 606551 Calle, Thomas, of Alresford, chapman 0
4834116 2306679 2306679 plaintiff Cooke John   606551 606551 Cooke, John, of Alresford 0
4876313 2319554 2319554 plaintiff Silver John   606551 606551 Silver, John, of Alresford 0
4893051 2324546 2324546 defendant Sondion or Soudion Edward weaver 606551 606551 Sondion or Soudion, Edward, of Alresford, weaver 0
4943572 2339958 2339958 defendant Horsman Richard butcher 606551 606551 Horsman, Richard, of Alresford, butcher 3
4995688 2355552 2355552 defendant Coupe John butcher 606551 606551 Coupe, John, of Alresford, butcher 1
5107534 2388633 2388633 defendant Warde Thomas husbandman 606551 606551 Warde, Thomas, of Alresford, husbandman 0
5129997 2395260 2395260 defendant Fynte Thomas husbandman 606551 606551 Fynte, Thomas, of Alresford, husbandman 2
5146389 2400074 2400074 defendant Fynte Thomas husbandman 606551 606551 Fynte, Thomas, of Alresford, husbandman 2
5149286 2400921 2400921 defendant Fynce Thomas husbandman 606551 606551 Fynce, Thomas, of Alresford, husbandman 2
5149291 2400923 2400923 defendant Stephen John husbandman 606551 606551 Stephen, John, of Alresford, husbandman 0
5149292 2400923 2400923 defendant Stephen William husbandman 606551 606551 Stephen, William, of Alresford, husbandman 1
5149293 2400923 2400923 defendant Warde Richard husbandman 606551 606551 Warde, Richard, of Alresford, husbandman 2
5149294 2400923 2400923 defendant Hookham William husbandman 606551 606551 Hookham, William, of Alresford, husbandman 3
5149295 2400923 2400923 defendant Northfeld William husbandman 606551 606551 Northfeld, William, of Alresford, husbandman 4
5168259 2406429 2406429 defendant Parker John yeoman 606551 606551 Parker, John, of Alresford, yeoman 0
5184112 2411090 2411090 defendant Parker John yeoman 606551 606551 Parker, John, of Alresford, yeoman 0
5193991 2413977 2413977 defendant Upham Edmund   606551 606551 Upham, Edmund, of Alresford, administrators of 0
5208485 2418213 2418213 defendant Upham Edmund   606551 606551 Upham, Edmund, of Alresford, administrators of 0
5255708 2431902 2431902 defendant Spyrke John cordwainer 606551 606551 Spyrke, John, of Alresford, cordwainer 0
5255709 2431902 2431902 defendant Grygge Alexander chandler 606551 606551 Grygge, Alexander, of Alresford, chandler 1
5255710 2431902 2431902 defendant Grygge Thomas mercer 606551 606551 Grygge, Thomas, of Alresford, mercer 2
5255711 2431902 2431902 defendant Benet William tailor 606551 606551 Benet, William, of Alresford, tailor 3
5255712 2431902 2431902 defendant Debelyn or Develyn Nicholas tanner 606551 606551 Debelyn or Develyn, Nicholas, of Alresford, tanner 4
5319375 2450886 2450886 defendant Frampton John yeoman 606551 606551 Frampton, John, of Alresford, yeoman 2
5330147 2454093 2454093 defendant Grygge John yeoman 606551 606551 Grygge, John, of Alresford, yeoman 1
5346516 2459058 2459058 defendant Cheseman Robert chapman 606551 606551 Cheseman, Robert, of Alresford, chapman 2
5359142 2462897 2462897 defendant Frampton John, junior chapman 606551 606551 Frampton, John, junior, of Alresford, chapman 3
5463876 2494110 2494110 defendant Barnak Lawrence yeoman 606551 606551 Barnak, Lawrence, of Alresford, yeoman 0
5464285 2494223 2494223 defendant Bodnam John shoemaker 606551 606551 Bodnam, John, of Alresford, shoemaker 0
5464288 2494223 2494223 defendant Clere Edward butcher 606551 606551 Clere, Edward, of Alresford, butcher 3
5475809 2497766 2497766 defendant Bodnam John   606551 606551 Bodnam, John, of Alresford 0
5475812 2497766 2497766 defendant Clere Edward butcher 606551 606551 Clere, Edward, of Alresford, butcher 3
5501751 2505481 2505481 defendant Bygon John glover 606551 606551 Bygon, John, of Alresford, glover 0
5574982 2527256 2527256 defendant Lynton John gent 606551 606551 Lynton, John, of Alresford, gent 0
5577467 2528012 2528012 defendant Smyth Richard smith 606551 606551 Smyth, Richard, of Alresford, smith 0
5577470 2528012 2528012 defendant Sowth John fuller 606551 606551 Sowth, John,of Alresford, fuller 3

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