names

43 rows where place_id = 590820

✎ 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
3602405 1868413 1868413 defendant Grene William husbandman 590820 590820 Grene, William, of Faldyngworth, husbandman 3
3701446 1926697 1926697 defendant Braunseby Thomas husbandman 590820 590820 Braunseby, Thomas, of Faldyngworth, husbandman 0
3845499 1972147 1972147 defendant Wylson Thomas yeoman 590820 590820 Wylson, Thomas, of Faldyngworth, yeoman 1
4161651 2082144 2082144 defendant Dicconson Robert (legal representative) 590820 590820 Dicconson, Robert, of Faldyngworth, husbandman, executrix of 0
4161652 2082144 2082144 defendant Dicconson Isabel widow 590820 590820 Dicconson, Isabel, of Faldyngworth, widow 1
4418635 2170701 2170701 defendant Stayle Robert   590820 590820 Stayle, Robert, of Faldyngworth 0
4440360 2181897 2181897 defendant Scayle Robert   590820 590820 Scayle, Robert, of Faldyngworth 0
4444142 2183145 2183145 defendant Cardwryght William   590820 590820 Cardwryght, William, of Faldyngworth 0
4448384 2184424 2184424 defendant Skayle Robert   590820 590820 Skayle, Robert, of Faldyngworth 0
4448385 2184424 2184424 defendant Skayle Thomas   590820 590820 Skayle, Thomas, of Faldyngworth 1
4448386 2184424 2184424 defendant Somercotes John   590820 590820 Somercotes, John, of Faldyngworth 2
4483192 2195440 2195440 defendant Smyth John   590820 590820 Smyth, John, of Faldyngworth 0
4488883 2197242 2197242 defendant Borward William   590820 590820 Borward, William, of Faldyngworth 0
4511145 2203936 2203936 defendant Nevyll John   590820 590820 Nevyll, John, of Faldyngworth 0
4571352 2222624 2222624 defendant Partrik William   590820 590820 Partrik, William, of Faldyngworth 4
4598467 2230758 2230758 defendant Spenser Nicholas   590820 590820 Spenser, Nicholas, of Faldyngworth 0
4601464 2231693 2231693 defendant Smyth John   590820 590820 Smyth, John, of Faldyngworth, son of Thomas 6
4645874 2244862 2244862 plaintiff Pantre John weaver 590820 590820 Pantre, John, of Faldyngworth, weaver 0
4664394 2250343 2250343 defendant Carter William   590820 590820 Carter, William, of Faldyngworth, "kidder" 2
4693054 2263335 2263335 defendant Maltby William husbandman 590820 590820 Maltby, William, of Faldyngworth, husbandman 1
4736580 2276571 2276571 defendant Stamford William yeoman 590820 590820 Stamford, William, of Faldyngworth, yeoman 0
4751539 2280935 2280935 defendant Taylebus William (legal representative) 590820 590820 Taylebus, William, of Faldyngworth, executors of 2
4807205 2298455 2298455 defendant Malteby John husbandman 590820 590820 Malteby, John, of Faldyngworth, husbandman 1
4837288 2307606 2307606 defendant Trowe John walker 590820 590820 Trowe, John, of Faldyngworth, walker 3
4863436 2315533 2315533 defendant Nicholas Peter husbandman 590820 590820 Nicholas, Peter, of Faldyngworth, husbandman 0
4876037 2319465 2319465 defendant Cokson John laborer 590820 590820 Cokson, John, of Faldyngworth, laborer 3
4971059 2348283 2348283 defendant Burgh John husbandman 590820 590820 Burgh, John, of Faldyngworth, husbandman 1
5016457 2361708 2361708 plaintiff Burgh John   590820 590820 Burgh, John, of Faldyngworth 0
5016459 2361709 2361709 plaintiff Burgh John   590820 590820 Burgh, John, of Faldyngworth 0
5087980 2382860 2382860 defendant West William husbandman 590820 590820 West, William, of Faldyngworth, husbandman 1
5087981 2382860 2382860 defendant Chaumbre John husbandman 590820 590820 Chaumbre, John, of Faldyngworth, husbandman 2
5090890 2383729 2383729 defendant West William husbandman 590820 590820 West, William, of Faldyngworth, husbandman 0
5096111 2385304 2385304 defendant Cartwright Robert   590820 590820 Cartwright, Robert, of Faldyngworth, cartwright 0
5198935 2415441 2415441 defendant Nevill John yeoman 590820 590820 Nevill, John, of Faldyngworth, yeoman 2
5246735 2429207 2429207 defendant Richardson William husbandman 590820 590820 Richardson, William, of Faldyngworth, husbandman 0
5246736 2429207 2429207 defendant Hochynson John smith 590820 590820 Hochynson, John, of Faldyngworth, smith 1
5246969 2429279 2429279 defendant West William husbandman 590820 590820 West, William, of Faldyngworth, husbandman 0
5274085 2437499 2437499 defendant Nevill John gent 590820 590820 Nevill, John, of Faldyngworth, gent 0
5274086 2437499 2437499 defendant Nevill John husbandman 590820 590820 Nevill, John, of Faldyngworth, husbandman 1
5274087 2437499 2437499 defendant a Wyke Henry husbandman 590820 590820 a Wyke, Henry, of Faldyngworth, husbandman 2
5274089 2437499 2437499 defendant Aleyn Thomas husbandman 590820 590820 Aleyn, Thomas, of Faldyngworth, husbandman 4
5296474 2443959 2443959 defendant Waterlade Robert clerk 590820 590820 Waterlade, Robert, of Faldyngworth, clerk 0
5338687 2456671 2456671 defendant Waterlad William yeoman 590820 590820 Waterlad, William, of Faldyngworth, yeoman 1

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);