names

60 rows where place_id = 590197

✎ 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
3600201 1867710 1867710 defendant Ratheby John gent 590197 590197 Ratheby, John, of Cokeryngton, gent 0
3607295 1869942 1869942 defendant Wren Thomas husbandman 590197 590197 Wren, Thomas, of Cokeryngton, husbandman 5
3609371 1870589 1870589 defendant Ratheby John gent 590197 590197 Ratheby, John, of Cokeryngton, gent 4
3872299 1980960 1980960 defendant Abryggys John husbandman 590197 590197 Abryggys, John, of Cokeryngton, husbandman 0
3970818 2014380 2014380 defendant Bayly Michael husbandman 590197 590197 Bayly, Michael, of Cokeryngton, husbandman 0
3970819 2014380 2014380 defendant Naler Christopher husbandman 590197 590197 Naler, Christopher, of Cokeryngton, husbandman 1
3972230 2014847 2014847 defendant Stampe Thomas yeoman 590197 590197 Stampe, Thomas, of Cokeryngton, yeoman 0
4046648 2041253 2041253 defendant Harde William yeoman 590197 590197 Harde, William, of Cokeryngton, yeoman 1
4421330 2171572 2171572 defendant Cowyk John de   590197 590197 Cowyk, John de, of Cokeryngton 0
4421332 2171573 2171573 defendant Cowyk John de   590197 590197 Cowyk, John de, of Cokeryngton 0
4421334 2171574 2171574 defendant Neusome Adam de   590197 590197 Neusome, Adam de, of Cokeryngton 0
4421335 2171574 2171574 defendant Wylby Richard   590197 590197 Wylby, Richard, of Cokeryngton 1
4429329 2173980 2173980 defendant Stanhall William de   590197 590197 Stanhall, William de, of Cokeryngton 0
4433202 2175136 2175136 defendant Alex John   590197 590197 Alex, John, of Cokeryngton, son of John 0
4565736 2220843 2220843 defendant Galle John   590197 590197 Galle, John, of Cokeryngton 3
4570773 2222431 2222431 defendant Gall_ John   590197 590197 Gall_, John, of Cokeryngton 1
4575187 2223759 2223759 defendant Howeton John   590197 590197 Howeton, John, of Cokeryngton 1
4579569 2225094 2225094 defendant Chubbe Richard   590197 590197 Chubbe, Richard, of Cokeryngton 0
4808802 2298920 2298920 defendant Bosewell Thomas yeoman 590197 590197 Bosewell, Thomas, of Cokeryngton, yeoman 0
4824337 2303674 2303674 defendant Reynold William yeoman 590197 590197 Reynold, William, of Cokeryngton, yeoman 0
4852417 2312173 2312173 plaintiff (not given) Robert vicar of Watson 590197 590197 Watson, Robert, of Cokeryngton, vicar of the church of St Leonard 0
4898984 2326327 2326327 defendant Salman John husbandman 590197 590197 Salman, John, of Cokeryngton, husbandman 0
4904949 2328151 2328151 defendant Caldale Roger husbandman 590197 590197 Caldale, Roger, of Cokeryngton, husbandman 0
4961701 2345462 2345462 defendant Raytheby Robert   590197 590197 Raytheby, Robert, of Cokeryngton, franklin 1
4967808 2347315 2347315 defendant Ratheby Robert gent 590197 590197 Ratheby, Robert, of Cokeryngton, gent 0
4968173 2347431 2347431 defendant Raytheby Robert gent 590197 590197 Raytheby, Robert, of Cokeryngton, gent 0
5025493 2364356 2364356 defendant Goodale William husbandman 590197 590197 Goodale, William, of Cokeryngton, husbandman 4
5099983 2386433 2386433 defendant Clerk John husbandman 590197 590197 Clerk, John, of Cokeryngton, husbandman 0
5147035 2400271 2400271 defendant Buntyng Roger husbandman 590197 590197 Buntyng, Roger, of Cokeryngton, husbandman 4
5241092 2427595 2427595 defendant Wylliamson alias Trynket John laborer 590197 590197 Wylliamson alias Trynket, John, of Cokeryngton, laborer 0
5241093 2427595 2427595 defendant Louthe John husbandman 590197 590197 Louthe, John, of Cokeryngton, husbandman 1
5256510 2432159 2432159 defendant Sauman Robert husbandman 590197 590197 Sauman, Robert, of Cokeryngton, husbandman 0
5283942 2440331 2440331 defendant Tayllour John yeoman 590197 590197 Tayllour, John, of Cokeryngton, yeoman 12
5287459 2441356 2441356 defendant Ryther Henry gent 590197 590197 Ryther, Henry, of Cokeryngton, gent 2
5287467 2441357 2441357 defendant Ryther Henry gent 590197 590197 Ryther, Henry, of Cokeryngton, gent 2
5293513 2443073 2443073 defendant Hangham John (legal representative) 590197 590197 Hangham, John, of Cokeryngton, husbandman, executors of 0
5293514 2443073 2443073 defendant Hangham William clerk 590197 590197 (Hangham, William, of Cokeryngton, clerk 1
5293515 2443073 2443073 defendant Hangham Agnes widow 590197 590197 Hangham, Agnes, of Cokeryngton, widow 2
5293516 2443073 2443073 defendant Hangham Richard clerk 590197 590197 Hangham, Richard, of Cokeryngton, clerk 3
5293517 2443073 2443073 defendant Hangham Thomas husbandman 590197 590197 Hangham, Thomas, of Cokeryngton, husbandman 4
5339171 2456827 2456827 defendant Ratheby John gent 590197 590197 Ratheby, John, of Cokeryngton, gent 0
5343026 2458006 2458006 defendant Caddale Alice widow 590197 590197 (Caddale, Alice, of Cokeryngton, widow 1
5343027 2458006 2458006 defendant Wryght William husbandman 590197 590197 Wryght, William, of Cokeryngton, husbandman 2
5343137 2458044 2458044 defendant Ratheb John gent 590197 590197 Ratheb, John, of Cokeryngton, gent 1
5348777 2459743 2459743 defendant Rathby Richard husbandman 590197 590197 Rathby, Richard, of Cokeryngton, husbandman 1
5348781 2459744 2459744 defendant Rathby Richard husbandman 590197 590197 Rathby, Richard, of Cokeryngton, husbandman 1
5366466 2465166 2465166 defendant Ratheby Richard husbandman 590197 590197 Ratheby, Richard, of Cokeryngton, husbandman 1
5424200 2482202 2482202 defendant Ratheby Richard husbandman 590197 590197 Ratheby, Richard, of Cokeryngton, husbandman 1
5443139 2487859 2487859 defendant Ratheby Richard husbandman 590197 590197 Ratheby, Richard, of Cokeryngton, husbandman 1
5443487 2487962 2487962 defendant Shewe John yeoman 590197 590197 Shewe, John, of Cokeryngton, yeoman 3
5443491 2487962 2487962 defendant Ratheby John yeoman 590197 590197 Ratheby, John, of Cokeryngton, yeoman 7
5455841 2491651 2491651 defendant Ratheby Richard husbandman 590197 590197 Ratheby, Richard, of Cokeryngton, husbandman 1
5463688 2494055 2494055 defendant Ratheby John gent 590197 590197 Ratheby, John, of Cokeryngton, gent 0
5467622 2495243 2495243 defendant Ratheby Richard husbandman 590197 590197 Ratheby, Richard, of Cokeryngton, husbandman 1
5468006 2495374 2495374 defendant Ratheby John gent 590197 590197 Ratheby, John, of Cokeryngton, gent 1
5468007 2495374 2495374 defendant Louthe Thomas mercer 590197 590197 Louthe, Thomas, of Cokeryngton, mercer 2
5486043 2500711 2500711 defendant Hopkynson Thomas husbandman 590197 590197 Hopkynson, Thomas, of Cokeryngton, husbandman 1
5488621 2501480 2501480 defendant Reston Edmund yeoman 590197 590197 Reston, Edmund, of Cokeryngton, yeoman 3
5522195 2511759 2511759 defendant Dodson John husbandman 590197 590197 Dodson, John, of Cokeryngton, husbandman 0
5535182 2515530 2515530 defendant Droury William husbandman 590197 590197 Droury, William, of Cokeryngton, husbandman 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);