names

51 rows where place_id = 671013

✎ 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
3999834 2024705 2024705 plaintiff Gateley John yeoman 671013 671013 Gateley, John, of Readinge, Berks, yeoman 0
3999836 2024706 2024706 plaintiff Gateley John yeoman 671013 671013 Gateley, John, of Readinge, Berks, yeoman 0
3999839 2024707 2024707 plaintiff Gateley John yeoman 671013 671013 Gateley, John, of Readinge, Berks, yeoman 0
4023453 2033096 2033096 defendant Newce Bartholomew vintner 671013 671013 Newce, Bartholomew, of Readinge, Berks, vintner 1
4023629 2033159 2033159 defendant Newce Bartholomew vintner 671013 671013 Newce, Bartholomew, of Readinge, Berks, vintner 1
4039012 2038574 2038574 defendant Silvertoppe Richard innholder 671013 671013 Silvertoppe, Richard, of Readinge, Berks, innholder 0
4081938 2053842 2053842 defendant Renold William clothier 671013 671013 Renold, William, of Readinge, Berks, clothier 0
4081958 2053847 2053847 defendant Reynolds William chapman 671013 671013 Reynolds, William, of Readinge, Berks, chapman 0
4094696 2058439 2058439 defendant Spryngall Richard innholder 671013 671013 Spryngall, Richard, of Readinge, Berks, innholder 0
4103489 2061533 2061533 defendant Coper Edmund clothier 671013 671013 Coper, Edmund, of Readinge, Berks, clothier 0
4117257 2066475 2066475 defendant Johnson Edward chapman 671013 671013 Johnson, Edward, of Readinge, Berks, chapman 3
4138458 2074120 2074120 defendant Reynoldes William yeoman 671013 671013 Reynoldes, William, of Readinge, Berks, yeoman 0
4140823 2074955 2074955 defendant Burnam John chapman 671013 671013 Burnam, John, of Readinge, Berks, chapman 0
4162990 2082591 2082591 defendant Reynold William yeoman 671013 671013 Reynold, William, of Readinge, Berks, yeoman 0
4184257 2089992 2089992 defendant Porter Christopher dyer 671013 671013 Porter, Christopher, of Readinge, Berks, dyer 0
4197751 2094770 2094770 defendant Searmer John barber 671013 671013 Searmer, John, of Readinge, Berks, barber 0
4200143 2095603 2095603 defendant Edward James baker 671013 671013 Edward, James, of Readinge, Berks, baker 0
4213322 2100173 2100173 defendant Andros John fishmonger 671013 671013 Andros, John, of Readinge, Berks, fishmonger 0
4223126 2103578 2103578 defendant Watlyngton John   671013 671013 Watlyngton, John, of Readinge, Berks, woollen draper 0
4253654 2114212 2114212 defendant Comes Roland chapman 671013 671013 Comes, Roland, of Readinge, Berks, chapman 2
4253658 2114213 2114213 defendant Comes Roland chapman 671013 671013 Comes, Roland, of Readinge, Berks, chapman 2
4260494 2116477 2116477 defendant Venge William chapman 671013 671013 Venge, William, of Readinge, Berks, chapman 0
4262733 2117205 2117205 defendant Hawe Henry chapman 671013 671013 Hawe, Henry, of Readinge, Berks, chapman 0
4266379 2118399 2118399 defendant Bodye William glasier 671013 671013 Bodye, William, of Readinge, Berks, glasier 0
4268256 2118997 2118997 defendant Edmond James chapman 671013 671013 Edmond, James, of Readinge, Berks, chapman 1
4271095 2119908 2119908 defendant Comes Roland chapman 671013 671013 Comes, Roland, of Readinge, Berks, chapman 0
4273436 2120675 2120675 defendant Halle Henry chapman 671013 671013 Halle, Henry, of Readinge, Berks, chapman 0
4284291 2124431 2124431 defendant Bull Robert yeoman 671013 671013 Bull, Robert, of Readinge, Berks, yeoman 0
4289704 2126382 2126382 defendant Butcher John   671013 671013 Butcher, John, of Readinge, Berks, barge man 1
4293005 2127558 2127558 defendant Strowde Simon clothier 671013 671013 Strowde, Simon, of Readinge, Berks, clothier 0
4298753 2129653 2129653 defendant Lane John chapman 671013 671013 Lane, John, of Readinge, Berks, chapman 2
4312944 2134652 2134652 defendant Deane Thomas clothier 671013 671013 Deane, Thomas, of Readinge, Berks, clothier 0
4318387 2136539 2136539 defendant Marten William mercer 671013 671013 Marten, William, of Readinge, Berks, mercer 0
4327870 2139644 2139644 defendant Combes Roland chapman 671013 671013 Combes, Roland, of Readinge, Berks, chapman 3
4330267 2140426 2140426 defendant Gryffyn William gent 671013 671013 Gryffyn, William, of Readinge, Berks, gent 3
4332257 2141080 2141080 defendant Purnell John yeoman 671013 671013 Purnell, John, of Readinge, Berks, yeoman 0
4335731 2142230 2142230 defendant Seyx or Sexe Francis chapman 671013 671013 Seyx or Sexe, Francis, of Readinge, Berks, chapman 0
4338792 2143321 2143321 defendant Bostocke Lionel gent 671013 671013 Bostocke, Lionel, of Readinge, Berks, gent 0
4344500 2145356 2145356 defendant Drewe Francis carrier 671013 671013 Drewe, Francis, of Readinge, Berks, yeoman, carrier 0
4344505 2145357 2145357 defendant Thorne William yeoman 671013 671013 Thorne, William, of Readinge, Berks, yeoman 2
4351077 2147630 2147630 defendant Newman John mercer 671013 671013 Newman, John, of Readinge, Berks, mercer 1
4354089 2148656 2148656 defendant Malthus Robert draper 671013 671013 Malthus, Robert, of Readinge, Berks, draper 0
4357759 2149952 2149952 defendant Nycholson Edward salter 671013 671013 Nycholson, Edward, of Readinge, Berks, salter 0
4361388 2151236 2151236 defendant Purnell John yeoman 671013 671013 Purnell, John, of Readinge, Berks, yeoman 0
4364665 2152421 2152421 defendant Dumpar John (legal representative) 671013 671013 Dumpar, John, of Readinge, Berks, shoemaker, executors of 0
4364666 2152421 2152421 defendant Byde Richard miller 671013 671013 (Byde, Richard, of Readinge, Berks, miller 1
4368037 2153622 2153622 defendant Penros John gent 671013 671013 Penros, John, of Readinge, Berks, gent 0
4395726 2163155 2163155 defendant Thorne William innholder 671013 671013 Thorne, William, of Readinge, Berks, innholder 2
4396472 2163395 2163395 defendant Lane John   671013 671013 Lane, John, of Readinge, Berks, woollen draper 0
4402962 2165576 2165576 defendant Browne Bartholomew chapman 671013 671013 Browne, Bartholomew, of Readinge, Berks, chapman 0
4408643 2167485 2167485 defendant Seakes Francis grocer 671013 671013 Seakes, Francis, of Readinge, Berks, grocer 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);