names

89 rows where place_id = 604938

✎ 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
3659812 1913323 1913323 defendant Grendon John gent 604938 604938 Grendon, John, of Caldecote, gent 0
4073388 2050770 2050770 defendant Bygrage Richard husbandman 604938 604938 Bygrage, Richard, of Caldecote, husbandman 0
4074339 2051124 2051124 defendant Bygrave Richard husbandman 604938 604938 Bygrave, Richard, of Caldecote, husbandman 0
4074357 2051132 2051132 defendant Bygrave Richard husbandman 604938 604938 Bygrave, Richard, of Caldecote, husbandman 0
4096517 2059081 2059081 defendant Bygrave Richard husbandman 604938 604938 Bygrave, Richard, of Caldecote, husbandman 1
4281154 2123313 2123313 defendant Bushe Nicholas husbandman 604938 604938 Bushe, Nicholas, of Caldecote, husbandman 3
4326980 2139355 2139355 defendant Bygrave Richard husbandman 604938 604938 Bygrave, Richard, of Caldecote, husbandman 0
4439142 2181525 2181525 defendant Norton John   604938 604938 Norton, John, of Caldecote 0
4439144 2181526 2181526 defendant Notton John   604938 604938 Notton, John, of Caldecote 0
4466908 2190322 2190322 defendant Morell William   604938 604938 Morell, William, of Caldecote 0
4472909 2192202 2192202 defendant Fullere John   604938 604938 Fullere, John, of Caldecote 4
4475014 2192856 2192856 defendant Blake John thresher 604938 604938 Blake, John, of Caldecote, thresher 0
4475018 2192857 2192857 defendant Blake John thressher 604938 604938 Blake, John, of Caldecote, thressher 0
4506026 2202397 2202397 defendant Hobson Henry   604938 604938 Hobson, Henry, of Caldecote 0
4527276 2208811 2208811 defendant Draper Thomas   604938 604938 Draper, Thomas, of Caldecote 0
4532189 2210332 2210332 defendant Broun Richard clerk 604938 604938 Broun, Richard, of Caldecote, clerk 0
4554642 2217378 2217378 defendant (illegible) Robert maltman 604938 604938 _, Robert, of Caldecote, maltman 0
4555261 2217580 2217580 plaintiff Hedewyn William   604938 604938 Hedewyn, William, of Caldecote, parson 0
4555835 2217766 2217766 plaintiff Hobbesson William   604938 604938 Hobbesson, William, of Caldecote, son of Henry 0
4555837 2217767 2217767 plaintiff Hobbesson William   604938 604938 Hobbesson, William, of Caldecote, son of Henry 0
4555889 2217781 2217781 defendant Taillour Ralph maltman 604938 604938 Taillour, Ralph, of Caldecote, maltman 0
4567174 2221295 2221295 plaintiff Taillour Ralph   604938 604938 Taillour, Ralph, of Caldecote 0
4567179 2221296 2221296 plaintiff Taillour Ralph   604938 604938 Taillour, Ralph, of Caldecote 0
4583678 2226310 2226310 plaintiff Fuller John   604938 604938 Fuller, John, of Caldecote 0
4597925 2230610 2230610 defendant Taillour Christiner   604938 604938 Taillour, Christiner, of Caldecote, formerly wife of Ralph 0
4637570 2242539 2242539 defendant Blayseworth Hugh   604938 604938 Blayseworth, Hugh, of Caldecote 0
4640941 2243448 2243448 defendant Taillour Ralph (legal representative) 604938 604938 Taillour, Ralph, of Caldecote, executors of 0
4656216 2247834 2247834 defendant Wodcok Henry husbandman 604938 604938 Wodcok, Henry, of Caldecote, husbandman 0
4656217 2247834 2247834 defendant Wodcok Thomas husbandman 604938 604938 Wodcok, Thomas, of Caldecote, husbandman 1
4676613 2258304 2258304 plaintiff Goodgamen Margaret   604938 604938 Goodgamen, Margaret, of Caldecote 0
4685940 2261192 2261192 defendant Fateby Roger gent 604938 604938 Fateby, Roger, of Caldecote, gent 2
4695832 2264180 2264180 defendant Caldecote Thomas gent 604938 604938 Caldecote, Thomas, of Caldecote, gent 1
4714994 2270018 2270018 defendant Jones William   604938 604938 Jones, William, of Caldecote, plough man 0
4732556 2275357 2275357 defendant Caldecote Thomas gent 604938 604938 Caldecote, Thomas, of Caldecote, gent 0
4737372 2276805 2276805 defendant Jones William ploughman 604938 604938 Jones, William, of Caldecote, ploughman 0
4741111 2277905 2277905 defendant Draper Thomas husbandman 604938 604938 Draper, Thomas, of Caldecote, husbandman 0
4751699 2280985 2280985 defendant Presions William yeoman 604938 604938 Presions, William, of Caldecote, yeoman 1
4761589 2283969 2283969 defendant Caldecote Thomas gent 604938 604938 Caldecote, Thomas, of Caldecote, gent 0
4788332 2292421 2292421 defendant Taillour John husbandman 604938 604938 Taillour, John, of Caldecote, husbandman 1
4794994 2294576 2294576 defendant Scot John husbandman 604938 604938 Scot, John, of Caldecote, husbandman 0
4794995 2294576 2294576 defendant Scot Richard   604938 604938 Scot, Richard, of Caldecote, servant 1
4794996 2294576 2294576 defendant Scot William   604938 604938 Scot, William, of Caldecote, servant 2
4801462 2296638 2296638 defendant Smyth Robert husbandman 604938 604938 Smyth, Robert, of Caldecote, husbandman 0
4821597 2302837 2302837 defendant Tylden John maltman 604938 604938 Tylden, John, of Caldecote, maltman 0
4822987 2303271 2303271 defendant Presyous William yeoman 604938 604938 Presyous, William, of Caldecote, yeoman 2
4830663 2305614 2305614 defendant Deke William husbandman 604938 604938 Deke, William, of Caldecote, husbandman 2
4836397 2307356 2307356 defendant Faceby Roger gent 604938 604938 Faceby, Roger, of Caldecote, gent 0
4846454 2310397 2310397 defendant Faceby Roger gent 604938 604938 Faceby, Roger, of Caldecote, gent 0
4846641 2310459 2310459 defendant Quadryng Robert husbandman 604938 604938 Quadryng, Robert, of Caldecote, husbandman 2
4856396 2313376 2313376 defendant Wayte John husbandman 604938 604938 Wayte, John, of Caldecote, husbandman 3
4880621 2320848 2320848 plaintiff Weryngton Nicholas   604938 604938 Weryngton, Nicholas, of Caldecote 0
4889854 2323615 2323615 plaintiff Hobson Thomas   604938 604938 Hobson, Thomas, of Caldecote 0
4892385 2324356 2324356 defendant Fuller John husbandman 604938 604938 Fuller, John, of Caldecote, husbandman 1
4911994 2330256 2330256 defendant Criss William maltman 604938 604938 Criss, William, of Caldecote, maltman 4
4920523 2332933 2332933 defendant Crysp William husbandman 604938 604938 Crysp, William, of Caldecote, husbandman 0
4920534 2332934 2332934 defendant Cryspe William husbandman 604938 604938 with Cryspe, William, of Caldecote, husbandman 3
4924799 2334189 2334189 defendant Wodekok Thomas yeoman 604938 604938 Wodekok, Thomas, of Caldecote, yeoman 0
4931701 2336300 2336300 defendant Flynt John husbandman 604938 604938 Flynt, John, of Caldecote, husbandman 3
4931705 2336302 2336302 defendant Carter John husbandman 604938 604938 Carter, John, of Caldecote, husbandman 0
4934641 2337226 2337226 defendant Flynt William husbandman 604938 604938 Flynt, William, of Caldecote, husbandman 4
4943462 2339925 2339925 defendant Cryspe William husbandman 604938 604938 Cryspe, William, of Caldecote, husbandman 0
4943463 2339925 2339925 defendant Cryspe Robert husbandman 604938 604938 Cryspe, Robert, of Caldecote, husbandman 1
4943464 2339925 2339925 defendant Evaresdon Robert husbandman 604938 604938 Evaresdon, Robert, of Caldecote, husbandman 2
4943465 2339925 2339925 defendant Dawe John husbandman 604938 604938 Dawe, John, of Caldecote, husbandman 3
4946142 2340777 2340777 defendant Crysp William husbandman 604938 604938 Crysp, William, of Caldecote, husbandman 3
4952221 2342632 2342632 defendant Curteys Stephen husbandman 604938 604938 Curteys, Stephen, of Caldecote, husbandman 0
4972030 2348572 2348572 defendant Carter John husbandman 604938 604938 Carter, John, of Caldecote, husbandman 1
4979877 2350936 2350936 defendant Boteler Reginald husbandman 604938 604938 Boteler, Reginald, of Caldecote, husbandman 3
4979878 2350936 2350936 defendant Carter John husbandman 604938 604938 Carter, John, of Caldecote, husbandman 4
4981256 2351317 2351317 defendant Bryan John husbandman 604938 604938 Bryan, John, of Caldecote, husbandman 3
4981257 2351317 2351317 defendant Tylden John husbandman 604938 604938 Tylden, John, of Caldecote, husbandman 4
5008381 2359340 2359340 defendant Carter John husbandman 604938 604938 Carter, John, of Caldecote, husbandman 0
5014114 2360981 2360981 defendant Scot Richard husbandman 604938 604938 Scot, Richard, of Caldecote, husbandman 0
5014681 2361160 2361160 defendant Everdon Robert husbandman 604938 604938 Everdon, Robert, of Caldecote, husbandman 2
5020276 2362819 2362819 defendant Hancheche or Haucheche Thomas gent 604938 604938 Hancheche or Haucheche, Thomas, of Caldecote, gent 0
5059180 2374310 2374310 defendant Hancheche Thomas gent 604938 604938 Hancheche, Thomas, of Caldecote, gent 0
5139895 2398149 2398149 defendant Waddesworth John husbandman 604938 604938 Waddesworth, John, of Caldecote, husbandman 0
5240815 2427524 2427524 defendant Scot Richard husbandman 604938 604938 Scot, Richard, of Caldecote, husbandman 1
5267323 2435544 2435544 defendant Algar William husbandman 604938 604938 Algar, William, of Caldecote, husbandman 0
5504362 2506280 2506280 defendant Lymeryk William gent 604938 604938 Lymeryk, William, of Caldecote, gent 0
5547479 2519281 2519281 defendant Rolffe Hugh yeoman 604938 604938 Rolffe, Hugh, of Caldecote, yeoman 0
5547738 2519355 2519355 defendant Rolfe Hugh yeoman 604938 604938 Rolfe, Hugh, of Caldecote, yeoman 0
5594577 2533283 2533283 defendant Rolff Hugh husbandman 604938 604938 Rolff, Hugh, of Caldecote, husbandman 1
5596970 2533967 2533967 defendant Grendon John gent 604938 604938 Grendon, John, of Caldecote, Toucester, gent 0
5609960 2546820 2546820 defendant Deye John   604938 604938 Deye, John, of Caldecote 1
5612543 2547670 2547670 defendant Tylere John   604938 604938 together with Tylere, John, of Caldecote, vicar 1
5622070 2550815 2550815 defendant Deye John   604938 604938 Deye, John, of Caldecote 1
5631119 2553740 2553740 defendant Chapman Thomas chapman 604938 604938 Chapman, Thomas, of Caldecote, chapman 0
5636159 2555262 2555262 defendant Jones William husbandman 604938 604938 Jones, William, of Caldecote, 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);