names

51 rows where place_id = 590001

✎ 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
3599555 1867498 1867498 defendant Wynche John husbandman 590001 590001 Wynche, John, of Aldebury, husbandman 0
3603218 1868675 1868675 defendant Wayte John maltman 590001 590001 Wayte, John, of Aldebury, maltman 1
3752702 1942773 1942773 defendant Hamshire John husbandman 590001 590001 Hamshire, John, of Aldebury, husbandman 0
3803760 1959090 1959090 defendant Whitmore Henry, senior husbandman 590001 590001 Whitmore, Henry, senior, of Aldebury, husbandman 0
3803761 1959090 1959090 defendant Whitmore Richard laborer 590001 590001 Whitmore, Richard, of Aldebury, laborer 1
3803762 1959090 1959090 defendant Whitmore John laborer 590001 590001 Whitmore, John, of Aldebury, laborer 2
3803763 1959090 1959090 defendant Whitmore Henry, junior laborer 590001 590001 Whitmore, Henry, junior, of Aldebury, laborer 3
3847712 1972856 1972856 plaintiff Hnyghton John gent 590001 590001 Hnyghton, John, of Aldebury, gent 0
3848865 1973235 1973235 plaintiff Knyghton John gent 590001 590001 Knyghton, John, of Aldebury, gent 0
4440669 2181992 2181992 defendant Cook William   590001 590001 Cook, William, of Aldebury 0
4516132 2205458 2205458 defendant Cook William   590001 590001 Cook, William, of Aldebury 1
4558757 2218691 2218691 defendant atte Nasshe John   590001 590001 atte Nasshe, John, of Aldebury 0
4563998 2220313 2220313 defendant Clerk John   590001 590001 Clerk, John, of Aldebury 2
4587991 2227641 2227641 defendant Smyth Richard   590001 590001 Smyth, Richard, of Aldebury 1
4668181 2255757 2255757 defendant Knyght John husbandman 590001 590001 Knyght, John, of Aldebury, husbandman 0
4676032 2258115 2258115 defendant Chilleworth John husbandman 590001 590001 Chilleworth, John, of Aldebury, husbandman 0
4729728 2274505 2274505 defendant Jay William shoemaker 590001 590001 Jay, William, of Aldebury, shoemaker 13
4731184 2274954 2274954 defendant Barley John, sen gent 590001 590001 Barley, John, sen, of Aldebury, gent 0
4731188 2274955 2274955 defendant Barley John, sen gent 590001 590001 together with Barley, John, sen, of Aldebury, gent 1
4880154 2320705 2320705 defendant Rumney John husbandman 590001 590001 Rumney, John, of Aldebury, husbandman 3
4881218 2321031 2321031 defendant Glade Henry yeoman 590001 590001 Glade, Henry, of Aldebury, yeoman 0
4881219 2321031 2321031 defendant Hayward Nicholas husbandman 590001 590001 Hayward, Nicholas, of Aldebury, husbandman 1
4915956 2331487 2331487 defendant de Pendle John laborer 590001 590001 de Pendle, John, of Aldebury, laborer 1
5009055 2359531 2359531 defendant Rysebrygger John husbandman 590001 590001 Rysebrygger, John, of Aldebury, husbandman 2
5009059 2359532 2359532 defendant Rysebrygger John husbandman 590001 590001 Rysebrygger, John, of Aldebury, husbandman 2
5015516 2361424 2361424 defendant Brokeweller John drover 590001 590001 Brokeweller, John, of Aldebury, drover 0
5028453 2365196 2365196 defendant Pepurcorn John husbandman 590001 590001 Pepurcorn, John, of Aldebury, husbandman 4
5028454 2365196 2365196 defendant Trewth John husbandman 590001 590001 Trewth, John, of Aldebury, husbandman 5
5077927 2379879 2379879 defendant Salman John laborer 590001 590001 Salman, John, of Aldebury, laborer 0
5078105 2379936 2379936 defendant Maret Thomas   590001 590001 Maret, Thomas, of Aldebury, shepherd 0
5093679 2384548 2384548 defendant Mynge John husbandman 590001 590001 Mynge, John, of Aldebury, husbandman 1
5097155 2385604 2385604 defendant Russell Henry husbandman 590001 590001 Russell, Henry, of Aldebury, husbandman 0
5097156 2385604 2385604 defendant Chesham Roger husbandman 590001 590001 Chesham, Roger, of Aldebury, husbandman 1
5097157 2385604 2385604 defendant Gonne John husbandman 590001 590001 Gonne, John, of Aldebury, husbandman 2
5112293 2389979 2389979 defendant Gyva Robert husbandman 590001 590001 Gyva, Robert, of Aldebury, husbandman 0
5120957 2392561 2392561 defendant Mynge John husbandman 590001 590001 Mynge, John, of Aldebury, husbandman 0
5242130 2427899 2427899 defendant Gyworth William smith 590001 590001 Gyworth, William, of Aldebury, smith 4
5252628 2430935 2430935 defendant Bryan John butcher 590001 590001 Bryan, John, of Aldebury, butcher 2
5345379 2458728 2458728 defendant Mawe John yeoman 590001 590001 Mawe, John, of Aldebury, yeoman 1
5345380 2458728 2458728 defendant Bryon John husbandman 590001 590001 Bryon, John, of Aldebury, husbandman 2
5458293 2492381 2492381 defendant Ottewey John husbandman 590001 590001 Ottewey, John, of Aldebury, husbandman 2
5469942 2495935 2495935 defendant Ottewey John husbandman 590001 590001 Ottewey, John, of Aldebury, husbandman 2
5575522 2527435 2527435 defendant ap David Reginald gent 590001 590001 ap David, Reginald, of Aldebury, gent 8
5575523 2527435 2527435 defendant Bloytyk Griffith gent 590001 590001 Bloytyk, Griffith, of Aldebury, gent 9
5575534 2527437 2527437 defendant ap David Reginald gent 590001 590001 ap David, Reginald, of Aldebury, gent 2
5575535 2527437 2527437 defendant Blotyk Griffith gent 590001 590001 Blotyk, Griffith, of Aldebury, gent 3
5624593 2551633 2551633 defendant Wryght Roger   590001 590001 Wryght, Roger, of Aldebury, wright 0
5636804 2555452 2555452 defendant atte Dene John husbandman 590001 590001 atte Dene, John, of Aldebury, husbandman 0
5636807 2555453 2555453 defendant atte Dene John husbandman 590001 590001 atte Dene, John, of Aldebury, husbandman 0
5636859 2555470 2555470 defendant Wolfeld Peter husbandman 590001 590001 Wolfeld, Peter, of Aldebury, husbandman 0
5636862 2555471 2555471 defendant Wolfeld Peter husbandman 590001 590001 Wolfeld, Peter, of Aldebury, husbandman 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);