names

72 rows where place_id = 611193

✎ 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
3687295 1922206 1922206 defendant Worsley Thomas yeoman 611193 611193 Worsley, Thomas, of Donewich, yeoman 0
3691084 1923373 1923373 plaintiff Halyday Thomas merchant 611193 611193 Halyday, Thomas, of Donewich, merchant 0
3700428 1926371 1926371 plaintiff Baldewyn Nicholas   611193 611193 Baldewyn, Nicholas, of Donewich 0
3820702 1964363 1964363 defendant Mollesforth or Mollesford John mariner 611193 611193 Mollesforth or Mollesford, John, of Donewich, mariner 0
4435450 2175842 2175842 defendant Gerard Stephen   611193 611193 Gerard, Stephen, of Donewich 0
4580711 2225446 2225446 defendant Wodeward Wasilia   611193 611193 Wodeward, Wasilia, of Donewich, formerly wife of William 0
4595436 2229828 2229828 defendant Deneys Nicholas   611193 611193 Deneys, Nicholas, of Donewich 0
4595437 2229828 2229828 defendant Morel John   611193 611193 Morel, John, of donewich 1
4752372 2281153 2281153 plaintiff Metefeld John   611193 611193 Metefeld, John, of Donewich, prior 5
4779197 2289469 2289469 defendant Jamys Thomas yeoman 611193 611193 Jamys, Thomas, of Donewich, yeoman 0
4780832 2290003 2290003 defendant Thorp Robert yeoman 611193 611193 Thorp, Robert, of Donewich, yeoman 0
4792710 2293807 2293807 plaintiff Barboure William   611193 611193 Barboure, William, of Donewich 1
4792711 2293807 2293807 defendant Thorp Robert   611193 611193 Thorp, Robert, of Donewich 0
4794113 2294294 2294294 defendant Barbour William yeoman 611193 611193 Barbour, William, of Donewich, yeoman 0
4836690 2307443 2307443 defendant Russell Richard chapman 611193 611193 Russell, Richard, of Donewich, chapman 1
4861790 2315061 2315061 defendant Tailour Clement tailor 611193 611193 Tailour, Clement, of Donewich, tailor 1
4862744 2315333 2315333 defendant Codon Robert esq 611193 611193 Codon, Robert, of Donewich, esq 0
4873635 2318694 2318694 plaintiff Moref John   611193 611193 Moref, John, of Donewich 1
4873867 2318765 2318765 defendant Thorp Robert yeoman 611193 611193 Thorp, Robert, of Donewich, yeoman 0
4890458 2323781 2323781 defendant Reston Thomas baker 611193 611193 Reston, Thomas, of Donewich, baker 0
4899507 2326485 2326485 defendant Gyne or Gyve John yeoman 611193 611193 Gyne or Gyve, John, of Donewich, yeoman 0
4899984 2326635 2326635 defendant Thorp Robert   611193 611193 Thorp, Robert, of Donewich, franklin 0
4899985 2326635 2326635 defendant Melton John husbandman 611193 611193 Melton, John, of Donewich, husbandman 1
4899986 2326635 2326635 defendant Russell Richard   611193 611193 Russell, Richard, of Donewich, mason 2
4899987 2326635 2326635 defendant Whetelofe Thomas smith 611193 611193 Whetelofe, Thomas, of Donewich, smith 3
4899988 2326635 2326635 defendant Aleyn John   611193 611193 Aleyn, John, of Donewich, wright 4
4899989 2326635 2326635 defendant Jentilman John pedder 611193 611193 Jentilman, John, of Donewich, pedder 5
4899990 2326635 2326635 defendant Wryght John   611193 611193 Wryght, John, of Donewich, wright 6
4904606 2328054 2328054 plaintiff Barbour William   611193 611193 Barbour, William, of Donewich 0
4937643 2338149 2338149 defendant Mores John merchant 611193 611193 Mores, John, of Donewich, merchant 0
4937644 2338149 2338149 defendant Codon Robert gent 611193 611193 Codon, Robert, of Donewich, gent 1
4938868 2338548 2338548 plaintiff Codon Richard   611193 611193 Codon, Richard, of Donewich 0
4938869 2338548 2338548 defendant Barburgh William merchant 611193 611193 Barburgh, William, of Donewich, merchant 0
4944140 2340136 2340136 defendant Codon Robert esq 611193 611193 Codon, Robert, of Donewich, esq 0
4947420 2341189 2341189 plaintiff Lewek John   611193 611193 Lewek, John, of Donewich 0
4947860 2341312 2341312 plaintiff Lowek John   611193 611193 Lowek, John, of Donewich 0
4949117 2341714 2341714 plaintiff Mores John   611193 611193 Mores, John, of Donewich 0
4966090 2346787 2346787 defendant Codon Robert   611193 611193 Codon, Robert, of Donewich 0
4966091 2346787 2346787 defendant Eyne John merchant 611193 611193 Eyne, John, of Donewich, merchant 1
4966367 2346873 2346873 defendant Whetlef Thomas smith 611193 611193 (Whetlef, Thomas, of Donewich, smith 5
4966368 2346873 2346873 defendant Skuttyng Clement pedder 611193 611193 Skuttyng, Clement, of Donewich, pedder 6
4971864 2348517 2348517 defendant Covy John mariner 611193 611193 Covy, John, of Donewich, mariner 1
4975048 2349513 2349513 plaintiff Mores or Moref John   611193 611193 Mores or Moref, John, of Donewich 0
4975049 2349513 2349513 defendant Bedman William yeoman 611193 611193 Bedman, William, of Donewich, yeoman 0
4981438 2351364 2351364 defendant Boston Richard yeoman 611193 611193 Boston, Richard, of Donewich, yeoman 2
5020954 2363026 2363026 plaintiff Eyne or Gyne John   611193 611193 Eyne or Gyne, John, of Donewich 0
5021130 2363076 2363076 defendant Heythe Thomas husbandman 611193 611193 Heythe, Thomas, of Donewich, husbandman 0
5023997 2363930 2363930 plaintiff Hethe Thomas   611193 611193 Hethe, Thomas, of Donewich 0
5028381 2365184 2365184 plaintiff Mores John merchant 611193 611193 Mores, John, of Donewich, merchant 0
5037800 2367934 2367934 defendant Heythe Thomas husbandman 611193 611193 Heythe, Thomas, of Donewich, husbandman 0
5046733 2370647 2370647 defendant Skuttyng Clement tailor 611193 611193 Skuttyng, Clement, of Donewich, tailor 1
5064378 2375892 2375892 defendant Lygote Robert shopman 611193 611193 Lygote, Robert, of Donewich, shopman 7
5066427 2376487 2376487 plaintiff Moress John (legal representative) 611193 611193 Moress, John, of Donewich, executors of 0
5066431 2376487 2376487 defendant Codon Richard yeoman 611193 611193 Codon, Richard, of Donewich, yeoman 0
5087830 2382821 2382821 plaintiff Jelle John   611193 611193 Jelle, John, of Donewich 0
5098067 2385867 2385867 defendant Potter John yeoman 611193 611193 Potter, John, of Donewich, yeoman 1
5111969 2389888 2389888 defendant Codon Robert gent 611193 611193 Codon, Robert, of Donewich, gent 0
5215058 2420127 2420127 defendant Thorp Robert merchant 611193 611193 Thorp, Robert, of Donewich, merchant 0
5224656 2422881 2422881 defendant Oreforth Thomas shipman 611193 611193 Oreforth, Thomas, of Donewich, shipman 2
5225619 2423165 2423165 defendant Whetelef Thomas husbandman 611193 611193 Whetelef, Thomas, of Donewich, husbandman 3
5239674 2427190 2427190 defendant Scutyng Clement pedder 611193 611193 Scutyng, Clement, of Donewich, pedder 3
5256653 2432200 2432200 defendant Spence William miller 611193 611193 Spence, William, of Donewich, miller 0
5256657 2432202 2432202 defendant Spence William miller 611193 611193 Spence, William, of Donewich, miller 0
5294952 2443515 2443515 plaintiff Thorp Robert   611193 611193 Thorp, Robert, of Donewich 0
5340770 2457314 2457314 plaintiff Peers Walter   611193 611193 Peers, Walter, of Donewich 0
5351370 2460527 2460527 plaintiff Davy Nicholas   611193 611193 Davy, Nicholas, of Donewich 0
5374301 2467566 2467566 defendant (not given) John rector of Tropynell 611193 611193 Tropynell, John, of Donewich, clerk & Rector of St Peter's church 0
5493782 2503046 2503046 defendant Reve Robert butcher 611193 611193 Reve, Robert, of Donewich, butcher 1
5543941 2518215 2518215 defendant Pyers William yeoman 611193 611193 Pyers, William, of Donewich, yeoman 0
5548644 2519646 2519646 plaintiff Bakke William clerk 611193 611193 Bakke, William, of Donewich, clerk 0
5627646 2552619 2552619 defendant Randessone John shipman 611193 611193 Randessone, John, of Donewich, shipman 0
5627648 2552620 2552620 defendant Randessone John shipman 611193 611193 Randessone, John, of Donewich, shipman 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);