names

60 rows where place_id = 591590

✎ 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
3604917 1869204 1869204 plaintiff Hepton William yeoman 591590 591590 Hepton, William, of Shefford, Beds, yeoman 0
3616280 1872733 1872733 defendant Tryket Nicholas draper 591590 591590 Tryket, Nicholas, of Shefford, Beds, draper 1
3618643 1873458 1873458 defendant Shirwode Thomas yeoman 591590 591590 Shirwode, Thomas, of Shefford, Beds, yeoman 0
3621737 1874337 1874337 defendant Neell John yeoman 591590 591590 Neell, John, of Shefford, Beds, yeoman 0
3640381 1907423 1907423 defendant Buers Robert esq 591590 591590 Buers, Robert, of Shefford, Beds, esq 1
3653954 1911502 1911502 defendant Buers Robert esq 591590 591590 Buers, Robert, of Shefford, Beds, esq 2
3667125 1915650 1915650 defendant Trist Thomas gent 591590 591590 Trist, Thomas, of Shefford, Beds, gent 0
3903380 1991353 1991353 defendant Ampes Oliver gent 591590 591590 Ampes, Oliver, of Shefford, Beds, gent 1
3983065 2018718 2018718 defendant Wright William yeoman 591590 591590 Wright, William, of Shefford, Beds, yeoman 1
3999623 2024630 2024630 defendant Parker John chapman or mercer 591590 591590 Parker, John, of Shefford, Beds, chapman or mercer 0
4250582 2113180 2113180 defendant Grene James chapman 591590 591590 Grene, James, of Shefford, Beds, chapman 0
4264794 2117863 2117863 defendant Grene James chapman 591590 591590 Grene, James, of Shefford, Beds, chapman 0
4277231 2121968 2121968 defendant Price John yeoman 591590 591590 Price, John, of Shefford, Beds, yeoman 1
4342057 2144503 2144503 defendant Price John yeoman 591590 591590 Price, John, of Shefford, Beds, yeoman 1
4343403 2144968 2144968 defendant Ventris Francis gent 591590 591590 Ventris, Francis, of Shefford, Beds, gent 0
4367156 2153310 2153310 defendant Ventris Francis gent 591590 591590 Ventris, Francis, of Shefford, Beds, gent 0
4698597 2265036 2265036 defendant Verdon Nicholas husbandman 591590 591590 Verdon, Nicholas, of Shefford, Beds, husbandman 0
4738711 2277196 2277196 defendant Verdon Nicholas yeoman 591590 591590 Verdon, Nicholas, of Shefford, Beds, yeoman 1
4739287 2277374 2277374 defendant Bonlegh Hugh yeoman 591590 591590 Bonlegh, Hugh, of Shefford, Beds, yeoman 0
4739289 2277375 2277375 defendant Boulegh Hugh yeoman 591590 591590 Boulegh, Hugh, of Shefford, Beds, yeoman 0
4806570 2298268 2298268 defendant Lounde Thomas gent 591590 591590 Lounde, Thomas, of Shefford, Beds, gent 0
4884554 2322076 2322076 defendant Barker Thomas husbandman 591590 591590 Barker, Thomas, of Shefford, Beds, husbandman 2
4907476 2328899 2328899 defendant Lounde Walter gent 591590 591590 Lounde, Walter, of Shefford, Beds, gent 0
4917068 2331845 2331845 defendant May William smith 591590 591590 May, William, of Shefford, Beds, smith 3
4917073 2331846 2331846 defendant May William smith 591590 591590 May, William, of Shefford, Beds, smith 3
4927331 2334978 2334978 defendant Drawe John husbandman 591590 591590 Drawe, John, of Shefford, Beds, husbandman 0
4935434 2337478 2337478 defendant Maye William smith 591590 591590 Maye, William, of Shefford, Beds, smith 0
4960576 2345130 2345130 defendant Pecke Henry chapman 591590 591590 Pecke, Henry, of Shefford, Beds, chapman 3
4960582 2345131 2345131 defendant Peeke Henry chapman 591590 591590 Peeke, Henry, of Shefford, Beds, chapman 3
4982964 2351819 2351819 defendant Bere William husbandman 591590 591590 Bere, William, of Shefford, Beds, husbandman 2
4982973 2351820 2351820 defendant May William smith 591590 591590 May, William, of Shefford, Beds, smith 3
4982991 2351822 2351822 defendant May William smith 591590 591590 May, William, of Shefford, Beds, smith 4
5005209 2358420 2358420 defendant Bere William chandler 591590 591590 Bere, William, of Shefford, Beds, chandler 1
5017136 2361909 2361909 defendant Borre William chandler 591590 591590 Borre, William, of Shefford, Beds, chandler 4
5059332 2374358 2374358 defendant Alom John fuller 591590 591590 Alom, John, of Shefford, Beds, or of Northampton, fuller 4
5098556 2386010 2386010 plaintiff Walker John   591590 591590 Walker, John, of Shefford, Beds 0
5107200 2388536 2388536 plaintiff Walker John   591590 591590 Walker, John, of Shefford, Beds 1
5108060 2388796 2388796 defendant Taillour John tailor 591590 591590 Taillour, John, of Shefford, Beds, tailor 0
5208222 2418132 2418132 defendant May William smith 591590 591590 May, William, of Shefford, Beds, smith 0
5221751 2422057 2422057 defendant Lound Walter esq 591590 591590 Lound, Walter, of Shefford, Beds, esq 1
5229080 2424114 2424114 defendant Peeke Thomas chapman 591590 591590 Peeke, Thomas, of Shefford, Beds, chapman 3
5236738 2426330 2426330 defendant Lounde Walter gent 591590 591590 Lounde, Walter, of Shefford, Beds, gent 1
5238880 2426961 2426961 defendant Lounde Walter gent 591590 591590 Lounde, Walter, of Shefford, Beds, gent 0
5245601 2428872 2428872 defendant Pek Thomas chapman 591590 591590 Pek, Thomas, of Shefford, Beds, chapman 0
5268691 2435959 2435959 defendant Burwell John shoemaker 591590 591590 Burwell, John, of Shefford, Beds, shoemaker 2
5313559 2449084 2449084 defendant Carlile Richard gent 591590 591590 Carlile, Richard, of Shefford, Beds, gent 0
5317245 2450239 2450239 defendant Lounde Thomas gent 591590 591590 Lounde, Thomas, of Shefford, Beds, gent, son of Lounde, Walter, of Shefford, gent 0
5334261 2455316 2455316 defendant Carlile Richard esq 591590 591590 Carlile, Richard, of Shefford, Beds, esq 0
5334264 2455317 2455317 defendant Carlyle Richard esq 591590 591590 Carlyle, Richard, of Shefford, Beds, esq 0
5334267 2455318 2455318 defendant Carlile Richard esq 591590 591590 Carlile, Richard, of Shefford, Beds, esq 0
5334270 2455319 2455319 defendant Carlyle Richard esq 591590 591590 Carlyle, Richard, of Shefford, Beds, esq 0
5381283 2469700 2469700 defendant Garard Margaret widow 591590 591590 Garard, Margaret, of Shefford, Beds, widow 4
5388159 2471665 2471665 defendant Garerd Margaret widow 591590 591590 Garerd, Margaret, of Shefford, Beds, widow 4
5400751 2475278 2475278 defendant Garard Margaret widow 591590 591590 Garard, Margaret, of Shefford, Beds, widow 3
5406138 2476832 2476832 defendant Lounde Thomas gent 591590 591590 Lounde, Thomas, of Shefford, Beds, gent 0
5533959 2515162 2515162 defendant Shirwode Thomas mercer 591590 591590 Shirwode, Thomas, of Shefford, Beds, mercer 1
5546202 2518882 2518882 defendant Sherwode Thomas yeoman 591590 591590 Sherwode, Thomas, of Shefford, Beds, yeoman 0
5625156 2551806 2551806 defendant Bretayn John maltman 591590 591590 Bretayn, John, of Shefford, Beds, maltman 0
5625159 2551807 2551807 defendant Bretayn John maltman 591590 591590 Bretayn, John, of Shefford, Beds, maltman 0
5625162 2551808 2551808 defendant Bretayn John maltman 591590 591590 Bretayn, John, of Shefford, Beds, maltman 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);