names

53 rows where place_id = 659207

✎ 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
3654590 1911698 1911698 defendant Harrys John   659207 659207 Harrys, John, of Uxbridge, Middx, inn holder 2
3951497 2007580 2007580 defendant Awdyens Robert chapman 659207 659207 Awdyens, Robert, of Uxbridge, Middx, chapman 3
3997269 2023794 2023794 defendant Wylde or Well Michael clother 659207 659207 Wylde or Well, Michael, of Uxbridge, Middx, clother 0
4001605 2025353 2025353 plaintiff Hargrave Elizabeth widow 659207 659207 Elizabeth his wife, alias Elizabeth Saunders, of Uxbridge, Middx, widow 1
4025901 2033914 2033914 defendant Buddell Thomas yeoman 659207 659207 Buddell, Thomas, of Uxbridge, Middx, yeoman 2
4034369 2036964 2036964 plaintiff Hargrave Elizabeth widow 659207 659207 Elizabeth his wife, alias Elizabeth Saunders, of Uxbridge, Middx, widow 1
4069021 2049211 2049211 plaintiff Lawghton William tanner 659207 659207 Lawghton, William, of Uxbridge, Middx, tanner 0
4069678 2049441 2049441 plaintiff Lowghton William tanner 659207 659207 Lowghton, William, of Uxbridge, Middx, tanner 0
4079591 2052999 2052999 defendant Ingeley Robert   659207 659207 Ingeley, Robert, of Uxbridge, Middx, locksnith 1
4093273 2057911 2057911 defendant Wythe Thomas smith 659207 659207 Wythe, Thomas, of Uxbridge, Middx, smith 1
4103827 2061642 2061642 defendant Adiens Robert innholder 659207 659207 (Adiens, Robert, of Uxbridge, Middx, innholder 1
4103830 2061643 2061643 defendant Adiens Robert innholder 659207 659207 (Adiens, Robert, of Uxbridge, Middx, innholder 1
4162866 2082542 2082542 defendant Laughton Edward gent 659207 659207 Laughton, Edward, of Uxbridge, Middx, gent 52
4166291 2083703 2083703 defendant Tompson Richard cordwainer 659207 659207 Tompson, Richard, of Uxbridge, Middx, cordwainer 2
4166435 2083761 2083761 defendant Redhead Robert chapman 659207 659207 Redhead, Robert, of Uxbridge, Middx, chapman 3
4166440 2083762 2083762 defendant Nicholl Thomas chapman 659207 659207 Nicholl, Thomas, of Uxbridge, Middx, chapman 3
4230023 2105990 2105990 defendant Underhill Perseus innholder 659207 659207 Underhill, Perseus, of Uxbridge, Middx, innholder 0
4263863 2117572 2117572 defendant Tailor John innholder 659207 659207 Tailor, John, of Uxbridge, Middx, salter maker, innholder 0
4280121 2122958 2122958 defendant Hoggborn or Ogborn Richard yeoman 659207 659207 Hoggborn or Ogborn, Richard, of Uxbridge, Middx, yeoman 0
4289164 2126179 2126179 defendant Hoggborne or Ogborn Richard yeoman 659207 659207 Hoggborne or Ogborn, Richard, of Uxbridge, Middx, yeoman 0
4328497 2139846 2139846 defendant Grant John chapman 659207 659207 Grant, John, of Uxbridge, Middx, chapman 2
4329966 2140323 2140323 defendant Birde William shoemaker 659207 659207 Birde, William, of Uxbridge, Middx, shoemaker 0
4331678 2140890 2140890 defendant Carlton Edmund smith 659207 659207 Carlton, Edmund, of Uxbridge, Middx, smith 2
4334712 2141876 2141876 defendant Grundye Abraham yeoman 659207 659207 Grundye, Abraham, of Uxbridge, Middx, yeoman 1
4336888 2142627 2142627 defendant Birche Richard yeoman 659207 659207 Birche, Richard, of Uxbridge, Middx, yeoman 2
4344961 2145516 2145516 defendant Neale William yeoman 659207 659207 Neale, William, of Uxbridge, Middx, yeoman 0
4344978 2145521 2145521 defendant Bedill Edward joiner 659207 659207 Bedill, Edward, of Uxbridge, Middx, joiner 0
4344980 2145522 2145522 defendant Bedill Edward joiner 659207 659207 Bedill, Edward, of Uxbridge, Middx, joiner 0
4353841 2148565 2148565 defendant Haukinson Samuel clerk 659207 659207 Haukinson, Samuel, of Uxbridge, Middx, clerk 1
4387841 2160567 2160567 defendant Colstock Thomas yeoman 659207 659207 Colstock, Thomas, of Uxbridge, Middx, yeoman 2
4394380 2162720 2162720 defendant Smyth Nicholas cooper 659207 659207 Smyth, Nicholas, of Uxbridge, Middx, cooper 0
4402149 2165307 2165307 defendant Hytchcott William gent 659207 659207 Hytchcott, William, of Uxbridge, Middx, gent 3
4406373 2166696 2166696 defendant Sharpe Gregory   659207 659207 Sharpe, Gregory, of Uxbridge, Middx, mercert 1
4407065 2166921 2166921 defendant Underhill Perse innholder 659207 659207 Underhill, Perse, of Uxbridge, Middx, innholder 2
4699980 2265418 2265418 defendant Gatesden Robert husbandman 659207 659207 Gatesden, Robert, of Uxbridge, Middx, husbandman 2
4699988 2265419 2265419 defendant Gadesden Robert husbandman 659207 659207 Gadesden, Robert, of Uxbridge, Middx, husbandman 2
4705105 2266970 2266970 defendant Forster John (legal representative) 659207 659207 Forster, John, of Uxbridge, Middx, administratrix of 1
4705109 2266971 2266971 defendant Forster John (legal representative) 659207 659207 Forster, John, of Uxbridge, Middx, administratrix of 1
4752409 2281163 2281163 defendant Gaddesdene Robert husbandman 659207 659207 Gaddesdene, Robert, of Uxbridge, Middx, husbandman 3
4755994 2282258 2282258 defendant Chaumbre Thomas yeoman 659207 659207 Chaumbre, Thomas, of Uxbridge, Middx, yeoman 1
4762453 2284241 2284241 defendant Tanner Thomas tanner 659207 659207 Tanner, Thomas, of Uxbridge, Middx, tanner 1
4832852 2306298 2306298 defendant Reyny Thomas yeoman 659207 659207 Reyny, Thomas, of Uxbridge, Middx, yeoman 1
4842178 2309088 2309088 defendant Wattys John yeoman 659207 659207 Wattys, John, of Uxbridge, Middx, yeoman 0
5152464 2401855 2401855 defendant Heggys Thomas ostler 659207 659207 Heggys, Thomas, of Uxbridge, Middx, ostler 0
5172537 2407694 2407694 defendant Good John yeoman 659207 659207 Good, John, of Uxbridge, Middx, yeoman 0
5172539 2407695 2407695 defendant Kynton Walter yeoman 659207 659207 Kynton, Walter, of Uxbridge, Middx, yeoman 0
5192076 2413410 2413410 defendant Good John yeoman 659207 659207 Good, John, of Uxbridge, Middx, yeoman 0
5192078 2413411 2413411 defendant Kynton Walter yeoman 659207 659207 Kynton, Walter, of Uxbridge, Middx, yeoman 0
5192900 2413647 2413647 defendant Hart John chapman 659207 659207 Hart, John, of Uxbridge, Middx, chapman 0
5194265 2414054 2414054 defendant Kynton Walter yeoman 659207 659207 Kynton, Walter, of Uxbridge, Middx, yeoman 0
5207607 2417965 2417965 defendant Good John yeoman 659207 659207 Good, John, of Uxbridge, Middx, yeoman 0
5207609 2417966 2417966 defendant Kynton Walter yeoman 659207 659207 Kynton, Walter, of Uxbridge, Middx, yeoman 0
5372864 2467109 2467109 defendant Lynton Walter gent 659207 659207 Lynton, Walter, of Uxbridge, Middx, gent 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);